ReferralHero
Explore the interactive ERD
Table & Field Reference
subscriber_reward
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
list_id | Unknown | PKFK |
subscriber_id | Unknown | PKFK |
coupon_code | Unknown | FK |
coupon_group | Unknown | |
created_at | Unknown | |
recurring_count | Unknown | |
referrals | Unknown | |
referrals_type | Unknown | |
signup_type | Unknown | |
status | Unknown |
coupon
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
coupon_group_id | Unknown | PKFK |
list_id | Unknown | PKFK |
available | Unknown | |
code | Unknown | |
created_at | Unknown | |
email_id | Unknown | |
sent_at | Unknown |
coupon_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
list_id | Unknown | PKFK |
active | Unknown | |
created_at | Unknown | |
name | Unknown |
list
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
name | Unknown | |
type | Unknown |
subscriber
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
list_id | Unknown | PKFK |
code | Unknown | FK |
referred_by_id | Unknown | FK |
conversion_amount | Unknown | |
created_at | Unknown | |
crypto_wallet_address | Unknown | |
crypto_wallet_provider | Unknown | |
device | Unknown | |
email | Unknown | |
extra_field | Unknown | |
extra_field_2 | Unknown | |
host | Unknown | |
last_updated_at | Unknown | |
level_2_confirmed_referrals | Unknown | |
level_3_confirmed_referrals | Unknown | |
name | Unknown | |
option_field | Unknown | |
other_identifier_value | Unknown | |
pending_referrals | Unknown | |
people_referred | Unknown | |
phone_number | Unknown | |
points | Unknown | |
position | Unknown | |
promoted | Unknown | |
referral_link | Unknown | |
referral_status | Unknown | |
referral_status_at | Unknown | |
referred | Unknown | |
referred_by_points | Unknown | |
risk_level | Unknown | |
source | Unknown | |
unconfirmed_referrals | Unknown | |
verified | Unknown | |
verified_at | Unknown |
reward
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
list_id | Unknown | PKFK |
category | Unknown | |
description | Unknown | |
header | Unknown | |
image | Unknown | |
label | Unknown | |
points | Unknown | |
referrals | Unknown | |
signup_type | Unknown | |
title | Unknown |