|
|
| Line 3: |
Line 3: |
| L_Log[L_Log table] | | L_Log[L_Log table] |
|
| |
|
| {{#cargo_query: | | {{ER Mermaid}} |
| 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"
| |
Revision as of 13:34, 2023 April 12
%% see for syntax https://mermaid.js.org/syntax/examples.html?
graph LR
L_Log[L_Log table]
{{ER Mermaid}}
%% see for syntax https://mermaid.js.org/syntax/examples.html?
graph LR
L_Log[L_Log table]
{{ER Mermaid}}