_999.patient_next_of_kin
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| 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 | datetime | YES | CURRENT_TIMESTAMP | |||
| pnk_disabled | tinyint(1) | NO | 0 | Next of kin is disabled? | ||
| pnk_created | datetime | YES | CURRENT_TIMESTAMP | |||
| pnk_created_by_usr_id | int(11) | NO | usr_id who created this next of kin |
References
| Local Column | References |
|---|