GRIN

Explore the interactive ERD

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	PKFK
`id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK

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	PKFK
`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	PKFK
`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	PKFK

media_library_content_tag

Column	Type	Keys
`id`	Unknown	PK
`media_library_content_id`	Unknown	PKFK
`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	PKFK
`id`	Unknown	PKFK

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	PKFK
`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	PKFK
`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	PKFK
`product_id`	Unknown	PKFK

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	PKFK
`user_id`	Unknown	PKFK

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