Data model

"DOCUMENT_HOSPITALIZATION_DECLARATION" {
  shape: sql_table
  "document_id": UUID 
  "hospitalization_declaration_id": UUID 
}
"HOSPITAL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "archived": BOOLEAN 
  "assur_card_hospital_id": VARCHAR(10) 
  "assur_card_site_id": VARCHAR(10) 
  "city": VARCHAR(255) 
  "is_visible_for_members": BOOLEAN 
  "postal_code": VARCHAR(4) 
  "site_name": VARCHAR(255) 
}
"HEALTH_PLAN_SEVERE_ILLNESS_TYPE_ASSOC" {
  shape: sql_table
  "health_plan_id": UUID 
  "severe_illness_type_id": UUID 
}
"HEALTH_COVERAGE_SEVERE_ILLNESS_TYPE_ASSOC" {
  shape: sql_table
  "health_coverage_id": UUID 
  "severe_illness_type_id": UUID 
}
"SEVERE_ILLNESS_TYPE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "description": TEXT 
  "is_default": BOOLEAN 
  "type": VARCHAR(255) 
}
"HEALTH_COVERAGE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "ambulatory_yearly_limit_cents": INTEGER 
  "assistance_abroad_supported": BOOLEAN 
  "bundle_code": VARCHAR(100) 
  "bundle_version": INTEGER 
  "coverage_level": VARCHAR(255) 
  "daily_care_rate": INTEGER 
  "dental_rate": INTEGER 
  "dental_yearly_checkup_rate": INTEGER 
  "hospitalization_rate": INTEGER 
  "post_hospitalization_coverage_months": INTEGER 
  "pre_hospitalization_coverage_months": INTEGER 
  "severe_illness_voids_personal_contribution_supported": BOOLEAN 
  "severe_illnesses_rate": INTEGER 
}
"PRICE_GRID" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "health_coverage_id": UUID 
}
"HEALTH_PLAN" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "all_beneficiaries_on_same_coverage": BOOLEAN 
  "all_dependents_on_same_coverage": BOOLEAN 
  "all_dependents_on_same_level": BOOLEAN 
  "available_for_self_serve": BOOLEAN 
  "blocked_affiliation_window_in_days": INTEGER 
  "builder_product_version_ref": INTEGER 
  "bundle_code": VARCHAR(100) 
  "bundle_version": INTEGER 
  "commercialisation_end_date": DATE 
  "display_name": VARCHAR(255) 
  "emoji_code": VARCHAR(255) 
  "health_partner_enabled": BOOLEAN 
  "hospitalization_single_room_personal_contribution_in_cents": INTEGER 
  "internal_comment": TEXT 
  "is_standalone": BOOLEAN 
  "pricing_category": VARCHAR(255) 
  "region": VARCHAR(255) 
  "retroactive_affiliation_window_in_days": INTEGER 
  "risk_category": INTEGER 
  "start_date": DATE 
  "tailored_for_company_fuzzy_name": VARCHAR(255) 
  "waiting_period_in_months": INTEGER 
}
"COVERAGE_MODULE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "all_dependents_or_none": BOOLEAN 
  "child_optionality": VARCHAR(255) 
  "health_coverage_id": UUID 
  "health_plan_id": UUID 
  "index": INTEGER 
  "is_hidden": BOOLEAN 
  "name": VARCHAR(255) 
  "partner_optionality": VARCHAR(255) 
  "price_grid_id": UUID 
  "primary_optionality": VARCHAR(255) 
}
"ENROLLMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "coverage_module_name": VARCHAR(255) 
  "end_date": DATE 
  "insurance_profile_id": UUID 
  "is_cancelled": BOOLEAN 
  "policy_id": UUID 
  "start_date": DATE 
  "start_type": VARCHAR(50) 
  "termination_type": VARCHAR(255) 
  "type": VARCHAR(255) 
}
"INSURANCE_PROFILE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "has_gmd": BOOLEAN 
  "insured_person_id": VARCHAR(10) 
  "mutuality_code": VARCHAR(10) 
  "user_id": UUID 
}
"HOSPITALIZATION_DECLARATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "accident_circumstance": VARCHAR(255) 
  "admitted": BOOLEAN 
  "assur_card_hospital_id": UUID 
  "assur_card_prehospi_id": VARCHAR(40) 
  "deprecated_assur_card_light": TEXT 
  "description": TEXT 
  "hospitalization_declaration_categories": ARRAY 
  "hospitalization_declaration_type": VARCHAR(255) 
  "hospitalization_end_date": DATE 
  "hospitalization_start_date": DATE 
  "insurance_profile_id": UUID 
  "is_cancelled": BOOLEAN 
  "planned_at": DATE 
  "room_type": VARCHAR(255) 
  "status": VARCHAR(255) 
  "status_comment": TEXT 
}
"ADDRESS" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "city": VARCHAR(255) 
  "country": VARCHAR(255) 
  "postal_code": VARCHAR(255) 
  "street": VARCHAR(255) 
}
"USER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "address_id": UUID 
  "assusoft_id": UUID 
  "authentication_id": UUID 
  "birth_date": DATE 
  "email": VARCHAR(255) 
  "first_name": VARCHAR(255) 
  "gender": VARCHAR(255) 
  "has_opted_in_to_commercial_emails": BOOLEAN 
  "health_stripe_customer_id": VARCHAR(255) 
  "is_sensitive_data": BOOLEAN 
  "keycloak_id": UUID 
  "lang": VARCHAR(2) 
  "last_name": VARCHAR(255) 
  "phone": VARCHAR 
  "profile_id": UUID 
  "stripe_repayment_customer_id": VARCHAR(255) 
}
"TRANSACTION" {
  shape: sql_table
  "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
  "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 
}
"ACCOUNT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "address_id": UUID 
  "name": VARCHAR(255) 
  "opportunity_id": VARCHAR(225) 
  "vat": VARCHAR(255) 
}
"VALID_SIGNATORY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "comment": TEXT 
  "company_id": UUID 
  "end_date": DATE 
  "first_name": VARCHAR(255) 
  "is_cancelled": BOOLEAN 
  "itsme_user_link_id": UUID 
  "itsme_user_link_matched_at": DATETIME 
  "last_name": VARCHAR(255) 
  "signer_email": VARCHAR(255) 
  "start_date": DATE 
}
"COMPANY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_id": UUID 
  "address_id": UUID 
  "day_to_send_pay_info": INTEGER 
  "demo": BOOLEAN 
  "dependents_managed_externally": BOOLEAN 
  "display_name": VARCHAR(255) 
  "display_prices_during_employee_onboarding": BOOLEAN 
  "employee_estimate": INTEGER 
  "employees_managed_externally": BOOLEAN 
  "health_stripe_customer_id": VARCHAR(255) 
  "insurance_insights_enabled": BOOLEAN 
  "is_sensitive_data": BOOLEAN 
  "mark_for_2023_health_partner_rollout": BOOLEAN 
  "name": VARCHAR(255) 
  "opportunity_id": VARCHAR(225) 
  "population_name": VARCHAR 
  "salesforce_account_id": VARCHAR(255) 
  "use_employee_payroll_id": BOOLEAN 
  "vat": VARCHAR(255) 
}
"FILE_IMPORT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "import_details": JSONB 
  "import_status": VARCHAR(255) 
  "imported_at": DATETIME 
  "source_file": VARCHAR(2083) 
  "source_type": VARCHAR(255) 
}
"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) 
}
"HEALTH_CONTRACT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "company_id": UUID 
  "debits_suspension_date": DATE 
  "display_name": VARCHAR 
  "end_date": DATE 
  "extra_insurance_year_reset_dates": ARRAY 
  "individual_id": UUID 
  "is_cancelled": BOOLEAN 
  "parent_health_contract_id": UUID 
  "payment_method": VARCHAR(255) 
  "signed_bundle_id": UUID 
  "start_date": DATE 
}
"EMPLOYEE_STATE_EXTRACTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "assusoft_file_id": UUID 
  "birth_date": DATE 
  "company_id": UUID 
  "email": VARCHAR(255) 
  "executed_at": DATETIME 
  "execution_details": JSONB 
  "execution_log": TEXT 
  "execution_status": VARCHAR(255) 
  "external_user_id": UUID 
  "first_name": VARCHAR(255) 
  "health_contract_id": UUID 
  "iban": TEXT 
  "language": VARCHAR(255) 
  "last_name": VARCHAR(255) 
  "note": TEXT 
  "payroll_id": VARCHAR(255) 
  "phone_number": TEXT 
  "raw_data": JSONB 
  "sex": VARCHAR(255) 
  "source_updated_at": DATETIME 
  "start_date": DATE 
  "termination_date": DATE 
  "termination_reason": VARCHAR(255) 
  "user_id": UUID 
}
"DEPENDENT_STATE_EXTRACTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "assusoft_file_id": UUID 
  "assusoft_id": UUID 
  "birth_date": DATE 
  "coverage_module_name": VARCHAR(255) 
  "dependent_type": VARCHAR(255) 
  "email": VARCHAR(255) 
  "employee_extraction_state_id": UUID 
  "executed_at": DATETIME 
  "execution_details": JSONB 
  "execution_status": VARCHAR(255) 
  "first_name": VARCHAR(255) 
  "iban": TEXT 
  "last_name": VARCHAR(255) 
  "note": TEXT 
  "phone_number": TEXT 
  "raw_data": JSONB 
  "sex": VARCHAR(255) 
  "start_date": DATE 
  "termination_date": DATE 
  "user_id": UUID 
}
"INSTALLMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount": INTEGER 
  "installment_plan_id": UUID 
}
"INSTALLMENT_PLAN" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "contract_ref": VARCHAR(64) 
  "contract_type": VARCHAR(32) 
}
"INVOICE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount_to_charge": INTEGER 
  "amount_to_refund": INTEGER 
  "appendix_uri": VARCHAR(2083) 
  "billing_reason": VARCHAR(32) 
  "contract_ref": VARCHAR(64) 
  "contract_type": VARCHAR(32) 
  "due_date": DATE 
  "email_sent_at": DATETIME 
  "event_date": DATE 
  "invoice_number": VARCHAR(255) 
  "issued_date": DATE 
  "month_amount": INTEGER 
  "payment_pending": BOOLEAN 
  "payment_skipped": BOOLEAN 
  "previous_balance": INTEGER 
  "refund_pending": BOOLEAN 
  "regularization_amount": INTEGER 
  "remaining_balance": INTEGER 
  "settlement_status": VARCHAR(31) 
  "uri": VARCHAR(2083) 
}
"INVOICE_EXTRA_INFO" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "company_ref": VARCHAR(64) 
  "key": VARCHAR(64) 
  "labels": JSONB 
  "value": VARCHAR(255) 
}
"PAYMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount": INTEGER 
  "bank_transfer_reference": VARCHAR(255) 
  "contract_ref": VARCHAR(64) 
  "contract_type": VARCHAR(32) 
  "dispute_reason": VARCHAR(255) 
  "disputed_payment_id": UUID 
  "failure_reason": VARCHAR(255) 
  "iban_id": UUID 
  "installment_id": UUID 
  "invoice_id": UUID 
  "off_session": BOOLEAN 
  "payment_date": DATE 
  "refunded_payment_id": UUID 
  "status": VARCHAR(255) 
  "stripe_charge_id": VARCHAR(255) 
  "stripe_dispute_id": VARCHAR(255) 
  "stripe_payment_intent_id": VARCHAR(255) 
  "stripe_refund_id": VARCHAR(255) 
  "type": VARCHAR(255) 
}
"BILLING_TASK_EXECUTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "category": VARCHAR 
  "country_prefix": VARCHAR 
  "end_time": DATETIME 
  "enqueued_jobs_count": INTEGER 
  "failure_message": VARCHAR 
  "scheduler_run_datetime": DATETIME 
  "start_time": DATETIME 
  "status": VARCHAR 
  "type": VARCHAR 
}
"BILLING_TASK_EXECUTION_RQ_JOB" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "billing_task_execution_id": UUID 
  "rq_job_id": VARCHAR 
}
"ASSUR_PHARMA_API_CALL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "api_call_metadata": JSONB 
  "call_operation": VARCHAR(255) 
  "called_at": DATETIME 
}
"DOCUMENT_REIMBURSEMENT_REQUEST" {
  shape: sql_table
  "document_id": UUID 
  "reimbursement_request_id": UUID 
}
"DOCUMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "beneficiary_insurance_profile_id": UUID 
  "content_hash": VARCHAR(64) 
  "document_class_type": VARCHAR(255) 
  "file_content_type": VARCHAR(255) 
  "is_cancelled": BOOLEAN 
  "policy_scoped_number": INTEGER 
  "upload_platform_type": VARCHAR(255) 
  "uploaded_at": DATETIME 
  "uploader_insurance_profile_id": UUID 
  "uri": VARCHAR(2083) 
}
"REIMBURSEMENT_REQUEST" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "comment_from_user": TEXT 
  "declared_care_act_type": VARCHAR(255) 
  "declared_care_act_type_from_user": VARCHAR(255) 
  "declared_parsing_result": JSONB 
  "first_viewed_at": DATETIME 
  "insurance_profile_id": UUID 
  "is_archived": BOOLEAN 
  "processing_completed_at": DATETIME 
  "request_type": VARCHAR(255) 
  "status": VARCHAR(255) 
  "user_id": UUID 
}
"BVAC_FILE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "bvac_file_metadata": JSONB 
  "document_id": UUID 
  "technical_id": VARCHAR(255) 
  "uri": VARCHAR(2083) 
}
"DEPRECATED_BVAC" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "bvac_file_id": UUID 
  "insurance_profile_id": UUID 
}
"PARSED_BVAC" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "bar_code": JSONB 
  "bvac_file_id": UUID 
  "bvac_id": UUID 
  "creator_id": UUID 
  "dead_branch_at": DATETIME 
  "dead_branch_caused_by": UUID 
  "dead_branch_caused_by_type": TEXT 
  "delivery_date": DATE 
  "doctor_information": JSONB 
  "insurance_profile_beneficiary_id": UUID 
  "insurance_profile_scanner_id": UUID 
  "internal_reference": TEXT 
  "operator_comment": TEXT 
  "patient": JSONB 
  "pharmacy_information": JSONB 
  "product_list": JSONB 
  "rejection_content": TEXT 
  "rejection_reason": VARCHAR(255) 
  "review_context": JSONB 
  "source": VARCHAR(255) 
  "total_amounts": JSONB 
  "validation_status": VARCHAR(255) 
  "version": INTEGER 
}
"HOSPITALIZATION_INVOICE_FILE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "document_id": VARCHAR(255) 
  "file_name": VARCHAR(255) 
  "hospitalization_invoice_file_metadata": JSONB 
  "is_paper": BOOLEAN 
  "technical_id": VARCHAR(255) 
  "uri": VARCHAR(2083) 
}
"HOSPITALIZATION_INVOICE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "hospitalization_invoice_file_id": UUID 
  "invoice_id": VARCHAR(255) 
}
"PARSED_HOSPITALIZATION_INVOICE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "admission_number": VARCHAR(255) 
  "assur_card_identifier": VARCHAR(255) 
  "chosen_room_type": VARCHAR(255) 
  "claim_reference": VARCHAR(255) 
  "creator_id": UUID 
  "credit_note_id": UUID 
  "dead_branch_at": DATETIME 
  "dead_branch_caused_by": UUID 
  "dead_branch_caused_by_type": TEXT 
  "hospital_bank_account": VARCHAR(255) 
  "hospital_id": UUID 
  "hospital_info": JSONB 
  "hospital_site_identifier": VARCHAR(255) 
  "hospitalization_declaration_id": UUID 
  "hospitalization_end": DATE 
  "hospitalization_invoice_file_id": UUID 
  "hospitalization_invoice_id": UUID 
  "hospitalization_start": DATE 
  "insurance_profile_id": UUID 
  "invoice_detail": JSONB 
  "invoice_generation_date": DATE 
  "invoice_id": VARCHAR(255) 
  "invoice_number": VARCHAR(255) 
  "invoice_warnings": JSONB 
  "invoicing_period": VARCHAR(255) 
  "mutuality_amount_in_cents": INTEGER 
  "operator_comment": TEXT 
  "overcharges_amount_in_cents": INTEGER 
  "parsing_result": JSONB 
  "patient_info": JSONB 
  "patient_part_amount_in_cents": INTEGER 
  "payment_reference": VARCHAR(255) 
  "rejection_reason": VARCHAR(255) 
  "review_context": JSONB 
  "source": VARCHAR(255) 
  "total_amount_without_mutuality_in_cents": INTEGER 
  "validation_status": VARCHAR(255) 
  "version": INTEGER 
}
"CLAIM_MANAGEMENT_INTERCOM_TASK" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "document_id": UUID 
  "fragment_latest_task_id": VARCHAR(255) 
  "hospitalization_declaration_id": UUID 
  "intercom_conversation_id": VARCHAR(255) 
  "intercom_conversation_id_eu": VARCHAR(255) 
  "parsed_bvac_id": UUID 
  "parsed_hospitalization_invoice_id": UUID 
  "reimbursement_request_id": UUID 
}
"LEGACY_LIMIT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "end_date": DATE 
  "enrollment_id": UUID 
  "is_cancelled": BOOLEAN 
  "limit_in_cents": INTEGER 
  "limit_type": VARCHAR(255) 
  "start_date": DATE 
}
"HOSPITAL_INVOICE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount_invoiced_in_cents": INTEGER 
  "assur_card_invoice_number": BIGINT 
  "correction_amount_in_cents": INTEGER 
  "correction_comment": TEXT 
  "hospitalization_declaration_id": UUID 
  "hospitalization_invoice_id": UUID 
}
"SETTLEMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "ambulatory_limit_id": UUID 
  "amount_already_reimbursed_by_alan_in_cents": INTEGER 
  "amount_applied_to_ambulatory_limit_in_cents": INTEGER 
  "amount_refused_by_alan_in_cents": INTEGER 
  "amount_reimbursed_by_alan_in_cents": INTEGER 
  "amount_reimbursed_by_mutualite_in_cents": INTEGER 
  "beneficiary_insurance_profile_id": UUID 
  "coverages_deprecated": ARRAY 
  "creator_id": UUID 
  "description": TEXT 
  "hospital_invoice_id": UUID 
  "recipient_hospital_id": UUID 
  "recipient_user_id": UUID 
}
"CARE_ACT_SETTLEMENT_ASSOCIATION_TABLE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "care_act_settlement_id": UUID 
  "hospital_payment_id": UUID 
  "reimbursement_payment_id": UUID 
}
"CARE_ACT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
}
"CARE_ACT_CONSOLIDATED_INFO" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "act_id_code": VARCHAR(50) 
  "act_id_type": VARCHAR(255) 
  "amount_invoiced_in_cents": INTEGER 
  "amount_paid_in_cents": INTEGER 
  "amount_reimbursed_by_mutuality_in_cents": INTEGER 
  "beneficiary_insurance_profile_id": UUID 
  "care_act_id": UUID 
  "care_act_source": VARCHAR(255) 
  "care_act_type": VARCHAR(255) 
  "creator_id": UUID 
  "dead_branch_at": DATETIME 
  "dead_branch_caused_by": UUID 
  "dead_branch_caused_by_type": TEXT 
  "delivering_pharmacy_inami_code": BIGINT 
  "delivering_pharmacy_name": TEXT 
  "description": TEXT 
  "end_date": DATE 
  "health_practitioner_code": VARCHAR(255) 
  "health_practitioner_name": VARCHAR(255) 
  "hospital_bank_account": VARCHAR(255) 
  "hospitalization_invoice_payment_reference": TEXT 
  "hospitalization_room_type": VARCHAR(255) 
  "is_cancelled": BOOLEAN 
  "last_link_event_rank": INTEGER 
  "operator_comment": TEXT 
  "paid_by_hospital_id": UUID 
  "paid_by_insurance_profile_id": UUID 
  "prescribing_doctor_code": VARCHAR(255) 
  "prescribing_doctor_name": TEXT 
  "quantity": INTEGER 
  "review_context": JSONB 
  "source": VARCHAR(255) 
  "start_date": DATE 
  "validation_status": VARCHAR(255) 
  "version": INTEGER 
}
"CARE_ACT_DECISION_RULE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "action": VARCHAR(255) 
  "bvac_product_id": VARCHAR(64) 
  "care_act_type": VARCHAR(255) 
  "comment_type": VARCHAR(255) 
  "coverage_type": VARCHAR(255) 
  "creator_id": UUID 
  "for_insurance_profile_id": UUID 
  "hospitalization_declaration_categories": ARRAY 
  "internal_comment": TEXT 
  "photo_invoice_care_act_id": VARCHAR(64) 
  "rejection_reason_translations": JSONB 
  "severe_illness_types": ARRAY 
}
"CARE_ACT_COVERAGE_COMPUTATION_RESULT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount_covered_by_alan_in_cents": INTEGER 
  "amount_impacting_personal_contribution_in_cents": INTEGER 
  "amount_to_reimburse_to_hospital_by_alan_in_cents": INTEGER 
  "care_act_consolidated_info_id": UUID 
  "consumed_limits": JSONB 
  "context_properties": ARRAY 
  "coverage_decision": VARCHAR(255) 
  "creator_id": UUID 
  "custom_comment": TEXT 
  "dead_branch_at": DATETIME 
  "dead_branch_caused_by": UUID 
  "dead_branch_caused_by_type": TEXT 
  "marked_as_impacted_limits": ARRAY 
  "operator_comment": TEXT 
  "paid_by_hospital_id": UUID 
  "paid_by_insurance_profile_id": UUID 
  "review_context": JSONB 
  "source": VARCHAR(255) 
  "used_care_act_decision_rule_id": UUID 
  "used_enrollment_id": UUID 
  "validation_status": VARCHAR(255) 
  "version": INTEGER 
}
"CARE_ACT_SETTLEMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount_in_cents": INTEGER 
  "care_act_coverage_computation_result_id": UUID 
  "hospital_id": UUID 
  "indu_repayment_qonto_transaction_id": VARCHAR(255) 
  "indu_repayment_stripe_charge_id": VARCHAR(255) 
  "invoice_payment_reference": VARCHAR 
  "type": VARCHAR(255) 
  "user_id": UUID 
}
"REIMBURSEMENT_PAYMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount_in_cents": INTEGER 
  "author_id": UUID 
  "description": VARCHAR(255) 
  "failed_at": DATETIME 
  "qonto_transaction_id": VARCHAR(255) 
  "revolut_business_account_name": VARCHAR(255) 
  "revolut_refund_id": VARCHAR(255) 
  "revolut_transaction_id": VARCHAR(255) 
  "settlement_id": UUID 
  "status": VARCHAR(255) 
  "status_reason": TEXT 
  "submitted_at": DATETIME 
  "succeeded_at": DATETIME 
  "to_iban_id": UUID 
  "transfer_type": VARCHAR(255) 
}
"HOSPITAL_PAYMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount_in_cents": INTEGER 
  "author_id": UUID 
  "committed_to_assur_card": BOOLEAN 
  "description": VARCHAR(255) 
  "failed_at": DATETIME 
  "qonto_transaction_id": VARCHAR(255) 
  "revolut_business_account_name": VARCHAR(255) 
  "revolut_refund_id": VARCHAR(255) 
  "revolut_transaction_id": VARCHAR(255) 
  "settlement_id": UUID 
  "status": VARCHAR(255) 
  "status_reason": TEXT 
  "submitted_at": DATETIME 
  "succeeded_at": DATETIME 
  "to_iban_id": UUID 
  "transfer_type": VARCHAR(255) 
}
"CLAIM_MANAGEMENT_NOTIFICATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "category": VARCHAR(255) 
  "email_tracking_id": UUID 
  "hospital_payment_id": UUID 
  "push_notification_log_ref": VARCHAR(255) 
  "reimbursement_payment_id": UUID 
  "settlement_id": UUID 
}
"PARSED_DOCUMENT_CONTENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "creator_id": UUID 
  "dead_branch_at": DATETIME 
  "dead_branch_caused_by": UUID 
  "dead_branch_caused_by_type": TEXT 
  "document_id": UUID 
  "document_type": VARCHAR(255) 
  "external_parsing_api_call_id": UUID 
  "hospitalization_declaration_id": UUID 
  "operator_comment": TEXT 
  "parsing_complete_at": DATETIME 
  "parsing_context": JSONB 
  "parsing_result": JSONB 
  "rejection_content": TEXT 
  "rejection_reason": VARCHAR(255) 
  "review_context": JSONB 
  "source": VARCHAR(255) 
  "time_spent_parsing_seconds": FLOAT 
  "validation_status": VARCHAR(255) 
  "version": INTEGER 
}
"SOURCE_CARE_ACT_EXTRACTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "creator_id": UUID 
  "dead_branch_at": DATETIME 
  "dead_branch_caused_by": UUID 
  "dead_branch_caused_by_type": TEXT 
  "operator_comment": TEXT 
  "parsed_bvac_id": UUID 
  "parsed_document_content_id": UUID 
  "parsed_hospitalization_invoice_id": UUID 
  "review_context": JSONB 
  "source": VARCHAR(255) 
  "validation_status": VARCHAR(255) 
  "version": INTEGER 
}
"CARE_ACT_PARTIAL_INFO" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "act_id_code": VARCHAR(50) 
  "act_id_type": VARCHAR(255) 
  "amount_invoiced_in_cents": INTEGER 
  "amount_paid_in_cents": INTEGER 
  "amount_reimbursed_by_mutuality_in_cents": INTEGER 
  "beneficiary_insurance_profile_id": UUID 
  "care_act_source": VARCHAR(255) 
  "care_act_type": VARCHAR(255) 
  "delivering_pharmacy_inami_code": BIGINT 
  "delivering_pharmacy_name": TEXT 
  "description": TEXT 
  "end_date": DATE 
  "health_practitioner_code": VARCHAR(255) 
  "health_practitioner_name": VARCHAR(255) 
  "hospital_bank_account": VARCHAR(255) 
  "hospitalization_invoice_payment_reference": TEXT 
  "hospitalization_room_type": VARCHAR(255) 
  "paid_by_hospital_id": UUID 
  "paid_by_insurance_profile_id": UUID 
  "prescribing_doctor_code": VARCHAR(255) 
  "prescribing_doctor_name": TEXT 
  "quantity": INTEGER 
  "source_care_act_extraction_id": UUID 
  "start_date": DATE 
}
"SOURCE_CARE_ACT_MATCHING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "creator_id": UUID 
  "dead_branch_at": DATETIME 
  "dead_branch_caused_by": UUID 
  "dead_branch_caused_by_type": TEXT 
  "operator_comment": TEXT 
  "result": JSONB 
  "review_context": JSONB 
  "source": VARCHAR(255) 
  "source_care_act_extraction_id": UUID 
  "validation_status": VARCHAR(255) 
  "version": INTEGER 
}
"CLAIM_MANAGEMENT_PROCESSING_CONTEXT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "bvac_file_id": UUID 
  "care_act_consolidated_info_id": UUID 
  "care_act_coverage_computation_result_id": UUID 
  "care_act_id": UUID 
  "care_act_partial_info_id": UUID 
  "care_act_settlement_id": UUID 
  "content": JSONB 
  "hospital_payment_id": UUID 
  "is_exception": BOOLEAN 
  "parsed_bvac_id": UUID 
  "parsed_document_content_id": UUID 
  "parsed_hospitalization_invoice_id": UUID 
  "reimbursement_payment_id": UUID 
  "source_care_act_extraction_id": UUID 
  "source_care_act_matching_id": UUID 
}
"DOCUMENT_REPROCESS_REQUEST" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "detail": TEXT 
  "document_id": UUID 
  "generated_parsed_document_content_id": UUID 
  "reason": TEXT 
  "rejected_at": DATETIME 
  "rejected_by_id": UUID 
  "requested_by_id": UUID 
}
"HOSPITAL_ROOM" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "comment": TEXT 
  "hospital_id": UUID 
  "price_in_cents": INTEGER 
  "room_type": VARCHAR(255) 
  "source": VARCHAR(255) 
  "supplements_in_percent": INTEGER 
}
"INTERNAL_CONTROL_RATIO" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "care_act_type": VARCHAR(255) 
  "hospitalization_declaration_type": VARCHAR(255) 
  "ratio_in_decimal": FLOAT 
  "source_type": VARCHAR(255) 
}
"INTERNAL_CONTROL_REVIEW" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "parsed_document_content_id": UUID 
  "parsed_hospitalization_invoice_id": UUID 
  "validation_status": VARCHAR(255) 
}
"BESCO_ACT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "act_code": INTEGER 
  "besco_act_id": INTEGER 
  "commercialized_since": DATE 
  "commercialized_until": DATE 
  "description_fr": TEXT 
  "description_nl": TEXT 
  "public_price_in_cents": INTEGER 
  "start_date_of_application": DATE 
}
"BESCO_ACT_CURRENT_POSSIBLE_MUTUALITY_INTERVENTION_REFERENCE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "age_from": FLOAT 
  "age_to": FLOAT 
  "ambu_act_code": INTEGER 
  "besco_act_id": INTEGER 
  "condition_fr": TEXT 
  "condition_nl": TEXT 
  "has_gmd": BOOLEAN 
  "is_conventioned": BOOLEAN 
  "is_referred": BOOLEAN 
  "public_price_in_cents": INTEGER 
  "reference": VARCHAR(10) 
  "start_date_of_application": DATE 
}
"BESCO_ACT_HISTORY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "ValueA1_1_in_cents": INTEGER 
  "ValueA1_2_in_cents": INTEGER 
  "ValueA1_3_in_cents": INTEGER 
  "ValueA1_4_in_cents": INTEGER 
  "ValueA1_5_in_cents": INTEGER 
  "ValueA1_6_in_cents": INTEGER 
  "ValueA1_7_in_cents": INTEGER 
  "ValueA1_8_in_cents": INTEGER 
  "ValueA2_1_in_cents": INTEGER 
  "ValueA2_2_in_cents": INTEGER 
  "ValueA2_3_in_cents": INTEGER 
  "ValueA2_4_in_cents": INTEGER 
  "ValueA2_5_in_cents": INTEGER 
  "ValueA2_6_in_cents": INTEGER 
  "ValueA2_7_in_cents": INTEGER 
  "ValueA3_1_in_cents": INTEGER 
  "ValueA3_2_in_cents": INTEGER 
  "ValueA3_3_in_cents": INTEGER 
  "ValueA3_4_in_cents": INTEGER 
  "ValueA3_5_in_cents": INTEGER 
  "ValueA3_6_in_cents": INTEGER 
  "ValueA3_7_in_cents": INTEGER 
  "ValueA4_1_in_cents": INTEGER 
  "ValueA4_2_in_cents": INTEGER 
  "ValueA4_3_in_cents": INTEGER 
  "ValueA4_4_in_cents": INTEGER 
  "ValueA4_5_in_cents": INTEGER 
  "ValueA4_6_in_cents": INTEGER 
  "ValueA4_7_in_cents": INTEGER 
  "ValueA5_1_in_cents": INTEGER 
  "ValueA5_2_in_cents": INTEGER 
  "ValueA5_3_in_cents": INTEGER 
  "ValueA5_5_in_cents": INTEGER 
  "ValueA6_1_in_cents": INTEGER 
  "ValueA6_2_in_cents": INTEGER 
  "ValueA6_3_in_cents": INTEGER 
  "ValueA6_4_in_cents": INTEGER 
  "ValueA6_5_in_cents": INTEGER 
  "ValueA6_6_in_cents": INTEGER 
  "act_code": INTEGER 
  "besco_act_id": INTEGER 
  "public_price_in_cents": INTEGER 
  "start_date_of_application": DATE 
}
"BESCO_ACT_POSSIBLE_MUTUALITY_INTERVENTION_REFERENCE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "age_from": FLOAT 
  "age_to": FLOAT 
  "ambu_act_code": INTEGER 
  "besco_act_id": INTEGER 
  "condition_fr": TEXT 
  "condition_nl": TEXT 
  "has_gmd": BOOLEAN 
  "is_conventioned": BOOLEAN 
  "is_referred": BOOLEAN 
  "reference": VARCHAR(10) 
  "start_date_of_application": DATE 
}
"BESCO_ACT_POSSIBLE_MUTUALITY_INTERVENTION_VALUES" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "ValueA1_1_in_cents": INTEGER 
  "ValueA1_2_in_cents": INTEGER 
  "ValueA1_3_in_cents": INTEGER 
  "ValueA1_4_in_cents": INTEGER 
  "ValueA1_5_in_cents": INTEGER 
  "ValueA1_6_in_cents": INTEGER 
  "ValueA1_7_in_cents": INTEGER 
  "ValueA1_8_in_cents": INTEGER 
  "ValueA2_1_in_cents": INTEGER 
  "ValueA2_2_in_cents": INTEGER 
  "ValueA2_3_in_cents": INTEGER 
  "ValueA2_4_in_cents": INTEGER 
  "ValueA2_5_in_cents": INTEGER 
  "ValueA2_6_in_cents": INTEGER 
  "ValueA2_7_in_cents": INTEGER 
  "ValueA2_8_in_cents": INTEGER 
  "ValueA3_1_in_cents": INTEGER 
  "ValueA3_2_in_cents": INTEGER 
  "ValueA3_3_in_cents": INTEGER 
  "ValueA3_4_in_cents": INTEGER 
  "ValueA3_5_in_cents": INTEGER 
  "ValueA3_6_in_cents": INTEGER 
  "ValueA3_7_in_cents": INTEGER 
  "ValueA3_8_in_cents": INTEGER 
  "ValueA4_1_in_cents": INTEGER 
  "ValueA4_2_in_cents": INTEGER 
  "ValueA4_3_in_cents": INTEGER 
  "ValueA4_4_in_cents": INTEGER 
  "ValueA4_5_in_cents": INTEGER 
  "ValueA4_6_in_cents": INTEGER 
  "ValueA4_7_in_cents": INTEGER 
  "ValueA4_8_in_cents": INTEGER 
  "ValueA5_1_in_cents": INTEGER 
  "ValueA5_2_in_cents": INTEGER 
  "ValueA5_3_in_cents": INTEGER 
  "ValueA5_4_in_cents": INTEGER 
  "ValueA5_5_in_cents": INTEGER 
  "ValueA5_6_in_cents": INTEGER 
  "ValueA5_7_in_cents": INTEGER 
  "ValueA5_8_in_cents": INTEGER 
  "ValueA6_1_in_cents": INTEGER 
  "ValueA6_2_in_cents": INTEGER 
  "ValueA6_3_in_cents": INTEGER 
  "ValueA6_4_in_cents": INTEGER 
  "ValueA6_5_in_cents": INTEGER 
  "ValueA6_6_in_cents": INTEGER 
  "ValueA6_7_in_cents": INTEGER 
  "ValueA6_8_in_cents": INTEGER 
  "ValueA7_1_in_cents": INTEGER 
  "ValueA7_2_in_cents": INTEGER 
  "ValueA7_3_in_cents": INTEGER 
  "ValueA7_4_in_cents": INTEGER 
  "ValueA7_5_in_cents": INTEGER 
  "ValueA7_6_in_cents": INTEGER 
  "ValueA7_7_in_cents": INTEGER 
  "ValueA7_8_in_cents": INTEGER 
  "ValueA8_1_in_cents": INTEGER 
  "ValueA8_2_in_cents": INTEGER 
  "ValueA8_3_in_cents": INTEGER 
  "ValueA8_4_in_cents": INTEGER 
  "ValueA8_5_in_cents": INTEGER 
  "ValueA8_6_in_cents": INTEGER 
  "ValueA8_7_in_cents": INTEGER 
  "ValueA8_8_in_cents": INTEGER 
  "ambu_act_code": INTEGER 
  "besco_act_id": INTEGER 
}
"HEALTH_PRACTITIONER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "city": VARCHAR(255) 
  "first_name": TEXT 
  "gender": VARCHAR(1) 
  "inami_number": INTEGER 
  "last_name": TEXT 
  "zip_code": VARCHAR(5) 
}
"HEALTH_PRACTITIONER_CONVENTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "convention_end": DATE 
  "convention_start": DATE 
  "inami_number": INTEGER 
  "is_conventioned": BOOLEAN 
  "is_partially_conventioned": BOOLEAN 
  "qualification_code": INTEGER 
}
"PRODUCT_PACKAGE_INFO" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "atc_code": VARCHAR(255) 
  "begin_date": DATE 
  "cnk": BIGINT 
  "cnk_amb_hosp": BIGINT 
  "description_fr": TEXT 
  "description_nl": TEXT 
  "end_date": DATE 
  "subtype_fr": VARCHAR(255) 
  "subtype_nl": VARCHAR(255) 
  "type": VARCHAR(255) 
}
"PRODUCT_PRICE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "cnk": BIGINT 
  "from_date": DATE 
  "paid_price_in_cents": INTEGER 
  "public_price_in_cents": INTEGER 
  "reimbursement_group": VARCHAR(10) 
  "type_code": INTEGER 
  "type_group": INTEGER 
}
"PRODUCT_REIMBURSEMENT_GROUP" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "begin_date": DATE 
  "cnk": BIGINT 
  "end_date": DATE 
  "reimbursement_group": VARCHAR(10) 
}
"CARE_CASE_SOURCE_DOCUMENTS" {
  shape: sql_table
  "bvac_id": UUID 
  "care_case_id": UUID 
  "hospital_invoice_id": UUID 
  "parsed_document_content_id": UUID 
  "source_type": VARCHAR(10) 
}
"CARE_CASE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount_invoiced_in_cents": INTEGER 
  "care_type": VARCHAR(255) 
  "end_date": DATE 
  "health_practitioner": VARCHAR(255) 
  "insurance_profile_id": UUID 
  "source_bvac_file_id": UUID 
  "start_date": DATE 
}
"HOSPITALIZATION_DECLARATION_REVIEW_RESULT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "blocked_reason": TEXT 
  "creator_id": UUID 
  "dead_branch_at": DATETIME 
  "dead_branch_caused_by": UUID 
  "dead_branch_caused_by_type": TEXT 
  "hospitalization_declaration_id": UUID 
  "operator_comment": TEXT 
  "required_information_to_unblock": VARCHAR(255) 
  "review_context": JSONB 
  "source": VARCHAR(255) 
  "unblocked_with_textual_explanation_from_member": TEXT 
  "validation_status": VARCHAR(255) 
  "version": INTEGER 
}
"REWARD" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "charity_donation_amount_in_cents": INTEGER 
  "charity_donation_payment_status": VARCHAR(255) 
  "charity_donation_qonto_transaction_id": VARCHAR(255) 
  "charity_name": VARCHAR(255) 
  "hospitalization_declaration_id": UUID 
  "status": VARCHAR(255) 
  "submitted_to_qonto_by": VARCHAR(100) 
  "user_benefit_amount_in_cents": INTEGER 
  "user_benefit_payment_status": VARCHAR(255) 
}
"REWARD_PAYMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount_in_cents": INTEGER 
  "author_id": UUID 
  "description": VARCHAR(255) 
  "failed_at": DATETIME 
  "qonto_transaction_id": VARCHAR(255) 
  "revolut_business_account_name": VARCHAR(255) 
  "revolut_refund_id": VARCHAR(255) 
  "revolut_transaction_id": VARCHAR(255) 
  "reward_id": UUID 
  "status": VARCHAR(255) 
  "status_reason": TEXT 
  "submitted_at": DATETIME 
  "succeeded_at": DATETIME 
  "to_iban_id": UUID 
  "transfer_type": VARCHAR(255) 
}
"DOCUMENT_SEVERE_ILLNESS_ASSOC" {
  shape: sql_table
  "document_id": UUID 
  "severe_illness_id": UUID 
}
"SEVERE_ILLNESS" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "description": TEXT 
  "end_date": DATE 
  "insurance_profile_id": UUID 
  "is_cancelled": BOOLEAN 
  "severe_illness_type": VARCHAR(255) 
  "start_date": DATE 
}
"HEALTH_PRACTITIONER_DECISION_RULE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "action": VARCHAR(255) 
  "end_date": DATE 
  "first_name": TEXT 
  "health_practitioner_code": TEXT 
  "last_name": TEXT 
  "postal_code": TEXT 
  "source": TEXT 
  "specialty": VARCHAR(255) 
  "start_date": DATE 
}
"CARE_ACT_LINK_EVENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "care_act_id": UUID 
  "care_act_partial_info_id": UUID 
  "is_active": BOOLEAN 
  "rank_for_care_act": INTEGER 
  "replacing_link_event_id": UUID 
  "source_care_act_matching_id": UUID 
  "type": VARCHAR(255) 
}
"REIMBURSEMENT_REQUEST_REVIEW_RESULT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "blocked_reason": TEXT 
  "creator_id": UUID 
  "dead_branch_at": DATETIME 
  "dead_branch_caused_by": UUID 
  "dead_branch_caused_by_type": TEXT 
  "operator_comment": TEXT 
  "reimbursement_request_id": UUID 
  "required_information_to_unblock": VARCHAR(255) 
  "review_context": JSONB 
  "source": VARCHAR(255) 
  "unblocked_with_textual_explanation_from_member": TEXT 
  "validation_status": VARCHAR(255) 
  "version": INTEGER 
}
"SETTLEMENT_CARE_ACT_MAPPING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "care_act_coverage_computation_result_id": UUID 
  "new_care_act_id": UUID 
  "settlement_id": UUID 
}
"HEALTH_INTEREST_SURVEY_ANSWER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "health_interest_name": VARCHAR 
  "medical_conversation_id": UUID 
  "survey_version": INTEGER 
  "user_id": UUID 
}
"ITSME_USER_LINK" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "alan_user_id": UUID 
  "context": VARCHAR(255) 
  "eid_card_number": VARCHAR(255) 
  "first_name": VARCHAR(255) 
  "itsme_subject_id": VARCHAR(255) 
  "last_name": VARCHAR(255) 
  "national_registration_number": VARCHAR(255) 
}
"DOCUMENT_TRANSCRIPTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "confidence": FLOAT 
  "detected_category": VARCHAR 
  "detected_category_confidence": FLOAT 
  "detected_language": VARCHAR 
  "detected_subcategory": VARCHAR 
  "detected_subcategory_confidence": FLOAT 
  "document_id": UUID 
  "gcloud_full_transcription_s3_key": TEXT 
  "gcloud_text_transcription_s3_key": TEXT 
  "pct_handwritten": FLOAT 
  "pdf_transcription_s3_key": TEXT 
  "raw_transcription": TEXT 
  "textract_transcription_s3_key": TEXT 
  "transcription_text": VARCHAR(50000) 
  "transcription_text_method": TEXT 
}
"EXTERNAL_PARSING_API_CALL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "api_call_metadata": JSONB 
  "api_call_type": VARCHAR(255) 
  "api_called_at": DATETIME 
  "document_id": UUID 
  "error": TEXT 
  "insurance_profile_id": UUID 
  "provider": VARCHAR(255) 
  "status_code": INTEGER 
}
"ACCOUNTANT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "company_id": UUID 
  "email": VARCHAR(255) 
  "lang": VARCHAR(2) 
  "should_receive_invoices": BOOLEAN 
  "should_receive_pay_info": BOOLEAN 
}
"ALAN_EMPLOYEE" {
  shape: sql_table
  "id": INTEGER {constraint: primary_key}
  "alan_email": VARCHAR(255) 
  "end_date": DATE 
  "roles": ARRAY 
  "start_date": DATE 
  "user_id": UUID 
}
"AUDIT_RECORD" {
  shape: sql_table
  "id": INTEGER {constraint: primary_key}
  "actor_id": UUID 
  "audit_event_type": VARCHAR 
  "data": JSONB 
}
"BENEFICIARY_PRIVACY_SETTING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "requester_insurance_profile_id": UUID 
  "subject_insurance_profile_id": UUID 
  "type": VARCHAR(255) 
}
"CARE_CONVERSATION_CONTEXT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "context": JSONB 
  "conversation_id": TEXT 
  "conversation_id_eu": TEXT 
  "original_care_conversation_context_id": UUID 
  "user_id": UUID 
}
"COMMAND_LOG" {
  shape: sql_table
  "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 
}
"COMMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "author_id": UUID 
  "end_date": DATE 
  "hospital_id": UUID 
  "is_cancelled": BOOLEAN 
  "start_date": DATE 
  "text": TEXT 
  "user_id": UUID 
}
"COMPANY_ADMIN" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "company_id": UUID 
  "ended_at": DATETIME 
  "last_seen_at": DATETIME 
  "user_id": UUID 
}
"COMPANY_ADMIN_INVITATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "cancelled_at": DATETIME 
  "company_admin_id": UUID 
  "company_id": UUID 
  "invite_email": VARCHAR(255) 
  "invite_emails_sent": INTEGER 
}
"CONTRACT_FLEXBEN_INFO" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "first_selection_period_end_date": DATE 
  "first_selection_period_start_date": DATE 
  "has_continuous_coverage": BOOLEAN 
  "provider_name": VARCHAR(255) 
}
"PROSPECT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "email": VARCHAR(255) 
}
"EMAIL_LOG" {
  shape: sql_table
  "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) 
  "prospect_id": UUID 
  "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 
}
"EMPLOYMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "company_id": UUID 
  "end_date": DATE 
  "invite_email": VARCHAR(255) 
  "invite_email_last_sent": DATETIME 
  "invite_emails_sent": INTEGER 
  "invited_by_shortlink": BOOLEAN 
  "is_cancelled": BOOLEAN 
  "payroll_id": VARCHAR 
  "remind_onboard_email_last_sent": DATETIME 
  "remind_onboard_sent_to_admin_email_last_sent": DATETIME 
  "start_date": DATE 
  "user_id": UUID 
}
"FEATURE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "feature_metadata": JSONB 
  "feature_owner": TEXT 
  "is_active": BOOLEAN 
  "name": VARCHAR(255) 
  "percent_enabled": INTEGER 
}
"FEATURE_OVERRIDE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_id": UUID 
  "company_id": UUID 
  "feature_id": UUID 
  "user_id": UUID 
}
"BE_HEALTH_SUBSCRIPTION_PAYLOAD" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "flexben_info_id": UUID 
  "has_dependent_affiliation_delay": BOOLEAN 
  "health_plan_id": UUID 
  "next_renewal_date": DATE 
  "participation_json": JSONB 
  "signed_bundle_id": UUID 
}
"IBAN" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "assur_card_hospital_id": UUID 
  "company_id": UUID 
  "country_iso": VARCHAR(2) 
  "end_date": DATE 
  "iban": VARCHAR(34) 
  "is_active": BOOLEAN 
  "name": VARCHAR(255) 
  "sepa_signed_bundle_id": UUID 
  "sepa_unique_id": VARCHAR(35) 
  "start_date": DATE 
  "stripe_payment_method_id": VARCHAR(255) 
  "stripe_sepa_debit_source_id": VARCHAR(255) 
  "suspended_by_stripe_on": DATE 
  "swift": VARCHAR(11) 
  "type": VARCHAR(255) 
  "user_id": UUID 
}
"PAY_CSV" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "email_sent_at": DATETIME 
  "health_contract_id": UUID 
  "month": DATE 
  "new_activity_uri": VARCHAR(2083) 
  "uri": VARCHAR(2083) 
}
"POLICY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "end_date": DATE 
  "health_contract_id": UUID 
  "is_cancelled": BOOLEAN 
  "max_insurance_document_scoped_number": INTEGER 
  "start_date": DATE 
  "termination_type": VARCHAR(255) 
}
"FLEXBEN_CHOICE_PROCESSING_LINE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "company_id": UUID 
  "corrected_by_line_id": UUID 
  "data": JSONB 
  "primary_email": VARCHAR(255) 
  "processing_error": JSONB 
}
"FLEXBEN_CHOICE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "employment_id": UUID 
  "end_date": DATE 
  "flexben_choice_processing_line_id": UUID 
  "health_contract_id": UUID 
  "is_cancelled": BOOLEAN 
  "is_validated": BOOLEAN 
  "start_date": DATE 
}
"PREMIUM_ENTRY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "base_price": INTEGER 
  "cancelled_premium_entry_id": UUID 
  "days_in_month": INTEGER 
  "enrollment_id": UUID 
  "flexben_choice_id": UUID 
  "invoice_id": UUID 
  "membership_fee_cents": INTEGER 
  "month": DATE 
  "pay_csv_id": UUID 
  "premium": INTEGER 
  "tax_rate": FLOAT 
  "version": INTEGER 
}
"PRICE_RULE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "child_estimated_acquisition_costs_cents": INTEGER 
  "child_estimated_administration_costs_cents": INTEGER 
  "child_invoicing_tax_rate": FLOAT 
  "child_membership_fee_cents": INTEGER 
  "child_taxes_and_contributions_cents": INTEGER 
  "child_taxes_membership_fee_cents": INTEGER 
  "child_total_premium_cents": INTEGER 
  "estimated_acquisition_costs_cents": INTEGER 
  "estimated_administration_costs_cents": INTEGER 
  "invoicing_tax_rate": FLOAT 
  "max_age": INTEGER 
  "membership_fee_cents": INTEGER 
  "min_age": INTEGER 
  "partner_estimated_acquisition_costs_cents": INTEGER 
  "partner_estimated_administration_costs_cents": INTEGER 
  "partner_invoicing_tax_rate": FLOAT 
  "partner_membership_fee_cents": INTEGER 
  "partner_taxes_and_contributions_cents": INTEGER 
  "partner_taxes_membership_fee_cents": INTEGER 
  "partner_total_premium_cents": INTEGER 
  "price_grid_id": UUID 
  "primary_estimated_acquisition_costs_cents": INTEGER 
  "primary_estimated_administration_costs_cents": INTEGER 
  "primary_invoicing_tax_rate": FLOAT 
  "primary_membership_fee_cents": INTEGER 
  "primary_taxes_and_contributions_cents": INTEGER 
  "primary_taxes_membership_fee_cents": INTEGER 
  "primary_total_premium_cents": INTEGER 
  "taxes_and_contributions_cents": INTEGER 
  "taxes_membership_fee_cents": INTEGER 
  "total_premium_cents": INTEGER 
}
"PRIVACY_PROPERTIES" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "column_name": VARCHAR 
  "privacy_properties": JSONB 
  "schema_name": VARCHAR 
  "table_name": VARCHAR 
}
"PUSH_NOTIFICATION_LOG" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "actor_id": UUID 
  "data": JSONB 
  "name": VARCHAR 
  "push_notification_token": VARCHAR 
  "status": VARCHAR(255) 
  "user_id": UUID 
}
"PUSH_NOTIFICATION_PENDING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "actor_id": UUID 
  "body": VARCHAR 
  "do_not_send_before": DATETIME 
  "extra_data": JSONB 
  "name": VARCHAR 
  "redirect_screen": VARCHAR 
  "title": VARCHAR 
  "user_id": UUID 
}
"PUSH_NOTIFICATION_TOKEN" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "has_permission": BOOLEAN 
  "platform": VARCHAR(16) 
  "registration_token": VARCHAR(256) 
  "user_id": UUID 
}
"QUEUE_POOL" {
  shape: sql_table
  "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
  "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 
}
"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) 
}
"USER_PROFILE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "eid": VARCHAR(14) 
  "rrn": VARCHAR(15) 
  "user_id": UUID 
}
"WEBHOOK_ENDPOINT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "actor_id": UUID 
  "deactivated_at": DATETIME 
  "description": TEXT 
  "event_types": ARRAY 
  "name": TEXT 
  "signature_key": VARCHAR 
  "url": TEXT 
}
"COMPANY_COMMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "author_id": UUID 
  "company_id": UUID 
  "end_date": DATE 
  "is_cancelled": BOOLEAN 
  "start_date": DATE 
  "text": TEXT 
}
"COMPANY_ONBOARDING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "admin_auth_email": VARCHAR(255) 
  "admin_first_name": VARCHAR(255) 
  "admin_last_name": VARCHAR(255) 
  "admin_phone": VARCHAR(16) 
  "admin_user_id": UUID 
  "alan_partner_code": VARCHAR(255) 
  "author_id": INTEGER 
  "company_city": VARCHAR(255) 
  "company_country": VARCHAR(255) 
  "company_employee_estimate": INTEGER 
  "company_id": UUID 
  "company_name": VARCHAR(255) 
  "company_population_name": VARCHAR 
  "company_postal_code": VARCHAR(255) 
  "company_street": VARCHAR(255) 
  "company_vat": VARCHAR(255) 
  "hellosign_signature": VARCHAR(255) 
  "iban_code": VARCHAR(34) 
  "iban_id": UUID 
  "is_self_serve": BOOLEAN 
  "lang": VARCHAR(2) 
  "legal_representative_email": VARCHAR(255) 
  "legal_representative_first_name": VARCHAR(255) 
  "legal_representative_language": VARCHAR(2) 
  "legal_representative_last_name": VARCHAR(255) 
  "onboarding_complete": BOOLEAN 
  "payment_method": VARCHAR(255) 
  "self_serve": JSON 
}
"CONSENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "has_given_exchange_with_medical_team_consent": BOOLEAN 
  "user_id": UUID 
}
"EMPLOYEE_ONBOARDING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "agreed_to_terms_at": DATETIME 
  "birth_date": DATE 
  "city": VARCHAR(255) 
  "company_id": UUID 
  "country": VARCHAR(255) 
  "coverage_start_date": DATE 
  "first_name": VARCHAR(255) 
  "gender": VARCHAR(255) 
  "health_contract_id": UUID 
  "iban_code": VARCHAR 
  "iban_id": UUID 
  "invite_email": VARCHAR(255) 
  "invite_email_tracking_id": UUID 
  "invited_by_id": UUID 
  "lang": VARCHAR(2) 
  "last_name": VARCHAR(255) 
  "payroll_id": VARCHAR 
  "phone": VARCHAR(16) 
  "postal_code": VARCHAR(255) 
  "street": VARCHAR(255) 
  "user_id": UUID 
}
"FLEXBEN_CHOICE_LINE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "coverage_module_name": VARCHAR(255) 
  "dependent_type": VARCHAR(255) 
  "flexben_choice_id": UUID 
  "insurance_profile_id": UUID 
  "is_adult_pricing": BOOLEAN 
}
"FLEXBEN_CHOICE_PROCESSING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "choices_processed_date": DATE 
  "health_contract_id": UUID 
}
"HEALTH_CONTRACT_CONFIG" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "child_participation": INTEGER 
  "company_onboarding_id": UUID 
  "dependent_participation": INTEGER 
  "end_date": DATE 
  "has_dependent_affiliation_delay": BOOLEAN 
  "health_contract_id": UUID 
  "health_plan_id": UUID 
  "hellosign_signature_id": VARCHAR(255) 
  "hellosign_signature_request_id": VARCHAR(255) 
  "hellosign_succeeded_at": DATETIME 
  "is_cancelled": BOOLEAN 
  "next_renewal_date": DATE 
  "participation": INTEGER 
  "payment_method": VARCHAR(255) 
  "start_date": DATE 
  "uri": VARCHAR(2083) 
}
"HEALTH_COVERAGE_RULE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "health_coverage_id": UUID 
  "limit_amount_in_cents": INTEGER 
  "limit_type": VARCHAR(255) 
  "limit_window": VARCHAR(255) 
}
"PAYFLIP_FLEXBEN_CHECKOUT_SESSION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "expires_at": DATETIME 
  "flexben_choice_id": UUID 
  "is_cancelled": BOOLEAN 
  "payflip_session_id": TEXT 
  "url": TEXT 
}
"SDWORX_SPENDING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "chosen_amount_cents": INTEGER 
  "contract_id": TEXT 
  "email": TEXT 
  "end_date": DATE 
  "first_name": TEXT 
  "flexben_choice_id": UUID 
  "insurance_profile_id": UUID 
  "is_cancelled": BOOLEAN 
  "last_name": TEXT 
  "organization_id": TEXT 
  "person_id": UUID 
  "spending_id": TEXT 
  "start_date": DATE 
}
"PREMIUM_COMPONENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount": INTEGER 
  "beneficiary_type": VARCHAR(8) 
  "cancelled_by_entry_id": UUID 
  "cancelled_entry_id": UUID 
  "collection_method": VARCHAR(14) 
  "contribution_type": VARCHAR(14) 
  "coverage_type": VARCHAR(8) 
  "currency": VARCHAR 
  "debtor_type": VARCHAR(7) 
  "enrollment_id": UUID 
  "invoice_id": CHAR(32) 
  "num_days": INTEGER 
  "period_end": DATE 
  "period_start": DATE 
  "premium_entry_id": UUID 
  "version": INTEGER 
}
"ACCOUNT_ADMIN" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_id": UUID 
  "ended_at": DATETIME 
  "user_id": UUID 
}
"HOSPITALIZATION_DECLARATION"."id" -> "DOCUMENT_HOSPITALIZATION_DECLARATION"."hospitalization_declaration_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DOCUMENT"."id" -> "DOCUMENT_HOSPITALIZATION_DECLARATION"."document_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"SEVERE_ILLNESS_TYPE"."id" -> "HEALTH_PLAN_SEVERE_ILLNESS_TYPE_ASSOC"."severe_illness_type_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HEALTH_PLAN"."id" -> "HEALTH_PLAN_SEVERE_ILLNESS_TYPE_ASSOC"."health_plan_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"SEVERE_ILLNESS_TYPE"."id" -> "HEALTH_COVERAGE_SEVERE_ILLNESS_TYPE_ASSOC"."severe_illness_type_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HEALTH_COVERAGE"."id" -> "HEALTH_COVERAGE_SEVERE_ILLNESS_TYPE_ASSOC"."health_coverage_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HEALTH_COVERAGE"."id" -> "PRICE_GRID"."health_coverage_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HEALTH_COVERAGE"."id" -> "COVERAGE_MODULE"."health_coverage_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PRICE_GRID"."id" -> "COVERAGE_MODULE"."price_grid_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HEALTH_PLAN"."id" -> "COVERAGE_MODULE"."health_plan_id": {
  source-arrowhead.shape: cf-one
  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" -> "ENROLLMENT"."policy_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "INSURANCE_PROFILE"."user_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"INSURANCE_PROFILE"."id" -> "HOSPITALIZATION_DECLARATION"."insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"HOSPITAL"."id" -> "HOSPITALIZATION_DECLARATION"."assur_card_hospital_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"ADDRESS"."id" -> "USER"."address_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"TRANSACTION"."id" -> "ACTIVITY"."transaction_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"ADDRESS"."id" -> "ACCOUNT"."address_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"COMPANY"."id" -> "VALID_SIGNATORY"."company_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"ITSME_USER_LINK"."id" -> "VALID_SIGNATORY"."itsme_user_link_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
}
"SIGNED_BUNDLE"."id" -> "HEALTH_CONTRACT"."signed_bundle_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "HEALTH_CONTRACT"."individual_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HEALTH_CONTRACT"."id" -> "HEALTH_CONTRACT"."parent_health_contract_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "HEALTH_CONTRACT"."company_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"FILE_IMPORT"."id" -> "EMPLOYEE_STATE_EXTRACTION"."assusoft_file_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "EMPLOYEE_STATE_EXTRACTION"."company_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"HEALTH_CONTRACT"."id" -> "EMPLOYEE_STATE_EXTRACTION"."health_contract_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "EMPLOYEE_STATE_EXTRACTION"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"FILE_IMPORT"."id" -> "DEPENDENT_STATE_EXTRACTION"."assusoft_file_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"EMPLOYEE_STATE_EXTRACTION"."id" -> "DEPENDENT_STATE_EXTRACTION"."employee_extraction_state_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "DEPENDENT_STATE_EXTRACTION"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"INSTALLMENT_PLAN"."id" -> "INSTALLMENT"."installment_plan_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"IBAN"."id" -> "PAYMENT"."iban_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"PAYMENT"."id" -> "PAYMENT"."disputed_payment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"INVOICE"."id" -> "PAYMENT"."invoice_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"INSTALLMENT"."id" -> "PAYMENT"."installment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"PAYMENT"."id" -> "PAYMENT"."refunded_payment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"BILLING_TASK_EXECUTION"."id" -> "BILLING_TASK_EXECUTION_RQ_JOB"."billing_task_execution_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"REIMBURSEMENT_REQUEST"."id" -> "DOCUMENT_REIMBURSEMENT_REQUEST"."reimbursement_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DOCUMENT"."id" -> "DOCUMENT_REIMBURSEMENT_REQUEST"."document_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "DOCUMENT"."beneficiary_insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "DOCUMENT"."uploader_insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "REIMBURSEMENT_REQUEST"."user_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" -> "DEPRECATED_BVAC"."insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"BVAC_FILE"."id" -> "DEPRECATED_BVAC"."bvac_file_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DEPRECATED_BVAC"."id" -> "PARSED_BVAC"."bvac_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "PARSED_BVAC"."insurance_profile_scanner_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"BVAC_FILE"."id" -> "PARSED_BVAC"."bvac_file_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "PARSED_BVAC"."insurance_profile_beneficiary_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "PARSED_BVAC"."creator_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"HOSPITALIZATION_INVOICE_FILE"."id" -> "HOSPITALIZATION_INVOICE"."hospitalization_invoice_file_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"HOSPITALIZATION_INVOICE"."id" -> "PARSED_HOSPITALIZATION_INVOICE"."hospitalization_invoice_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "PARSED_HOSPITALIZATION_INVOICE"."creator_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"HOSPITAL"."id" -> "PARSED_HOSPITALIZATION_INVOICE"."hospital_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"HOSPITALIZATION_INVOICE_FILE"."id" -> "PARSED_HOSPITALIZATION_INVOICE"."hospitalization_invoice_file_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PARSED_HOSPITALIZATION_INVOICE"."id" -> "PARSED_HOSPITALIZATION_INVOICE"."credit_note_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HOSPITALIZATION_DECLARATION"."id" -> "PARSED_HOSPITALIZATION_INVOICE"."hospitalization_declaration_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "PARSED_HOSPITALIZATION_INVOICE"."insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"REIMBURSEMENT_REQUEST"."id" -> "CLAIM_MANAGEMENT_INTERCOM_TASK"."reimbursement_request_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"PARSED_BVAC"."id" -> "CLAIM_MANAGEMENT_INTERCOM_TASK"."parsed_bvac_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"HOSPITALIZATION_DECLARATION"."id" -> "CLAIM_MANAGEMENT_INTERCOM_TASK"."hospitalization_declaration_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"PARSED_HOSPITALIZATION_INVOICE"."id" -> "CLAIM_MANAGEMENT_INTERCOM_TASK"."parsed_hospitalization_invoice_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"DOCUMENT"."id" -> "CLAIM_MANAGEMENT_INTERCOM_TASK"."document_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"ENROLLMENT"."id" -> "LEGACY_LIMIT"."enrollment_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"HOSPITALIZATION_DECLARATION"."id" -> "HOSPITAL_INVOICE"."hospitalization_declaration_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"HOSPITALIZATION_INVOICE"."id" -> "HOSPITAL_INVOICE"."hospitalization_invoice_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"HOSPITAL_INVOICE"."id" -> "SETTLEMENT"."hospital_invoice_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HOSPITAL"."id" -> "SETTLEMENT"."recipient_hospital_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "SETTLEMENT"."recipient_user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"LEGACY_LIMIT"."id" -> "SETTLEMENT"."ambulatory_limit_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "SETTLEMENT"."beneficiary_insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "SETTLEMENT"."creator_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CARE_ACT_SETTLEMENT"."id" -> "CARE_ACT_SETTLEMENT_ASSOCIATION_TABLE"."care_act_settlement_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HOSPITAL_PAYMENT"."id" -> "CARE_ACT_SETTLEMENT_ASSOCIATION_TABLE"."hospital_payment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"REIMBURSEMENT_PAYMENT"."id" -> "CARE_ACT_SETTLEMENT_ASSOCIATION_TABLE"."reimbursement_payment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HOSPITAL"."id" -> "CARE_ACT_CONSOLIDATED_INFO"."paid_by_hospital_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "CARE_ACT_CONSOLIDATED_INFO"."beneficiary_insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "CARE_ACT_CONSOLIDATED_INFO"."paid_by_insurance_profile_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
}
"USER"."id" -> "CARE_ACT_CONSOLIDATED_INFO"."creator_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "CARE_ACT_DECISION_RULE"."for_insurance_profile_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "CARE_ACT_DECISION_RULE"."creator_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"ENROLLMENT"."id" -> "CARE_ACT_COVERAGE_COMPUTATION_RESULT"."used_enrollment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HOSPITAL"."id" -> "CARE_ACT_COVERAGE_COMPUTATION_RESULT"."paid_by_hospital_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "CARE_ACT_COVERAGE_COMPUTATION_RESULT"."creator_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CARE_ACT_DECISION_RULE"."id" -> "CARE_ACT_COVERAGE_COMPUTATION_RESULT"."used_care_act_decision_rule_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "CARE_ACT_COVERAGE_COMPUTATION_RESULT"."paid_by_insurance_profile_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
}
"USER"."id" -> "CARE_ACT_SETTLEMENT"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CARE_ACT_COVERAGE_COMPUTATION_RESULT"."id" -> "CARE_ACT_SETTLEMENT"."care_act_coverage_computation_result_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HOSPITAL"."id" -> "CARE_ACT_SETTLEMENT"."hospital_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"SETTLEMENT"."id" -> "REIMBURSEMENT_PAYMENT"."settlement_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "REIMBURSEMENT_PAYMENT"."author_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"IBAN"."id" -> "REIMBURSEMENT_PAYMENT"."to_iban_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"IBAN"."id" -> "HOSPITAL_PAYMENT"."to_iban_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"SETTLEMENT"."id" -> "HOSPITAL_PAYMENT"."settlement_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "HOSPITAL_PAYMENT"."author_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"HOSPITAL_PAYMENT"."id" -> "CLAIM_MANAGEMENT_NOTIFICATION"."hospital_payment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"REIMBURSEMENT_PAYMENT"."id" -> "CLAIM_MANAGEMENT_NOTIFICATION"."reimbursement_payment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"SETTLEMENT"."id" -> "CLAIM_MANAGEMENT_NOTIFICATION"."settlement_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"DOCUMENT"."id" -> "PARSED_DOCUMENT_CONTENT"."document_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"HOSPITALIZATION_DECLARATION"."id" -> "PARSED_DOCUMENT_CONTENT"."hospitalization_declaration_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "PARSED_DOCUMENT_CONTENT"."creator_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PARSED_DOCUMENT_CONTENT"."id" -> "SOURCE_CARE_ACT_EXTRACTION"."parsed_document_content_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"PARSED_BVAC"."id" -> "SOURCE_CARE_ACT_EXTRACTION"."parsed_bvac_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"PARSED_HOSPITALIZATION_INVOICE"."id" -> "SOURCE_CARE_ACT_EXTRACTION"."parsed_hospitalization_invoice_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "SOURCE_CARE_ACT_EXTRACTION"."creator_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "CARE_ACT_PARTIAL_INFO"."beneficiary_insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"SOURCE_CARE_ACT_EXTRACTION"."id" -> "CARE_ACT_PARTIAL_INFO"."source_care_act_extraction_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"HOSPITAL"."id" -> "CARE_ACT_PARTIAL_INFO"."paid_by_hospital_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "CARE_ACT_PARTIAL_INFO"."paid_by_insurance_profile_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "SOURCE_CARE_ACT_MATCHING"."creator_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"SOURCE_CARE_ACT_EXTRACTION"."id" -> "SOURCE_CARE_ACT_MATCHING"."source_care_act_extraction_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PARSED_BVAC"."id" -> "CLAIM_MANAGEMENT_PROCESSING_CONTEXT"."parsed_bvac_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CARE_ACT_CONSOLIDATED_INFO"."id" -> "CLAIM_MANAGEMENT_PROCESSING_CONTEXT"."care_act_consolidated_info_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CARE_ACT_SETTLEMENT"."id" -> "CLAIM_MANAGEMENT_PROCESSING_CONTEXT"."care_act_settlement_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"REIMBURSEMENT_PAYMENT"."id" -> "CLAIM_MANAGEMENT_PROCESSING_CONTEXT"."reimbursement_payment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CARE_ACT_PARTIAL_INFO"."id" -> "CLAIM_MANAGEMENT_PROCESSING_CONTEXT"."care_act_partial_info_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"BVAC_FILE"."id" -> "CLAIM_MANAGEMENT_PROCESSING_CONTEXT"."bvac_file_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"SOURCE_CARE_ACT_EXTRACTION"."id" -> "CLAIM_MANAGEMENT_PROCESSING_CONTEXT"."source_care_act_extraction_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CARE_ACT_COVERAGE_COMPUTATION_RESULT"."id" -> "CLAIM_MANAGEMENT_PROCESSING_CONTEXT"."care_act_coverage_computation_result_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"SOURCE_CARE_ACT_MATCHING"."id" -> "CLAIM_MANAGEMENT_PROCESSING_CONTEXT"."source_care_act_matching_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HOSPITAL_PAYMENT"."id" -> "CLAIM_MANAGEMENT_PROCESSING_CONTEXT"."hospital_payment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CARE_ACT"."id" -> "CLAIM_MANAGEMENT_PROCESSING_CONTEXT"."care_act_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"PARSED_DOCUMENT_CONTENT"."id" -> "CLAIM_MANAGEMENT_PROCESSING_CONTEXT"."parsed_document_content_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"PARSED_HOSPITALIZATION_INVOICE"."id" -> "CLAIM_MANAGEMENT_PROCESSING_CONTEXT"."parsed_hospitalization_invoice_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"DOCUMENT"."id" -> "DOCUMENT_REPROCESS_REQUEST"."document_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "DOCUMENT_REPROCESS_REQUEST"."rejected_by_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "DOCUMENT_REPROCESS_REQUEST"."requested_by_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PARSED_DOCUMENT_CONTENT"."id" -> "DOCUMENT_REPROCESS_REQUEST"."generated_parsed_document_content_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HOSPITAL"."id" -> "HOSPITAL_ROOM"."hospital_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PARSED_HOSPITALIZATION_INVOICE"."id" -> "INTERNAL_CONTROL_REVIEW"."parsed_hospitalization_invoice_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"PARSED_DOCUMENT_CONTENT"."id" -> "INTERNAL_CONTROL_REVIEW"."parsed_document_content_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HOSPITAL_INVOICE"."id" -> "CARE_CASE_SOURCE_DOCUMENTS"."hospital_invoice_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"PARSED_DOCUMENT_CONTENT"."id" -> "CARE_CASE_SOURCE_DOCUMENTS"."parsed_document_content_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"DEPRECATED_BVAC"."id" -> "CARE_CASE_SOURCE_DOCUMENTS"."bvac_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CARE_CASE"."id" -> "CARE_CASE_SOURCE_DOCUMENTS"."care_case_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"BVAC_FILE"."id" -> "CARE_CASE"."source_bvac_file_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "CARE_CASE"."insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"HOSPITALIZATION_DECLARATION"."id" -> "HOSPITALIZATION_DECLARATION_REVIEW_RESULT"."hospitalization_declaration_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "HOSPITALIZATION_DECLARATION_REVIEW_RESULT"."creator_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"HOSPITALIZATION_DECLARATION"."id" -> "REWARD"."hospitalization_declaration_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"REWARD"."id" -> "REWARD_PAYMENT"."reward_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "REWARD_PAYMENT"."author_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"IBAN"."id" -> "REWARD_PAYMENT"."to_iban_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"SEVERE_ILLNESS"."id" -> "DOCUMENT_SEVERE_ILLNESS_ASSOC"."severe_illness_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"DOCUMENT"."id" -> "DOCUMENT_SEVERE_ILLNESS_ASSOC"."document_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "SEVERE_ILLNESS"."insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CARE_ACT_LINK_EVENT"."id" -> "CARE_ACT_LINK_EVENT"."replacing_link_event_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"CARE_ACT"."id" -> "CARE_ACT_LINK_EVENT"."care_act_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"SOURCE_CARE_ACT_MATCHING"."id" -> "CARE_ACT_LINK_EVENT"."source_care_act_matching_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CARE_ACT_PARTIAL_INFO"."id" -> "CARE_ACT_LINK_EVENT"."care_act_partial_info_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"REIMBURSEMENT_REQUEST"."id" -> "REIMBURSEMENT_REQUEST_REVIEW_RESULT"."reimbursement_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "REIMBURSEMENT_REQUEST_REVIEW_RESULT"."creator_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"SETTLEMENT"."id" -> "SETTLEMENT_CARE_ACT_MAPPING"."settlement_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CARE_ACT"."id" -> "SETTLEMENT_CARE_ACT_MAPPING"."new_care_act_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CARE_ACT_COVERAGE_COMPUTATION_RESULT"."id" -> "SETTLEMENT_CARE_ACT_MAPPING"."care_act_coverage_computation_result_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "HEALTH_INTEREST_SURVEY_ANSWER"."user_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "ITSME_USER_LINK"."alan_user_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DOCUMENT"."id" -> "DOCUMENT_TRANSCRIPTION"."document_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "ACCOUNTANT"."company_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
}
"USER"."id" -> "AUDIT_RECORD"."actor_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "BENEFICIARY_PRIVACY_SETTING"."requester_insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "BENEFICIARY_PRIVACY_SETTING"."subject_insurance_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "CARE_CONVERSATION_CONTEXT"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CARE_CONVERSATION_CONTEXT"."id" -> "CARE_CONVERSATION_CONTEXT"."original_care_conversation_context_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "COMMENT"."author_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "COMMENT"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HOSPITAL"."id" -> "COMMENT"."hospital_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "COMPANY_ADMIN"."company_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "COMPANY_ADMIN"."user_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "COMPANY_ADMIN_INVITATION"."company_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"COMPANY_ADMIN"."id" -> "COMPANY_ADMIN_INVITATION"."company_admin_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "EMAIL_LOG"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"PROSPECT"."id" -> "EMAIL_LOG"."prospect_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "EMPLOYMENT"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "EMPLOYMENT"."company_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"FEATURE"."id" -> "FEATURE_OVERRIDE"."feature_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"HEALTH_PLAN"."id" -> "BE_HEALTH_SUBSCRIPTION_PAYLOAD"."health_plan_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"SIGNED_BUNDLE"."id" -> "BE_HEALTH_SUBSCRIPTION_PAYLOAD"."signed_bundle_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CONTRACT_FLEXBEN_INFO"."id" -> "BE_HEALTH_SUBSCRIPTION_PAYLOAD"."flexben_info_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "IBAN"."company_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HOSPITAL"."id" -> "IBAN"."assur_card_hospital_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"SIGNED_BUNDLE"."id" -> "IBAN"."sepa_signed_bundle_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"USER"."id" -> "IBAN"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HEALTH_CONTRACT"."id" -> "PAY_CSV"."health_contract_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"HEALTH_CONTRACT"."id" -> "POLICY"."health_contract_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"FLEXBEN_CHOICE_PROCESSING_LINE"."id" -> "FLEXBEN_CHOICE_PROCESSING_LINE"."corrected_by_line_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "FLEXBEN_CHOICE_PROCESSING_LINE"."company_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"EMPLOYMENT"."id" -> "FLEXBEN_CHOICE"."employment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"FLEXBEN_CHOICE_PROCESSING_LINE"."id" -> "FLEXBEN_CHOICE"."flexben_choice_processing_line_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HEALTH_CONTRACT"."id" -> "FLEXBEN_CHOICE"."health_contract_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"PAY_CSV"."id" -> "PREMIUM_ENTRY"."pay_csv_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"INVOICE"."id" -> "PREMIUM_ENTRY"."invoice_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"ENROLLMENT"."id" -> "PREMIUM_ENTRY"."enrollment_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"FLEXBEN_CHOICE"."id" -> "PREMIUM_ENTRY"."flexben_choice_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"PREMIUM_ENTRY"."id" -> "PREMIUM_ENTRY"."cancelled_premium_entry_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"PRICE_GRID"."id" -> "PRICE_RULE"."price_grid_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "PUSH_NOTIFICATION_LOG"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "PUSH_NOTIFICATION_PENDING"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "PUSH_NOTIFICATION_TOKEN"."user_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "REFRESH_TOKEN"."user_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
}
"USER"."id" -> "USER_PROFILE"."user_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "COMPANY_COMMENT"."company_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "COMPANY_COMMENT"."author_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "COMPANY_ONBOARDING"."admin_user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "COMPANY_ONBOARDING"."company_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"ALAN_EMPLOYEE"."id" -> "COMPANY_ONBOARDING"."author_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"IBAN"."id" -> "COMPANY_ONBOARDING"."iban_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "CONSENT"."user_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"COMPANY"."id" -> "EMPLOYEE_ONBOARDING"."company_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "EMPLOYEE_ONBOARDING"."invited_by_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HEALTH_CONTRACT"."id" -> "EMPLOYEE_ONBOARDING"."health_contract_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "EMPLOYEE_ONBOARDING"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"IBAN"."id" -> "EMPLOYEE_ONBOARDING"."iban_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"FLEXBEN_CHOICE"."id" -> "FLEXBEN_CHOICE_LINE"."flexben_choice_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"INSURANCE_PROFILE"."id" -> "FLEXBEN_CHOICE_LINE"."insurance_profile_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HEALTH_CONTRACT"."id" -> "FLEXBEN_CHOICE_PROCESSING"."health_contract_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"COMPANY_ONBOARDING"."id" -> "HEALTH_CONTRACT_CONFIG"."company_onboarding_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"HEALTH_CONTRACT"."id" -> "HEALTH_CONTRACT_CONFIG"."health_contract_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"HEALTH_PLAN"."id" -> "HEALTH_CONTRACT_CONFIG"."health_plan_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"HEALTH_COVERAGE"."id" -> "HEALTH_COVERAGE_RULE"."health_coverage_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"FLEXBEN_CHOICE"."id" -> "PAYFLIP_FLEXBEN_CHECKOUT_SESSION"."flexben_choice_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"FLEXBEN_CHOICE"."id" -> "SDWORX_SPENDING"."flexben_choice_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"INSURANCE_PROFILE"."id" -> "SDWORX_SPENDING"."insurance_profile_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "ACCOUNT_ADMIN"."user_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"ACCOUNT"."id" -> "ACCOUNT_ADMIN"."account_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}

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