# ReferralHero schema ERD

Table and field reference for the Fivetran ReferralHero connector.

## Table & Field Reference

### subscriber_reward

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| list_id | Unknown | PK, FK |
| subscriber_id | Unknown | PK, FK |
| 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 | PK, FK |
| list_id | Unknown | PK, FK |
| available | Unknown |  |
| code | Unknown |  |
| created_at | Unknown |  |
| email_id | Unknown |  |
| sent_at | Unknown |  |

### coupon_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| list_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| category | Unknown |  |
| description | Unknown |  |
| header | Unknown |  |
| image | Unknown |  |
| label | Unknown |  |
| points | Unknown |  |
| referrals | Unknown |  |
| signup_type | Unknown |  |
| title | Unknown |  |

## Relationships

- subscriber_reward(coupon_code) → coupon(code)
- subscriber_reward(list_id) → subscriber(list_id)
- subscriber_reward(subscriber_id) → subscriber(id)
- coupon(list_id) → coupon_group(list_id)
- coupon(coupon_group_id) → coupon_group(id)
- coupon_group(list_id) → list(id)
- subscriber(code) → coupon(index)
- subscriber(referred_by_id) → subscriber(id)
- subscriber(list_id) → list(id)
- reward(list_id) → list(id)