Mermaid:Test w Cargo: Difference between revisions
The following pages link to this diagram: User:Ttenbergen/Relationship Diagram, User:Ttenbergen/Flex Diagram testing
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
%% Test to run w Cargo query | %% Test to run w Cargo query. | ||
graph LR | graph LR | ||
L_Log[L_Log table] | L_Log[L_Log table] | ||
Latest revision as of 14:08, 12 April 2023
%% 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=
}}
%% 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=
}}