_1.patients_health_concerns
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| phc_id | int(11) | NO | PRI | auto_increment | ||
| phc_cus_id | int(11) | NO | 0 | MUL | Customer ID# | |
| phc_cli_id | int(11) | NO | 0 | MUL | Client ID# | |
| phc_pat_id | int(11) | NO | 0 | Patient ID# | ||
| phc_desc | text | NO | Narrative description of concern | |||
| phc_cs_id | int(11) | NO | 0 | MUL | Code System | |
| phc_code_id | bigint(20) | NO | 0 | MUL | Code ID | |
| phc_code | varchar(45) | NO | Code | |||
| phc_code_desc | varchar(256) | NO | Code Description | |||
| phc_start_dt | datetime | YES | Start of concern | |||
| phc_end_dt | datetime | YES | End of concern | |||
| phc_disabled | tinyint(1) | NO | 0 | Disabled indicator | ||
| phc_modified | datetime | YES | CURRENT_TIMESTAMP | |||
| phc_created | datetime | YES | CURRENT_TIMESTAMP |
References
| Local Column | References | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| phc_id |
|