common.models

Field	Type	Null	Default	Key	Extra	Comment
mdl_id	int(11)	NO		PRI	auto_increment
mdl_name	varchar(40)	NO
mdl_key	varchar(40)	NO
mdl_db_type	varchar(256)	NO				Associated database type
mdl_table	varchar(256)	NO				Associated table
mdl_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
mdl_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

mdl_id

Table	Column
_1.audits_archive_components	audcomp_mdl_id
_1.audits_components	audcomp_mdl_id
_1.clinical_interventions_coded_attributes	cica_mdl_id
_1.external_identifier_map	exi_mdl_id
_1.flowsheet_models_map	fmm_mdl_id
_1.interface_messaging_logs_map	imlm_mdl_id
_1.models_updates	mdu_mdl_id
_1.patient_portal_requests	ppr_mdl_id
_1.patients_education_results	peres_mdl_id
_1.patients_health_observations	pho_mdl_id
_1.portal_released_data	prd_mdl_id
_1.portal_withheld_data	pwd_mdl_id
_1188.audits_archive_components	audcomp_mdl_id
_1188.audits_components	audcomp_mdl_id
_1188.data_import_history	dih_mdl_id
_1188.external_identifier_map	exi_mdl_id
_1188.interface_messaging_logs_map	imlm_mdl_id
_1188.models_updates	mdu_mdl_id
_1188.patient_portal_requests	ppr_mdl_id
_1188.patients_education_results	peres_mdl_id
_1188.patients_health_observations	pho_mdl_id
_1188.portal_released_data	prd_mdl_id
_1188.portal_withheld_data	pwd_mdl_id
_1218.audits_archive_components	audcomp_mdl_id
_1218.audits_components	audcomp_mdl_id
_1218.data_import_history	dih_mdl_id
_1218.external_identifier_map	exi_mdl_id
_1218.flowsheet_models_map	fmm_mdl_id
_1218.interface_messaging_logs_map	imlm_mdl_id
_1218.models_updates	mdu_mdl_id
_1218.patient_portal_requests	ppr_mdl_id
_1218.patients_education_results	peres_mdl_id
_1218.patients_health_observations	pho_mdl_id
_1218.portal_released_data	prd_mdl_id
_1218.portal_withheld_data	pwd_mdl_id
_1548.audits_archive_components	audcomp_mdl_id
_1548.audits_components	audcomp_mdl_id
_1548.clinical_interventions_coded_attributes	cica_mdl_id
_1548.external_identifier_map	exi_mdl_id
_1548.flowsheet_models_map	fmm_mdl_id
_1548.interface_messaging_logs_map	imlm_mdl_id
_1548.models_updates	mdu_mdl_id
_1548.patient_portal_requests	ppr_mdl_id
_1548.patients_education_results	peres_mdl_id
_1548.patients_health_observations	pho_mdl_id
_1548.portal_released_data	prd_mdl_id
_1548.portal_withheld_data	pwd_mdl_id
_435.audits_archive_components	audcomp_mdl_id
_435.audits_components	audcomp_mdl_id
_435.audits_components_2008	audcomp_mdl_id
_435.audits_components_2009	audcomp_mdl_id
_435.audits_components_2010	audcomp_mdl_id
_435.audits_components_2011	audcomp_mdl_id
_435.audits_components_2012	audcomp_mdl_id
_435.audits_components_2013	audcomp_mdl_id
_435.audits_components_2014	audcomp_mdl_id
_435.audits_components_2015	audcomp_mdl_id
_435.audits_components_2016	audcomp_mdl_id
_435.audits_components_2017	audcomp_mdl_id
_435.audits_components_2018	audcomp_mdl_id
_435.audits_components_2019	audcomp_mdl_id
_435.audits_components_2020	audcomp_mdl_id
_435.clinical_interventions_coded_attributes	cica_mdl_id
_435.data_import_history	dih_mdl_id
_435.external_identifier_map	exi_mdl_id
_435.flowsheet_models_map	fmm_mdl_id
_435.interface_messaging_logs_map	imlm_mdl_id
_435.models_updates	mdu_mdl_id
_435.patient_portal_requests	ppr_mdl_id
_435.patients_education_results	peres_mdl_id
_435.patients_health_observations	pho_mdl_id
_435.portal_released_data	prd_mdl_id
_435.portal_withheld_data	pwd_mdl_id
_436.audits_archive_components	audcomp_mdl_id
_436.audits_components	audcomp_mdl_id
_436.clinical_interventions_coded_attributes	cica_mdl_id
_436.data_import_history	dih_mdl_id
_436.external_identifier_map	exi_mdl_id
_436.flowsheet_models_map	fmm_mdl_id
_436.interface_messaging_logs_map	imlm_mdl_id
_436.models_updates	mdu_mdl_id
_436.patient_portal_requests	ppr_mdl_id
_436.patients_education_results	peres_mdl_id
_436.patients_health_observations	pho_mdl_id
_436.portal_released_data	prd_mdl_id
_436.portal_withheld_data	pwd_mdl_id
_436_archive_testing.audits_archive_components	audcomp_mdl_id
_436_archive_testing.audits_components	audcomp_mdl_id
_436_archive_testing.audits_components_2008	audcomp_mdl_id
_436_archive_testing.audits_components_2009	audcomp_mdl_id
_436_archive_testing.audits_components_2010	audcomp_mdl_id
_436_archive_testing.audits_components_2011	audcomp_mdl_id
_436_archive_testing.audits_components_2012	audcomp_mdl_id
_436_archive_testing.audits_components_2013	audcomp_mdl_id
_436_archive_testing.audits_components_2014	audcomp_mdl_id
_436_archive_testing.audits_components_2015	audcomp_mdl_id
_436_archive_testing.audits_components_2016	audcomp_mdl_id
_436_archive_testing.audits_components_2017	audcomp_mdl_id
_436_archive_testing.audits_components_2018	audcomp_mdl_id
_436_archive_testing.audits_components_2019	audcomp_mdl_id
_436_archive_testing.audits_components_2020	audcomp_mdl_id
_436_archive_testing.audits_components_2021	audcomp_mdl_id
_436_archive_testing.clinical_interventions_coded_attributes	cica_mdl_id
_436_archive_testing.data_import_history	dih_mdl_id
_436_archive_testing.external_identifier_map	exi_mdl_id
_436_archive_testing.flowsheet_models_map	fmm_mdl_id
_436_archive_testing.interface_messaging_logs_map	imlm_mdl_id
_436_archive_testing.models_updates	mdu_mdl_id
_436_archive_testing.patient_portal_requests	ppr_mdl_id
_436_archive_testing.patients_education_results	peres_mdl_id
_436_archive_testing.patients_health_observations	pho_mdl_id
_436_archive_testing.portal_released_data	prd_mdl_id
_436_archive_testing.portal_withheld_data	pwd_mdl_id
_437.audits_archive_components	audcomp_mdl_id
_437.audits_components	audcomp_mdl_id
_437.clinical_interventions_coded_attributes	cica_mdl_id
_437.data_import_history	dih_mdl_id
_437.external_identifier_map	exi_mdl_id
_437.flowsheet_models_map	fmm_mdl_id
_437.interface_messaging_logs_map	imlm_mdl_id
_437.models_updates	mdu_mdl_id
_437.patient_portal_requests	ppr_mdl_id
_437.patients_education_results	peres_mdl_id
_437.patients_health_observations	pho_mdl_id
_437.portal_released_data	prd_mdl_id
_437.portal_withheld_data	pwd_mdl_id
_8.audits_archive_components	audcomp_mdl_id
_8.audits_components	audcomp_mdl_id
_8.audits_components_2020	audcomp_mdl_id
_8.clinical_interventions_coded_attributes	cica_mdl_id
_8.data_import_history	dih_mdl_id
_8.external_identifier_map	exi_mdl_id
_8.flowsheet_models_map	fmm_mdl_id
_8.interface_messaging_logs_map	imlm_mdl_id
_8.models_updates	mdu_mdl_id
_8.patient_portal_requests	ppr_mdl_id
_8.patients_education_results	peres_mdl_id
_8.patients_health_observations	pho_mdl_id
_8.portal_released_data	prd_mdl_id
_8.portal_withheld_data	pwd_mdl_id
_81.audits_archive_components	audcomp_mdl_id
_81.audits_components	audcomp_mdl_id
_81.data_import_history	dih_mdl_id
_81.external_identifier_map	exi_mdl_id
_81.interface_messaging_logs_map	imlm_mdl_id
_81.models_updates	mdu_mdl_id
_81.patient_portal_requests	ppr_mdl_id
_81.patients_education_results	peres_mdl_id
_81.patients_health_observations	pho_mdl_id
_81.portal_released_data	prd_mdl_id
_81.portal_withheld_data	pwd_mdl_id
_999.audits_archive_components	audcomp_mdl_id
_999.audits_components	audcomp_mdl_id
_999.clinical_interventions_coded_attributes	cica_mdl_id
_999.data_import_history	dih_mdl_id
_999.external_identifier_map	exi_mdl_id
_999.flowsheet_models_map	fmm_mdl_id
_999.interface_messaging_logs_map	imlm_mdl_id
_999.models_updates	mdu_mdl_id
_999.patient_portal_requests	ppr_mdl_id
_999.patients_education_results	peres_mdl_id
_999.patients_health_observations	pho_mdl_id
_999.portal_released_data	prd_mdl_id
_999.portal_withheld_data	pwd_mdl_id