# Tremendous schema ERD

Table and field reference for the Fivetran Tremendous connector.

## Table & Field Reference

### reward_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| reward_id | Unknown | PK, FK |
| label | Unknown |  |
| value | Unknown |  |

### reward

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| created_at | Instant |  |
| deliver_at | Unknown |  |
| delivery_method | Unknown |  |
| delivery_status | Unknown |  |
| recipient_email | Unknown |  |
| recipient_name | Unknown |  |
| recipient_phone | Unknown |  |
| value_currency_code | Unknown |  |
| value_denomination | Unknown |  |

### balance_transaction

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| action | Unknown |  |
| amount | Unknown |  |
| balance | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |

### product_currency_code

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| currency_code | Unknown |  |

### product_sku

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| max | Unknown |  |
| min | Unknown |  |

### product_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| abbr | Unknown |  |

### product_image

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| src | Unknown |  |
| type | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category | Unknown |  |
| description | Unknown |  |
| disclosure | Unknown |  |
| name | Unknown |  |

### role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| title | Unknown |  |

### funding_source_usage_permission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| funding_source_id | Unknown | PK, FK |
| usage_permission | Unknown |  |

### funding_source

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_number_mask | Unknown |  |
| account_routing_mask | Unknown |  |
| account_type | Unknown |  |
| accountholder_name | Unknown |  |
| available_cents | Unknown |  |
| bank_name | Unknown |  |
| expired | Unknown |  |
| last_4 | Unknown |  |
| last_payment_failed_at | Unknown |  |
| method | Unknown |  |
| network | Unknown |  |
| pending_cents | Unknown |  |
| refundable | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| website | Unknown |  |

### member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| role_id | Unknown | FK |
| active | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| last_login_at | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |

### campaign_product

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| product | Unknown | FK |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| email_button_color | Unknown |  |
| email_logo_background_color | Unknown |  |
| email_logo_image_height_px | Unknown |  |
| email_logo_image_url | Unknown |  |
| email_sender_name | Unknown |  |
| email_subject_line | Unknown |  |
| name | Unknown |  |
| webpage_background_color | Unknown |  |
| webpage_headline | Unknown |  |
| webpage_logo_background_color | Unknown |  |
| webpage_logo_image_height_px | Unknown |  |
| webpage_logo_image_url | Unknown |  |
| webpage_message | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| invoice_id | Unknown | FK |
| channel | Unknown |  |
| created_at | Unknown |  |
| external_id | Unknown |  |
| payment_channel | Unknown |  |
| payment_fees | Unknown |  |
| payment_refund_total | Unknown |  |
| payment_subtotal | Unknown |  |
| payment_total | Unknown |  |
| status | Unknown |  |

### invoice_order

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| order_id | Unknown | FK |

### invoice_reward

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| reward_id | Unknown | FK |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amount | Unknown |  |
| created_at | Instant |  |
| paid_at | Unknown |  |
| po_number | Unknown |  |
| status | Unknown |  |

### fraud_review_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| fraud_review_reward_id | Unknown | PK, FK |
| label | Unknown |  |
| value | Unknown |  |

### fraud_review_reason

| Column | Type | Keys |
| --- | --- | --- |
| reason | Unknown | PK |
| fraud_review_reward_id | Unknown | PK, FK |

### fraud_review

| Column | Type | Keys |
| --- | --- | --- |
| reward_id | Unknown | PK, FK |
| order_id | Unknown | FK |
| created_at | Instant |  |
| currency_code | Unknown |  |
| deliver_at | Unknown |  |
| delivery_method | Unknown |  |
| delivery_status | Unknown |  |
| denomination | Unknown |  |
| recipient_email | Unknown |  |
| recipient_name | Unknown |  |
| recipient_phone | Unknown |  |
| status | Unknown |  |

## Relationships

- reward_custom_field(reward_id) → reward(id)
- reward(order_id) → orders(id)
- product_currency_code(product_id) → product(id)
- product_sku(product_id) → product(id)
- product_country(product_id) → product(id)
- product_image(product_id) → product(id)
- funding_source_usage_permission(funding_source_id) → funding_source(id)
- member(role_id) → role(id)
- campaign_product(product) → product(id)
- campaign_product(campaign_id) → campaign(id)
- orders(campaign_id) → campaign(id)
- orders(invoice_id) → invoice(id)
- invoice_order(order_id) → orders(id)
- invoice_order(invoice_id) → invoice(id)
- invoice_reward(reward_id) → reward(id)
- invoice_reward(invoice_id) → invoice(id)
- fraud_review_custom_field(fraud_review_reward_id) → fraud_review(reward_id)
- fraud_review_reason(fraud_review_reward_id) → fraud_review(reward_id)
- fraud_review(reward_id) → reward(id)
- fraud_review(order_id) → orders(id)