Data model

"subscription"."SUBSCRIPTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "owner_ref": VARCHAR 
  "owner_type": VARCHAR 
  "payload_ref": UUID 
  "subscription_scope": VARCHAR(255) 
}
"subscription"."SUBSCRIPTION_VERSION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "end_date": DATE 
  "operation_ref": VARCHAR(255) 
  "payload_ref": UUID 
  "start_date": DATE 
  "subscription_ref": VARCHAR 
  "subscription_scope": VARCHAR(255) 
}
"subscription"."SUBSCRIPTION_UPDATE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "end_date": DATE 
  "is_deletion": BOOLEAN 
  "operation_ref": VARCHAR(255) 
  "payload_ref": UUID 
  "revision": INTEGER 
  "start_date": DATE 
  "subscription_ref": VARCHAR 
  "subscription_scope": VARCHAR(255) 
}
"SUBSCRIPTION_PERIOD_NOTIFICATION_SETTING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "communication_choice": VARCHAR(255) 
  "custom_blocks_variation_id": VARCHAR 
  "first_sent_at": DATETIME 
  "notification_type": VARCHAR(255) 
  "scheduled_at": DATETIME 
  "shoot_id": UUID 
  "subscription_period_ref": VARCHAR 
  "subscription_type": VARCHAR(255) 
}
"TURING_ACCOUNT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_name": VARCHAR 
  "account_size": INTEGER 
  "alan_play_enrollment_ratio": FLOAT 
  "am_level": VARCHAR 
  "app_name": VARCHAR 
  "bankruptcy_types": ARRAY 
  "churn_risk_score": INTEGER 
  "churn_segment_category": VARCHAR 
  "default_renewal_channel": VARCHAR 
  "franchise_name": VARCHAR 
  "has_companies_in_bankruptcy": BOOLEAN 
  "has_companies_in_liquidation": BOOLEAN 
  "has_enough_care_events_privacy": BOOLEAN 
  "is_dormant": BOOLEAN 
  "is_eligible_to_account_level_loss_ratio": BOOLEAN 
  "is_eligible_to_evin_report": BOOLEAN 
  "is_key_account": BOOLEAN 
  "is_unmanaged_key_account": BOOLEAN 
  "main_churn_risk_reason": VARCHAR 
  "max_end_date": DATE 
  "min_start_date": DATE 
  "salesforce_owner_alan_employee_id": INTEGER 
  "salesforce_owner_name": VARCHAR 
  "status": VARCHAR 
  "sub_industry": VARCHAR 
  "value_segment": VARCHAR 
}
"account_hub"."ACCOUNT_SETTINGS" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_ref": UUID 
  "price_stability_mechanism": VARCHAR(255) 
  "price_stability_mechanism_ends_at": DATETIME 
  "price_stability_mechanism_starts_at": DATETIME 
}
"account_hub"."CHURN_RISK_ALERT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_ref": UUID 
  "comment": TEXT 
  "creator_full_name": VARCHAR(255) 
  "creator_ref": VARCHAR(255) 
  "risk_type": VARCHAR(255) 
  "state": VARCHAR(255) 
}
"dashboard"."ACTIVITY_LOG" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_ref": UUID 
  "activity_type": TEXT 
  "company_ref": VARCHAR(255) 
  "link": VARCHAR(255) 
  "logged_username": TEXT 
  "message": TEXT 
  "proposal_id": VARCHAR(255) 
  "subscription_ref": VARCHAR(255) 
  "subscription_type": VARCHAR(255) 
  "user_ref": VARCHAR(255) 
}
"insights"."TURING_METRICS_PER_HEALTH_SUBSCRIPTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_ref": VARCHAR 
  "contract_size": INTEGER 
  "n_1st_or_2nd_children": INTEGER 
  "n_1st_or_2nd_children_option": INTEGER 
  "n_1st_or_2nd_children_option2": INTEGER 
  "n_employees": INTEGER 
  "n_live_children": INTEGER 
  "n_live_families": INTEGER 
  "n_live_families_option": INTEGER 
  "n_live_partners": INTEGER 
  "n_live_partners_option": INTEGER 
  "n_live_primaries": INTEGER 
  "n_live_primaries_option": INTEGER 
  "n_live_primaries_option2": INTEGER 
  "n_primaries_with_children": INTEGER 
  "n_primaries_with_children_option": INTEGER 
  "n_primaries_with_children_option2": INTEGER 
  "subscription_ref": VARCHAR 
  "subscriptor_ref": VARCHAR 
}
"insights"."TURING_USER_EXPERIMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "arg1": VARCHAR 
  "arg10": VARCHAR 
  "arg2": VARCHAR 
  "arg3": VARCHAR 
  "arg4": VARCHAR 
  "arg5": VARCHAR 
  "arg6": VARCHAR 
  "arg7": VARCHAR 
  "arg8": VARCHAR 
  "arg9": VARCHAR 
}
"legal_document"."DOCUMENT_SHORTLINK" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "document_metadata": JSONB 
  "document_type": VARCHAR(255) 
  "language": VARCHAR(7) 
  "segment": VARCHAR(255) 
  "subscription_scope": VARCHAR(255) 
}
"legal_document"."LEGAL_CLAUSE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "app_name": TEXT 
  "clause_type": VARCHAR(255) 
  "contents": JSONB 
  "creator_display_name": TEXT 
  "creator_ref": TEXT 
  "legal_document_type": VARCHAR(255) 
  "name": VARCHAR(255) 
  "sorting_index": INTEGER 
  "subscription_scope": VARCHAR(255) 
  "titles": JSONB 
}
"legal_document"."LEGAL_DOCUMENT_TEMPLATE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "app_name": TEXT 
  "content": TEXT 
  "content_type": VARCHAR(255) 
  "creator_display_name": TEXT 
  "creator_ref": TEXT 
  "fragment_name": VARCHAR(255) 
  "language": VARCHAR(255) 
  "published_at": DATETIME 
  "publisher_display_name": TEXT 
  "publisher_ref": TEXT 
  "release_date": DATE 
  "revision": INTEGER 
  "subscription_scope": VARCHAR(255) 
}
"legal_document"."LEGAL_DOCUMENT_MATCHER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "document_type": VARCHAR(255) 
  "legal_document_template_id": UUID 
  "segment": VARCHAR(255) 
}
"legal_document"."SUBSCRIPTION_CUSTOM_CLAUSE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_ref": VARCHAR(255) 
  "app_name": TEXT 
  "legal_clause_id": UUID 
  "subscription_period_ref": VARCHAR(255) 
  "subscription_ref": VARCHAR(255) 
}
"proposal"."PROPOSAL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "app_name": TEXT 
  "cancel_after": DATE 
  "creator_display_name": TEXT 
  "creator_ref": TEXT 
  "expire_after": DATE 
  "finalizor_display_name": TEXT 
  "finalizor_ref": TEXT 
  "language": TEXT 
  "lifecycle_notifications": ARRAY 
  "name": TEXT 
  "origin": TEXT 
  "renewal_campaign_name": TEXT 
  "state": TEXT 
  "subscriptor_scope": ARRAY 
  "tags": ARRAY 
}
"proposal"."PROPOSAL_ITEM" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "internal_metadata": JSONB 
  "name": TEXT 
  "noncompliance_acknowledgement_link": TEXT 
  "plugin_id": TEXT 
  "product_ref": TEXT 
  "proposal_id": UUID 
  "settings": JSONB 
  "start_date": DATE 
}
"proposal"."PROPOSAL_ITEM_TARGET" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_ref": TEXT 
  "activity_type": VARCHAR 
  "app_name": TEXT 
  "ccn_id": INTEGER 
  "internal_metadata": JSONB 
  "professional_category": VARCHAR 
  "proposal_item_id": UUID 
  "subscription_ref": TEXT 
  "subscription_type": TEXT 
  "subscriptor_legal_status": TEXT 
  "subscriptor_ref": TEXT 
}
"proposal"."SIGNED_BUNDLE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "documents_metadata": JSONB 
  "requester_first_name": TEXT 
  "requester_last_name": TEXT 
  "requester_ref": VARCHAR 
  "signature_id": VARCHAR(255) 
  "signature_request_all_signed_at": DATETIME 
  "signature_request_all_signed_event": JSONB 
  "signature_request_id": VARCHAR(255) 
  "signature_step": VARCHAR(255) 
  "signer": JSONB 
  "uri": VARCHAR(2083) 
}
"proposal"."APPROVAL_REQUEST" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "activity_logs": ARRAY 
  "approved_at": DATETIME 
  "approver_email": TEXT 
  "approver_first_name": TEXT 
  "approver_last_name": TEXT 
  "approver_ref": TEXT 
  "auto_approve_after": DATE 
  "can_be_forwarded": BOOLEAN 
  "cc_recipients": ARRAY 
  "client_signed_at": DATETIME 
  "document_provider_type": TEXT 
  "is_approved": BOOLEAN 
  "is_approver_external": BOOLEAN 
  "is_withdrawn": BOOLEAN 
  "notification_type": TEXT 
  "onfido_workflow_run_id": UUID 
  "proposal_id": UUID 
  "reminder_scheduled_at": DATE 
  "reminder_sent_at": DATETIME 
  "signed_bundle_id": UUID 
}
"proposal"."MANUAL_DOCUMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "approval_request_id": UUID 
  "document_key": VARCHAR(255) 
  "document_metadata": JSONB 
  "proposal_item_target_id": UUID 
  "provided_at": DATETIME 
  "uri": VARCHAR(2083) 
}
"proposal"."PREVIEWED_DOCUMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "document_key": VARCHAR(255) 
  "document_metadata": JSONB 
  "file_name": VARCHAR(255) 
  "language": VARCHAR(255) 
  "proposal_id": UUID 
  "uri": VARCHAR(2083) 
}
"proposal"."PROPOSAL_ERROR" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "code": TEXT 
  "context": JSONB 
  "has_been_bypassed": BOOLEAN 
  "message": TEXT 
  "proposal_id": UUID 
  "require_acknowledgement_link": BOOLEAN 
  "scope": TEXT 
  "seen_at": DATETIME 
  "severity_level": TEXT 
  "username": TEXT 
}
"proposal"."PROPOSAL_ITEM_TEMPLATE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "custom_template_uri": TEXT 
  "language": TEXT 
  "proposal_item_id": UUID 
  "template_type": TEXT 
}
"proposal"."SIGNED_DOCUMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "document_key": VARCHAR(255) 
  "document_metadata": JSONB 
  "signed_at": DATETIME 
  "signed_bundle_id": UUID 
  "uri": VARCHAR(2083) 
}
"proposal"."TARGET_ORIGIN_PROPOSAL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "internal_metadata": JSONB 
  "proposal_id": UUID 
  "target_ref": TEXT 
  "target_type": VARCHAR(255) 
}
"renewal"."RENEWAL_CAMPAIGN_CONFIGURATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "admin_announcement_campaign": TEXT 
  "admin_reminder_campaign": TEXT 
  "app_name": TEXT 
  "campaign_name": VARCHAR(255) 
  "contractee_type": VARCHAR(25) 
  "default_admin_announcement_date": DATETIME 
  "default_admin_reminder_date": DATETIME 
  "default_employee_announcement_date": DATETIME 
  "default_renewal_date": DATE 
  "default_tacit_approval_date": DATETIME 
  "employee_announcement_campaign": TEXT 
  "end_date": DATE 
  "health_scope_cutoff_date": DATE 
  "is_admin_dashboard_experience_enabled": BOOLEAN 
  "is_auto_admin_announcement_enabled": BOOLEAN 
  "is_auto_employee_announcement_enabled": BOOLEAN 
  "is_auto_proposal_creation_enabled": BOOLEAN 
  "is_auto_reminder_announcement_enabled": BOOLEAN 
  "is_auto_specs_import_enabled": BOOLEAN 
  "is_auto_tacit_approval_enabled": BOOLEAN 
  "prevoyance_scope_cutoff_date": DATE 
  "start_date": DATE 
  "tacit_approval_confirmation_campaign": TEXT 
}
"renewal"."RENEWAL_PRODUCT_CHANGE_SELECTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "contractee_renewal_operation_id": UUID 
  "product_id": VARCHAR(255) 
  "turing_renewal_product_change_slug": VARCHAR(255) 
}
"renewal"."TURING_RENEWAL_PRODUCT_CHANGE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_id": VARCHAR(255) 
  "account_id_or_user_id": VARCHAR(255) 
  "app_name": TEXT 
  "campaign_name": VARCHAR(255) 
  "change_metadata": JSONB 
  "changes_overview": JSONB 
  "collective_retiree_account_id": UUID 
  "contract_type": VARCHAR(32) 
  "contractee_segment": VARCHAR(32) 
  "formula": JSONB 
  "internal_description": TEXT 
  "internal_display_name": VARCHAR 
  "is_default": BOOLEAN 
  "is_self_serve_eligible": BOOLEAN 
  "name": TEXT 
  "product_id": VARCHAR(255) 
  "slug": TEXT 
  "user_id": VARCHAR(255) 
}
"renewal"."TURING_RENEWAL_PRODUCT_CHANGE_LOG" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_id": VARCHAR(255) 
  "account_id_or_user_id": VARCHAR(255) 
  "app_name": TEXT 
  "campaign_name": VARCHAR(255) 
  "change_metadata": JSONB 
  "changes_overview": JSONB 
  "collective_retiree_account_id": UUID 
  "contract_type": VARCHAR(32) 
  "contractee_segment": VARCHAR(32) 
  "formula": JSONB 
  "internal_description": TEXT 
  "internal_display_name": VARCHAR 
  "is_default": BOOLEAN 
  "is_self_serve_eligible": BOOLEAN 
  "name": TEXT 
  "product_id": VARCHAR(255) 
  "slug": TEXT 
  "user_id": VARCHAR(255) 
}
"renewal"."CONTRACTEE_RENEWAL_OPERATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_id": UUID 
  "account_id_or_user_id": VARCHAR(255) 
  "admin_announcement_clicked_at": DATETIME 
  "admin_announcement_custom_blocks_variation_id": VARCHAR 
  "admin_announcement_delivered_at": DATETIME 
  "admin_announcement_opened_at": DATETIME 
  "admin_announcement_requested_at": DATETIME 
  "admin_announcement_scheduled_at": DATETIME 
  "admin_announcement_sent_at": DATETIME 
  "admin_announcement_shoot_id": UUID 
  "admin_reminder_clicked_at": DATETIME 
  "admin_reminder_delivered_at": DATETIME 
  "admin_reminder_opened_at": DATETIME 
  "admin_reminder_requested_at": DATETIME 
  "admin_reminder_scheduled_at": DATETIME 
  "admin_reminder_sent_at": DATETIME 
  "admin_reminder_shoot_id": UUID 
  "app_name": TEXT 
  "apply_min_price": BOOLEAN 
  "campaign_name": TEXT 
  "contractee_name": VARCHAR(255) 
  "contractee_type": VARCHAR(25) 
  "employee_announcement_custom_blocks_variation_id": VARCHAR 
  "employee_announcement_delivered_at": DATETIME 
  "employee_announcement_requested_at": DATETIME 
  "employee_announcement_scheduled_at": DATETIME 
  "employee_announcement_sent_at": DATETIME 
  "employee_announcement_shoot_id": UUID 
  "first_presented_renewal_product_change_ids": ARRAY 
  "is_admin_dashboard_experience_enabled_for_contractee": BOOLEAN 
  "manual_renewal_owner_display_name": VARCHAR(255) 
  "manual_renewal_owner_ref": VARCHAR(255) 
  "tacit_announcement_clicked_at": DATETIME 
  "tacit_announcement_delivered_at": DATETIME 
  "tacit_announcement_opened_at": DATETIME 
  "tacit_announcement_requested_at": DATETIME 
  "tacit_announcement_scheduled_at": DATETIME 
  "tacit_announcement_sent_at": DATETIME 
  "tacit_announcement_shoot_id": UUID 
  "tacit_approval_completed_at": DATETIME 
  "tacit_approval_scheduled_at": DATETIME 
  "tags": ARRAY 
  "target_date": DATE 
  "user_id": VARCHAR(255) 
}
"renewal"."RENEWAL_SPECS" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_ref": UUID 
  "app_name": TEXT 
  "approved_at": DATETIME 
  "campaign_name": TEXT 
  "cancelled_at": DATETIME 
  "company_ref": VARCHAR(255) 
  "contract_id": VARCHAR(255) 
  "contract_type": VARCHAR(25) 
  "contractee_type": VARCHAR(25) 
  "dimension": VARCHAR(255) 
  "dismissed_at": DATETIME 
  "overridden_at": DATETIME 
  "proposal_id": UUID 
  "spec_id": VARCHAR(255) 
  "spec_metadata": JSONB 
  "state": TEXT 
  "target_date": DATE 
  "user_ref": VARCHAR(255) 
  "value": VARCHAR(255) 
}
"renewal"."ACCOUNT_RENEWAL_CAMPAIGN" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_name": VARCHAR(255) 
  "account_ref": UUID 
  "admin_announcement_clicked_at": DATETIME 
  "admin_announcement_custom_blocks_variation_id": VARCHAR 
  "admin_announcement_delivered_at": DATETIME 
  "admin_announcement_opened_at": DATETIME 
  "admin_announcement_requested_at": DATETIME 
  "admin_announcement_scheduled_at": DATETIME 
  "admin_announcement_sent_at": DATETIME 
  "admin_announcement_shoot_id": UUID 
  "admin_reminder_clicked_at": DATETIME 
  "admin_reminder_delivered_at": DATETIME 
  "admin_reminder_opened_at": DATETIME 
  "admin_reminder_requested_at": DATETIME 
  "admin_reminder_scheduled_at": DATETIME 
  "admin_reminder_sent_at": DATETIME 
  "admin_reminder_shoot_id": UUID 
  "admin_tacit_approval_announcement_clicked_at": DATETIME 
  "admin_tacit_approval_announcement_delivered_at": DATETIME 
  "admin_tacit_approval_announcement_opened_at": DATETIME 
  "admin_tacit_approval_announcement_requested_at": DATETIME 
  "admin_tacit_approval_announcement_sent_at": DATETIME 
  "admin_tacit_approval_announcement_shoot_id": UUID 
  "app_name": TEXT 
  "campaign_name": TEXT 
  "employee_announcement_custom_blocks_variation_id": VARCHAR 
  "employee_announcement_delivered_at": DATETIME 
  "employee_announcement_requested_at": DATETIME 
  "employee_announcement_scheduled_at": DATETIME 
  "employee_announcement_sent_at": DATETIME 
  "employee_announcement_shoot_id": UUID 
  "manual_renewal_channel": VARCHAR(255) 
  "manual_renewal_owner_display_name": VARCHAR(255) 
  "manual_renewal_owner_ref": VARCHAR(255) 
  "tacit_approval_scheduled_at": DATETIME 
  "tags": ARRAY 
  "target_date": DATE 
}
"renewal"."INDIV_RENEWAL_CAMPAIGN" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "app_name": TEXT 
  "campaign_name": TEXT 
  "tacit_announcement_delivered_at": DATETIME 
  "tacit_announcement_opened_at": DATETIME 
  "tacit_announcement_requested_at": DATETIME 
  "tacit_announcement_scheduled_at": DATETIME 
  "tacit_announcement_sent_at": DATETIME 
  "tacit_announcement_shoot_id": UUID 
  "tacit_approval_completed_at": DATETIME 
  "tacit_approval_scheduled_at": DATETIME 
  "tags": ARRAY 
  "target_date": DATE 
  "user_display_name": VARCHAR(255) 
  "user_ref": VARCHAR(255) 
}
"renewal"."SUBSCRIPTION_RENEWAL_DETAILS" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "admin_group_loss_ratio": FLOAT 
  "admin_group_min_start_date": DATE 
  "admin_group_ref": TEXT 
  "channel": TEXT 
  "contract_new_bundle_version": TEXT 
  "contract_renewed_bundle_version": TEXT 
  "contract_start_date": DATE 
  "eligible_for_renewal": BOOLEAN 
  "has_coverage_change": BOOLEAN 
  "has_price_change": BOOLEAN 
  "has_tc_change": BOOLEAN 
  "in_renewal_scope": BOOLEAN 
  "mutualization_segment": TEXT 
  "mutualization_segment_health_claims_cost": FLOAT 
  "mutualization_segment_health_premium": FLOAT 
  "mutualization_segment_loss_ratio": FLOAT 
  "mutualization_type": TEXT 
  "n_ani_primaries": INTEGER 
  "n_insured_employees": INTEGER 
  "n_live_children": INTEGER 
  "n_live_children_option": INTEGER 
  "n_live_children_option2": INTEGER 
  "n_live_families": INTEGER 
  "n_live_families_option": INTEGER 
  "n_live_families_option2": INTEGER 
  "n_live_isole": INTEGER 
  "n_live_partners": INTEGER 
  "n_live_partners_option": INTEGER 
  "n_live_partners_option2": INTEGER 
  "n_live_primaries": INTEGER 
  "n_live_primaries_option": INTEGER 
  "n_live_primaries_option2": INTEGER 
  "n_primaries_with_children": INTEGER 
  "price_increase_target": FLOAT 
  "renewal_date": DATE 
  "subscription_ref": TEXT 
  "subscriptor_ref": TEXT 
  "subscriptor_type": TEXT 
}
"renewal"."RENEWAL_ADMIN_FLOW" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "admin_ref": TEXT 
  "is_cancelled": BOOLEAN 
  "subscription_ref": TEXT 
}
"renewal"."RENEWAL_ADMIN_FLOW_ACTIVITY_LOG" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "activity_type": TEXT 
  "logged_username": TEXT 
  "message": TEXT 
  "renewal_admin_flow_id": UUID 
}
"renewal"."RENEWAL_PROPOSAL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "admin_handles_employee_notification": BOOLEAN 
  "proposal_ref": UUID 
  "subscription_ref": TEXT 
}
"subscription"."GLOBAL_CONTRACT_VERSION_VIEW" {
  shape: sql_table
  "primary_key": UUID {constraint: primary_key}
  "account_id": UUID 
  "account_id_or_user_id": VARCHAR 
  "app_name": VARCHAR 
  "contract_id": VARCHAR 
  "end_date": DATE 
  "id": UUID 
  "is_on_new_legal_doc_stack": BOOLEAN 
  "origin": VARCHAR 
  "product_id": VARCHAR 
  "product_name": VARCHAR 
  "signed_at": DATE 
  "start_date": DATE 
  "subscription_type": VARCHAR 
  "subscriptor_display_name": VARCHAR 
  "subscriptor_id": VARCHAR 
  "subscriptor_legal_status": VARCHAR 
  "tags": ARRAY 
}
"subscription"."DUMMY_OFFER_VERSION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "name": VARCHAR 
}
"subscription"."DUMMY_PROPERTIES" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "offer_version_id": UUID 
  "participation": FLOAT 
}
"subscription"."DUMMY_CONTRACTEE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "name": VARCHAR 
}
"subscription"."DUMMY_SUBSCRIPTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "contractee_id": UUID 
}
"legal_document"."LEGAL_DOCUMENT_TEMPLATE"."id" -> "legal_document"."LEGAL_DOCUMENT_MATCHER"."legal_document_template_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"legal_document"."LEGAL_CLAUSE"."id" -> "legal_document"."SUBSCRIPTION_CUSTOM_CLAUSE"."legal_clause_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"proposal"."PROPOSAL"."id" -> "proposal"."PROPOSAL_ITEM"."proposal_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"proposal"."PROPOSAL_ITEM"."id" -> "proposal"."PROPOSAL_ITEM_TARGET"."proposal_item_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"proposal"."PROPOSAL"."id" -> "proposal"."APPROVAL_REQUEST"."proposal_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"proposal"."SIGNED_BUNDLE"."id" -> "proposal"."APPROVAL_REQUEST"."signed_bundle_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"proposal"."PROPOSAL_ITEM_TARGET"."id" -> "proposal"."MANUAL_DOCUMENT"."proposal_item_target_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"proposal"."APPROVAL_REQUEST"."id" -> "proposal"."MANUAL_DOCUMENT"."approval_request_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"proposal"."PROPOSAL"."id" -> "proposal"."PREVIEWED_DOCUMENT"."proposal_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"proposal"."PROPOSAL"."id" -> "proposal"."PROPOSAL_ERROR"."proposal_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"proposal"."PROPOSAL_ITEM"."id" -> "proposal"."PROPOSAL_ITEM_TEMPLATE"."proposal_item_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"proposal"."SIGNED_BUNDLE"."id" -> "proposal"."SIGNED_DOCUMENT"."signed_bundle_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"proposal"."PROPOSAL"."id" -> "proposal"."TARGET_ORIGIN_PROPOSAL"."proposal_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"renewal"."RENEWAL_CAMPAIGN_CONFIGURATION"."campaign_name" -> "renewal"."CONTRACTEE_RENEWAL_OPERATION"."campaign_name": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"proposal"."PROPOSAL"."id" -> "renewal"."RENEWAL_SPECS"."proposal_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"renewal"."RENEWAL_CAMPAIGN_CONFIGURATION"."campaign_name" -> "renewal"."ACCOUNT_RENEWAL_CAMPAIGN"."campaign_name": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"renewal"."RENEWAL_CAMPAIGN_CONFIGURATION"."campaign_name" -> "renewal"."INDIV_RENEWAL_CAMPAIGN"."campaign_name": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"renewal"."SUBSCRIPTION_RENEWAL_DETAILS"."subscription_ref" -> "renewal"."RENEWAL_ADMIN_FLOW"."subscription_ref": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"renewal"."RENEWAL_ADMIN_FLOW"."id" -> "renewal"."RENEWAL_ADMIN_FLOW_ACTIVITY_LOG"."renewal_admin_flow_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"renewal"."SUBSCRIPTION_RENEWAL_DETAILS"."subscription_ref" -> "renewal"."RENEWAL_PROPOSAL"."subscription_ref": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"subscription"."DUMMY_OFFER_VERSION"."id" -> "subscription"."DUMMY_PROPERTIES"."offer_version_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"subscription"."DUMMY_CONTRACTEE"."id" -> "subscription"."DUMMY_SUBSCRIPTION"."contractee_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}

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