_999.clinical_alerts

Field Type Null Default Key Extra Comment
ca_id int(11) NO PRI auto_increment
ca_cus_id int(11) NO MUL
ca_cli_id int(11) NO
ca_phy_id int(11) NO 0
ca_name varchar(80) NO
ca_cat_id int(11) NO MUL
ca_cacs_id int(11) NO
ca_operator varchar(4) NO
ca_val varchar(12) NO
ca_pat_sex char(1) NO
ca_pat_age int(11) NO
ca_text text NO
ca_modified datetime YES CURRENT_TIMESTAMP
ca_created datetime YES CURRENT_TIMESTAMP

References

Local Column References
ca_id
TableColumn
_1.clinical_alerts_accesscaa_ca_id
_1.clinical_alerts_rulescar_ca_id
_1188.clinical_alerts_accesscaa_ca_id
_1188.clinical_alerts_rulescar_ca_id
_1218.clinical_alerts_accesscaa_ca_id
_1218.clinical_alerts_rulescar_ca_id
_1548.clinical_alerts_accesscaa_ca_id
_1548.clinical_alerts_rulescar_ca_id
_435.clinical_alerts_accesscaa_ca_id
_435.clinical_alerts_rulescar_ca_id
_436.clinical_alerts_accesscaa_ca_id
_436.clinical_alerts_rulescar_ca_id
_436_archive_testing.clinical_alerts_accesscaa_ca_id
_436_archive_testing.clinical_alerts_rulescar_ca_id
_437.clinical_alerts_accesscaa_ca_id
_437.clinical_alerts_rulescar_ca_id
_8.clinical_alerts_accesscaa_ca_id
_8.clinical_alerts_rulescar_ca_id
_81.clinical_alerts_accesscaa_ca_id
_81.clinical_alerts_rulescar_ca_id
_999.clinical_alerts_accesscaa_ca_id
_999.clinical_alerts_rulescar_ca_id
aurora_standard.vault_relationshipspatient_relationship_ca_id
aurora_standard.vault_relationshipsholder_relationship_ca_id