Data model
"GROWTH_SETTING" {
shape: sql_table
"id": UUID {constraint: primary_key}
"name": VARCHAR(255)
"value": VARCHAR(255)
}
"SELF_SERVE_FEEDBACK" {
shape: sql_table
"id": UUID {constraint: primary_key}
"country_code": VARCHAR(255)
"email": VARCHAR(255)
"flow_type": VARCHAR(255)
"survey_response": JSONB
}
"SELF_SERVE_FLOW_PROGRESS" {
shape: sql_table
"id": UUID {constraint: primary_key}
"country_code": VARCHAR(255)
"flow_type": VARCHAR(255)
"proposal_ref": UUID
"state": JSONB
"user_ref": VARCHAR(255)
}
"referral"."REFERRAL_PROFILE" {
shape: sql_table
"id": UUID {constraint: primary_key}
"profile_id": UUID
"referral_token": VARCHAR(32)
}
"referral"."REFERRAL" {
shape: sql_table
"id": UUID {constraint: primary_key}
"referred_contract_ref": VARCHAR(64)
"referred_contract_rewarded_on": DATE
"referred_country_code": VARCHAR(2)
"referred_profile_id": UUID
"referring_partner": VARCHAR(255)
"referring_profile_id": UUID
"referring_user_has_received_amount": INTEGER
"referring_user_rewarded_at": DATETIME
}
"referral"."REFERRAL_REWARD" {
shape: sql_table
"id": UUID {constraint: primary_key}
"amount": INTEGER
"country_code": VARCHAR(2)
"start_date": DATE
"type": VARCHAR
}
"referral"."REFERRAL_REWARD_PARTNERSHIP" {
shape: sql_table
"id": UUID {constraint: primary_key}
"country_code": VARCHAR(2)
"description_for_users": JSONB
"discount_amount_for_children_in_cents": INTEGER
"discount_amount_for_partner_in_cents": INTEGER
"discount_amount_for_primary_in_cents": INTEGER
"discount_free_month": BOOLEAN
"discount_length_in_months": INTEGER
"end_date": DATE
"referring_partner": VARCHAR
}
"referral"."REFERRAL_PROFILE"."id" -> "referral"."REFERRAL"."referred_profile_id": {
source-arrowhead.shape: cf-one-required
target-arrowhead.shape: cf-many
}
"referral"."REFERRAL_PROFILE"."id" -> "referral"."REFERRAL"."referring_profile_id": {
source-arrowhead.shape: cf-one
target-arrowhead.shape: cf-many
}
Hold "Alt" / "Option" to enable pan & zoom