Patient.identifier[]).
Primary Keys:
- patient_identifier_id
- patient_id - links to the patient table
| Column | Data Type | Description |
|---|---|---|
| patient_identifier_id | varchar | Unique identifier for the identifier row |
| patient_id | varchar | Parent patient |
| system | varchar | Namespace/URI that defines the identifier value |
| value | varchar | The identifier value |
| use | varchar | Intended use of the identifier (e.g., official, usual, temp) |
| type_text | varchar | Human-readable type description |
| period_start | datetime | Start of the period when the identifier was valid |
| period_end | datetime | End of the period when the identifier was valid |