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