HEALTH ERD
View full image | Download SVG | Download DOT file
Table Field Previews
Tables in domain: 9
ssd_address
| Field | Type | Notes |
|---|
| addr_table_id | nvarchar | PK |
| addr_address_json | nvarchar | |
| addr_person_id | nvarchar | FK → ssd_person |
| addr_address_type | nvarchar | |
| addr_address_start_date | datetime | |
| addr_address_end_date | datetime | |
| addr_address_postcode | nvarchar | |
ssd_cla_health
| Field | Type | Notes |
|---|
| clah_health_check_id | nvarchar | PK |
| clah_person_id | nvarchar | FK → ssd_cla_episodes |
| clah_health_check_type | nvarchar | |
| clah_health_check_date | datetime | |
| clah_health_check_status | nvarchar | |
ssd_cla_immunisations
| Field | Type | Notes |
|---|
| clai_person_id | nvarchar | FK → ssd_cla_episodes |
| clai_immunisations_status | nchar | |
| clai_immunisations_status_date | datetime | |
ssd_cla_substance_misuse
| Field | Type | Notes |
|---|
| clas_substance_misuse_id | nvarchar | PK |
| clas_person_id | nvarchar | FK → ssd_cla_episodes |
| clas_substance_misuse_date | datetime | |
| clas_substance_misused | nchar | |
| clas_intervention_received | nchar | |
ssd_disability
| Field | Type | Notes |
|---|
| disa_person_id | nvarchar | FK → ssd_person |
| disa_table_id | nvarchar | PK |
| disa_disability_code | nvarchar | |
ssd_immigration_status
| Field | Type | Notes |
|---|
| immi_person_id | nvarchar | FK → ssd_person |
| immi_immigration_status_id | nvarchar | PK |
| immi_immigration_status | nvarchar | |
| immi_immigration_status_start_date | datetime | |
| immi_immigration_status_end_date | datetime | |
ssd_linked_identifiers
| Field | Type | Notes |
|---|
| link_table_id | nvarchar | PK |
| link_person_id | nvarchar | FK → ssd_person |
| link_identifier_type | nvarchar | |
| link_identifier_value | nvarchar | |
| link_valid_from_date | datetime | |
| link_valid_to_date | datetime | |
ssd_person
| Field | Type | Notes |
|---|
| pers_person_id | nvarchar | PK |
| pers_sex | nvarchar | |
| pers_gender | nvarchar | |
| pers_ethnicity | nvarchar | |
| pers_dob | datetime | |
| pers_common_child_id | nvarchar | |
| pers_legacy_id | nvarchar | |
| pers_upn_unknown | nvarchar | |
| pers_send_flag | nchar | |
| pers_expected_dob | datetime | |
| pers_death_date | datetime | |
| pers_is_mother | nchar | |
| pers_nationality | nvarchar | |
ssd_voice_of_child
| Field | Type | Notes |
|---|
| voch_table_id | nvarchar | PK |
| voch_person_id | nvarchar | FK → ssd_person |
| voch_explained_worries | nchar | |
| voch_story_help_understand | nchar | |
| voch_agree_worker | nchar | |
| voch_plan_safe | nchar | |
| voch_tablet_help_explain | nchar | |