# GRIN schema ERD

Table and field reference for the Fivetran GRIN connector.

## Table & Field Reference

### media_library_folder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Instant |  |

### product_selection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| brand_id | Unknown | FK |
| contact_address_id | Unknown | FK |
| contact_id | Unknown | FK |
| created_at | Unknown |  |
| fulfilled_at | Unknown |  |
| is_fulfilled | Unknown |  |
| order_errors | Json |  |
| order_status | Unknown |  |
| order_status_updated_at | Unknown |  |
| proposal_id | Unknown |  |
| updated_at | Instant |  |

### payable

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| payment_id | Unknown | FK |
| amount | Unknown |  |
| conversion | Json |  |
| conversion_rate | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| due_at | Unknown |  |
| is_verified | Unknown |  |
| is_voided | Unknown |  |
| payment_status | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |
| usd_amount | Unknown |  |

### activation_brief

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activation_id | Unknown | FK |
| brand_id | Unknown | FK |
| contact_id | Unknown | FK |
| member_id | Unknown | FK |
| accepted_at | Unknown |  |
| accepted_by | Unknown |  |
| account_id | Unknown |  |
| created_at | Unknown |  |
| declined_at | Unknown |  |
| declined_by | Unknown |  |
| previous_status | Unknown |  |
| reviewed_at | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### contact_custom_property

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| property_id | Unknown | FK |
| created_at | Unknown |  |
| date_value | Unknown |  |
| json_value | Json |  |
| name | Unknown |  |
| number_value | Unknown |  |
| string_value | Unknown |  |
| text_value | Unknown |  |
| updated_at | Unknown |  |

### contact_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | PK, FK |
| name | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| payment_account_id | Unknown | FK |
| primary_address_id | Unknown | FK |
| primary_contact_id | Unknown | FK |
| added_manually | Unknown |  |
| application_completed_at | Unknown |  |
| application_page_id | Unknown |  |
| birthday | Unknown |  |
| company | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| is_archived | Unknown |  |
| is_declined | Unknown |  |
| joined_at | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| live_url_id | Unknown |  |
| notification_channel | Unknown |  |
| phone_country_code | Unknown |  |
| phone_number | Unknown |  |
| phone_number_display | Unknown |  |
| profile_picture | Unknown |  |
| promoted_to_influencer_at | Unknown |  |
| record_type | Unknown |  |
| source | Unknown |  |
| stage_id | Unknown |  |
| stage_name | Unknown |  |
| stage_position | Unknown |  |
| stage_type | Unknown |  |
| total_reach | Unknown |  |
| updated_at | Instant |  |
| website | Unknown |  |

### payment_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| payment_id | Unknown | PK, FK |
| contact_id | Unknown | FK |
| amount | Unknown |  |
| conversion | Json |  |
| conversion_rate | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| due_at | Unknown |  |
| is_verified | Unknown |  |
| is_voided | Unknown |  |
| payment_status | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |
| usd_amount | Unknown |  |

### payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| contact_id | Unknown | FK |
| payment_account_id | Unknown | FK |
| user_id | Unknown | FK |
| amount | Unknown |  |
| batch_id | Unknown |  |
| conversion_rate | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| deleted_at | Unknown |  |
| sent_at | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### brand

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| currency | Unknown |  |
| description | Unknown |  |
| logo | Unknown |  |
| name | Unknown |  |
| support_email | Unknown |  |
| updated_at | Instant |  |
| url | Unknown |  |

### partnership_proposal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partnership_id | Unknown | PK, FK |
| brand_id | Unknown | FK |
| campaign_id | Unknown | FK |
| contact_address_id | Unknown | FK |
| contact_id | Unknown | FK |
| content_rights_id | Unknown | FK |
| accepted_at | Unknown |  |
| agreed | Unknown |  |
| agreed_at | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| declined_at | Unknown |  |
| end_date | Unknown |  |
| has_payment | Unknown |  |
| has_product | Unknown |  |
| is_complete | Unknown |  |
| notes | Unknown |  |
| partnership_position | Unknown |  |
| price | Unknown |  |
| start_date | Unknown |  |
| updated_at | Unknown |  |

### partnership_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partnership_id | Unknown | PK, FK |
| campaign_id | Unknown | FK |
| network_id | Unknown | FK |
| bio_text | Unknown |  |
| created_at | Unknown |  |
| deliverable_price | Unknown |  |
| description | Unknown |  |
| interval_index | Json |  |
| is_required | Unknown |  |
| media_type | Unknown |  |
| name | Unknown |  |
| partnership_interval_type | Unknown |  |
| position | Unknown |  |
| quantity | Unknown |  |
| requires_creator_oauth | Unknown |  |
| starting_interval_index | Unknown |  |
| updated_at | Unknown |  |

### partnership

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| affiliate_link_id | Unknown | FK |
| brand_id | Unknown | FK |
| contact_id | Unknown | FK |
| content_rights_id | Unknown | FK |
| discount_code_group_id | Unknown | FK |
| allow_influencer_upload | Unknown |  |
| budget | Unknown |  |
| compensation | Json |  |
| created_at | Unknown |  |
| deal_content | Json |  |
| deal_total_cost | Unknown |  |
| deliverable_interval | Unknown |  |
| description | Unknown |  |
| duration_interval | Unknown |  |
| duration_length | Unknown |  |
| end_date | Unknown |  |
| has_strict_deliverable_date | Unknown |  |
| ignore_end_date_for_content | Unknown |  |
| image | Unknown |  |
| influencer_title | Unknown |  |
| internal_title | Unknown |  |
| is_published | Unknown |  |
| payable | Json |  |
| payment_method | Unknown |  |
| property | Json |  |
| requires_signature | Unknown |  |
| set_end_date | Unknown |  |
| short_description | Unknown |  |
| show_revenue_tracking_information | Unknown |  |
| signed_at | Unknown |  |
| stage_id | Unknown |  |
| stage_name | Unknown |  |
| stage_position | Unknown |  |
| stage_type | Unknown |  |
| start_date | Unknown |  |
| tracking_tags | Unknown |  |
| updated_at | Instant |  |

### partnership_job

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| partnership_id | Unknown | PK |
| campaign_id | Unknown | FK |
| contact_id | Unknown | FK |
| proposal_id | Unknown | FK |
| task_id | Unknown | FK |
| content_posted_at | Unknown |  |
| created_at | Unknown |  |
| delivered_at | Unknown |  |
| due_at | Unknown |  |
| is_extra | Unknown |  |
| is_global | Unknown |  |
| media_library_content_id | Unknown |  |
| note | Unknown |  |
| status | Unknown |  |
| status_info | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### discount_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| ecommerce_account_id | Unknown | FK |
| group_id | Unknown | FK |
| code | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| disabled_at | Unknown |  |
| disabled_reason | Unknown |  |
| end_date | Unknown |  |
| external_id | Unknown |  |
| start_date | Unknown |  |
| updated_at | Instant |  |

### product_variant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| cost | Unknown |  |
| external_id | Unknown |  |
| price | Unknown |  |
| qty | Unknown |  |
| shipping_cost | Unknown |  |
| sku | Unknown |  |

### ecommerce_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| brand_id | Unknown | FK |
| created_at | Unknown |  |
| provider | Unknown |  |
| updated_at | Unknown |  |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| role_name | Unknown | PK |
| users_id | Unknown | PK, FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| email | Unknown |  |
| email_verified_at | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| phone | Unknown |  |
| phone_country_code | Unknown |  |
| profile_picture | Unknown |  |
| timezone | Unknown |  |
| updated_at | Instant |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee_id | Unknown | FK |
| contact_id | Unknown | FK |
| creator_id | Unknown | FK |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| due_at | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### payment_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| reference_id | Unknown |  |
| updated_at | Instant |  |

### domain

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| is_white_labeled | Unknown |  |
| subdomain | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### content_rights_selected

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| content_rights_id | Unknown | PK, FK |
| text | Unknown |  |

### content_rights

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| content_rights_header | Unknown |  |
| created_at | Unknown |  |
| updated_at | Instant |  |

### deposit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amount | Unknown |  |
| created_at | Unknown |  |
| failure_reason | Unknown |  |
| provider | Unknown |  |
| state | Unknown |  |
| total | Unknown |  |
| updated_at | Instant |  |

### campaign_compensation

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

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| affiliate_link_id | Unknown | FK |
| brand_id | Unknown | FK |
| discount_code_group_id | Unknown | FK |
| team_id | Unknown | FK |
| allow_influencer_uploads | Unknown |  |
| budget | Unknown |  |
| created_at | Unknown |  |
| date_content_end | Unknown |  |
| date_content_start | Unknown |  |
| date_proposals_end | Unknown |  |
| date_proposals_start | Unknown |  |
| description | Unknown |  |
| image | Unknown |  |
| influencer_inputs_price | Unknown |  |
| influencer_title | Unknown |  |
| internal_title | Unknown |  |
| payment_method | Unknown |  |
| public_tags | Unknown |  |
| recurring_proposals | Unknown |  |
| short_description | Unknown |  |
| show_revenue_tracking_information | Unknown |  |
| tracking_tags | Unknown |  |
| updated_at | Unknown |  |
| version | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| contact_id | Unknown | FK |
| ecommerce_account_id | Unknown | FK |
| product_selection_id | Unknown | FK |
| user_id | Unknown | FK |
| campaign_proposal_id | Unknown |  |
| created_at | Unknown |  |
| external_order_id | Unknown |  |
| fulfillment | Json |  |
| shipment_status | Unknown |  |
| shipment_status_date | Unknown |  |
| updated_at | Instant |  |

### activation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| brand_id | Unknown | FK |
| team_id | Unknown | FK |
| account_id | Unknown |  |
| budget | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| currency_rate | Unknown |  |
| description | Unknown |  |
| dollar_budget | Unknown |  |
| image | Unknown |  |
| name | Unknown |  |
| previous_status | Unknown |  |
| public_name | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### media_library_content_hashtag

| Column | Type | Keys |
| --- | --- | --- |
| hashtag_name | Unknown | PK |
| media_library_content_id | Unknown | PK, FK |

### media_library_content_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| media_library_content_id | Unknown | PK, FK |
| name | Unknown |  |

### media_library_content

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| contact_id | Unknown | FK |
| content_id | Unknown | FK |
| content_rights_id | Unknown | FK |
| folder_id | Unknown | FK |
| network_id | Unknown | FK |
| owner_id | Unknown | FK |
| album_id | Unknown |  |
| annotations_colors | Json |  |
| annotations_labels | Json |  |
| away_swipe | Unknown |  |
| campaign_job_id | Unknown |  |
| caption | Unknown |  |
| comment | Unknown |  |
| content_rights_accepted_at | Unknown |  |
| content_url | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| engagement | Unknown |  |
| engagement_rate | Unknown |  |
| estimated_impression | Unknown |  |
| exit | Unknown |  |
| impression | Unknown |  |
| impressions_real | Unknown |  |
| imv | Unknown |  |
| interaction | Unknown |  |
| is_reel | Unknown |  |
| is_story | Unknown |  |
| label | Unknown |  |
| likes | Unknown |  |
| media_type | Unknown |  |
| mentions | Json |  |
| name | Unknown |  |
| owner_name | Unknown |  |
| owner_picture | Unknown |  |
| owner_reach | Unknown |  |
| owner_reached | Unknown |  |
| owner_username | Unknown |  |
| posted_at | Unknown |  |
| reach | Unknown |  |
| reply | Unknown |  |
| reply_rate | Unknown |  |
| share | Unknown |  |
| source | Unknown |  |
| source_url | Unknown |  |
| taps_back | Unknown |  |
| taps_forward | Unknown |  |
| thumbnail | Unknown |  |
| updated_at | Instant |  |
| view | Unknown |  |
| metadata_** |  |  |

### link

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### affiliate_link_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_domain_id | Unknown | FK |
| brand_id | Unknown | FK |
| attribution_window | Unknown |  |
| cascade_update | Unknown |  |
| created_at | Unknown |  |
| destination_url | Unknown |  |
| end_date | Unknown |  |
| name | Unknown |  |
| query_parameter | Json |  |
| settings_creator_attribution | Unknown |  |
| settings_link_pattern | Unknown |  |
| settings_payout_amount | Unknown |  |
| settings_payout_tiers | Json |  |
| settings_payout_type | Unknown |  |
| start_date | Unknown |  |
| updated_at | Instant |  |

### product_selection_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| product_id | Unknown | FK |
| product_selection_id | Unknown | FK |
| variant_id | Unknown | FK |

### product_option_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| option_id | Unknown | FK |
| name | Unknown |  |
| position | Unknown |  |

### discount_code_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ecommerce_account_id | Unknown | FK |
| affiliatepayout_amount | Unknown |  |
| affiliatepayout_type | Unknown |  |
| code_pattern | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| external_id | Unknown |  |
| name | Unknown |  |
| rules_applies_to | Unknown |  |
| rules_cascade_update_amount | Unknown |  |
| rules_customer_group_ids | Json |  |
| rules_customer_selection | Unknown |  |
| rules_discount_amount | Unknown |  |
| rules_discount_type | Unknown |  |
| rules_enable_shipping_price_limit | Unknown |  |
| rules_end_date | Unknown |  |
| rules_end_tz | Unknown |  |
| rules_has_end_date | Unknown |  |
| rules_limit_one_per_customer | Unknown |  |
| rules_limit_total | Unknown |  |
| rules_limit_total_amount | Unknown |  |
| rules_requirement | Unknown |  |
| rules_requirement_value | Unknown |  |
| rules_shipping_price_limit | Unknown |  |
| rules_specific_ids | Json |  |
| rules_start_date | Unknown |  |
| rules_start_tz | Unknown |  |
| updated_at | Instant |  |

### product_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| name | Unknown |  |
| position | Unknown |  |

### content

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| contact_id | Unknown | FK |
| content_id | Unknown | FK |
| content_rights_id | Unknown | FK |
| media_library_content_id | Unknown | FK |
| network_id | Unknown | FK |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| is_story | Unknown |  |
| job_id | Unknown |  |
| posted_at | Unknown |  |
| updated_at | Instant |  |

### content_stat

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| content_id | Unknown | FK |
| away_swipe | Unknown |  |
| comment | Unknown |  |
| created_at | Unknown |  |
| engagement | Unknown |  |
| engagement_rate | Unknown |  |
| exit | Unknown |  |
| impression | Unknown |  |
| imv | Unknown |  |
| interaction | Unknown |  |
| likes | Unknown |  |
| owner_reach | Unknown |  |
| reach | Unknown |  |
| reply | Unknown |  |
| reply_rate | Unknown |  |
| share | Unknown |  |
| taps_back | Unknown |  |
| taps_forward | Unknown |  |
| updated_at | Instant |  |
| view | Unknown |  |

### custom_property_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom_property_id | Unknown | PK, FK |
| label | Unknown |  |
| position | Unknown |  |
| slug | Unknown |  |
| value | Unknown |  |

### custom_property

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| external_label | Unknown |  |
| name | Unknown |  |
| slug | Unknown |  |
| type | Unknown |  |

### contact_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| city | Unknown |  |
| country | Unknown |  |
| country_code | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| label | Unknown |  |
| last_name | Unknown |  |
| phone_country_code | Unknown |  |
| phone_number | Unknown |  |
| phone_number_display | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |
| state_code | Unknown |  |
| street | Unknown |  |
| street_2 | Unknown |  |
| updated_at | Instant |  |

### contact_network

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| avg_comments | Unknown |  |
| avg_engagement | Unknown |  |
| avg_likes | Unknown |  |
| avg_likes_to_comment | Unknown |  |
| avg_posts_per_day | Unknown |  |
| avg_shares | Unknown |  |
| avg_views | Unknown |  |
| connection_last_checked_at | Unknown |  |
| created_at | Unknown |  |
| graph_id | Unknown |  |
| network | Unknown |  |
| network_account_type | Unknown |  |
| network_connection_permissions | Unknown |  |
| network_connection_type | Unknown |  |
| network_id | Unknown |  |
| network_name | Unknown |  |
| network_slug | Unknown |  |
| network_url | Unknown |  |
| network_user_id | Unknown |  |
| network_username | Unknown |  |
| profile | Unknown |  |
| reach | Unknown |  |
| reach_updated_at | Unknown |  |
| stats_updated_at | Unknown |  |
| updated_at | Instant |  |

### conversion

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| affiliate_link_id | Unknown | FK |
| brand_id | Unknown | FK |
| contact_id | Unknown | FK |
| discount_code_id | Unknown | FK |
| amount | Unknown |  |
| commission_amount | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| is_verified | Unknown |  |
| is_voided | Unknown |  |
| meta_data | Json |  |
| order_id | Unknown |  |
| order_number | Unknown |  |
| rate | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |
| void_reason | Unknown |  |
| voided_at | Unknown |  |

### affiliate_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| group_id | Unknown | FK |
| created_at | Unknown |  |
| destination_url | Unknown |  |
| end_date | Unknown |  |
| fraud_detected_at | Unknown |  |
| fraud_reason | Unknown |  |
| full_url | Unknown |  |
| query_parameter | Json |  |
| settings_creator_attribution | Unknown |  |
| settings_link_pattern | Unknown |  |
| settings_payout_amount | Unknown |  |
| settings_payout_tiers | Json |  |
| settings_payout_type | Unknown |  |
| start_date | Unknown |  |
| updated_at | Instant |  |
| url_path | Unknown |  |

### product_image

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| admin_graphql_api_id | Unknown |  |
| alt | Unknown |  |
| created_at | Unknown |  |
| height | Unknown |  |
| position | Unknown |  |
| src | Unknown |  |
| updated_at | Unknown |  |
| variant_id | Json |  |
| width | Unknown |  |

### collection

| Column | Type | Keys |
| --- | --- | --- |
| collection_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| brand_id | Unknown | FK |
| cost | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| external_id | Unknown |  |
| has_option | Unknown |  |
| image | Unknown |  |
| is_shipped | Unknown |  |
| name | Unknown |  |
| price | Unknown |  |
| qty | Unknown |  |
| shipping_cost | Unknown |  |
| sku | Unknown |  |
| track_inventory | Unknown |  |
| track_variant_inventory | Unknown |  |
| updated_at | Instant |  |

### product_collection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| brand_id | Unknown | FK |
| parent_id | Unknown | FK |
| children | Json |  |
| created_at | Unknown |  |
| description | Unknown |  |
| external_id | Unknown |  |
| image | Unknown |  |
| is_nav | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| updated_at | Instant |  |

### custom_property_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| partnership_id | Unknown | FK |
| property_id | Unknown | FK |
| created_at | Unknown |  |
| updated_at | Unknown |  |
| value | Json |  |

### affiliate_page_view

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| link_id | Unknown | FK |
| ip_address | Unknown |  |
| url | Unknown |  |
| metadata_** |  |  |

### team_user

| Column | Type | Keys |
| --- | --- | --- |
| team_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| defaults | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### media_library_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Instant |  |

## Relationships

- media_library_folder(parent_id) → media_library_folder(id)
- product_selection(brand_id) → brand(id)
- product_selection(contact_address_id) → contact_address(id)
- product_selection(contact_id) → contact(id)
- payable(payment_id) → payment(id)
- payable(contact_id) → contact(id)
- activation_brief(member_id) → users(id)
- activation_brief(activation_id) → activation(id)
- activation_brief(brand_id) → brand(id)
- activation_brief(contact_id) → contact(id)
- contact_custom_property(id) → custom_property_value(id)
- contact_custom_property(property_id) → custom_property(id)
- contact_custom_property(contact_id) → contact(id)
- contact_tag(contact_id) → contact(id)
- contact(payment_account_id) → payment_account(id)
- contact(owner_id) → users(id)
- contact(primary_contact_id) → contact(id)
- contact(primary_address_id) → contact_address(id)
- payment_item(payment_id) → payment(id)
- payment_item(contact_id) → contact(id)
- payment(user_id) → users(id)
- payment(campaign_id) → campaign(id)
- payment(payment_account_id) → payment_account(id)
- payment(contact_id) → contact(id)
- partnership_proposal(campaign_id) → campaign(id)
- partnership_proposal(content_rights_id) → content_rights(id)
- partnership_proposal(brand_id) → brand(id)
- partnership_proposal(contact_address_id) → contact_address(id)
- partnership_proposal(contact_id) → contact(id)
- partnership_proposal(partnership_id) → partnership(id)
- partnership_task(campaign_id) → campaign(id)
- partnership_task(network_id) → contact_network(network_id)
- partnership_task(partnership_id) → partnership(id)
- partnership(discount_code_group_id) → discount_code_group(id)
- partnership(affiliate_link_id) → affiliate_link(id)
- partnership(content_rights_id) → content_rights(id)
- partnership(brand_id) → brand(id)
- partnership(contact_id) → contact(id)
- partnership_job(task_id) → partnership_task(id)
- partnership_job(campaign_id) → campaign(id)
- partnership_job(proposal_id) → partnership_proposal(id)
- partnership_job(contact_id) → contact(id)
- discount_code(group_id) → discount_code_group(id)
- discount_code(ecommerce_account_id) → ecommerce_account(id)
- discount_code(contact_id) → contact(id)
- product_variant(product_id) → product(id)
- ecommerce_account(brand_id) → brand(id)
- user_role(users_id) → users(id)
- task(assignee_id) → users(id)
- task(creator_id) → users(id)
- task(contact_id) → contact(id)
- content_rights_selected(content_rights_id) → content_rights(id)
- campaign_compensation(campaign_id) → campaign(id)
- campaign(discount_code_group_id) → discount_code_group(id)
- campaign(team_id) → team(id)
- campaign(affiliate_link_id) → affiliate_link(id)
- campaign(brand_id) → brand(id)
- orders(user_id) → users(id)
- orders(campaign_id) → campaign(id)
- orders(product_selection_id) → product_selection(id)
- orders(ecommerce_account_id) → ecommerce_account(id)
- orders(contact_id) → contact(id)
- activation(team_id) → team(id)
- activation(brand_id) → brand(id)
- media_library_content_hashtag(media_library_content_id) → media_library_content(id)
- media_library_content_tag(media_library_content_id) → media_library_content(id)
- media_library_content(folder_id) → media_library_folder(id)
- media_library_content(campaign_id) → campaign(id)
- media_library_content(content_rights_id) → content_rights(id)
- media_library_content(network_id) → contact_network(network_id)
- media_library_content(content_id) → content(id)
- media_library_content(contact_id) → contact(id)
- media_library_content(owner_id) → users(id)
- link(id) → affiliate_link(id)
- link(group_id) → affiliate_link_group(id)
- affiliate_link_group(account_domain_id) → domain(id)
- affiliate_link_group(brand_id) → brand(id)
- product_selection_item(product_selection_id) → product_selection(id)
- product_selection_item(contact_id) → contact(id)
- product_selection_item(product_id) → product(id)
- product_selection_item(variant_id) → product_variant(id)
- product_option_value(option_id) → product_option(id)
- discount_code_group(ecommerce_account_id) → ecommerce_account(id)
- product_option(product_id) → product(id)
- content(campaign_id) → campaign(id)
- content(content_rights_id) → content_rights(id)
- content(network_id) → contact_network(network_id)
- content(media_library_content_id) → media_library_content(id)
- content(content_id) → content(id)
- content(contact_id) → contact(id)
- content_stat(content_id) → content(id)
- custom_property_option(custom_property_id) → custom_property(id)
- contact_address(contact_id) → contact(id)
- contact_network(contact_id) → contact(id)
- conversion(affiliate_link_id) → affiliate_link(id)
- conversion(brand_id) → brand(id)
- conversion(discount_code_id) → discount_code(id)
- conversion(contact_id) → contact(id)
- affiliate_link(group_id) → affiliate_link_group(id)
- affiliate_link(contact_id) → contact(id)
- product_image(product_id) → product(id)
- collection(collection_id) → product_collection(id)
- collection(product_id) → product(id)
- product(brand_id) → brand(id)
- product_collection(brand_id) → brand(id)
- product_collection(parent_id) → product_collection(id)
- custom_property_value(contact_id) → contact(id)
- custom_property_value(partnership_id) → partnership(id)
- custom_property_value(property_id) → custom_property(id)
- affiliate_page_view(link_id) → affiliate_link(id)
- team_user(user_id) → users(id)
- team_user(team_id) → team(id)