_1.clinical_interventions_review_map

Field Type Null Default Key Extra Comment
cirm_id int(11) NO PRI auto_increment
cirm_ci_id int(11) NO MUL
cirm_pat_id int(11) NO MUL Patient on which the CI was reviewed
cirm_cus_id int(11) NO
cirm_cli_id int(11) NO
cirm_disabled tinyint(1) NO 0
cirm_disabled_usr_id int(11) YES User who disabled the CI
cirm_creator_usr_id int(11) NO User created/reviewed the CI
cirm_modified datetime YES CURRENT_TIMESTAMP
cirm_created datetime YES CURRENT_TIMESTAMP

References

Local Column References