_435.radiology_orders_numbers
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| radnum_id | int(11) | NO | PRI | auto_increment | ||
| radnum_cus_id | int(11) | NO | 0 | MUL | Customer ID # | |
| radnum_cli_id | int(11) | NO | 0 | MUL | Client ID # | |
| radnum_pat_id | int(11) | NO | 0 | MUL | Patient ID # | |
| radnum_alpha | varchar(3) | NO | Alphanumeric starting character of req number | |||
| radnum_num | int(11) | NO | 0 | Numeric starting character of req number | ||
| radnum_modified | timestamp | YES | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | ||
| radnum_created | timestamp | YES | CURRENT_TIMESTAMP |
References
| Local Column | References |
|---|