Data model

"ACCOUNT_SETTINGS_VERSION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_id": UUID 
  "account_management_level": VARCHAR 
  "end_date": DATE 
  "is_key_account": BOOLEAN 
  "start_date": DATE 
}
"BOOKMARK_ACCOUNT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_id": UUID 
  "user_id": VARCHAR 
}
"TURING_SEARCH_ACCOUNT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "am_level": VARCHAR 
  "app_name": VARCHAR 
  "company_count": INTEGER 
  "credibility": FLOAT 
  "employee_count": INTEGER 
  "franchise_name": VARCHAR 
  "is_key_account": BOOLEAN 
  "is_unmanaged_key_account": BOOLEAN 
  "live_health_contract_count": INTEGER 
  "live_prevoyance_contract_count": INTEGER 
  "loss_ratio_credibility": FLOAT 
  "max_end_date": DATE 
  "min_start_date": DATE 
  "n_live_primaries": INTEGER 
  "name": VARCHAR 
  "owner_name": VARCHAR 
  "signed_total_arr": FLOAT 
  "status": VARCHAR 
  "sub_industry": VARCHAR 
  "value_segment": VARCHAR 
}
"INSTANT_QUOTE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_ref": VARCHAR(255) 
  "competitor_product_refs": ARRAY 
  "contact_email": TEXT 
  "creator_display_name": TEXT 
  "creator_ref": TEXT 
  "expire_on": DATE 
  "introduction_paragraph": TEXT 
  "product_version_ref": VARCHAR(255) 
  "product_versions": ARRAY 
  "title": TEXT 
  "token": VARCHAR(255) 
}
"INSTANT_QUOTE_DEMOGRAPHICS" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "instant_quote_id": UUID 
  "n_primaries_alone": INTEGER 
  "n_primaries_with_1_child": INTEGER 
  "n_primaries_with_2_children": INTEGER 
  "n_primaries_with_partner": INTEGER 
  "n_primaries_with_partner_and_1_child": INTEGER 
  "n_primaries_with_partner_and_2_children": INTEGER 
}
"INSTANT_QUOTE_SETTINGS" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "instant_quote_id": UUID 
  "participation_children": FLOAT 
  "participation_partner": FLOAT 
  "participation_primary": FLOAT 
}
"INSTANT_QUOTE"."id" -> "INSTANT_QUOTE_DEMOGRAPHICS"."instant_quote_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSTANT_QUOTE"."id" -> "INSTANT_QUOTE_SETTINGS"."instant_quote_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
Hold "Alt" / "Option" to enable pan & zoom