Patient name
Contents |
[edit]
Description
[edit]
Attributes
| Column Name | Type | Default | Description | |
|---|---|---|---|---|
| | patient_name_id | int | ||
| | preferred | bit | ||
| | patient_id patient.patient_id | int | ||
| prefix | varchar(50) | NULL | ||
| given_name | varchar(50) | NULL | ||
| middle_name | varchar(50) | NULL | ||
| family_name_prefix | varchar(50) | NULL | ||
| family_name | varchar(50) | NULL | ||
| family_name2 | varchar(50) | NULL | ||
| family_name_suffix | varchar(50) | NULL | ||
| degree | varchar(50) | NULL | ||
| | creator users.user_id | int | ||
| | date_created | datetime | 0000-00-00 00:00:00 | |
| | voided | bit | ||
| voided_by users.user_id | int | NULL | ||
| date_voided | datetime | NULL | ||
| void_reason | varchar(255) | NULL | ||
| changed_by | int | NULL | ||
| date_changed | datetime | NULL | ||
| | ||||
