Mermaid:Test w explicit: Difference between revisions

mNo edit summary
mNo edit summary
Line 3: Line 3:
%% L_ tables  
%% L_ tables  
L_Log[L_Log table]
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]
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]
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]
L_CCI_Component -->|"CCI_1_Code to #8734; CCI_1_Code"| S_CCI_1[S_CCI_1 table]
L_CCI_Component -->|"CCI_2_Code to #8734; CCI_2_Code"| S_CCI_2[S_CCI_2 table]
L_CCI_Component -->|"CCI_2_Code to #8734; CCI_2_Code"| S_CCI_2[S_CCI_2 table]
Line 15: Line 18:


L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_CCI_Picklist[L_CCI_Picklist 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]
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]
S_CCI_Picklist -->|"CCI_Picklist_code to #8734; CCI_code"| S_CCI_Categories_Collection_Mode[S_CCI_Categories_Collection_Mode table]
Line 20: Line 24:


L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_ICD10[L_ICD10 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]
L_ICD10 -->|"ICD10_code to #8734; ICD10_code"| S_ICD10[S_ICD10 table]
S_ICD10 -->|"ICD10_code to #8734; ICD10_code"| S_ICD10_Categories[s_ICD10_Categories]
S_ICD10 -->|"ICD10_code to #8734; ICD10_code"| S_ICD10_Categories[s_ICD10_Categories table]


L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_Labs_DSM[L_Labs_DSM table]
L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_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]
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_Pharm_Flowsheet[L_Pharm_Flowsheet table]
L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_Pharm_Flowsheet[L_Pharm_Flowsheet table]
L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_TmpV[L_TmpV table]
click L_Pharm_Flowsheet "https://ccmdb.kuality.ca/index.php?title=L_Pharm_Flowsheet_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/Pat_ID to #8734; D_ID/Pat_ID"| L_Dxs[L_Dxs table]
L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| L_Dxs[L_Dxs table]
click L_Dxs "https://ccmdb.kuality.ca/index.php?title=L_Dxs_table"


click L_CCI_Picklist "https://ccmdb.kuality.ca/index.php?title=L_CCI_Picklist_table"
click L_CCI_Component "https://ccmdb.kuality.ca/index.php?title=L_CCI_Component table"
click L_Dxs "https://ccmdb.kuality.ca/index.php?title=L_Dxs_table"
click L_ICD10 "https://ccmdb.kuality.ca/index.php?title=L_ICD10_table"
click L_Labs_DSM "https://ccmdb.kuality.ca/index.php?title=L_Labs_DSM_table"
click L_Labs_Flowsheet "https://ccmdb.kuality.ca/index.php?title=L_Labs_Flowsheet_table"
click L_Log "https://ccmdb.kuality.ca/index.php?title=L_Log_table"
click L_PCH "https://ccmdb.kuality.ca/index.php?title=L_PCH_table"
click L_Person "https://ccmdb.kuality.ca/index.php?title=L_Person_table"
click L_Pharm_Flowsheet "https://ccmdb.kuality.ca/index.php?title=L_Pharm_Flowsheet_table"
click L_PHI "https://ccmdb.kuality.ca/index.php?title=L_PHI_table"
click L_TmpV "https://ccmdb.kuality.ca/index.php?title=L_TmpV_table"


%%s_ tables
%%s_ tables
L_Log -->|"RecordStatus to #8734; RecordStatus_value"| s_RecordStatus
L_Log -->|"dispo_ID to #8734; Pre-admit Inpatient Institution"| s_dispo  
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; Previous Location"|s_dispo   
L_Log -->|"dispo_ID to #8734; Dispo"| s_dispo[s_dispo table]
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_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_Dressing to #8734; ADL_Bathing"| S_ADLOptions[S_ADLOptions table]
Line 52: Line 60:
L_Log -->|"ADL_Continence 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]
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]
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]
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]
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 -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| S_GCS[S_GCS table]
L_Log -->|"D_ID/Pat_ID to #8734; D_ID/Pat_ID"| S_GCS[S_GCS table]
click s_dispo "https://ccmdb.kuality.ca/index.php?title=s_dispo_table"
click S_ADLOptions "https://ccmdb.kuality.ca/index.php?title=S_ADLOptions_table"
click S_AP_AdmitType "https://ccmdb.kuality.ca/index.php?title=S_AP_AdmitType_table"
click S_AP_Chronic "https://ccmdb.kuality.ca/index.php?title=S_AP_Chronic_table"
click S_FIO2 "https://ccmdb.kuality.ca/index.php?title=S_FIO2_table"
click S_GCS "https://ccmdb.kuality.ca/index.php?title=S_GCS_table"
click S_GCS "https://ccmdb.kuality.ca/index.php?title=S_GCS_table"