| pn_id | int(11) | NO | | PRI | auto_increment | |
| pn_cus_id | int(11) | NO | | | | |
| pn_cli_id | int(11) | NO | | | | |
| pn_pat_id | int(11) | NO | | MUL | | |
| pn_fname | varchar(40) | NO | | | | First Name |
| pn_mname | varchar(40) | NO | | | | Middle Name |
| pn_lname | varchar(40) | NO | | | | Last Name |
| pn_prefix | varchar(10) | NO | | | | Parts before Name |
| pn_suffix | varchar(10) | NO | | | | Parts after Name |
| pn_type | varchar(20) | NO | | | | https://build.fhir.org/valueset-name-use.html |
| pn_current | tinyint(1) | NO | 1 | | | current name in use by Patient (only one per patient) |
| pn_previous | tinyint(1) | NO | 0 | | | previous name used by Patient (only one per patient) |
| pn_disabled | tinyint(1) | NO | 0 | | | |
| pn_end_dt | datetime | YES | | | | when name stopped being used -- https://build.fhir.org/datatypes.html#Period |
| pn_start_dt | datetime | YES | | | | when name started being used -- https://build.fhir.org/datatypes.html#Period |
| pn_created | timestamp | YES | CURRENT_TIMESTAMP | | | |
| pn_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |