Data model

"subscription"."CONTRACT_OPTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amendment_id": UUID 
  "children_participation": INTEGER 
  "children_price": INTEGER 
  "company_onboarding_id": UUID 
  "configuration": JSONB 
  "dependent_participation": INTEGER 
  "end_date": DATE 
  "health_contract_id": UUID 
  "health_contract_version_id": UUID 
  "is_cancelled": BOOLEAN 
  "is_employee_selectable": BOOLEAN 
  "participation": INTEGER 
  "partner_price": INTEGER 
  "pre_discount_price": INTEGER 
  "price": INTEGER 
  "primary_price": INTEGER 
  "start_date": DATE 
  "type": VARCHAR(50) 
}
"subscription"."HEALTH_CONTRACT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "alan_mind_slug": VARCHAR 
  "company_id": UUID 
  "debits_suspension_date": DATE 
  "dependent_participation": INTEGER 
  "dkv_id": VARCHAR(10) 
  "end_date": DATE 
  "is_cancelled": BOOLEAN 
  "is_ended_for_upsell": BOOLEAN 
  "max_dkv_id_on_policy": INTEGER 
  "participation": INTEGER 
  "payment_method": VARCHAR(31) 
  "price": INTEGER 
  "signed_bundle_id": UUID 
  "start_date": DATE 
  "user_id": UUID 
}
"subscription"."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) 
}
"subscription"."HEALTH_CONTRACT_VERSION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "dependent_participation": INTEGER 
  "end_date": DATE 
  "health_contract_id": UUID 
  "is_cancelled": BOOLEAN 
  "participation": INTEGER 
  "price": INTEGER 
  "signed_bundle_id": UUID 
  "start_date": DATE 
}
"ACCOUNT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "name": VARCHAR(255) 
}
"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 
  "authentication_id": UUID 
  "birth_date": DATE 
  "email": VARCHAR(255) 
  "first_name": VARCHAR(255) 
  "gender": VARCHAR(255) 
  "has_access_to_meeting_doctors": BOOLEAN 
  "has_opted_in_to_commercial_emails": BOOLEAN 
  "health_stripe_customer_id": VARCHAR(255) 
  "keycloak_id": UUID 
  "lang": VARCHAR(2) 
  "last_booking_synchronisation_at": DATE 
  "last_name": VARCHAR(255) 
  "phone": VARCHAR 
  "profile_id": UUID 
}
"EMPLOYMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "company_id": UUID 
  "connector_external_id": VARCHAR 
  "end_date": DATE 
  "finiquito_generation_date": DATE 
  "invite_email": VARCHAR(255) 
  "invite_email_last_sent": DATETIME 
  "invite_emails_sent": INTEGER 
  "invited_by_shortlink": BOOLEAN 
  "is_cancelled": BOOLEAN 
  "offboarding_email_send_date": DATE 
  "offboarding_email_sent": 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 
}
"COMPANY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_id": UUID 
  "address_id": UUID 
  "adyen_legal_entity_id": VARCHAR(255) 
  "connector_credentials": VARCHAR 
  "connector_filters": JSONB 
  "connector_rollout_date": DATE 
  "connector_type": VARCHAR 
  "coverage_start_date_max_day_of_month": INTEGER 
  "day_to_send_pay_info": INTEGER 
  "demo": BOOLEAN 
  "dependent_coverage_start_date_max_day_of_month": INTEGER 
  "display_name": VARCHAR(255) 
  "employee_estimate": INTEGER 
  "force_offboarding_date_on_end_of_month": BOOLEAN 
  "health_stripe_customer_id": VARCHAR(255) 
  "healthy_benefits_stripe_customer_id": VARCHAR(255) 
  "name": VARCHAR(255) 
  "nif": VARCHAR(11) 
  "payment_account_id": UUID 
  "population_name": VARCHAR 
  "use_auto_enrollment": BOOLEAN 
  "use_connector": BOOLEAN 
  "use_employee_payroll_id": BOOLEAN 
}
"subscription"."AMENDMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "company_id": UUID 
  "lang": VARCHAR(10) 
  "new_contract_id": UUID 
  "new_contract_version_id": UUID 
  "previous_contract_id": UUID 
  "previous_contract_version_id": UUID 
  "signed_at": DATETIME 
  "signer_email": VARCHAR(255) 
  "signer_first_name": VARCHAR(255) 
  "signer_last_name": VARCHAR(255) 
  "start_date": DATE 
  "status": VARCHAR(255) 
  "user_id": UUID 
}
"subscription"."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) 
}
"billing"."INSTALLMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount": INTEGER 
  "installment_plan_id": UUID 
}
"billing"."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) 
}
"payroll"."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 
  "enrollment_option_id": UUID 
  "finiquito_id": UUID 
  "invoice_id": UUID 
  "month": DATE 
  "pay_csv_id": UUID 
  "premium": INTEGER 
  "version": INTEGER 
}
"billing"."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) 
}
"IBAN" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "company_id": UUID 
  "country_iso": VARCHAR(2) 
  "end_date": DATE 
  "healthy_benefits_sepa_unique_id": VARCHAR(35) 
  "iban": VARCHAR(34) 
  "name": VARCHAR(255) 
  "sepa_unique_id": VARCHAR(35) 
  "start_date": DATE 
  "stripe_healthy_benefits_payment_method_id": VARCHAR(255) 
  "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 
}
"ENROLLMENT_OPTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "contract_option_id": UUID 
  "end_date": DATE 
  "enrollment_id": UUID 
  "is_cancelled": BOOLEAN 
  "start_date": DATE 
}
"CARD_SHIPMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "batch_id": UUID 
  "enrollment_id": UUID 
  "reason": VARCHAR 
  "status": VARCHAR 
}
"CARD_SHIPMENT_BATCH" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
}
"ENROLLMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "civil_status_with_primary": VARCHAR 
  "dkv_id": INTEGER 
  "dkv_status": VARCHAR 
  "end_date": DATE 
  "insurance_profile_id": UUID 
  "is_cancelled": BOOLEAN 
  "policy_id": UUID 
  "start_date": DATE 
  "termination_type": VARCHAR(255) 
  "type": VARCHAR(255) 
}
"healthy_benefits"."ES_NURSERY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "address_id": UUID 
  "contact_email": VARCHAR 
  "iban_code": VARCHAR(34) 
  "name": VARCHAR 
  "phone_number": VARCHAR 
  "terminated_at": DATETIME 
}
"INSURANCE_PROFILE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "dkv_id": VARCHAR(10) 
  "gira_id": UUID 
  "identity_document_type": VARCHAR(16) 
  "nif_number": VARCHAR(16) 
  "user_id": UUID 
}
"healthy_benefits"."ES_NURSERY_BENEFICIARY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "birth_date": DATE 
  "enrollment_ref": UUID 
  "first_name": VARCHAR 
  "insurance_profile_id": UUID 
  "last_name": VARCHAR 
  "terminated_at": DATETIME 
}
"healthy_benefits"."ES_NURSERY_INSTALLMENT_PLAN" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "beneficiary_id": UUID 
  "end_date": DATE 
  "enrollment_ref": UUID 
  "is_paused": BOOLEAN 
  "monthly_amount": INTEGER 
  "nursery_id": UUID 
  "payment_type": VARCHAR(255) 
  "start_date": DATE 
  "terminated_at": DATETIME 
  "working_mom_tax_deduction": BOOLEAN 
}
"COMPANY_ADMIN" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "company_id": UUID 
  "connector_credentials": VARCHAR 
  "connector_type": VARCHAR 
  "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 
}
"COMPANY_ONBOARDING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_id": UUID 
  "admin_auth_email": VARCHAR(255) 
  "admin_email": VARCHAR(255) 
  "admin_first_name": VARCHAR(255) 
  "admin_last_name": VARCHAR(255) 
  "average_age": INTEGER 
  "company_admin_id": UUID 
  "company_city": VARCHAR(255) 
  "company_country": VARCHAR(255) 
  "company_employee_estimate": INTEGER 
  "company_id": UUID 
  "company_name": VARCHAR(255) 
  "company_nif": VARCHAR(11) 
  "company_population_name": VARCHAR 
  "company_postal_code": VARCHAR(255) 
  "company_street": VARCHAR(255) 
  "contract_dependent_participation": INTEGER 
  "contract_end_date": DATE 
  "contract_participation": INTEGER 
  "contract_start_date": DATE 
  "existing_admin_credentials_authentication_id": UUID 
  "health_contract_price": INTEGER 
  "hellosign_signature": VARCHAR(255) 
  "iban_code": VARCHAR(34) 
  "iban_id": UUID 
  "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 
  "opportunity_id": VARCHAR(50) 
  "payment_method": VARCHAR(31) 
  "pre_discount_price": INTEGER 
  "uses_2020_legacy_pricing": BOOLEAN 
}
"POLICY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "dkv_id": INTEGER 
  "end_date": DATE 
  "health_contract_id": UUID 
  "is_cancelled": BOOLEAN 
  "max_dkv_id_on_enrollment": INTEGER 
  "start_date": DATE 
  "termination_type": 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 
}
"AMEDICS_PROFESSIONAL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amedics_id": VARCHAR 
  "medical_specialty_code": VARCHAR(5) 
  "professional_name": VARCHAR 
}
"AMEDICS_BOOKABLE_ACTIVITY" {
  shape: sql_table
  "id": VARCHAR {constraint: primary_key}
  "clinic_dkv_id": INTEGER 
  "doctor_nif": VARCHAR 
  "first_availability": DATETIME 
  "medical_specialty_dkv_id": VARCHAR(5) 
  "professional_id": VARCHAR 
  "title": VARCHAR 
}
"AUTHORIZATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "dkv_api_status": VARCHAR 
  "dkv_api_status_checked_at": DATETIME 
  "dkv_authorization_id": VARCHAR 
  "dkv_authorization_metadata": JSONB 
  "dkv_medical_service_code": VARCHAR(5) 
  "dkv_medical_specialty_code": VARCHAR(5) 
  "enrollment_id": UUID 
  "hospital_address_code": INTEGER 
  "hospital_company_code": INTEGER 
  "hospital_nif": VARCHAR(9) 
  "hospitalization_date": DATE 
  "hospitalization_type": VARCHAR 
  "performer_address_code": INTEGER 
  "performer_company_code": INTEGER 
  "performer_nif": VARCHAR(9) 
  "scope": VARCHAR 
}
"AUTHORIZATION_DOCUMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "authorization_id": UUID 
  "content_hash": VARCHAR(64) 
  "mime_type": VARCHAR(255) 
  "name": VARCHAR(255) 
  "uri": VARCHAR(2083) 
}
"BOOKING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "booked_for_user_id": UUID 
  "cancelled_at": DATETIME 
  "clinic_dkv_id": VARCHAR 
  "doctor_nif": VARCHAR 
  "end_localtime": DATETIME 
  "medical_specialty_code": VARCHAR(5) 
  "provider": VARCHAR 
  "provider_booking_id": VARCHAR 
  "start_localtime": DATETIME 
  "timezone": INTEGER 
  "user_id": UUID 
}
"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_DRAFT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_id": UUID 
  "admin_auth_email": VARCHAR(255) 
  "admin_first_name": VARCHAR(255) 
  "admin_last_name": VARCHAR(255) 
  "author_id": UUID 
  "average_age": INTEGER 
  "company_city": VARCHAR(255) 
  "company_country": VARCHAR(5) 
  "company_employee_estimate": INTEGER 
  "company_name": VARCHAR(255) 
  "company_nif": VARCHAR(9) 
  "company_onboarding_id": UUID 
  "company_postal_code": VARCHAR(255) 
  "company_street": VARCHAR(255) 
  "contract_children_participation": INTEGER 
  "contract_dependent_participation": INTEGER 
  "contract_participation": INTEGER 
  "contract_start_date": DATE 
  "fresa_children_participation": INTEGER 
  "fresa_dependent_participation": INTEGER 
  "fresa_is_employee_selectable": BOOLEAN 
  "fresa_participation": INTEGER 
  "fresa_price": INTEGER 
  "fresa_selected": BOOLEAN 
  "fresa_start_date": DATE 
  "health_contract_price": INTEGER 
  "iban_code": VARCHAR(34) 
  "lang": VARCHAR(2) 
  "manzana_children_participation": INTEGER 
  "manzana_dependent_participation": INTEGER 
  "manzana_free_therapy_sessions_limit": INTEGER 
  "manzana_has_copayments": BOOLEAN 
  "manzana_has_waiting_periods": BOOLEAN 
  "manzana_is_employee_selectable": BOOLEAN 
  "manzana_participation": INTEGER 
  "manzana_price": INTEGER 
  "manzana_selected": BOOLEAN 
  "manzana_start_date": DATE 
  "manzana_waiting_periods_from_date": DATE 
  "name": VARCHAR(255) 
  "opportunity_id": VARCHAR(50) 
  "optical_children_participation": INTEGER 
  "optical_dependent_participation": INTEGER 
  "optical_is_employee_selectable": BOOLEAN 
  "optical_participation": INTEGER 
  "optical_price": INTEGER 
  "optical_selected": BOOLEAN 
  "optical_start_date": DATE 
  "payment_method": VARCHAR(31) 
  "pec_children_participation": INTEGER 
  "pec_dependent_participation": INTEGER 
  "pec_is_employee_selectable": BOOLEAN 
  "pec_participation": INTEGER 
  "pec_price": INTEGER 
  "pec_selected": BOOLEAN 
  "pec_start_date": DATE 
  "pharmacy_children_participation": INTEGER 
  "pharmacy_dependent_participation": INTEGER 
  "pharmacy_is_employee_selectable": BOOLEAN 
  "pharmacy_participation": INTEGER 
  "pharmacy_price": INTEGER 
  "pharmacy_selected": BOOLEAN 
  "pharmacy_start_date": DATE 
  "physio_nutrition_children_participation": INTEGER 
  "physio_nutrition_dependent_participation": INTEGER 
  "physio_nutrition_is_employee_selectable": BOOLEAN 
  "physio_nutrition_participation": INTEGER 
  "physio_nutrition_price": INTEGER 
  "physio_nutrition_selected": BOOLEAN 
  "physio_nutrition_start_date": DATE 
  "reimbursements_children_participation": INTEGER 
  "reimbursements_dependent_participation": INTEGER 
  "reimbursements_is_employee_selectable": BOOLEAN 
  "reimbursements_participation": INTEGER 
  "reimbursements_price": INTEGER 
  "reimbursements_selected": BOOLEAN 
  "reimbursements_start_date": DATE 
}
"CONCIERGE_REQUEST" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "actor_profile_id": UUID 
  "appointment_reason": VARCHAR 
  "bookedSlot": DATETIME 
  "booked_for_user_profile_id": UUID 
  "comments": VARCHAR 
  "location_address": VARCHAR 
  "medical_specialty_id": UUID 
  "medical_specialty_reference": VARCHAR 
  "preferred_languages": ARRAY 
  "status": VARCHAR(255) 
  "time_preferences": VARCHAR 
  "user_location": ARRAY 
}
"NETWORK_CLINIC_SPECIALTY" {
  shape: sql_table
  "medical_specialty_id": UUID 
  "network_clinic_id": UUID 
}
"NETWORK_DOCTOR_CLINIC_LINK" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "network_clinic_id": UUID 
  "network_doctor_id": UUID 
  "updated": BOOLEAN 
}
"NETWORK_CLINIC" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "address_city": VARCHAR(40) 
  "address_code": INTEGER 
  "address_postal_code": VARCHAR(5) 
  "address_province": VARCHAR(2) 
  "address_street": VARCHAR(128) 
  "company_code": INTEGER 
  "dkv_id": INTEGER 
  "dkv_medical_network_clinic_key": CHAR(64) 
  "gira_id": VARCHAR(6) 
  "is_displayed_in_find_a_doctor": BOOLEAN 
  "is_hospital": BOOLEAN 
  "latitude": REAL 
  "longitude": REAL 
  "name": VARCHAR(128) 
  "nif": VARCHAR(9) 
  "origin": VARCHAR(16) 
  "phone": VARCHAR(9) 
  "updated": BOOLEAN 
}
"CONCIERGE_BOOKING_OPTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "availabilities": ARRAY 
  "clinic_id": UUID 
  "concierge_request_id": UUID 
  "provider_channel": VARCHAR(255) 
  "provider_type": VARCHAR(255) 
  "status": VARCHAR(255) 
}
"voice_ai"."VOICE_AI_CALLS" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "agent_id": VARCHAR(255) 
  "agent_phone_number_id": VARCHAR(255) 
  "audio_url": TEXT 
  "call_type": VARCHAR(255) 
  "completed_at": DATETIME 
  "conversation_id": VARCHAR(255) 
  "country_code": VARCHAR(50) 
  "duration_seconds": INTEGER 
  "dynamic_vars": JSONB 
  "error_message": TEXT 
  "output_variables": JSONB 
  "started_at": DATETIME 
  "status": VARCHAR(255) 
  "to_number": VARCHAR(50) 
  "transcript": TEXT 
  "user_ref": VARCHAR(255) 
}
"CONCIERGE_BOOKING_OPTION_VOICE_CALL_LINK" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "concierge_booking_option_id": UUID 
  "retry_count": INTEGER 
  "voice_ai_call_id": UUID 
}
"CREU_BLANCA_CENTER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "address": VARCHAR 
  "city": VARCHAR 
  "country": VARCHAR 
  "creu_blanca_id": VARCHAR 
  "dkv_id": VARCHAR 
  "name": VARCHAR 
  "nif": VARCHAR 
  "state": VARCHAR 
}
"CREU_BLANCA_AGENDA" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "center_id": VARCHAR 
  "creu_blanca_id": VARCHAR 
  "is_doctor": BOOLEAN 
  "name": VARCHAR 
  "nif": VARCHAR 
}
"CREU_BLANCA_BOOKABLE_ACTIVITY" {
  shape: sql_table
  "id": VARCHAR {constraint: primary_key}
  "agenda_id": VARCHAR 
  "center_id": VARCHAR 
  "clinic_dkv_id": INTEGER 
  "doctor_nif": VARCHAR 
  "medical_specialty_dkv_id": VARCHAR(5) 
  "service_id": VARCHAR 
  "title": VARCHAR 
}
"CREU_BLANCA_SERVICE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "agenda_id": VARCHAR 
  "center_id": VARCHAR 
  "creu_blanca_id": VARCHAR 
  "name": VARCHAR 
  "nomenclature_act_code": VARCHAR 
  "nomenclature_list_code": VARCHAR 
  "nomenclature_specialty_code": VARCHAR 
}
"DENTAL_COVERAGE_RENEWAL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "company_id": UUID 
  "current_contract_id": UUID 
  "employee_communication_sent_at": DATETIME 
  "first_communication_sent_at": DATETIME 
  "new_contract_id": UUID 
  "second_communication_sent_at": DATETIME 
  "user_id": UUID 
}
"DENTAL_COVERAGE_RENEWAL_EMPLOYEE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "communication_sent_at": DATETIME 
  "enrollment_id": UUID 
  "user_id": UUID 
}
"DKV_API_CALL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "api_call_metadata": JSONB 
  "api_call_type": VARCHAR(255) 
  "called_at": DATETIME 
}
"DKV_AUTHORIZATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "additional_information_request": BOOLEAN 
  "authorization_approval_date": DATE 
  "authorization_creation_channel": VARCHAR(16) 
  "authorization_managed_date": DATE 
  "authorization_number": VARCHAR(16) 
  "authorization_registration_date": DATE 
  "authorization_status": VARCHAR(16) 
  "authorization_status_date": DATE 
  "authorization_validity_date": DATE 
  "card_number": VARCHAR(50) 
  "denial_reason_code": VARCHAR(5) 
  "denial_reason_description": VARCHAR(50) 
  "dkv_file_line": INTEGER 
  "dkv_file_name": VARCHAR(32) 
  "dkv_internal_document_id": VARCHAR(13) 
  "email": VARCHAR(80) 
  "file_posting_date": DATE 
  "inpatient_reason_code": VARCHAR(10) 
  "inpatient_reason_description": VARCHAR(50) 
  "insured_first_name": VARCHAR(50) 
  "insured_id": INTEGER 
  "insured_last_name": VARCHAR(50) 
  "medical_departement_review": BOOLEAN 
  "medical_report": VARCHAR(500) 
  "medical_service_code": INTEGER 
  "medical_service_description": VARCHAR(50) 
  "medical_specialty_code": INTEGER 
  "medical_specialty_description": VARCHAR(50) 
  "modication_date": DATE 
  "new_authorization_number": VARCHAR(16) 
  "number_of_days_in_medical_service": INTEGER 
  "patient_type": VARCHAR(16) 
  "personal_id": VARCHAR(16) 
  "policy_number": VARCHAR(16) 
  "prescriber_medical_specialty_code": INTEGER 
  "prescribing_professional_collegiate_number": INTEGER 
  "prescribing_professional_name": VARCHAR(50) 
  "prescribing_professional_nif": VARCHAR(9) 
  "prescribing_professional_point_of_service_id": INTEGER 
  "province_of_the_service": VARCHAR(2) 
  "treating_professional_business_info": VARCHAR(50) 
  "treating_professional_collegiate_number": INTEGER 
  "treating_professional_nif": VARCHAR(9) 
  "treating_professional_point_of_service_id": INTEGER 
}
"DKV_CLAIM" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "additional_code": VARCHAR(10) 
  "amount_paid_to_professional_in_cents": INTEGER 
  "authorization_code": VARCHAR(32) 
  "authorization_medical_service_code": INTEGER 
  "authorization_medical_specialty_code": INTEGER 
  "card_number": VARCHAR(25) 
  "date_of_payment": DATE 
  "date_of_registration_in_dkv": DATE 
  "date_of_service": DATE 
  "denial_reason_code": INTEGER 
  "denial_reason_description": VARCHAR(50) 
  "dkv_file_line": INTEGER 
  "dkv_file_name": VARCHAR(32) 
  "dkv_internal_document_id": VARCHAR(16) 
  "dni": VARCHAR(16) 
  "file_posting_date": DATE 
  "inpatient_invoice_detailed_code": VARCHAR(16) 
  "inpatient_reason_code": INTEGER 
  "inpatient_reason_description": VARCHAR(50) 
  "insured_first_name": VARCHAR(255) 
  "insured_id": INTEGER 
  "insured_last_name": VARCHAR(255) 
  "invoice_date": DATE 
  "invoice_number": VARCHAR(50) 
  "medical_service_code": INTEGER 
  "medical_service_number": VARCHAR(50) 
  "medical_specialty_code": INTEGER 
  "net_amount_in_cents": INTEGER 
  "number_of_days_in_medical_service": INTEGER 
  "patient_type": VARCHAR(16) 
  "payment_type": VARCHAR(50) 
  "point_of_service_id": INTEGER 
  "policy_number": VARCHAR(16) 
  "prescriber_medical_specialty_code": INTEGER 
  "prescribing_professional_id": INTEGER 
  "prescribing_professional_name": VARCHAR(65) 
  "prescribing_professional_nif": VARCHAR(9) 
  "professional_name": VARCHAR(65) 
  "professional_nif": VARCHAR(9) 
  "professional_tax_in_cents": INTEGER 
  "province_of_the_service": VARCHAR(2) 
  "service_amount_in_cents": INTEGER 
  "tariff_in_cents": INTEGER 
  "treating_professional_nif": VARCHAR(9) 
  "vat_tax_in_cents": INTEGER 
}
"DKV_CLAIM_WITHOUT_AMOUNTS" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "additional_code": VARCHAR(10) 
  "amount_paid_to_professional_in_cents": INTEGER 
  "authorization_code": VARCHAR(32) 
  "authorization_medical_service_code": INTEGER 
  "authorization_medical_specialty_code": INTEGER 
  "card_number": VARCHAR(25) 
  "date_of_payment": DATE 
  "date_of_registration_in_dkv": DATE 
  "date_of_service": DATE 
  "denial_reason_code": INTEGER 
  "denial_reason_description": VARCHAR(50) 
  "dkv_file_line": INTEGER 
  "dkv_file_name": VARCHAR(32) 
  "dkv_internal_document_id": VARCHAR(16) 
  "dni": VARCHAR(16) 
  "file_posting_date": DATE 
  "inpatient_invoice_detailed_code": VARCHAR(16) 
  "inpatient_reason_code": INTEGER 
  "inpatient_reason_description": VARCHAR(50) 
  "insured_first_name": VARCHAR(255) 
  "insured_id": INTEGER 
  "insured_last_name": VARCHAR(255) 
  "invoice_date": DATE 
  "invoice_number": VARCHAR(50) 
  "medical_service_code": INTEGER 
  "medical_service_number": VARCHAR(50) 
  "medical_specialty_code": INTEGER 
  "net_amount_in_cents": INTEGER 
  "number_of_days_in_medical_service": INTEGER 
  "patient_type": VARCHAR(16) 
  "payment_type": VARCHAR(50) 
  "point_of_service_id": INTEGER 
  "policy_number": VARCHAR(16) 
  "prescriber_medical_specialty_code": INTEGER 
  "prescribing_professional_id": INTEGER 
  "prescribing_professional_name": VARCHAR(65) 
  "prescribing_professional_nif": VARCHAR(9) 
  "professional_name": VARCHAR(65) 
  "professional_nif": VARCHAR(9) 
  "professional_tax_in_cents": INTEGER 
  "province_of_the_service": VARCHAR(2) 
  "service_amount_in_cents": INTEGER 
  "tariff_in_cents": INTEGER 
  "treating_professional_nif": VARCHAR(9) 
  "type_of_claims_file": VARCHAR(10) 
  "vat_tax_in_cents": INTEGER 
}
"DKV_MEDICAL_NETWORK" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "address_additional_info": VARCHAR(40) 
  "address_city": VARCHAR(40) 
  "address_code": INTEGER 
  "address_final_number": VARCHAR(6) 
  "address_initial_number": VARCHAR(6) 
  "address_phone_1": VARCHAR(9) 
  "address_postal_code": VARCHAR(5) 
  "address_province": VARCHAR(2) 
  "address_street_name": VARCHAR(50) 
  "address_type": VARCHAR(3) 
  "billing_nif": VARCHAR(9) 
  "cancellation_date_of_medical_network": DATE 
  "company_code": INTEGER 
  "dkv_id": INTEGER 
  "dkv_medical_specialty_id": UUID 
  "dkv_retrieved_file_name": VARCHAR(32) 
  "effective_date_on_medical_network_guideline": DATE 
  "included_medical_network_guideline": BOOLEAN 
  "is_preferred_provider": BOOLEAN 
  "network_name": VARCHAR(65) 
  "professional_name": VARCHAR(65) 
  "professional_nif": VARCHAR(9) 
  "rating_count_of_professional": INTEGER 
  "rating_of_professional": INTEGER 
  "safe_hashed_key": CHAR(128) 
}
"DKV_MEDICAL_SERVICE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "dkv_retrieved_file_name": VARCHAR(32) 
  "medical_service_code": VARCHAR(5) 
  "medical_service_description": VARCHAR(50) 
}
"DKV_MEDICAL_SERVICE_TO_DKV_MEDICAL_SPECIALTY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "dkv_medical_service_id": UUID 
  "dkv_medical_specialty_id": UUID 
  "dkv_retrieved_file_name": VARCHAR(32) 
  "needs_authorization": BOOLEAN 
  "scope": VARCHAR(1) 
}
"DKV_MEDICAL_SPECIALTY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "dkv_retrieved_file_name": VARCHAR(32) 
  "medical_specialty_code": VARCHAR(5) 
  "medical_specialty_description": VARCHAR(50) 
}
"DKV_RETRIEVED_FILE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "corrected_file_name": VARCHAR(255) 
  "dkv_file_name": VARCHAR(32) 
  "fetched_at": DATETIME 
  "file_metadata": JSONB 
  "status": VARCHAR(16) 
  "uri": VARCHAR(2083) 
}
"DOCTOR_LANGUAGE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "languages": ARRAY 
  "matching": VARCHAR 
  "name": VARCHAR 
  "nif": VARCHAR 
}
"DOCTOR_RATING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "nif": VARCHAR 
  "number_of_rating": INTEGER 
  "rating": INTEGER 
}
"EMPLOYEE_ONBOARDING" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "agreed_to_healthy_benefits_terms_at": DATETIME 
  "agreed_to_terms_at": DATETIME 
  "annual_salary": BIGINT 
  "auto_enrolled": BOOLEAN 
  "birth_date": DATE 
  "cancelled_at": DATE 
  "city": VARCHAR(255) 
  "company_id": UUID 
  "connector_external_id": VARCHAR 
  "coverage_end_date": DATE 
  "coverage_start_date": DATE 
  "email": VARCHAR(255) 
  "existing_user_credentials_authentication_id": UUID 
  "first_name": VARCHAR(255) 
  "gender": VARCHAR(8) 
  "health_contract_id": UUID 
  "healthy_benefits_start_date": DATE 
  "hiring_date": DATE 
  "iban_code": VARCHAR 
  "identity_document_type": VARCHAR(16) 
  "invitation_email_sent_at": DATETIME 
  "invite_email": VARCHAR(255) 
  "invite_email_tracking_id": UUID 
  "lang": VARCHAR(2) 
  "last_name": VARCHAR(255) 
  "nif_number": VARCHAR(16) 
  "opted_in_benefits": ARRAY 
  "opted_in_options": ARRAY 
  "payroll_id": VARCHAR 
  "phone": VARCHAR(16) 
  "population_id": VARCHAR(255) 
  "postal_code": VARCHAR(255) 
  "should_consent_to_healthy_benefits": BOOLEAN 
  "street": VARCHAR(255) 
  "tax_regime": TEXT 
  "user_id": UUID 
}
"ACCOUNT_ADMIN" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_id": UUID 
  "ended_at": DATETIME 
  "user_id": UUID 
}
"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 
}
"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 
  "is_cancelled": BOOLEAN 
  "start_date": DATE 
  "text": TEXT 
  "user_id": UUID 
}
"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 
}
"ES_EMPLOYEE_TRANSFER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "destination_company_id": UUID 
  "initial_employment_id": UUID 
  "new_employment_id": UUID 
  "reason": VARCHAR 
  "should_cancel_initial_employment": BOOLEAN 
  "status": VARCHAR 
  "transfer_date": DATE 
  "transferred_at": DATE 
}
"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 
}
"HEALTH_COVERAGE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
}
"PRICE_GRID" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
}
"PRICE_RULE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "price_grid_id": UUID 
}
"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 
}
"REIMBURSEMENT_REQUEST" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "dependent_id": UUID 
  "intercom_conversation_id": VARCHAR(255) 
  "intercom_conversation_id_eu": VARCHAR(255) 
  "specialty": VARCHAR 
  "user_id": UUID 
}
"SETTLEMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount_invoiced_in_cents": INTEGER 
  "amount_reimbursed_by_alan_in_cents": INTEGER 
  "beneficiary_id": UUID 
  "care_act_code": VARCHAR 
  "care_act_date": DATE 
  "comment": VARCHAR 
  "doctor_name": VARCHAR(125) 
  "invoice_number": VARCHAR 
  "manually_paid": BOOLEAN 
  "note_to_user": VARCHAR(125) 
  "prescriber_nif": VARCHAR 
  "prescriber_specialty_code": VARCHAR 
  "provider_nif": VARCHAR 
  "provider_specialty_code": VARCHAR 
  "reimbursement_request_id": UUID 
  "reimbursement_type": VARCHAR 
  "reviewer_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 
}
"GENDER_INFORMATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "ga_gender": VARCHAR(7) 
  "name": VARCHAR(65) 
  "nif": VARCHAR(9) 
}
"GIRA_API_CALL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "api_call_metadata": JSONB 
  "api_call_type": VARCHAR(255) 
  "called_at": DATETIME 
}
"GIRA_CLINIC" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "CP": TEXT 
  "Calle": TEXT 
  "CodigoProfesional": TEXT 
  "Domingo": BOOLEAN 
  "DomingoManhana": TEXT 
  "DomingoTarde": TEXT 
  "Email": TEXT 
  "EspecialidadATMOclusion": BOOLEAN 
  "EspecialidadCirugiaMaxilofacial": BOOLEAN 
  "EspecialidadCirugiaOral": BOOLEAN 
  "EspecialidadEndodoncia": BOOLEAN 
  "EspecialidadImplantologia": BOOLEAN 
  "EspecialidadOdontologiaEstetica": BOOLEAN 
  "EspecialidadOdontologiaGeneral": BOOLEAN 
  "EspecialidadOdontopediatria": BOOLEAN 
  "EspecialidadOrtodoncia": BOOLEAN 
  "EspecialidadOrtopantomografia": BOOLEAN 
  "EspecialidadPeriodoncia": BOOLEAN 
  "EspecialidadPlasmaRicoPlaquetas": BOOLEAN 
  "EspecialidadProtesis": BOOLEAN 
  "EspecialidadRadiologia": BOOLEAN 
  "EspecialidadTAC": BOOLEAN 
  "EspecialidadTelerradiografia": BOOLEAN 
  "Fax": TEXT 
  "Jueves": BOOLEAN 
  "JuevesManhana": TEXT 
  "JuevesTarde": TEXT 
  "Latitud": TEXT 
  "Longitud": TEXT 
  "Lunes": BOOLEAN 
  "LunesManhana": TEXT 
  "LunesTarde": TEXT 
  "Martes": BOOLEAN 
  "MartesManhana": TEXT 
  "MartesTarde": TEXT 
  "Miercoles": BOOLEAN 
  "MiercolesManhana": TEXT 
  "MiercolesTarde": TEXT 
  "NombreComercial": TEXT 
  "NumGratuidades": INTEGER 
  "NumOdontoAv": INTEGER 
  "NumPromos": INTEGER 
  "Poblacion": TEXT 
  "PoblacionMatriz": TEXT 
  "Provincia": TEXT 
  "Sabado": BOOLEAN 
  "SabadoManhana": TEXT 
  "SabadoTarde": TEXT 
  "Telefono1": TEXT 
  "Telefono2": TEXT 
  "Telefono3": TEXT 
  "Viernes": BOOLEAN 
  "ViernesManhana": TEXT 
  "ViernesTarde": TEXT 
  "Web": TEXT 
  "alan_province": VARCHAR(2) 
}
"MEDICAL_NETWORK_UPDATE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "data": JSONB 
  "entry_type": VARCHAR(50) 
  "identifier": VARCHAR(50) 
  "type": VARCHAR(50) 
}
"MEDICAL_SERVICE_INFORMATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "display_name": VARCHAR(65) 
  "dkv_code": VARCHAR(5) 
  "dkv_specialty_code": VARCHAR(5) 
  "is_hidden_from_members": BOOLEAN 
  "needs_authorization": BOOLEAN 
  "needs_prescription": BOOLEAN 
  "requires_medical_report": BOOLEAN 
}
"MEDICAL_SERVICE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "dkv_code": VARCHAR(5) 
  "dkv_description": VARCHAR(50) 
  "medical_specialty_id": UUID 
  "needs_authorization": BOOLEAN 
  "scope": VARCHAR(255) 
  "updated": BOOLEAN 
}
"NETWORK_DOCTOR_SPECIALTY" {
  shape: sql_table
  "medical_specialty_id": UUID 
  "network_doctor_id": UUID 
}
"MEDICAL_SPECIALTY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "dkv_code": VARCHAR(5) 
  "dkv_name": VARCHAR(50) 
  "is_displayed_in_find_a_doctor": BOOLEAN 
  "origin": VARCHAR(16) 
  "updated": BOOLEAN 
}
"NETWORK_CLINIC_TO_MEDICAL_SPECIALTY_WITHOUT_DOCTOR" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "is_displayed_in_find_a_doctor": BOOLEAN 
  "medical_specialty_id": UUID 
  "network_clinic_id": UUID 
  "origin": VARCHAR(16) 
  "updated": BOOLEAN 
}
"NETWORK_DOCTOR" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "dkv_medical_network_doctor_key": CHAR(64) 
  "ga_gender": VARCHAR(7) 
  "is_displayed_in_find_a_doctor": BOOLEAN 
  "languages": ARRAY 
  "name": VARCHAR(100) 
  "nif": VARCHAR(9) 
  "origin": VARCHAR(16) 
  "rating": INTEGER 
  "rating_count": INTEGER 
  "updated": BOOLEAN 
}
"ONLINE_BOOKING_PROVIDER_API_CALL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "api_call_metadata": JSONB 
  "called_at": DATETIME 
  "provider": VARCHAR 
  "url": VARCHAR 
}
"REIMBURSEMENT_DOCUMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "content_hash": VARCHAR(64) 
  "mime_type": VARCHAR(255) 
  "name": VARCHAR(255) 
  "reimbursement_request_id": UUID 
  "uploader_id": UUID 
  "uri": VARCHAR(2083) 
}
"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) 
}
"SETTLEMENT_CARE_ACT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "care_act_code": VARCHAR 
  "care_act_date": DATE 
  "invoice_number": VARCHAR 
  "settlement_id": UUID 
}
"TUOTEMPO_API_CALL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "api_call_metadata": JSONB 
  "called_at": DATETIME 
  "url": VARCHAR 
}
"TUOTEMPO_BOOKABLE_ACTIVITY" {
  shape: sql_table
  "id": VARCHAR {constraint: primary_key}
  "clinic_dkv_id": INTEGER 
  "doctor_nif": VARCHAR 
  "medical_specialty_dkv_id": VARCHAR(5) 
  "title": VARCHAR 
  "tt_activity_id": VARCHAR 
  "tt_area_id": VARCHAR 
  "tt_catalog_id": VARCHAR 
  "tt_resource_id": VARCHAR 
  "tt_typology_id": VARCHAR 
}
"TUOTEMPO_BOOKABLE_AREA" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "address": VARCHAR 
  "area_id": VARCHAR 
  "area_title": VARCHAR 
  "city": VARCHAR 
  "is_forced_match": BOOLEAN 
  "latitude": FLOAT 
  "longitude": FLOAT 
  "map_url": VARCHAR 
  "matched_clinic_dkv_id": INTEGER 
}
"TUOTEMPO_BOOKABLE_DOCTOR" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "area_ids": ARRAY 
  "city": VARCHAR 
  "cp": VARCHAR 
  "idnumber": VARCHAR 
  "is_forced_match": BOOLEAN 
  "name": VARCHAR 
  "nif": VARCHAR(9) 
  "resourceid": VARCHAR 
  "typologies": ARRAY 
}
"TUOTEMPO_CATALOG_ACTIVITY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "failure_reason": VARCHAR 
  "tt_activity_consumer_id": VARCHAR 
  "tt_activity_id": VARCHAR 
  "tt_activity_legacy_id": VARCHAR 
  "tt_activity_title": VARCHAR 
  "tt_area_address": VARCHAR 
  "tt_area_city": VARCHAR 
  "tt_area_consumer_id": VARCHAR 
  "tt_area_country": VARCHAR 
  "tt_area_cp": VARCHAR 
  "tt_area_id": VARCHAR 
  "tt_area_latitude": VARCHAR 
  "tt_area_legacy_id": VARCHAR 
  "tt_area_longitude": VARCHAR 
  "tt_area_province": VARCHAR 
  "tt_area_title": VARCHAR 
  "tt_area_web_title": VARCHAR 
  "tt_catalog_id": VARCHAR 
  "tt_resource_consumer_id": VARCHAR 
  "tt_resource_id": VARCHAR 
  "tt_resource_legacy_id": VARCHAR 
  "tt_resource_name": VARCHAR 
  "tt_typology_id": VARCHAR 
  "tt_typology_title": VARCHAR 
}
"TUOTEMPO_KPI" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "available_agendas_count": INTEGER 
  "available_bookable_claims_count": INTEGER 
  "catalog_count": INTEGER 
  "date": DATE 
  "matched_clinics_count": INTEGER 
  "matched_doctors_count": INTEGER 
  "possible_bookable_agendas_count": INTEGER 
  "possible_bookable_claims_count": INTEGER 
  "total_bookable_clinics_count": INTEGER 
  "total_bookable_doctors_count": INTEGER 
}
"TUOTEMPO_MATCHING_DOCTOR_CANDIDATE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "candidate_network_doctor_id": UUID 
  "matching_score": INTEGER 
  "tt_bookable_doctor_id": UUID 
}
"USER_INVITATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "email": VARCHAR(255) 
  "is_delivered": BOOLEAN 
  "journey_id": VARCHAR(255) 
  "user_id": UUID 
}
"billing"."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"."BILLING_TASK_EXECUTION_RQ_JOB" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "billing_task_execution_id": UUID 
  "rq_job_id": VARCHAR 
}
"billing"."INSTALLMENT_PLAN" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "contract_ref": VARCHAR(64) 
  "contract_type": VARCHAR(32) 
}
"healthy_benefits"."ES_COMPANY_ACCOUNT_STATEMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_statement_balance_in_cents": INTEGER 
  "at_date": DATE 
  "company_id": UUID 
  "regular_balance_in_cents": INTEGER 
}
"healthy_benefits"."ES_COMPANY_BALANCE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "at_date": DATE 
  "balance_in_cents": INTEGER 
  "balance_in_cents_with_ledger": INTEGER 
  "company_id": UUID 
  "estimated_required_balance_in_cents": INTEGER 
}
"payroll"."FINIQUITO" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "email_sent_at": DATETIME 
  "employment_id": UUID 
  "month": DATE 
  "uri": VARCHAR(2083) 
}
"payroll"."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) 
}
"healthy_benefits"."ES_HEALTHY_BENEFITS_CONSUMPTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "allowance_spending_regularization": INTEGER 
  "at_date": DATE 
  "benefit_type": VARCHAR(255) 
  "company_id": UUID 
  "enrollment_ref": VARCHAR 
  "enrollment_start_date": DATE 
  "finiquito_id": UUID 
  "month": VARCHAR(7) 
  "monthly_allowance": INTEGER 
  "monthly_spending_from_allowance": INTEGER 
  "monthly_spending_in_salary_sacrifice": INTEGER 
  "monthly_spending_tax_exempted": INTEGER 
  "monthly_spending_total": INTEGER 
  "not_tax_exempted_amount_regularization": INTEGER 
  "pay_csv_id": UUID 
  "regularized_by_benefits_consumption_id": UUID 
  "remaining_accumulated_allowance": INTEGER 
  "remaining_allowance": INTEGER 
  "salary_sacrifice_spending_regularization": INTEGER 
  "total_spending_regularization": INTEGER 
  "user_id": UUID 
}
"healthy_benefits"."ES_HEALTHY_BENEFITS_PROFILE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "card_holder_id": UUID 
  "first_time_greeting_viewed_date": DATE 
  "identity_document_type": VARCHAR(255) 
  "last_card_suspension_date": DATE 
  "nif_number": VARCHAR(16) 
  "pin_code_first_viewed_date": DATE 
  "population_ref": VARCHAR 
  "user_id": UUID 
}
"healthy_benefits"."ES_HEALTHY_BENEFITS_PROFILE_VERSION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "annual_salary": BIGINT 
  "end_date": DATE 
  "healthy_benefits_profile_id": UUID 
  "is_cancelled": BOOLEAN 
  "start_date": DATE 
  "tax_regime": TEXT 
}
"healthy_benefits"."ES_LEARNING_COURSE_REQUEST" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "course_name": VARCHAR 
  "course_provider": VARCHAR 
  "course_provider_website": VARCHAR 
  "enrollment_ref": UUID 
  "preferred_number_of_installments": INTEGER 
  "rejection_reason": VARCHAR 
  "requested_at": DATETIME 
  "reviewed_at": DATETIME 
  "start_date": DATE 
  "status": VARCHAR(255) 
  "total_amount": INTEGER 
}
"healthy_benefits"."ES_LEARNING_INSTALLMENT_PLAN" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "course_request_id": UUID 
  "end_date": DATE 
  "nb_installments": INTEGER 
  "start_date": DATE 
  "total_amount": INTEGER 
}
"healthy_benefits"."ES_LEARNING_INSTALLMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount": INTEGER 
  "due_date": DATE 
  "installment_plan_id": UUID 
  "transfer_ref": UUID 
}
"healthy_benefits"."ES_MERCHANT_BENEFIT_OVERRIDE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "benefit_type": VARCHAR(255) 
  "merchant_id": VARCHAR 
}
"healthy_benefits"."ES_NURSERY_INSTALLMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount": INTEGER 
  "description": TEXT 
  "due_date": DATE 
  "installment_plan_id": UUID 
  "reference": TEXT 
}
"healthy_benefits"."ES_SALARY_IN_KIND_LIMIT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "at_date": DATE 
  "company_id": UUID 
  "month": VARCHAR(7) 
  "remaining_monthly_limit": INTEGER 
  "user_id": UUID 
}
"healthy_benefits"."ES_SCHEDULED_PAYMENT_CARD_TERMINATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "card_id": UUID 
  "card_terminated_at": DATETIME 
  "healthy_benefits_profile_id": UUID 
  "planned_card_termination_date": DATE 
  "reason": VARCHAR 
  "status": VARCHAR(255) 
}
"healthy_benefits"."ES_TRANSACTION_DETAILS" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "amount": INTEGER 
  "amount_from_allowance": INTEGER 
  "benefit_type": VARCHAR(255) 
  "currency": VARCHAR(3) 
  "merchant_country_code": VARCHAR(3) 
  "merchant_id": VARCHAR 
  "merchant_mcc": VARCHAR(4) 
  "merchant_name": VARCHAR 
  "notification_sent_at": DATETIME 
  "occurred_at": DATETIME 
  "reason": VARCHAR(255) 
  "remaining_budget": INTEGER 
  "remaining_from_allowance": INTEGER 
  "status": VARCHAR(255) 
  "transaction_ref": VARCHAR 
  "user_id": UUID 
}
"payroll"."ES_MONTHLY_PAYROLL_INFORMATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "company_id": UUID 
  "month": DATE 
  "upper_date_limit_health_insurance": DATETIME 
  "upper_date_limit_healthy_benefits": DATETIME 
}
"COMPANY_ONBOARDING"."id" -> "subscription"."CONTRACT_OPTION"."company_onboarding_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"subscription"."HEALTH_CONTRACT_VERSION"."id" -> "subscription"."CONTRACT_OPTION"."health_contract_version_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"subscription"."AMENDMENT"."id" -> "subscription"."CONTRACT_OPTION"."amendment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"subscription"."HEALTH_CONTRACT"."id" -> "subscription"."CONTRACT_OPTION"."health_contract_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"subscription"."SIGNED_BUNDLE"."id" -> "subscription"."HEALTH_CONTRACT"."signed_bundle_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "subscription"."HEALTH_CONTRACT"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "subscription"."HEALTH_CONTRACT"."company_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"subscription"."HEALTH_CONTRACT"."id" -> "subscription"."HEALTH_CONTRACT_VERSION"."health_contract_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"subscription"."SIGNED_BUNDLE"."id" -> "subscription"."HEALTH_CONTRACT_VERSION"."signed_bundle_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
}
"COMPANY"."id" -> "EMPLOYMENT"."company_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "EMPLOYMENT"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"ADDRESS"."id" -> "COMPANY"."address_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"ACCOUNT"."id" -> "COMPANY"."account_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "subscription"."AMENDMENT"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"subscription"."HEALTH_CONTRACT_VERSION"."id" -> "subscription"."AMENDMENT"."previous_contract_version_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"subscription"."HEALTH_CONTRACT"."id" -> "subscription"."AMENDMENT"."previous_contract_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"subscription"."HEALTH_CONTRACT_VERSION"."id" -> "subscription"."AMENDMENT"."new_contract_version_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"subscription"."HEALTH_CONTRACT"."id" -> "subscription"."AMENDMENT"."new_contract_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "subscription"."AMENDMENT"."company_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"subscription"."SIGNED_BUNDLE"."id" -> "subscription"."SIGNED_DOCUMENT"."signed_bundle_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"billing"."INSTALLMENT_PLAN"."id" -> "billing"."INSTALLMENT"."installment_plan_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"IBAN"."id" -> "billing"."PAYMENT"."iban_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"billing"."INSTALLMENT"."id" -> "billing"."PAYMENT"."installment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"billing"."PAYMENT"."id" -> "billing"."PAYMENT"."refunded_payment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"billing"."PAYMENT"."id" -> "billing"."PAYMENT"."disputed_payment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"billing"."INVOICE"."id" -> "billing"."PAYMENT"."invoice_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"ENROLLMENT"."id" -> "payroll"."PREMIUM_ENTRY"."enrollment_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"billing"."INVOICE"."id" -> "payroll"."PREMIUM_ENTRY"."invoice_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"payroll"."PAY_CSV"."id" -> "payroll"."PREMIUM_ENTRY"."pay_csv_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"payroll"."FINIQUITO"."id" -> "payroll"."PREMIUM_ENTRY"."finiquito_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"payroll"."PREMIUM_ENTRY"."id" -> "payroll"."PREMIUM_ENTRY"."cancelled_premium_entry_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"ENROLLMENT_OPTION"."id" -> "payroll"."PREMIUM_ENTRY"."enrollment_option_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
}
"USER"."id" -> "IBAN"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"ENROLLMENT"."id" -> "ENROLLMENT_OPTION"."enrollment_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"subscription"."CONTRACT_OPTION"."id" -> "ENROLLMENT_OPTION"."contract_option_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"ENROLLMENT"."id" -> "CARD_SHIPMENT"."enrollment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CARD_SHIPMENT_BATCH"."id" -> "CARD_SHIPMENT"."batch_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
}
"ADDRESS"."id" -> "healthy_benefits"."ES_NURSERY"."address_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" -> "healthy_benefits"."ES_NURSERY_BENEFICIARY"."insurance_profile_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-one-required
}
"healthy_benefits"."ES_NURSERY"."id" -> "healthy_benefits"."ES_NURSERY_INSTALLMENT_PLAN"."nursery_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"healthy_benefits"."ES_NURSERY_BENEFICIARY"."id" -> "healthy_benefits"."ES_NURSERY_INSTALLMENT_PLAN"."beneficiary_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
}
"USER"."id" -> "COMPANY_ADMIN"."user_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
}
"COMPANY"."id" -> "COMPANY_ADMIN_INVITATION"."company_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "COMPANY_ONBOARDING"."company_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"ACCOUNT"."id" -> "COMPANY_ONBOARDING"."account_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"COMPANY_ADMIN"."id" -> "COMPANY_ONBOARDING"."company_admin_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
}
"subscription"."HEALTH_CONTRACT"."id" -> "POLICY"."health_contract_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"TRANSACTION"."id" -> "ACTIVITY"."transaction_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"AMEDICS_PROFESSIONAL"."amedics_id" -> "AMEDICS_BOOKABLE_ACTIVITY"."professional_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"ENROLLMENT"."id" -> "AUTHORIZATION"."enrollment_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"AUTHORIZATION"."id" -> "AUTHORIZATION_DOCUMENT"."authorization_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "BOOKING"."user_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "BOOKING"."booked_for_user_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
}
"COMPANY"."id" -> "COMPANY_COMMENT"."company_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "COMPANY_ONBOARDING_DRAFT"."author_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"COMPANY_ONBOARDING"."id" -> "COMPANY_ONBOARDING_DRAFT"."company_onboarding_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"MEDICAL_SPECIALTY"."id" -> "NETWORK_CLINIC_SPECIALTY"."medical_specialty_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"NETWORK_CLINIC"."id" -> "NETWORK_CLINIC_SPECIALTY"."network_clinic_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"NETWORK_DOCTOR"."id" -> "NETWORK_DOCTOR_CLINIC_LINK"."network_doctor_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"NETWORK_CLINIC"."id" -> "NETWORK_DOCTOR_CLINIC_LINK"."network_clinic_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CONCIERGE_REQUEST"."id" -> "CONCIERGE_BOOKING_OPTION"."concierge_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"NETWORK_CLINIC"."id" -> "CONCIERGE_BOOKING_OPTION"."clinic_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"voice_ai"."VOICE_AI_CALLS"."id" -> "CONCIERGE_BOOKING_OPTION_VOICE_CALL_LINK"."voice_ai_call_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CONCIERGE_BOOKING_OPTION"."id" -> "CONCIERGE_BOOKING_OPTION_VOICE_CALL_LINK"."concierge_booking_option_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"CREU_BLANCA_CENTER"."creu_blanca_id" -> "CREU_BLANCA_AGENDA"."center_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"CREU_BLANCA_CENTER"."creu_blanca_id" -> "CREU_BLANCA_SERVICE"."center_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "DENTAL_COVERAGE_RENEWAL"."company_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"subscription"."HEALTH_CONTRACT"."id" -> "DENTAL_COVERAGE_RENEWAL"."current_contract_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"subscription"."HEALTH_CONTRACT"."id" -> "DENTAL_COVERAGE_RENEWAL"."new_contract_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "DENTAL_COVERAGE_RENEWAL"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"ENROLLMENT"."id" -> "DENTAL_COVERAGE_RENEWAL_EMPLOYEE"."enrollment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "DENTAL_COVERAGE_RENEWAL_EMPLOYEE"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"DKV_MEDICAL_SPECIALTY"."id" -> "DKV_MEDICAL_NETWORK"."dkv_medical_specialty_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DKV_MEDICAL_SPECIALTY"."id" -> "DKV_MEDICAL_SERVICE_TO_DKV_MEDICAL_SPECIALTY"."dkv_medical_specialty_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"DKV_MEDICAL_SERVICE"."id" -> "DKV_MEDICAL_SERVICE_TO_DKV_MEDICAL_SPECIALTY"."dkv_medical_service_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
}
"subscription"."HEALTH_CONTRACT"."id" -> "EMPLOYEE_ONBOARDING"."health_contract_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "EMPLOYEE_ONBOARDING"."company_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
}
"USER"."id" -> "ACCOUNT_ADMIN"."user_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
}
"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
}
"PROSPECT"."id" -> "EMAIL_LOG"."prospect_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
}
"EMPLOYMENT"."id" -> "ES_EMPLOYEE_TRANSFER"."initial_employment_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"EMPLOYMENT"."id" -> "ES_EMPLOYEE_TRANSFER"."new_employment_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "ES_EMPLOYEE_TRANSFER"."destination_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
}
"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
}
"USER"."id" -> "REIMBURSEMENT_REQUEST"."user_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "REIMBURSEMENT_REQUEST"."dependent_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "SETTLEMENT"."reviewer_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"REIMBURSEMENT_REQUEST"."id" -> "SETTLEMENT"."reimbursement_request_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"ENROLLMENT"."id" -> "SETTLEMENT"."beneficiary_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"MEDICAL_SPECIALTY"."id" -> "MEDICAL_SERVICE"."medical_specialty_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"NETWORK_DOCTOR"."id" -> "NETWORK_DOCTOR_SPECIALTY"."network_doctor_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"MEDICAL_SPECIALTY"."id" -> "NETWORK_DOCTOR_SPECIALTY"."medical_specialty_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"NETWORK_CLINIC"."id" -> "NETWORK_CLINIC_TO_MEDICAL_SPECIALTY_WITHOUT_DOCTOR"."network_clinic_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"MEDICAL_SPECIALTY"."id" -> "NETWORK_CLINIC_TO_MEDICAL_SPECIALTY_WITHOUT_DOCTOR"."medical_specialty_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "REIMBURSEMENT_DOCUMENT"."uploader_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"REIMBURSEMENT_REQUEST"."id" -> "REIMBURSEMENT_DOCUMENT"."reimbursement_request_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
}
"SETTLEMENT"."id" -> "REIMBURSEMENT_PAYMENT"."settlement_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
}
"SETTLEMENT"."id" -> "SETTLEMENT_CARE_ACT"."settlement_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"TUOTEMPO_BOOKABLE_DOCTOR"."id" -> "TUOTEMPO_MATCHING_DOCTOR_CANDIDATE"."tt_bookable_doctor_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"NETWORK_DOCTOR"."id" -> "TUOTEMPO_MATCHING_DOCTOR_CANDIDATE"."candidate_network_doctor_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "USER_INVITATION"."user_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"billing"."BILLING_TASK_EXECUTION"."id" -> "billing"."BILLING_TASK_EXECUTION_RQ_JOB"."billing_task_execution_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "healthy_benefits"."ES_COMPANY_ACCOUNT_STATEMENT"."company_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "healthy_benefits"."ES_COMPANY_BALANCE"."company_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"EMPLOYMENT"."id" -> "payroll"."FINIQUITO"."employment_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"subscription"."HEALTH_CONTRACT"."id" -> "payroll"."PAY_CSV"."health_contract_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"payroll"."FINIQUITO"."id" -> "healthy_benefits"."ES_HEALTHY_BENEFITS_CONSUMPTION"."finiquito_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"healthy_benefits"."ES_HEALTHY_BENEFITS_CONSUMPTION"."id" -> "healthy_benefits"."ES_HEALTHY_BENEFITS_CONSUMPTION"."regularized_by_benefits_consumption_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "healthy_benefits"."ES_HEALTHY_BENEFITS_CONSUMPTION"."company_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "healthy_benefits"."ES_HEALTHY_BENEFITS_CONSUMPTION"."user_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"payroll"."PAY_CSV"."id" -> "healthy_benefits"."ES_HEALTHY_BENEFITS_CONSUMPTION"."pay_csv_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "healthy_benefits"."ES_HEALTHY_BENEFITS_PROFILE"."user_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"healthy_benefits"."ES_HEALTHY_BENEFITS_PROFILE"."id" -> "healthy_benefits"."ES_HEALTHY_BENEFITS_PROFILE_VERSION"."healthy_benefits_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"healthy_benefits"."ES_LEARNING_COURSE_REQUEST"."id" -> "healthy_benefits"."ES_LEARNING_INSTALLMENT_PLAN"."course_request_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"healthy_benefits"."ES_LEARNING_INSTALLMENT_PLAN"."id" -> "healthy_benefits"."ES_LEARNING_INSTALLMENT"."installment_plan_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"healthy_benefits"."ES_NURSERY_INSTALLMENT_PLAN"."id" -> "healthy_benefits"."ES_NURSERY_INSTALLMENT"."installment_plan_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "healthy_benefits"."ES_SALARY_IN_KIND_LIMIT"."company_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "healthy_benefits"."ES_SALARY_IN_KIND_LIMIT"."user_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"healthy_benefits"."ES_HEALTHY_BENEFITS_PROFILE"."id" -> "healthy_benefits"."ES_SCHEDULED_PAYMENT_CARD_TERMINATION"."healthy_benefits_profile_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"USER"."id" -> "healthy_benefits"."ES_TRANSACTION_DETAILS"."user_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"COMPANY"."id" -> "payroll"."ES_MONTHLY_PAYROLL_INFORMATION"."company_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}

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