| 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 | | | | |
| pnk_mname | varchar(40) | NO | | | | |
| pnk_lname | varchar(40) | NO | | | | |
| pnk_rlsp_code | varchar(10) | NO | | | | |
| pnk_address1 | varchar(40) | NO | | | | |
| pnk_address2 | varchar(40) | NO | | | | |
| pnk_city | varchar(30) | NO | | | | |
| pnk_state | varchar(2) | NO | | | | |
| pnk_zip | varchar(5) | NO | | | | |
| pnk_zip_4 | varchar(4) | NO | | | | |
| pnk_phone | varchar(20) | NO | | | | |
| pnk_phone_type | varchar(5) | NO | | | | |
| 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 | | | |
| pnk_created_by_usr_id | int(11) | NO | | | | usr_id who created this next of kin |