Class diagram

"USER" {
  shape: sql_table
    link: "[components.ca.internal.tech.models.ca_user.CaUser][]"

"id": UUID {constraint: primary_key}
  "authentication_id": UUID 
  "birth_date": DATE 
  "email": VARCHAR(255) 
  "first_name": VARCHAR(255) 
  "gender": VARCHAR(255) 
  "has_opted_in_to_commercial_emails": BOOLEAN 
  "is_sensitive_data": BOOLEAN 
  "keycloak_id": UUID 
  "lang": VARCHAR(2) 
  "last_name": VARCHAR(255) 
  "phone": VARCHAR 
  "profile_id": UUID 
}
"TRANSACTION" {
  shape: sql_table
    link: "[components.ca.internal.tech.models.ca_versioning_manager.CaTransaction][]"

"id": BIGINT {constraint: primary_key}
  "actor_id": UUID 
  "client_addr": INET 
  "correlation_id": UUID 
  "issued_at": DATETIME 
  "native_transaction_id": BIGINT 
}
"ACTIVITY" {
  shape: sql_table
    link: "[components.ca.internal.tech.models.ca_versioning_manager.CaActivity][]"

"id": BIGINT {constraint: primary_key}
  "changed_data": JSONB 
  "issued_at": DATETIME 
  "native_transaction_id": BIGINT 
  "old_data": JSONB 
  "relid": INTEGER 
  "schema_name": TEXT 
  "table_name": TEXT 
  "transaction_id": BIGINT 
  "verb": TEXT 
}
"BANK_ACCOUNT" {
  shape: sql_table
    link: "[components.ca.internal.affiliation.models.ca_bank_account.CaBankAccount][]"

"id": UUID {constraint: primary_key}
  "bank_account_info": VARCHAR(255) 
  "bank_account_type": VARCHAR(255) 
  "profile_id": UUID 
}
"INSURANCE_PROFILE" {
  shape: sql_table
    link: "[components.ca.internal.affiliation.models.ca_insurance_profile.CaInsuranceProfile][]"

"id": UUID {constraint: primary_key}
  "profile_id": UUID 
}
"POLICY" {
  shape: sql_table
    link: "[components.ca.internal.affiliation.models.ca_policy.CaPolicy][]"

"id": UUID {constraint: primary_key}
  "end_date": DATE 
  "is_cancelled": BOOLEAN 
  "max_document_scoped_number": INTEGER 
  "next_enrollment_partner_index": INTEGER 
  "partner_class_id": INTEGER 
  "partner_div_id": INTEGER 
  "partner_id": INTEGER 
  "start_date": DATE 
  "subscription_ref": UUID 
  "termination_type": VARCHAR(255) 
}
"ENROLLMENT" {
  shape: sql_table
    link: "[components.ca.internal.affiliation.models.ca_enrollment.CaEnrollment][]"

"id": UUID {constraint: primary_key}
  "end_date": DATE 
  "enrollment_type": VARCHAR(255) 
  "insurance_profile_id": UUID 
  "is_cancelled": BOOLEAN 
  "partner_id": INTEGER 
  "policy_id": UUID 
  "start_date": DATE 
  "termination_type": VARCHAR(255) 
  "xodus_benefits_card_url": VARCHAR 
}
"PERSISTED_DEPENDENTS" {
  shape: sql_table
    link: "[components.ca.internal.affiliation.models.ca_persisted_dependents.CaPersistedDependents][]"

"id": UUID {constraint: primary_key}
  "has_children": BOOLEAN 
  "has_partner": BOOLEAN 
  "policy_id": UUID 
}
"CARE_ACT" {
  shape: sql_table
    link: "[components.ca.internal.claim_management.claim_engine.steps.matching.models.ca_care_act.CaCareAct][]"

"id": UUID {constraint: primary_key}
  "latest_care_act_consolidated_info_id": UUID 
}
"CARE_ACT_CONSOLIDATED_INFO" {
  shape: sql_table
    link: "[components.ca.internal.claim_management.claim_engine.steps.consolidation.models.ca_care_act_consolidated_info.CaCareActConsolidatedInfo][]"

"id": UUID {constraint: primary_key}
  "alan_tp_amount": INTEGER 
  "care_act_id": UUID 
  "creator_id": UUID 
  "dead_branch_at": DATETIME 
  "dead_branch_caused_by": UUID 
  "dead_branch_caused_by_type": TEXT 
  "dental_locations": ARRAY 
  "end_date": DATE 
  "health_professional_code": VARCHAR(255) 
  "health_professional_name": VARCHAR(255) 
  "insurance_profile_id": UUID 
  "internal_care_act_type": VARCHAR(38) 
  "is_cancelled": BOOLEAN 
  "latest_care_act_coverage_computation_result_id": UUID 
  "operator_comment": TEXT 
  "other_insurer_reimbursed_amount": INTEGER 
  "payment_recipient_number": VARCHAR(255) 
  "procedure_name": VARCHAR(255) 
  "quantity": INTEGER 
  "review_context": JSONB 
  "side": VARCHAR(5) 
  "source": VARCHAR(255) 
  "start_date": DATE 
  "total_spend": INTEGER 
  "validation_status": VARCHAR(255) 
  "version": INTEGER 
}
"CARE_ACT_COVERAGE_COMPUTATION_RESULT" {
  shape: sql_table
    link: "[components.ca.internal.claim_management.claim_engine.steps.coverage_computation.models.ca_care_act_coverage_computation_result.CaCareActCoverageComputationResult][]"

"id": UUID {constraint: primary_key}
  "alan_covered_amount": INTEGER 
  "alan_reimburse_to_user_amount": INTEGER 
  "care_act_consolidated_info_id": UUID 
  "context_properties": ARRAY 
  "creator_id": UUID 
  "dead_branch_at": DATETIME 
  "dead_branch_caused_by": UUID 
  "dead_branch_caused_by_type": TEXT 
  "eligible_coverage_amount": INTEGER 
  "eligible_coverage_percentage": INTEGER 
  "enrollment_id": UUID 
  "insurance_profile_id": UUID 
  "operator_comment": TEXT 
  "review_context": JSONB 
  "source": VARCHAR(255) 
  "validation_status": VARCHAR(255) 
  "version": INTEGER 
}
"INSURANCE_DOCUMENT_REIMBURSEMENT_REQUEST" {
  shape: sql_table
  "insurance_document_id": UUID 
  "reimbursement_request_id": UUID 
}
"REIMBURSEMENT_REQUEST" {
  shape: sql_table
    link: "[components.ca.internal.claim_management.models.ca_reimbursement_request.CaReimbursementRequest][]"

"id": UUID {constraint: primary_key}
  "comment_from_user": TEXT 
  "insurance_profile_id": UUID 
  "partner_claim_id": INTEGER 
  "status": VARCHAR(255) 
  "submitted_by_insurance_profile_id": UUID 
}
"ALAN_EMPLOYEE" {
  shape: sql_table
    link: "[components.ca.internal.tech.models.ca_alan_employee.CaAlanEmployee][]"

"id": INTEGER {constraint: primary_key}
  "alan_email": VARCHAR(255) 
  "end_date": DATE 
  "roles": ARRAY 
  "start_date": DATE 
  "user_id": UUID 
}
"SETTLEMENT" {
  shape: sql_table
    link: "[components.ca.internal.claim_management.claim_engine.steps.settlement.models.ca_settlement.CaSettlement][]"

"id": UUID {constraint: primary_key}
  "amount_refused_by_alan_in_cents": INTEGER 
  "amount_reimbursed_by_alan_in_cents": INTEGER 
  "beneficiary_insurance_profile_id": UUID 
  "care_type_id": TEXT 
  "creator_alan_employee_id": INTEGER 
  "description": TEXT 
  "recipient_insurance_profile_id": UUID 
  "reimbursement_request_id": UUID 
}
"REIMBURSEMENT_PAYMENT" {
  shape: sql_table
    link: "[components.ca.internal.claim_management.claim_engine.steps.reimbursement_payment.models.ca_reimbursement_payment.CaReimbursementPayment][]"

"id": UUID {constraint: primary_key}
  "amount": INTEGER 
  "bank_account_id": UUID 
  "bank_transfer_ref": UUID 
  "profile_id": UUID 
  "settlement_id": UUID 
  "status": VARCHAR(255) 
  "status_reason": TEXT 
  "transfer_type": VARCHAR(255) 
}
"CLAIM_MANAGEMENT_OPERATION_TASK" {
  shape: sql_table
    link: "[components.ca.internal.claim_management.models.ca_claim_management_operation_task.CaClaimManagementOperationTask][]"

"id": UUID {constraint: primary_key}
  "fragment_latest_task_id": VARCHAR(255) 
  "intercom_conversation_id": VARCHAR(255) 
  "intercom_conversation_id_eu": VARCHAR(255) 
  "reimbursement_request_id": UUID 
}
"INSURANCE_DOCUMENT" {
  shape: sql_table
    link: "[components.ca.internal.claim_management.models.ca_insurance_document.CaInsuranceDocument][]"

"id": UUID {constraint: primary_key}
  "beneficiary_insurance_profile_id": UUID 
  "content_hash": VARCHAR(64) 
  "global_document_pure_parsing_ref": UUID 
  "is_cancelled": BOOLEAN 
  "mime_type": VARCHAR(255) 
  "partner_document_id": INTEGER 
  "policy_scoped_number": INTEGER 
  "uploader_insurance_profile_id": UUID 
  "uri": VARCHAR(2083) 
}
"MEMBER_LIMIT" {
  shape: sql_table
    link: "[components.ca.internal.claim_management.models.ca_member_limit.CaMemberLimit][]"

"id": UUID {constraint: primary_key}
  "end_date": DATE 
  "enrollment_id": UUID 
  "limit_type": VARCHAR(255) 
  "maximum_benefit": INTEGER 
  "remaining_balance": INTEGER 
  "start_date": DATE 
}
"TELUS_PROCEDURE" {
  shape: sql_table
    link: "[components.ca.internal.claim_management.models.ca_telus_procedure.CaTelusProcedure][]"

"id": UUID {constraint: primary_key}
  "care_act_consolidated_info_id": UUID 
  "claim_id": INTEGER 
  "claim_json_payload": JSONB 
  "is_processed": BOOLEAN 
  "procedure_id": INTEGER 
}
"ACCOUNT" {
  shape: sql_table
    link: "[components.ca.internal.contracting.models.ca_account.CaAccount][]"

"id": UUID {constraint: primary_key}
  "is_partner_placeholder": BOOLEAN 
  "name": VARCHAR(255) 
  "partner_id": INTEGER 
}
"ADDRESS" {
  shape: sql_table
    link: "[components.ca.internal.contracting.models.ca_address.CaAddress][]"

"id": UUID {constraint: primary_key}
  "city": VARCHAR(255) 
  "country": VARCHAR(255) 
  "postal_code": VARCHAR(255) 
  "province": VARCHAR(255) 
  "street": VARCHAR(255) 
}
"COMPANY" {
  shape: sql_table
    link: "[components.ca.internal.contracting.models.ca_company.CaCompany][]"

"id": UUID {constraint: primary_key}
  "account_id": UUID 
  "address_id": UUID 
  "business_number": VARCHAR(9) 
  "day_to_send_pay_info": INTEGER 
  "display_name": VARCHAR(255) 
  "employee_estimate": INTEGER 
  "health_stripe_customer_id": VARCHAR(255) 
  "is_demo": BOOLEAN 
  "is_partner_placeholder": BOOLEAN 
  "name": VARCHAR(255) 
  "partner_class_ontario_id": INTEGER 
  "partner_division_ontario_id": INTEGER 
  "partner_id": INTEGER 
}
"HEALTH_SUBSCRIPTION_PAYLOAD" {
  shape: sql_table
    link: "[components.ca.internal.contracting.models.ca_health_subscription_payload.CaHealthSubscriptionPayload][]"

"id": UUID {constraint: primary_key}
  "display_id": INTEGER 
}
"SIGNED_BUNDLE" {
  shape: sql_table
    link: "[components.ca.internal.contracting.models.ca_signed_bundle.CaSignedBundle][]"

"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) 
}
"PRICE_GRID" {
  shape: sql_table
    link: "[components.ca.internal.offer.models.ca_price_grid.CaPriceGrid][]"

"id": UUID {constraint: primary_key}
  "family_price_in_cents": INTEGER 
  "single_price_in_cents": INTEGER 
}
"HEALTH_PLAN" {
  shape: sql_table
    link: "[components.ca.internal.offer.models.ca_health_plan.CaHealthPlan][]"

"id": UUID {constraint: primary_key}
  "coverage_name": VARCHAR(255) 
  "partner_id": INTEGER 
  "price_grid_id": UUID 
}
"HEALTH_SUBSCRIPTION_VERSION_PAYLOAD" {
  shape: sql_table
    link: "[components.ca.internal.contracting.models.ca_health_subscription_version_payload.CaHealthSubscriptionVersionPayload][]"

"id": UUID {constraint: primary_key}
  "has_life_insurance": BOOLEAN 
  "has_salary_dependent_coverage": BOOLEAN 
  "health_plan_id": UUID 
  "participation": INTEGER 
  "signed_bundle_id": UUID 
  "waiting_period": INTEGER 
}
"SIGNED_DOCUMENT" {
  shape: sql_table
    link: "[components.ca.internal.contracting.models.ca_signed_document.CaSignedDocument][]"

"id": UUID {constraint: primary_key}
  "document_key": VARCHAR(255) 
  "document_metadata": JSONB 
  "signed_at": DATETIME 
  "signed_bundle_id": UUID 
  "uri": VARCHAR(2083) 
}
"COMPANY_ADMIN" {
  shape: sql_table
    link: "[components.ca.internal.customer_dashboard.models.ca_company_admin.CaCompanyAdmin][]"

"id": UUID {constraint: primary_key}
  "company_id": UUID 
  "end_date": DATE 
  "is_cancelled": BOOLEAN 
  "last_seen_at": DATETIME 
  "profile_id": UUID 
  "start_date": DATE 
}
"TELUS_PAYLOAD" {
  shape: sql_table
    link: "[components.ca.internal.document_parsing.models.ca_telus_payload.CaTelusPayload][]"

"id": UUID {constraint: primary_key}
  "ca_insurance_document_id": UUID 
  "global_document_pure_parsing_ref": UUID 
  "payload": JSONB 
  "reasons_for_review": ARRAY 
  "version": INTEGER 
}
"RWAM_EMPLOYEE_SNAPSHOT" {
  shape: sql_table
    link: "[components.ca.internal.rwam.models.ca_rwam_employee_snapshot.CaRwamEmployeeSnapshot][]"

"id": UUID {constraint: primary_key}
  "birth_date": DATE 
  "city": VARCHAR 
  "company_id": UUID 
  "company_name": VARCHAR 
  "date_of_hire": DATE 
  "dental": VARCHAR 
  "email": VARCHAR 
  "end_date": DATE 
  "extended_health_care": VARCHAR 
  "first_name": VARCHAR 
  "gender": VARCHAR(255) 
  "home_province": VARCHAR 
  "is_cancelled": BOOLEAN 
  "last_name": VARCHAR 
  "occupation": VARCHAR 
  "postal_code": VARCHAR 
  "profile_id": UUID 
  "salary": INTEGER 
  "start_date": DATE 
  "street_address": VARCHAR 
  "work_province": VARCHAR 
}
"RWAM_EXPORT_DOCUMENT" {
  shape: sql_table
    link: "[components.ca.internal.rwam.models.ca_rwam_export_document.CaRwamExportDocument][]"

"id": UUID {constraint: primary_key}
  "uri": VARCHAR(2083) 
}
"COMMAND_LOG" {
  shape: sql_table
    link: "[components.ca.internal.tech.models.ca_command_log.CaCommandLog][]"

"id": INTEGER {constraint: primary_key}
  "actor_id": UUID 
  "command": VARCHAR 
  "completed_at": DATETIME 
  "dyno": VARCHAR 
  "interactive_logs": TEXT 
  "is_interactive": BOOLEAN 
  "run_at": DATETIME 
  "success": BOOLEAN 
}
"EMAIL_LOG" {
  shape: sql_table
    link: "[components.ca.internal.tech.models.ca_email_log.CaEmailLog][]"

"id": INTEGER {constraint: primary_key}
  "account_ref": UUID 
  "actor_id": UUID 
  "attachment_filenames": JSONB 
  "bounced_at": DATETIME 
  "bounced_reason": VARCHAR 
  "campaign_name": VARCHAR 
  "category": VARCHAR(255) 
  "clicks": JSONB 
  "delivered_at": DATETIME 
  "delivery_id": VARCHAR 
  "dropped_at": DATETIME 
  "dropped_reason": VARCHAR 
  "dry_run": BOOLEAN 
  "email_address": VARCHAR 
  "expected_run_at": DATETIME 
  "mailer": VARCHAR(255) 
  "opened_at": DATETIME 
  "params": JSONB 
  "priority": VARCHAR(15) 
  "recipient_type": VARCHAR(255) 
  "result": JSONB 
  "sender_email": VARCHAR 
  "sender_method": VARCHAR(255) 
  "sent_at": DATETIME 
  "skipped": BOOLEAN 
  "success": BOOLEAN 
  "tracking_id": VARCHAR 
  "user_id": UUID 
  "workspace_id": VARCHAR 
}
"PRIVACY_PROPERTIES" {
  shape: sql_table
    link: "[components.ca.internal.tech.models.ca_privacy_properties.CaPrivacyProperties][]"

"id": UUID {constraint: primary_key}
  "column_name": VARCHAR 
  "privacy_properties": JSONB 
  "schema_name": VARCHAR 
  "table_name": VARCHAR 
}
"QUEUE_POOL" {
  shape: sql_table
    link: "[components.ca.internal.tech.models.ca_queue_pool.CaQueuePool][]"

"id": UUID {constraint: primary_key}
  "enabled": BOOLEAN 
  "max_jobs_per_second": FLOAT 
  "name": VARCHAR 
  "ordered_queues": JSONB 
  "realtime": BOOLEAN 
  "weight": INTEGER 
}
"REFRESH_TOKEN" {
  shape: sql_table
    link: "[components.ca.internal.tech.models.ca_refresh_token.CaRefreshToken][]"

"id": INTEGER {constraint: primary_key}
  "next_token": VARCHAR(128) 
  "next_token_created_at": INTEGER 
  "session_id": UUID 
  "token": VARCHAR(128) 
  "token_type": VARCHAR(255) 
  "user_id": UUID 
}
"WEBHOOK_ENDPOINT" {
  shape: sql_table
    link: "[components.ca.internal.tech.models.ca_webhook_endpoint.CaWebhookEndpoint][]"

"id": UUID {constraint: primary_key}
  "actor_id": UUID 
  "deactivated_at": DATETIME 
  "description": TEXT 
  "event_types": ARRAY 
  "name": TEXT 
  "signature_key": VARCHAR 
  "url": TEXT 
}
"TELUS_EXPORT_DOCUMENT" {
  shape: sql_table
    link: "[components.ca.internal.telus.models.ca_telus_export_document.CaTelusExportDocument][]"

"id": UUID {constraint: primary_key}
  "uri": VARCHAR(2083) 
}
"XODUS_EXPORT_DOCUMENT" {
  shape: sql_table
    link: "[components.ca.internal.xodus.models.ca_xodus_export_document.CaXodusExportDocument][]"

"id": UUID {constraint: primary_key}
  "document_parsed_at": DATETIME 
  "uri": VARCHAR(2083) 
}
"TRANSACTION"."id" -> "ACTIVITY"."transaction_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"POLICY"."id" -> "ENROLLMENT"."policy_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "ENROLLMENT"."insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"POLICY"."id" -> "PERSISTED_DEPENDENTS"."policy_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"CARE_ACT_CONSOLIDATED_INFO"."id" -> "CARE_ACT"."latest_care_act_consolidated_info_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CARE_ACT_COVERAGE_COMPUTATION_RESULT"."id" -> "CARE_ACT_CONSOLIDATED_INFO"."latest_care_act_coverage_computation_result_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CARE_ACT"."id" -> "CARE_ACT_CONSOLIDATED_INFO"."care_act_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "CARE_ACT_CONSOLIDATED_INFO"."insurance_profile_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "CARE_ACT_COVERAGE_COMPUTATION_RESULT"."insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"ENROLLMENT"."id" -> "CARE_ACT_COVERAGE_COMPUTATION_RESULT"."enrollment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CARE_ACT_CONSOLIDATED_INFO"."id" -> "CARE_ACT_COVERAGE_COMPUTATION_RESULT"."care_act_consolidated_info_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"REIMBURSEMENT_REQUEST"."id" -> "INSURANCE_DOCUMENT_REIMBURSEMENT_REQUEST"."reimbursement_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSURANCE_DOCUMENT"."id" -> "INSURANCE_DOCUMENT_REIMBURSEMENT_REQUEST"."insurance_document_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "REIMBURSEMENT_REQUEST"."insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "REIMBURSEMENT_REQUEST"."submitted_by_insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "ALAN_EMPLOYEE"."user_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"INSURANCE_PROFILE"."id" -> "SETTLEMENT"."beneficiary_insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "SETTLEMENT"."recipient_insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"ALAN_EMPLOYEE"."id" -> "SETTLEMENT"."creator_alan_employee_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"REIMBURSEMENT_REQUEST"."id" -> "SETTLEMENT"."reimbursement_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"BANK_ACCOUNT"."id" -> "REIMBURSEMENT_PAYMENT"."bank_account_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"SETTLEMENT"."id" -> "REIMBURSEMENT_PAYMENT"."settlement_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"REIMBURSEMENT_REQUEST"."id" -> "CLAIM_MANAGEMENT_OPERATION_TASK"."reimbursement_request_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"INSURANCE_PROFILE"."id" -> "INSURANCE_DOCUMENT"."beneficiary_insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "INSURANCE_DOCUMENT"."uploader_insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"ENROLLMENT"."id" -> "MEMBER_LIMIT"."enrollment_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CARE_ACT_CONSOLIDATED_INFO"."id" -> "TELUS_PROCEDURE"."care_act_consolidated_info_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"ACCOUNT"."id" -> "COMPANY"."account_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"ADDRESS"."id" -> "COMPANY"."address_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"PRICE_GRID"."id" -> "HEALTH_PLAN"."price_grid_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"HEALTH_PLAN"."id" -> "HEALTH_SUBSCRIPTION_VERSION_PAYLOAD"."health_plan_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"SIGNED_BUNDLE"."id" -> "HEALTH_SUBSCRIPTION_VERSION_PAYLOAD"."signed_bundle_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"SIGNED_BUNDLE"."id" -> "SIGNED_DOCUMENT"."signed_bundle_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "COMPANY_ADMIN"."company_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSURANCE_DOCUMENT"."id" -> "TELUS_PAYLOAD"."ca_insurance_document_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "EMAIL_LOG"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "REFRESH_TOKEN"."user_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}

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