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