| rrnot_id | int(11) | NO | | PRI | auto_increment | |
| rrnot_cus_id | int(11) | NO | 0 | MUL | | Customer ID # |
| rrnot_cli_id | int(11) | NO | 0 | MUL | | Client ID # |
| rrnot_rad_res_id | int(11) | NO | 0 | MUL | | Radiology Result ID # |
| rrnot_rrtcm_id | int(11) | NO | 0 | MUL | | Radiology Result Test Code ID # |
| rrnot_rrtcres_id | int(11) | NO | 0 | MUL | | Radiology Result Test Code Result ID # |
| rrnot_seq_num | smallint(6) | NO | 0 | | | sequence number of not supplied by HL7 segment. Used to keep the notes in order. |
| rrnot_details | varchar(512) | NO | | | | |
| rrnot_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| rrnot_created | timestamp | YES | CURRENT_TIMESTAMP | | | |