Mermaid:Test w template

From CCMDB Wiki
Revision as of 14:32, 2023 April 12 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
%% see for syntax https://mermaid.js.org/syntax/examples.html? graph LR 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= }} {{#cargo_query: tables=foreign_keys |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= }} %% 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 %% 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"
%% see for syntax https://mermaid.js.org/syntax/examples.html?
graph LR
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=
}}

{{#cargo_query:
tables=foreign_keys
|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=
}}

%% 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
%% 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&oldid=158946"