User:Ttenbergen/Relationship Diagram

From CCMDB Wiki
Jump to navigation Jump to search

wiki housekeeping

  • added: no added date
  • action: no action date
  • Cargo


  • Categories

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

Mermaid:Test w 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   

BPMN:Test

Mermaid:Test

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

Problems

Explicit call

Mermaid ER diagram

xxx

yyy
   "L_Log