CCMDB Wiki

Mermaid:Test w template: Difference between revisions

← Older editNewer edit →
mNo edit summary
mNo edit summary
Line 3: Line 3:
L_Log[L_Log table]
L_Log[L_Log table]


{{#cargo_query:
tables=foreign_keys
|fields= CONCAT(foreign_key_table,"[", foreign_key_table," table] -->{{!}}\"",foreign_key_field," to #8734; ", primary_key_field, "\"{{!}} ", primary_key_table)
|delimiter=<br>
}}


{{#cargo_query:
tables=foreign_keys
|fields=CONCAT("click ", foreign_key_table, " \"https://ccmdb.kuality.ca/index.php?title=", foreign_key_table, "\" \"open table page\"<br>")
|group by=foreign_key_table
|delimiter=
}}


s_dispo[s_dispo table] -->|"dispo_ID to #8734; Dispo"| L_Log
{{#cargo_query:
s_dispo[s_dispo table] -->|"dispo_ID to #8734; Pre-admit Inpatient Institution"| L_Log
tables=foreign_keys
s_dispo[s_dispo table] -->|"dispo_ID to #8734; Previous Location"| L_Log
|fields=CONCAT("click ", primary_key_table, " \"https://ccmdb.kuality.ca/index.php?title=", primary_key_table, "\" \"open table page\"<br>")
|group by=primary_key_table
|delimiter=
}}


click s_dispo "https://ccmdb.kuality.ca/index.php?title=s_dispo" "open table page"
%% s_dispo[s_dispo table] -->|"dispo_ID to #8734; Dispo"| L_Log
 
%% s_dispo[s_dispo table] -->|"dispo_ID to #8734; Pre-admit Inpatient Institution"| L_Log
click L_Log "https://ccmdb.kuality.ca/index.php?title=L_Log" "open table page"
%% s_dispo[s_dispo table] -->|"dispo_ID to #8734; Previous Location"| L_Log
%% click s_dispo "https://ccmdb.kuality.ca/index.php?title=s_dispo" "open table page"
%% click L_Log "https://ccmdb.kuality.ca/index.php?title=L_Log" "open table page"
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Mermaid:Test_w_template"