User:Ttenbergen/Relationship Diagram: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 8: Line 8:
erDiagram
erDiagram
     CAR ||--o{ NAMED-DRIVER : allows
     CAR ||--o{ NAMED-DRIVER : allows
    CAR {
 
        string registrationNumber
        string make
        string model
    }
    PERSON ||--o{ NAMED-DRIVER : is
    PERSON {
        string firstName
        string lastName
        int age
    }
}}yyy
}}yyy
     L_Log ||--o{ L_ICD10: D_ID to D_ID
     L_Log ||--o{ L_ICD10: D_ID to D_ID
Line 30: Line 19:
click L_Log "https://ccmdb.kuality.ca/index.php?title=L_Log_table" "Tooltip L_Log"
click L_Log "https://ccmdb.kuality.ca/index.php?title=L_Log_table" "Tooltip L_Log"
     click s_Dispo "s_Dispo_table" "Tooltip s_Dispo"
     click s_Dispo "s_Dispo_table" "Tooltip s_Dispo"


=== Mermaid graph ===
=== Mermaid graph ===

Revision as of 16:10, 2021 November 16

Documentation: https://github.com/SemanticMediaWiki/Mermaid/blob/master/docs/USAGE.md


Explicit call

Mermaid ER diagram

xxx

yyy

   L_Log ||--o{ L_ICD10: D_ID to D_ID
   click L_Log "https://ccmdb.kuality.ca/index.php?title=L_Log_table" "Tooltip L_Log"
   L_Log||--o{ L_ICD10: D_ID to D_ID
   L_Log||--o{ L_CCI_Picklist: D_ID to D_ID
   L_Log||--|| Service/Location: s_dispo_ID" to s_Dispo

click L_Log "https://ccmdb.kuality.ca/index.php?title=L_Log_table" "Tooltip L_Log"

   click s_Dispo "s_Dispo_table" "Tooltip s_Dispo"

Mermaid graph

Why are we not doing this data driven

Frankly because Tina could not get it to work.

Mermaid with Cargo Query Input

  1. mermaid:

graph LR No results

   L_Log -->|"1 D_ID to #8734; D_ID"| L_CCI
   L_Log -->|"#8734; Service/Location to #8734; s_dispo_ID" | s_Dispo
   click L_Log "https://ccmdb.kuality.ca/index.php?title=L_Log_table" "Tooltip L_Log"
   click s_Dispo "s_Dispo_table" "Tooltip s_Dispo"

}}


Cargo query to generate a line

No results