_999.systems_components

Field Type Null Default Key Extra Comment
scmp_id int(11) NO PRI auto_increment
scmp_cs_id int(11) YES MUL Coding System ID#
scmp_cli_id int(11) NO MUL
scmp_esl_id int(11) NO
scmp_name varchar(256) NO
scmp_datatype varchar(40) NO
scmp_default_value text NO
scmp_default_unit varchar(10) NO
scmp_value text NO
scmp_gender char(1) NO
scmp_code varchar(45) NO
scmp_modified datetime YES CURRENT_TIMESTAMP
scmp_created datetime YES CURRENT_TIMESTAMP

References

Local Column References
scmp_id
TableColumn
_1.encounters_soap_labels_componentseslc_scmp_id
_1.soap_labels_system_component_mapslsm_scmp_id
_1.structured_answerssra_scmp_id
_1.systems_components_piecesscmpp_scmp_id
_1188.encounters_soap_labels_componentseslc_scmp_id
_1188.soap_labels_system_component_mapslsm_scmp_id
_1188.structured_answerssra_scmp_id
_1188.systems_components_piecesscmpp_scmp_id
_1218.encounters_soap_labels_componentseslc_scmp_id
_1218.soap_labels_system_component_mapslsm_scmp_id
_1218.structured_answerssra_scmp_id
_1218.systems_components_piecesscmpp_scmp_id
_1548.encounters_soap_labels_componentseslc_scmp_id
_1548.soap_labels_system_component_mapslsm_scmp_id
_1548.structured_answerssra_scmp_id
_1548.systems_components_piecesscmpp_scmp_id
_435.encounters_soap_labels_componentseslc_scmp_id
_435.soap_labels_system_component_mapslsm_scmp_id
_435.structured_answerssra_scmp_id
_435.systems_components_piecesscmpp_scmp_id
_436.encounters_soap_labels_componentseslc_scmp_id
_436.soap_labels_system_component_mapslsm_scmp_id
_436.structured_answerssra_scmp_id
_436.systems_components_piecesscmpp_scmp_id
_436_archive_testing.encounters_soap_labels_componentseslc_scmp_id
_436_archive_testing.soap_labels_system_component_mapslsm_scmp_id
_436_archive_testing.structured_answerssra_scmp_id
_436_archive_testing.systems_components_piecesscmpp_scmp_id
_437.encounters_soap_labels_componentseslc_scmp_id
_437.soap_labels_system_component_mapslsm_scmp_id
_437.structured_answerssra_scmp_id
_437.systems_components_piecesscmpp_scmp_id
_8.encounters_soap_labels_componentseslc_scmp_id
_8.soap_labels_system_component_mapslsm_scmp_id
_8.structured_answerssra_scmp_id
_8.systems_components_piecesscmpp_scmp_id
_81.encounters_soap_labels_componentseslc_scmp_id
_81.soap_labels_system_component_mapslsm_scmp_id
_81.structured_answerssra_scmp_id
_81.systems_components_piecesscmpp_scmp_id
_999.encounters_soap_labels_componentseslc_scmp_id
_999.soap_labels_system_component_mapslsm_scmp_id
_999.structured_answerssra_scmp_id
_999.systems_components_piecesscmpp_scmp_id
template_library.soap_labels_system_component_mapslsm_scmp_id
template_library.systems_components_piecesscmpp_scmp_id
scmp_name
TableColumn
_1.encounters_soap_labels_componentseslc_scmp_name
_1188.encounters_soap_labels_componentseslc_scmp_name
_1218.encounters_soap_labels_componentseslc_scmp_name
_1548.encounters_soap_labels_componentseslc_scmp_name
_435.encounters_soap_labels_componentseslc_scmp_name
_436.encounters_soap_labels_componentseslc_scmp_name
_436_archive_testing.encounters_soap_labels_componentseslc_scmp_name
_437.encounters_soap_labels_componentseslc_scmp_name
_8.encounters_soap_labels_componentseslc_scmp_name
_81.encounters_soap_labels_componentseslc_scmp_name
_999.encounters_soap_labels_componentseslc_scmp_name
scmp_datatype
TableColumn
_1.encounters_soap_labels_componentseslc_scmp_datatype
_1188.encounters_soap_labels_componentseslc_scmp_datatype
_1218.encounters_soap_labels_componentseslc_scmp_datatype
_1548.encounters_soap_labels_componentseslc_scmp_datatype
_435.encounters_soap_labels_componentseslc_scmp_datatype
_436.encounters_soap_labels_componentseslc_scmp_datatype
_436_archive_testing.encounters_soap_labels_componentseslc_scmp_datatype
_437.encounters_soap_labels_componentseslc_scmp_datatype
_8.encounters_soap_labels_componentseslc_scmp_datatype
_81.encounters_soap_labels_componentseslc_scmp_datatype
_999.encounters_soap_labels_componentseslc_scmp_datatype
scmp_value
TableColumn
_1.encounters_soap_labels_componentseslc_scmp_value
_1188.encounters_soap_labels_componentseslc_scmp_value
_1218.encounters_soap_labels_componentseslc_scmp_value
_1548.encounters_soap_labels_componentseslc_scmp_value
_435.encounters_soap_labels_componentseslc_scmp_value
_436.encounters_soap_labels_componentseslc_scmp_value
_436_archive_testing.encounters_soap_labels_componentseslc_scmp_value
_437.encounters_soap_labels_componentseslc_scmp_value
_8.encounters_soap_labels_componentseslc_scmp_value
_81.encounters_soap_labels_componentseslc_scmp_value
_999.encounters_soap_labels_componentseslc_scmp_value