| pnk_id | int(11) | NO | | PRI | auto_increment | primary key |
| pnk_cus_id | int(11) | NO | 0 | MUL | | Customer ID |
| pnk_cli_id | int(11) | NO | 0 | MUL | | Client ID |
| pnk_pat_id | int(11) | NO | 0 | MUL | | Patient to whom the Next of Kin relates |
| pnk_fname | varchar(40) | NO | | | | First Name |
| pnk_mname | varchar(40) | NO | | | | Middle Name |
| pnk_lname | varchar(40) | NO | | | | Last Name |
| pnk_rlsp_code | varchar(10) | NO | | | | Next of kin relationship code matches HL7 relationship code |
| pnk_address1 | varchar(40) | NO | | | | Next of kin first line address |
| pnk_address2 | varchar(40) | NO | | | | Next of kin second line address |
| pnk_city | varchar(30) | NO | | | | Next of kin city |
| pnk_state | varchar(2) | NO | | | | Next of kin state |
| pnk_zip | varchar(5) | NO | | | | Next of kin zip |
| pnk_zip_4 | varchar(4) | NO | | | | Next of kin zip plus the 4 |
| pnk_phone | varchar(20) | NO | | | | Next of kin phone number |
| pnk_phone_type | varchar(5) | NO | | | | HL7 Telecommunication Equipment Type |
| pnk_created_by_usr_id | int(11) | NO | 0 | | | usr_id who created this next of kin |
| pnk_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| pnk_disabled | tinyint(1) | NO | 0 | | | Next of kin is disabled? |
| pnk_created | timestamp | YES | CURRENT_TIMESTAMP | | | |