Entity Relationship Diagram for the Critical Care and Medicine Database

Also see Strange data structures in CCMDB for some data that doesn't fit in here.

%% Test with explicit code works graph LR%% Test with explicit code worksgraph LR %% L_ tables L_Log[L_Log table] click L_Log "https://ccmdb.kuality.ca/index.php?title=L_Log_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_PHI[L_PHI table] click L_PHI "https://ccmdb.kuality.ca/index.php?title=L_PHI_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_CCI_Component[L_CCI_Component table] click L_CCI_Component "https://ccmdb.kuality.ca/index.php?title=L_CCI_Component table" L_CCI_Component -->|"CCI_1_Code to #8734; CCI_1_Code"| s_CCI_1[s_CCI_1 table] click s_CCI_1 "https://ccmdb.kuality.ca/index.php?title=s_CCI_1 table" L_CCI_Component -->|"CCI_2_Code to #8734; CCI_2_Code"| s_CCI_2[s_CCI_2 table] click s_CCI_2 "https://ccmdb.kuality.ca/index.php?title=s_CCI_2 table" s_CCI_1 -->|"CCI_1_code to #8734; CCI_code"| s_CCI_Categories_Collection_Mode[s_CCI_Categories_Collection_Mode table] s_CCI_2 -->|"CCI_2_code to #8734; CCI_code"| s_CCI_Categories_Collection_Mode[s_CCI_Categories_Collection_Mode table] s_CCI_1 -->|"CCI_1_code to #8734; CCI_code"| s_CCI_Categories[s_CCI_Categories table] s_CCI_2 -->|"CCI_2_code to #8734; CCI_code"| s_CCI_Categories[s_CCI_Categories table] L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_CCI_Picklist[L_CCI_Picklist table] click L_CCI_Picklist "https://ccmdb.kuality.ca/index.php?title=L_CCI_Picklist_table" L_CCI_Picklist -->|"CCI_Picklist_Code to #8734; CCI_Picklist_Code"| s_CCI_Picklist[s_CCI_Picklist table] s_CCI_Picklist -->|"CCI_Picklist_code to #8734; CCI_code"| s_CCI_Categories_Collection_Mode[s_CCI_Categories_Collection_Mode table] click s_CCI_Picklist "https://ccmdb.kuality.ca/index.php?title=s_CCI_Picklist_table" s_CCI_Picklist -->|"CCI_Picklist_code to #8734; CCI_code"| s_CCI_Categories[s_CCI_Categories table] click s_CCI_Categories_Collection_Mode "https://ccmdb.kuality.ca/index.php?title=s_CCI_Categories_Collection_Mode_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_ICD10[L_ICD10 table] click L_ICD10 "https://ccmdb.kuality.ca/index.php?title=L_ICD10_table" L_ICD10 -->|"ICD10_code to #8734; ICD10_code"| s_ICD10[s_ICD10 table] click s_ICD10 "https://ccmdb.kuality.ca/index.php?title=s_ICD10_table" s_ICD10 -->|"ICD10_code to #8734; ICD10_code"| s_ICD10_Categories[s_ICD10_Categories table] click s_ICD10_Categories "https://ccmdb.kuality.ca/index.php?title=s_ICD10_Categories_table" L_Log -->|"D_ID to #8734; D_ID"| L_Labs_DSM[L_Labs_DSM table] click L_Labs_DSM "https://ccmdb.kuality.ca/index.php?title=L_Labs_DSM_table" L_Labs_DSM -->|"ICD10_code to #8734; ICD10_code"| s_group[s_group table] L_Labs_DSM -->|"ICD10_code to #8734; ICD10_code"| s_mapping_lab[s_mapping_lab table] L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_Labs_Flowsheet[L_Labs_Flowsheet table] click L_Labs_Flowsheet "https://ccmdb.kuality.ca/index.php?title=L_Labs_Flowsheet_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_Labs_pre_2014_Aug[L_Labs_pre_2014_Aug table] click L_Labs_pre_2014_Aug "https://ccmdb.kuality.ca/index.php?title=L_Labs_pre_2014_Aug_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_Pharm_Flowsheet[L_Pharm_Flowsheet table] click L_Pharm_Flowsheet "https://ccmdb.kuality.ca/index.php?title=L_Pharm_Flowsheet_table" L_Log -->|"D_ID to #8734; D_ID"| L_Pharmacy_pre_2012[L_Pharmacy_pre_2012 table] click L_Pharmacy_pre_2012 "https://ccmdb.kuality.ca/index.php?title=L_Pharmacy_pre_2012_table" L_Log -->|"D_ID to #8734; D_ID"| L_TISS_Item[L_TISS_Item table] click L_TISS_Item "https://ccmdb.kuality.ca/index.php?title=L_TISS_Item_table" L_TISS_Item -->|"TISS_ITEM to #8734; TISS_ITEM_NO"| L_TISS_Reference[L_TISS_Reference table] click L_TISS_Reference "https://ccmdb.kuality.ca/index.php?title=L_TISS_Reference_table" L_Log -->|"D_ID to #8734; D_ID"| L_TISS_Form[L_TISS_Form table] click L_TISS_Form "https://ccmdb.kuality.ca/index.php?title=L_TISS_Form_table" L_Log -->|"D_ID to #8734; D_ID"| L_TISS76[L_TISS76 table] click L_TISS76 "https://ccmdb.kuality.ca/index.php?title=L_TISS76_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_TmpV2[L_TmpV2 table] click L_TmpV2 "https://ccmdb.kuality.ca/index.php?title=L_TmpV2_table" L_TmpV2 -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| s_Tmp[s_tmp table] click s_Tmp "https://ccmdb.kuality.ca/index.php?title=s_Tmp_table" L_Log -->|"D_ID to #8734; D_ID"| L_Dxs[L_Dxs table] click L_Dxs "https://ccmdb.kuality.ca/index.php?title=L_Dxs_table" L_Dxs -->|"DiagnosisCodeto #8734; DiagnosisCode"| s_AllDiagnoses[s_AllDiagnoses table] click s_AllDiagnoses "https://ccmdb.kuality.ca/index.php?title=s_AllDiagnoses table" L_Dxs -->|"DiagnosisCode to #8734; PathogenSubCode"| s_Pathogens[s_Pathogens table] click s_Pathogens "https://ccmdb.kuality.ca/index.php?title=s_Pathogens" L_Log -->|"D_ID to #8734; D_ID"| L_Como[L_Como table] click L_Como "https://ccmdb.kuality.ca/index.php?title=L_Como_table" L_Como -->|"ComorbidCode #8734; DiagnosisCode"| s_AllDiagnoses[s_AllDiagnoses table] L_Como -->|"ComorbidCode #8734; DiagnosisCode"| s_charlson_dxs[s_charlson_dxs table] click s_charlson_dxs "https://ccmdb.kuality.ca/index.php?title=s_charlson_dxs" L_Log -->|"D_ID to #8734; D_ID"| L_Communication_Notes[L_Communication_Notes table] click L_Communication_Notes "https://ccmdb.kuality.ca/index.php?title=L_Communication_Notes_table" L_Log -->|"D_ID to #8734; D_ID"| L_Hospitalization[L_Hospitalization table] click L_Hospitalization "https://ccmdb.kuality.ca/index.php?title=L_Hospitalization _table" L_Log -->|"D_ID to #8734; D_ID"| L_Problem[L_Problem table] click L_Problem "https://ccmdb.kuality.ca/index.php?title=L_Problem_table" L_Log -->|"D_ID to #8734; D_ID"| L_Problem[L_Problems_D_ID table] click L_Problems_D_ID "https://ccmdb.kuality.ca/index.php?title=L_Problems_D_ID_table" %%s_ tables L_Log -->|"R_Province to #8734; Code"| s_Provinces click s_Provinces "https://ccmdb.kuality.ca/index.php?title=s_Provinces_table" L_Log -->|"RecordStatus to #8734; RecordStatus_value"| s_RecordStatus click s_RecordStatus "https://ccmdb.kuality.ca/index.php?title=s_RecordStatus_table" L_Log -->|"dispo_ID to #8734; Pre-admit Inpatient Institution"| s_dispo L_Log -->|"dispo_ID to #8734; Previous Location"|s_dispo L_Log -->|"dispo_ID to #8734; Dispo"| s_dispo[s_dispo table] click s_dispo "https://ccmdb.kuality.ca/index.php?title=s_dispo_table" L_Log -->|"ADL_Bathing to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] L_Log -->|"ADL_Dressing to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] L_Log -->|"ADL_Toileting to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] L_Log -->|"ADL_Transfering to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] L_Log -->|"ADL_Continence to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] L_Log -->|"ADL_Feeding to #8734; ADL_Bathing"| s_ADLOptions[s_ADLOptions table] click s_ADLOptions "https://ccmdb.kuality.ca/index.php?title=s_ADLOptions_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| s_AP_AdmitType[s_AP_AdmitType table] click s_AP_AdmitType "https://ccmdb.kuality.ca/index.php?title=s_AP_AdmitType_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| s_AP_Chronic[s_AP_Chronic table] click s_AP_Chronic "https://ccmdb.kuality.ca/index.php?title=s_AP_Chronic_table" L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| s_FIO2[s_FIO2 table] click s_FIO2 "https://ccmdb.kuality.ca/index.php?title=s_FIO2_table" L_Log -->|"AP_Eye to #8734; full_text"| s_GCS[s_GCS table] L_Log -->|"AP_Motor to #8734; full_text"| s_GCS[s_GCS table] L_Log -->|"AP_Verbal to #8734; full_text"| s_GCS[s_GCS table] click s_GCS "https://ccmdb.kuality.ca/index.php?title=s_GCS_table" L_Log -->|"Pre_Acute_Living_Situation to #8734; pre_acute_living_situation_ID"| s_pre_acute_living_situation[s_pre_acute_living_situation table] click s_pre_acute_living_situation "https://ccmdb.kuality.ca/index.php?title=s_pre_acute_living_situation_table" L_Log -->|"Previous_Service to #8734; previous_service"| s_previous_service[s_previous_service table] click s_previous_service "https://ccmdb.kuality.ca/index.php?title=s_previous_service_table"

Implementation

This is generated using mediawiki extension Flex Diagrams. The diagram is encoded at Mermaid:Test w explicit.