Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| customer_referral_id | int8 | 19 | null |
|
|
Primary key - unique identifier for each customer referral record. |
|||||
| referring_customer_id | int8 | 19 | √ | null |
|
|
The customer who made the referral and may receive rewards. |
||||
| referred_customer_id | int8 | 19 | √ | null |
|
|
The new customer who was referred and may receive welcome rewards. |
||||
| bool | 1 | √ | null |
|
|
Indicates whether any premium reward has been redeemed by either the referring or referred customer. |
|||||
| relationship | varchar | 256 | √ | null |
|
|
How the referring customer knows the referred customer. |
||||
| source_event | varchar | 256 | √ | null |
|
|
The business event that triggered this referral reward eligibility. |
||||
| waiting_period_days | int4 | 10 | √ | null |
|
|
Number of days the referred customer must remain active before rewards can be redeemed. |
||||
| referral_created_date | timestamp | 29,6 | √ | null |
|
|
Date and time when the referral was recorded, localized to the referring customer’s home studio timezone. |
||||
| waiting_period_end_date | timestamp | 29,6 | √ | null |
|
|
Date when the waiting period ends and rewards become redeemable, localized to the referring customer’s home studio timezone. |
||||
| referral_status | varchar | 256 | √ | null |
|
|
Approval status for referrals. AUTO_ACCEPTED indicates no manual review was needed, other values indicate the proposal went through manual review process. |
||||
| manual_referral_source | varchar | 256 | √ | null |
|
|
Where the manually reviewed referral proposal originated from. Only populated for referrals that went through the manual review process. |
||||
| manual_rejected_reason | varchar | 256 | √ | null |
|
|
Customer-facing explanation for why a referral proposal was rejected. |
||||
| manual_internal_rejected_reason | varchar | 256 | √ | null |
|
|
Internal notes about why a referral proposal was rejected, not visible to customers. |
||||
| last_updated | timestamptz | 35 | √ | null |
|
|
System column. UTC Timestamp at which entry was calculated (lags shortly behind source system). |
Relationships
Close relationships within degrees of separation
