Instroom — entiteit-relatiediagram

erDiagram PERSOON { uuid id PK } referral_request { uuid id PK uuid person_id FK timestamp initiated_at string initiator_type text presenting_need_text } referral_submission { uuid id PK timestamp received_at string channel } submission_document { uuid id PK uuid submission_id FK string document_type } submission_request_link { uuid submission_id FK uuid referral_request_id FK timestamp established_at } submission_duplicate_assessment { uuid submission_id FK uuid duplicate_of_submission_id FK timestamp assessed_at } referral_case { uuid id PK uuid person_id FK timestamp opened_at string wettelijk_kader } submission_case_assignment { uuid submission_id FK uuid referral_case_id FK timestamp assigned_at } request_case_link { uuid referral_request_id FK uuid referral_case_id FK date since } case_consolidation { uuid primary_case_id FK uuid related_case_id FK timestamp designated_at } screening_activity { uuid id PK uuid referral_case_id FK string activity_type } case_information_request { uuid id PK uuid referral_case_id FK uuid resolved_by_submission_id FK timestamp requested_at } care_acceptance_decision { uuid id PK uuid referral_case_id FK uuid replaces_decision_id FK string decision_outcome string follow_up_route } case_withdrawal { uuid id PK uuid referral_case_id FK timestamp withdrawn_at } professional_referral { uuid id PK uuid referral_request_id FK uuid replaces_referral_id FK date referral_date } municipal_care_assignment { uuid id PK uuid referral_request_id FK uuid replaces_assignment_id FK string legal_framework } legal_mandate { uuid id PK uuid referral_case_id FK string mandate_type } crisis_encounter_note { uuid id PK uuid referral_case_id FK string fact_type } clinical_care_episode { uuid id PK uuid originating_decision_id FK uuid originating_mandate_id FK uuid possible_continuation_of_episode_id FK timestamp started_at } case_urgency_assessment { uuid id PK uuid referral_case_id FK string urgency_level } episode_team_involvement { uuid id PK uuid clinical_care_episode_id FK string team_reference } PERSOON |o--o{ referral_request : "person_id" PERSOON |o--o{ referral_case : "person_id" referral_submission ||--o{ submission_document : "documenten" referral_submission ||--o{ submission_request_link : "koppelingen" referral_request ||--|{ submission_request_link : "min 1 submission" referral_submission ||--o{ submission_duplicate_assessment : "als duplicaat" referral_submission ||--o{ submission_duplicate_assessment : "als origineel" referral_case ||--|{ submission_case_assignment : "min 1 toewijzing" referral_submission ||--o{ submission_case_assignment : "toewijzingen" referral_case ||--|{ request_case_link : "min 1 request" referral_request ||--|{ request_case_link : "normaliter 1 case" referral_case ||--o{ case_consolidation : "primary (leidend)" referral_case ||--o| case_consolidation : "related (uniek)" referral_case ||--o{ screening_activity : "activiteiten" referral_case ||--o{ case_information_request : "informatieverzoeken" referral_submission |o--o| case_information_request : "resolved_by (0..1)" referral_case ||--o{ care_acceptance_decision : "besluiten" care_acceptance_decision |o--o| care_acceptance_decision : "vervangt (self)" referral_case ||--o{ case_withdrawal : "intrekkingen" referral_request ||--o{ professional_referral : "verwijzingen" professional_referral |o--o| professional_referral : "vervangt (self)" referral_request ||--o{ municipal_care_assignment : "toewijzingen" municipal_care_assignment |o--o| municipal_care_assignment : "vervangt (self)" referral_case ||--o{ legal_mandate : "mandaten" referral_case ||--o{ crisis_encounter_note : "notities" care_acceptance_decision ||--o| clinical_care_episode : "XOR met mandaat" legal_mandate ||--o| clinical_care_episode : "XOR met besluit" clinical_care_episode |o--o| clinical_care_episode : "mogelijke vervolg (self)" referral_case ||--o{ case_urgency_assessment : "beoordelingen" clinical_care_episode ||--o{ episode_team_involvement : "team-betrokkenheid"