_1218.charts
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| chrt_id | int(11) | NO | PRI | auto_increment | ||
| chrt_cus_id | int(11) | NO | MUL | |||
| chrt_cli_id | int(11) | NO | MUL | |||
| chrt_pat_id | int(11) | NO | 0 | MUL | ||
| chrt_status | int(11) | NO | 1 | |||
| chrt_phy_id | int(11) | NO | 0 | MUL | ||
| chrt_phy_id_referring | int(11) | NO | 0 | MUL | ||
| chrt_phy_id_referring_out | int(11) | NO | 0 | |||
| chrt_phy_id_supervising | int(11) | NO | MUL | |||
| chrt_phy_id_reviewing | int(11) | NO | 0 | |||
| chrt_chart_num | varchar(20) | NO | MUL | |||
| chrt_pid | varchar(20) | NO | MUL | |||
| chrt_mrn | varchar(20) | NO | MUL | |||
| chrt_ssn | varchar(11) | NO | MUL | |||
| chrt_fname | varchar(20) | NO | MUL | |||
| chrt_mname | varchar(20) | NO | ||||
| chrt_lname | varchar(20) | NO | MUL | |||
| chrt_suffix | varchar(10) | NO | ||||
| chrt_email | varchar(80) | NO | ||||
| chrt_bill_type | char(1) | NO | ||||
| chrt_dob | varchar(8) | NO | MUL | |||
| chrt_age | varchar(3) | NO | ||||
| chrt_sex | varchar(7) | NO | ||||
| chrt_race | varchar(50) | NO | ||||
| chrt_ethnicity | varchar(30) | NO | ||||
| chrt_marital_status | varchar(15) | NO | ||||
| chrt_address1 | varchar(40) | NO | ||||
| chrt_address2 | varchar(40) | NO | ||||
| chrt_city | varchar(30) | NO | ||||
| chrt_state | varchar(2) | NO | ||||
| chrt_zip | varchar(5) | NO | ||||
| chrt_zip_plus4 | varchar(4) | NO | ||||
| chrt_phone | varchar(20) | NO | ||||
| chrt_phone_work | varchar(20) | NO | ||||
| chrt_phone_other | varchar(20) | NO | ||||
| chrt_fax | varchar(20) | NO | ||||
| chrt_date_of_service | varchar(8) | NO | MUL | |||
| chrt_loc_id | int(11) | NO | 0 | |||
| chrt_version_num | tinyint(3) unsigned | NO | 0 | |||
| chrt_modified | timestamp | YES | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | ||
| chrt_created | timestamp | YES | CURRENT_TIMESTAMP |
References
| Local Column | References | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| chrt_id |
|