| pho_id | int(11) | NO | | PRI | auto_increment | |
| pho_cus_id | int(11) | NO | 0 | MUL | | Customer ID# |
| pho_cli_id | int(11) | NO | 0 | MUL | | Client ID# |
| pho_pat_id | int(11) | NO | 0 | MUL | | Patient ID# |
| pho_phc_id | int(11) | NO | 0 | MUL | | Patient Health Concern ID# |
| pho_mdl_id | int(11) | NO | 0 | MUL | | Model ID# |
| pho_key_val | int(11) | NO | 0 | MUL | | Primary key of linked item |
| pho_key_attribute | varchar(256) | NO | | | | linked attribute, if any |
| pho_desc | text | NO | | | | Narrative description of observation |
| pho_modified | datetime | YES | CURRENT_TIMESTAMP | | | |
| pho_created | datetime | YES | CURRENT_TIMESTAMP | | | |