User:Ttenbergen/Relationship Diagram: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 21: | Line 21: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=foreign_keys | tables=foreign_keys | ||
|fields=CONCAT("click ", foreign_key_table, "\"https://ccmdb.kuality.ca/index.php?title=", foreign_key_table, "\"") | |fields=CONCAT("click ", foreign_key_table, " \"https://ccmdb.kuality.ca/index.php?title=", foreign_key_table, "\" \"open table page\"") | ||
|group by=foreign_key_table | |group by=foreign_key_table | ||
|delimiter=<br> | |delimiter=<br> | ||
| Line 28: | Line 28: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=foreign_keys | tables=foreign_keys | ||
|fields=CONCAT("click ", primary_key_table, "\"https://ccmdb.kuality.ca/index.php?title=", primary_key_table, "\"") | |fields=CONCAT("click ", primary_key_table, " \"https://ccmdb.kuality.ca/index.php?title=", primary_key_table, "\" \"open table page\"") | ||
|group by=primary_key_table | |group by=primary_key_table | ||
|delimiter=<br> | |delimiter=<br> | ||
Revision as of 14:29, 2023 April 12
|
wiki housekeeping
|
|
Cargo query to generate a line
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
s_FIO2[s_FIO2 table] -->|"type to #8734; Previous FiO2"| L_Log
click s_dispo "https://ccmdb.kuality.ca/index.php?title=s_dispo" "open table page"
click s_FIO2 "https://ccmdb.kuality.ca/index.php?title=s_FIO2" "open table page"
click L_Log "https://ccmdb.kuality.ca/index.php?title=L_Log" "open table page"
Approach: FlexDiagrams
| see examples |
|
Page Mermaid:Test does not exist.
|
Approach: Mermaid
| Mermaid seems unsupported, trying FlexDiagrams instead |
|
Mermaid Documentation: https://github.com/SemanticMediaWiki/Mermaid/blob/master/docs/USAGE.md Explicit callMermaid ER diagramxxx yyy
"L_Log |