Data model

"GROWTH_SETTING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "name": VARCHAR(255) 
  "value": VARCHAR(255) 
}
"PROSPECT" {
  shape: sql_table
  "id": INTEGER {constraint: primary_key}
  "alan_partner_code": VARCHAR(255) 
  "ape_code": VARCHAR(255) 
  "attribution_survey_response": JSONB 
  "ccn_code": VARCHAR(10) 
  "close_opportunity_survey_response": JSONB 
  "email": VARCHAR(255) 
  "has_opted_in_to_commercial_emails": BOOLEAN 
  "individual_postal_code": INTEGER 
  "learnings_survey_response_list": JSONB 
  "number_of_children": INTEGER 
  "number_of_employees": INTEGER 
  "partner_age": INTEGER 
  "phone": VARCHAR(16) 
  "postal_code": INTEGER 
  "primary_age": INTEGER 
  "secondary_email": VARCHAR(255) 
  "segment": VARCHAR(255) 
  "siren": VARCHAR(9) 
  "year_founded": INTEGER 
}
"PROSPECT_EVENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "country_code": VARCHAR(2) 
  "event_name": VARCHAR(255) 
  "event_properties": JSONB 
  "marketing_parameters": JSONB 
  "persona_type": VARCHAR(255) 
  "prospect_id": INTEGER 
}
"REFERRAL_PROFILE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "referral_token": VARCHAR(32) 
  "user_id": VARCHAR 
}
"REFERRAL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "legacy_referral_id": INTEGER 
  "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_REWARD" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount": INTEGER 
  "country_code": VARCHAR(2) 
  "start_date": DATE 
  "type": VARCHAR 
}
"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 
}
"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) 
}
"PROSPECT"."id" -> "PROSPECT_EVENT"."prospect_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"REFERRAL_PROFILE"."id" -> "REFERRAL"."referring_profile_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"REFERRAL_PROFILE"."id" -> "REFERRAL"."referred_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}

Hold "Alt" / "Option" to enable pan & zoom