Grin schema and ERD

66 tables

Loading diagram…

account_user

affiliate_link

contact_payment

content

content_right

discount_code

partnership

product

product_selection

proposal

account_brand

string

name

string

description

string

logo

string

url

string

currency

string

support_email

string

created_at

date

updated_at

date

_weld_synced

date

account_deposit

string

amount

double

total

double

state

string

failure_reason

string

created_at

date

updated_at

date

_weld_synced

date

account_domain

string

type

string

subdomain

string

is_white_labeled

boolean

created_at

date

updated_at

date

_weld_synced

date

account_team

string

name

string

default

boolean

created_at

date

updated_at

date

_weld_synced

date

account_user

string

first_name

string

last_name

string

phone

string

phone_country_code

string

profile_picture

string

timezone

string

created_at

date

updated_at

date

email_verified_at

date

_weld_synced

date

account_user_role

account_user_id

string

role

string

_weld_synced

date

activation

string

account_id

string

brand_id

string

team_id

string

image

string

name

string

public_name

string

description

string

type

string

activation_brief

string

activation_id

string

contact_id

string

account_id

string

brand_id

string

member_id

string

reviewed_at

date

type

string

status

string

previous_status

string

accepted_at

date

activation_member

string

activation_id

string

contact_id

string

contact_ids

string

is_paused

boolean

created_at

date

_weld_synced

date

affiliate_link

string

contact_id

string

group_id

string

destination_url

string

query_parameters

string

url_path

string

full_url

string

start_date

date

end_date

date

created_at

date

updated_at

date

_weld_synced

date

affiliate_page_view

string

link_id

string

url

string

ip_address

string

meta_data

string

_weld_synced

date

affiliate_link_group

string

account_domain_id

string

brand_id

string

name

string

destination_url

string

query_parameters

string

start_date

date

end_date

date

settings

string

attribution_window

double

cascade_update

boolean

created_at

date

updated_at

date

_weld_synced

date

campaign

string

discount_code_group_id

string

affiliate_link_id

string

brand_id

string

team_id

string

version

long

internal_title

string

influencer_title

string

image

string

budget

double

description

string

campaign_content

string

activation_id

string

campaign_id

string

contact_id

string

content_id

string

media_library_content_id

string

job_id

string

network_id

string

content_rights_id

string

is_story

boolean

posted_at

date

created_at

date

updated_at

date

deleted_at

date

_weld_synced

date

campaign_conversion

string

campaign_id

string

contact_id

string

discount_code_id

string

affiliate_link_id

string

activation_id

string

brand_id

string

type

string

order_id

string

order_number

string

amount

double

commission_amount

double

currency

string

rate

string

campaign_deliverable_task

string

campaign_id

string

network_id

string

name

string

description

string

position

long

is_required

boolean

media_type

string

requires_creator_oauth

boolean

deliverable_price

double

campaign_payable

string

campaign_id

string

contact_id

string

activation_id

string

payment_id

string

amount

double

currency

string

conversion_rate

double

usd_amount

double

status

string

payment_status

string

is_verified

boolean

contact

string

record_type

string

source

string

owner_id

string

stage_id

string

live_url_id

string

added_manually

boolean

profile_picture

string

first_name

string

contact_address

string

contact_id

string

label

string

first_name

string

last_name

string

phone_number

string

phone_country_code

string

phone_number_display

string

street

string

contact_campaign

string

contact_id

string

discount_code_group_id

string

affiliate_link_id

string

brand_id

string

team_id

string

version

long

internal_title

string

influencer_title

string

image

string

budget

double

description

string

contact_custom_property_value

string

contact_id

string

partnership_id

string

property_id

string

value

string

created_at

date

updated_at

date

_weld_synced

date

contact_network

string

contact_id

string

network_id

string

network_user_id

string

network_url

string

network_username

string

network_name

string

network_account_type

string

network_connection_type

string

network_connection_permissions

string

contact_order

string

product_selection_id

string

ecommerce_account_id

string

campaign_id

string

contact_id

string

campaign_proposal_id

string

user_id

string

external_order_id

string

fulfillments

string

shipment_status

string

shipment_status_date

date

created_at

date

updated_at

date

_weld_synced

date

contact_payment

string

campaign_id

string

payment_account_id

string

contact_id

string

activation_id

string

user_id

string

type

string

amount

double

currency

string

conversion_rate

double

batch_id

string

status

string

created_at

date

updated_at

date

sent_at

date

deleted_at

date

_weld_synced

date

contact_payment_item

string

contact_id

string

payment_id

string

amount

double

conversion

string

conversion_rate

double

created_at

date

currency

string

due_at

date

is_verified

boolean

contact_tag

string

name

string

_weld_synced

date

content

string

activation_id

string

campaign_id

string

contact_id

string

content_id

string

media_library_content_id

string

job_id

string

network_id

string

content_rights_id

string

is_story

boolean

network_name

string

network_slug

string

posted_at

date

created_at

date

updated_at

date

deleted_at

date

_weld_synced

date

content_stat

string

content_id

string

activation_id

string

owner_reach

double

imv

double

engagements

double

engagement_rate

double

views

double

likes

double

comments

double

media_library_content

string

activation_id

string

contact_id

string

campaign_id

string

content_id

string

content_rights_id

string

campaign_job_id

string

album_id

string

network_id

string

folder_id

string

source

string

is_story

boolean

is_reel

boolean

media_library_content_tag

string

media_library_content_id

string

name

string

_weld_synced

date

media_library_tag

string

name

string

created_at

date

updated_at

date

_weld_synced

date

content_right

string

rights_content_rights_header

string

created_at

date

updated_at

date

_weld_synced

date

content_right_selected_right

string

content_right_id

string

text

string

_weld_synced

date

conversion

string

contact_id

string

activation_id

string

activation_member_id

string

activation_brief_id

string

discount_code_id

string

affiliate_link_id

string

account_id

string

brand_id

string

type

string

external_id

string

order_number

string

amount

double

commission_amount

double

currency

string

custom_property

string

name

string

external_label

string

slug

string

description

string

type

string

_weld_synced

date

custom_property_option

string

field_id

string

label

string

slug

string

value

string

position

string

_weld_synced

date

custom_property_value

string

contact_id

string

partnership_id

string

property_id

string

value

string

created_at

date

updated_at

date

_weld_synced

date

deliverable_task

string

campaign_id

string

network_id

string

name

string

description

string

position

long

is_required

boolean

media_type

string

requires_creator_oauth

boolean

deliverable_price

double

discount_code

string

ecommerce_account_id

string

contact_id

string

external_id

string

group_id

string

code

string

start_date

date

end_date

date

created_at

date

updated_at

date

disabled_at

date

disabled_reason

string

deleted_at

date

_weld_synced

date

discount_code_group

string

ecommerce_account_id

string

external_id

string

name

string

code_pattern

string

affiliatepayout_amount

double

affiliatepayout_type

string

rules_applies_to

string

rules_cascade_update_amount

boolean

rules_customer_group_ids

string

ecommerce_account

string

brand_id

string

provider

string

created_at

date

updated_at

date

_weld_synced

date

media_library_folder

string

parent_id

string

name

string

created_at

date

updated_at

date

_weld_synced

date

partnership

string

contact_id

string

discount_code_group_id

string

affiliate_link_id

string

brand_id

string

internal_title

string

influencer_title

string

image

string

budget

double

description

string

short_description

string

content_rights_id

string

partnership_proposal

string

partnership_id

string

campaign_id

string

contact_address_id

string

contact_id

string

brand_id

string

content_rights_id

string

accepted_at

date

agreed

boolean

agreed_at

date

completed_at

date

created_at

date

declined_at

date

partnership_job

string

partnership_id

string

campaign_id

string

contact_id

string

proposal_id

string

task_id

string

media_library_content_id

string

content_posted_at

date

created_at

date

delivered_at

date

due_at

date

is_extra

boolean

is_global

boolean

note

string

status

string

status_info

string

type

string

updated_at

date

_weld_synced

date

partnership_task

string

partnership_id

string

campaign_id

string

network_id

string

bio_text

string

created_at

date

deliverable_price

double

description

string

interval_index

long

is_required

boolean

media_type

string

payable

string

contact_id

string

activation_id

string

payment_id

string

amount

double

currency

string

conversion_rate

double

usd_amount

double

status

string

payment_status

string

is_verified

boolean

payment_account

string

reference_id

string

created_at

date

updated_at

date

_weld_synced

date

product

string

brand_id

string

name

string

cost

double

price

double

image

string

description

string

has_options

boolean

is_shipped

boolean

product_option

string

product_id

string

name

string

position

long

_weld_synced

date

product_variant

string

product_id

string

external_id

string

sku

string

cost

double

price

double

shipping_cost

double

qty

long

_weld_synced

date

product_variant_option

variant_id

string

option_id

string

_weld_synced

date

product_variant_option_value

variant_id

string

option_value_id

string

_weld_synced

date

product_image

string

product_id

string

admin_graphql_api_id

string

alt

string

src

string

width

long

height

long

position

long

variant_ids

string

created_at

date

updated_at

date

_weld_synced

date

product_collection_relationship

product_id

string

collection_id

string

_weld_synced

date

product_collection

string

brand_id

string

parent_id

string

external_id

string

is_nav

boolean

name

string

description

string

image

string

position

long

created_at

date

updated_at

date

_weld_synced

date

product_option_value

string

option_id

string

name

string

position

long

_weld_synced

date

product_selection

string

contact_id

string

proposal_id

string

contact_address_id

string

brand_id

string

order_status

string

order_status_updated_at

date

order_errors

string

is_fulfilled

boolean

created_at

date

updated_at

date

fulfilled_at

date

_weld_synced

date

product_selection_item

string

product_selection_id

string

contact_id

string

product_id

string

variant_id

string

created_at

date

updated_at

date

_weld_synced

date

proposal

string

campaign_id

string

contact_id

string

contact_address_id

string

partnership_id

string

brand_id

string

content_rights_id

string

notes

string

price

double

is_complete

boolean

start_date

date

end_date

date

has_product

boolean

proposal_file

string

campaign_id

string

proposal_id

string

contact_id

string

name

string

mime

string

label

string

size

double

created_at

date

updated_at

date

deleted_at

date

_weld_synced

date

proposal_note

string

campaign_id

string

proposal_id

string

user_id

string

text

string

created_at

date

updated_at

date

_weld_synced

date

proposal_deliverable

string

campaign_id

string

proposal_id

string

task_id

string

contact_id

string

media_library_content_id

string

status

string

status_info

string

is_global

boolean

is_extra

boolean

notes

string

created_at

date

updated_at

date

due_at

date

delivered_at

date

content_posted_at

date

_weld_synced

date

proposal_deliverable_content

string

activation_id

string

campaign_id

string

contact_id

string

content_id

string

media_library_content_id

string

job_id

string

network_id

string

content_rights_id

string

is_story

boolean

posted_at

date

created_at

date

updated_at

date

deleted_at

date

_weld_synced

date

relationship_stage

string

type

string

name

string

position

long

_weld_synced

date

task

string

contact_id

string

creator_id

string

assignee_id

string

name

string

type

string

notes

string

created_at

date

updated_at

date

due_at

date

completed_at

date

_weld_synced

date