_1218.hl7_lab_locations
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| hll_id | int(11) | NO | PRI | auto_increment | ||
| hll_cus_id | int(11) | NO | 0 | MUL | ||
| hll_cli_id | int(11) | NO | 0 | MUL | ||
| hll_acc_id | int(11) | NO | 0 | MUL | ||
| hll_seq_num | tinyint(4) | NO | 0 | MUL | ||
| hll_key | varchar(10) | NO | ||||
| hll_name | varchar(40) | NO | ||||
| hll_address1 | varchar(40) | NO | ||||
| hll_address2 | varchar(40) | NO | ||||
| hll_city | varchar(30) | NO | ||||
| hll_state | varchar(2) | NO | ||||
| hll_zip | varchar(5) | NO | ||||
| hll_zip_plus4 | varchar(4) | NO | ||||
| hll_phone | varchar(20) | NO | ||||
| hll_director | varchar(45) | NO | ||||
| hll_modified | timestamp | YES | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | ||
| hll_created | timestamp | YES | CURRENT_TIMESTAMP |
References
| Local Column | References | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| hll_id |
|