User:Ttenbergen/Relationship Diagram: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m (→Cargo) |
||
Line 37: | Line 37: | ||
=== Cargo === | === Cargo === | ||
[[Mermaid:Test w Cargo]] | [[Mermaid:Test w Cargo]] | ||
{{#display_diagram:Mermaid:Test w | {{#display_diagram:Mermaid:Test w Cargo}} | ||
{{Collapsable|always=see examples|full= | {{Collapsable|always=see examples|full= | ||
Line 47: | Line 47: | ||
{{#display_diagram:Mermaid:Test}} | {{#display_diagram:Mermaid:Test}} | ||
}} | }} | ||
== Approach: Extension Mermaid == | == Approach: Extension Mermaid == |
Revision as of 12:47, 2023 April 18
wiki housekeeping
|
|
https://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model
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
Cargo
%% Test to run w Cargo query.
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=
}}
see examples |
Page Mermaid:Test does not exist.
|
Approach: Extension Mermaid
Mermaid seems unsupported, trying FlexDiagrams instead |
Mermaid Documentation: https://github.com/SemanticMediaWiki/Mermaid/blob/master/docs/USAGE.md ProblemsExplicit callMermaid ER diagramxxx yyy
"L_Log |