_1.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(1) | 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 | datetime | YES | CURRENT_TIMESTAMP | |||
| hll_created | datetime | YES | CURRENT_TIMESTAMP |
References
| Local Column | References | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| hll_id |
|