| radnot_id | int(11) | NO | | PRI | auto_increment | |
| radnot_cus_id | int(11) | NO | 0 | MUL | | Customer ID # |
| radnot_cli_id | int(11) | NO | 0 | MUL | | Client ID # |
| radnot_pat_id | int(11) | NO | 0 | MUL | | Patient ID # |
| radnot_rad_id | int(11) | NO | 0 | MUL | | Radiology Order ID # |
| radnot_oct_id | int(11) | NO | 0 | MUL | | Order Comment Type ID # |
| radnot_is_pat_note | char(1) | NO | 0 | | | If no radnot_rtcm_id and this is 1, indicates a patient level note |
| radnot_rtcm_id | int(11) | NO | 0 | MUL | | Radiology Test Code ID #. If not set, this is either an order level or patient level note |
| radnot_segment | varchar(4) | NO | | | | Where Note goes in HL7. EITHER PID (Patient), ORC (Order as whole), OBR (test code). These map to front end ui note text fields. |
| radnot_comment | varchar(302) | NO | | | | The comment |
| radnot_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| radnot_created | timestamp | YES | CURRENT_TIMESTAMP | | | |