| 6dd74de | | | 1 | <!doctype html> |
| 6dd74de | | | 2 | <html lang="en"> |
| 6dd74de | | | 3 | <head> |
| 6dd74de | | | 4 | <meta charset="utf-8" /> |
| 6dd74de | | | 5 | <meta http-equiv="X-UA-Compatible" content="IE=edge" /> |
| 6dd74de | | | 6 | <title>ER diagram | Mermaid Quick Test Page</title> |
| 6dd74de | | | 7 | <link rel="icon" type="image/png" href="data:image/png;base64,iVBORw0KGgo=" /> |
| 6dd74de | | | 8 | <style> |
| 6dd74de | | | 9 | div.mermaid { |
| 6dd74de | | | 10 | /* font-family: 'trebuchet ms', verdana, arial; */ |
| 6dd74de | | | 11 | font-family: 'Courier New', Courier, monospace !important; |
| 6dd74de | | | 12 | } |
| 6dd74de | | | 13 | .diagram-title { |
| 6dd74de | | | 14 | fill: red; |
| 6dd74de | | | 15 | font-size: 24pt; |
| 6dd74de | | | 16 | } |
| 6dd74de | | | 17 | </style> |
| 6dd74de | | | 18 | </head> |
| 6dd74de | | | 19 | |
| 6dd74de | | | 20 | <body> |
| 6dd74de | | | 21 | <pre class="mermaid"> |
| 6dd74de | | | 22 | --- |
| 6dd74de | | | 23 | title: This is a title |
| 6dd74de | | | 24 | config: |
| 6dd74de | | | 25 | theme: forest |
| 6dd74de | | | 26 | --- |
| 6dd74de | | | 27 | erDiagram |
| 6dd74de | | | 28 | %% title This is a title |
| 6dd74de | | | 29 | %% accDescription Test a description |
| 6dd74de | | | 30 | |
| 6dd74de | | | 31 | "Person . CUSTOMER"||--o{ ORDER : places |
| 6dd74de | | | 32 | |
| 6dd74de | | | 33 | ORDER ||--|{ "€£LINE_ITEM ¥" : contains |
| 6dd74de | | | 34 | |
| 6dd74de | | | 35 | "Person . CUSTOMER" }|..|{ "Address//StreetAddress::[DELIVERY ADDRESS]" : uses |
| 6dd74de | | | 36 | |
| 6dd74de | | | 37 | "Address//StreetAddress::[DELIVERY ADDRESS]" { |
| 6dd74de | | | 38 | int customerID FK |
| 6dd74de | | | 39 | string line1 "this is the first address line comment" |
| 6dd74de | | | 40 | string line2 |
| 6dd74de | | | 41 | string city |
| 6dd74de | | | 42 | string region |
| 6dd74de | | | 43 | string state |
| 6dd74de | | | 44 | string(5) postal_code |
| 6dd74de | | | 45 | string country |
| 6dd74de | | | 46 | } |
| 6dd74de | | | 47 | |
| 6dd74de | | | 48 | "a_~`!@#$^&*()-_=+[]{}|/;:'.?¡⁄™€£‹¢›∞fi§‡•°ª·º‚≠±œŒ∑„®†ˇ¥Á¨ˆˆØπ∏“«»åÅßÍ∂΃ϩ˙Ó∆Ô˚¬Ò…ÚæÆΩ¸≈π˛çÇ√◊∫ı˜µÂ≤¯≥˘÷¿" { |
| 6dd74de | | | 49 | string name "this is an entity with an absurd name just to show characters that are now acceptable as long as the name is in double quotes" |
| 6dd74de | | | 50 | } |
| 6dd74de | | | 51 | |
| 6dd74de | | | 52 | "€£LINE_ITEM ¥" { |
| 6dd74de | | | 53 | int orderID FK |
| 6dd74de | | | 54 | int currencyId FK |
| 6dd74de | | | 55 | number price |
| 6dd74de | | | 56 | number quantity |
| 6dd74de | | | 57 | number adjustment |
| 6dd74de | | | 58 | number final_price |
| 6dd74de | | | 59 | } |
| 6dd74de | | | 60 | </pre> |
| 6dd74de | | | 61 | <hr /> |
| 6dd74de | | | 62 | |
| 6dd74de | | | 63 | <pre class="mermaid"> |
| 6dd74de | | | 64 | erDiagram |
| 6dd74de | | | 65 | "HOSPITAL" { |
| 6dd74de | | | 66 | int id PK |
| 6dd74de | | | 67 | int doctor_id FK |
| 6dd74de | | | 68 | string address UK |
| 6dd74de | | | 69 | string name |
| 6dd74de | | | 70 | string phone_number |
| 6dd74de | | | 71 | string fax_number |
| 6dd74de | | | 72 | } |
| 6dd74de | | | 73 | </pre> |
| 6dd74de | | | 74 | <hr /> |
| 6dd74de | | | 75 | |
| 6dd74de | | | 76 | <pre class="mermaid"> |
| 6dd74de | | | 77 | erDiagram |
| 6dd74de | | | 78 | "HOSPITAL" { |
| 6dd74de | | | 79 | int id PK |
| 6dd74de | | | 80 | int doctor_id PK, FK |
| 6dd74de | | | 81 | string address UK |
| 6dd74de | | | 82 | string name |
| 6dd74de | | | 83 | string phone_number |
| 6dd74de | | | 84 | string fax_number |
| 6dd74de | | | 85 | } |
| 6dd74de | | | 86 | </pre |
| 6dd74de | | | 87 | > |
| 6dd74de | | | 88 | <hr /> |
| 6dd74de | | | 89 | |
| 6dd74de | | | 90 | <pre class="mermaid"> |
| 6dd74de | | | 91 | erDiagram |
| 6dd74de | | | 92 | CAR ||--o{ NAMED-DRIVER : allows |
| 6dd74de | | | 93 | CAR { |
| 6dd74de | | | 94 | string registrationNumber PK |
| 6dd74de | | | 95 | string make |
| 6dd74de | | | 96 | string model |
| 6dd74de | | | 97 | string[] parts |
| 6dd74de | | | 98 | } |
| 6dd74de | | | 99 | PERSON ||--o{ NAMED-DRIVER : is |
| 6dd74de | | | 100 | PERSON { |
| 6dd74de | | | 101 | string driversLicense PK "The license #" |
| 6dd74de | | | 102 | string(99) firstName "Only 99 characters are allowed" |
| 6dd74de | | | 103 | string lastName |
| 6dd74de | | | 104 | string phone UK |
| 6dd74de | | | 105 | int age |
| 6dd74de | | | 106 | } |
| 6dd74de | | | 107 | NAMED-DRIVER { |
| 6dd74de | | | 108 | string carRegistrationNumber PK, FK |
| 6dd74de | | | 109 | string driverLicence PK,FK |
| 6dd74de | | | 110 | } |
| 6dd74de | | | 111 | MANUFACTURER only one to zero or more CAR : makes |
| 6dd74de | | | 112 | </pre> |
| 6dd74de | | | 113 | <hr /> |
| 6dd74de | | | 114 | |
| 6dd74de | | | 115 | <pre class="mermaid"> |
| 6dd74de | | | 116 | erDiagram |
| 6dd74de | | | 117 | p[Person] { |
| 6dd74de | | | 118 | string firstName |
| 6dd74de | | | 119 | string lastName |
| 6dd74de | | | 120 | } |
| 6dd74de | | | 121 | a["Customer Account"] { |
| 6dd74de | | | 122 | string email |
| 6dd74de | | | 123 | } |
| 6dd74de | | | 124 | p ||--o| a : has |
| 6dd74de | | | 125 | </pre> |
| 6dd74de | | | 126 | <hr /> |
| 6dd74de | | | 127 | |
| 6dd74de | | | 128 | <pre class="mermaid"> |
| 6dd74de | | | 129 | erDiagram |
| 6dd74de | | | 130 | p[Person] { |
| 6dd74de | | | 131 | string firstName |
| 6dd74de | | | 132 | string lastName |
| 6dd74de | | | 133 | } |
| 6dd74de | | | 134 | a["Customer Account"] { |
| 6dd74de | | | 135 | string email |
| 6dd74de | | | 136 | } |
| 6dd74de | | | 137 | |
| 6dd74de | | | 138 | b["Customer Account Secondary"] { |
| 6dd74de | | | 139 | string email |
| 6dd74de | | | 140 | } |
| 6dd74de | | | 141 | |
| 6dd74de | | | 142 | c["Customer Account Tertiary"] { |
| 6dd74de | | | 143 | string email |
| 6dd74de | | | 144 | } |
| 6dd74de | | | 145 | |
| 6dd74de | | | 146 | d["Customer Account Nth"] { |
| 6dd74de | | | 147 | string email |
| 6dd74de | | | 148 | } |
| 6dd74de | | | 149 | |
| 6dd74de | | | 150 | p ||--o| a : "has<br />one" |
| 6dd74de | | | 151 | p ||--o| b : "has<br />one<br />two" |
| 6dd74de | | | 152 | p ||--o| c : "has<br />one<br />two<br />three" |
| 6dd74de | | | 153 | p ||--o| d : "has<br />one<br />two<br />three<br />...<br />Nth" |
| 6dd74de | | | 154 | </pre> |
| 6dd74de | | | 155 | <hr /> |
| 6dd74de | | | 156 | |
| 6dd74de | | | 157 | <pre class="mermaid"> |
| 6dd74de | | | 158 | erDiagram |
| 6dd74de | | | 159 | _customer_order { |
| 6dd74de | | | 160 | bigint id PK |
| 6dd74de | | | 161 | bigint customer_id FK |
| 6dd74de | | | 162 | text shipping_address |
| 6dd74de | | | 163 | text delivery_method |
| 6dd74de | | | 164 | timestamp_with_time_zone ordered_at |
| 6dd74de | | | 165 | numeric total_tax_amount |
| 6dd74de | | | 166 | numeric total_price |
| 6dd74de | | | 167 | text payment_method |
| 6dd74de | | | 168 | } |
| 6dd74de | | | 169 | </pre> |
| 6dd74de | | | 170 | <hr /> |
| 6dd74de | | | 171 | |
| 6dd74de | | | 172 | <script type="module"> |
| 6dd74de | | | 173 | import mermaid from './mermaid.esm.mjs'; |
| 6dd74de | | | 174 | mermaid.initialize({ |
| 6dd74de | | | 175 | theme: 'default', |
| 6dd74de | | | 176 | |
| 6dd74de | | | 177 | // themeCSS: '.node rect { fill: red; }', |
| 6dd74de | | | 178 | logLevel: 3, |
| 6dd74de | | | 179 | securityLevel: 'loose', |
| 6dd74de | | | 180 | flowchart: { curve: 'basis' }, |
| 6dd74de | | | 181 | gantt: { axisFormat: '%m/%d/%Y' }, |
| 6dd74de | | | 182 | sequence: { actorMargin: 50 }, |
| 6dd74de | | | 183 | // sequenceDiagram: { actorMargin: 300 } // deprecated |
| 6dd74de | | | 184 | }); |
| 6dd74de | | | 185 | </script> |
| 6dd74de | | | 186 | </body> |
| 6dd74de | | | 187 | </html> |