-
Notifications
You must be signed in to change notification settings - Fork 0
/
DB Example.drawio.html
12 lines (12 loc) · 16 KB
/
DB Example.drawio.html
1
2
3
4
5
6
7
8
9
10
11
12
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>draw.io</title>
<meta http-equiv="refresh" content="0;URL='https://app.diagrams.net/?libs=general;er#Hconnorpwilliams%2Fdraw.io%2Fmaster%2FDB%20Example.drawio.html'"/>
<meta charset="utf-8"/>
</head>
<body>
<div class="mxgraph" style="max-width:100%;border:1px solid transparent;" data-mxgraph="{"highlight":"#0000ff","nav":true,"resize":true,"xml":"<mxfile host=\"app.diagrams.net\" modified=\"2024-03-26T12:58:34.581Z\" agent=\"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:124.0) Gecko/20100101 Firefox/124.0\" etag=\"Qw44zGWz6CUvgzejWh39\" version=\"24.0.2\" type=\"github\">&#xa; <diagram id=\"R2lEEEUBdFMjLlhIrx00\" name=\"Page-1\">&#xa; <mxGraphModel dx=\"1223\" dy=\"797\" grid=\"1\" gridSize=\"10\" guides=\"1\" tooltips=\"1\" connect=\"1\" arrows=\"1\" fold=\"1\" page=\"1\" pageScale=\"1\" pageWidth=\"850\" pageHeight=\"1100\" math=\"0\" shadow=\"0\" extFonts=\"Permanent Marker^https://fonts.googleapis.com/css?family=Permanent+Marker\">&#xa; <root>&#xa; <mxCell id=\"0\"/>&#xa; <mxCell id=\"1\" parent=\"0\"/>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-1\" value=\"\" style=\"edgeStyle=entityRelationEdgeStyle;endArrow=ERzeroToMany;startArrow=ERone;endFill=1;startFill=0;\" parent=\"1\" source=\"C-vyLk0tnHw3VtMMgP7b-24\" target=\"C-vyLk0tnHw3VtMMgP7b-6\" edge=\"1\">&#xa; <mxGeometry width=\"100\" height=\"100\" relative=\"1\" as=\"geometry\">&#xa; <mxPoint x=\"340\" y=\"720\" as=\"sourcePoint\"/>&#xa; <mxPoint x=\"440\" y=\"620\" as=\"targetPoint\"/>&#xa; </mxGeometry>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-12\" value=\"\" style=\"edgeStyle=entityRelationEdgeStyle;endArrow=ERzeroToMany;startArrow=ERone;endFill=1;startFill=0;\" parent=\"1\" source=\"C-vyLk0tnHw3VtMMgP7b-3\" target=\"C-vyLk0tnHw3VtMMgP7b-17\" edge=\"1\">&#xa; <mxGeometry width=\"100\" height=\"100\" relative=\"1\" as=\"geometry\">&#xa; <mxPoint x=\"400\" y=\"180\" as=\"sourcePoint\"/>&#xa; <mxPoint x=\"460\" y=\"205\" as=\"targetPoint\"/>&#xa; </mxGeometry>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-2\" value=\"Orders\" style=\"shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;\" parent=\"1\" vertex=\"1\">&#xa; <mxGeometry x=\"450\" y=\"120\" width=\"250\" height=\"130\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-3\" value=\"\" style=\"shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;\" parent=\"C-vyLk0tnHw3VtMMgP7b-2\" vertex=\"1\">&#xa; <mxGeometry y=\"30\" width=\"250\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-4\" value=\"PK\" style=\"shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;\" parent=\"C-vyLk0tnHw3VtMMgP7b-3\" vertex=\"1\">&#xa; <mxGeometry width=\"30\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-5\" value=\"order_id int NOT NULL \" style=\"shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;\" parent=\"C-vyLk0tnHw3VtMMgP7b-3\" vertex=\"1\">&#xa; <mxGeometry x=\"30\" width=\"220\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-6\" value=\"\" style=\"shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"C-vyLk0tnHw3VtMMgP7b-2\" vertex=\"1\">&#xa; <mxGeometry y=\"60\" width=\"250\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-7\" value=\"FK1\" style=\"shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;\" parent=\"C-vyLk0tnHw3VtMMgP7b-6\" vertex=\"1\">&#xa; <mxGeometry width=\"30\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-8\" value=\"customer_id int NOT NULL\" style=\"shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;\" parent=\"C-vyLk0tnHw3VtMMgP7b-6\" vertex=\"1\">&#xa; <mxGeometry x=\"30\" width=\"220\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-9\" value=\"\" style=\"shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"C-vyLk0tnHw3VtMMgP7b-2\" vertex=\"1\">&#xa; <mxGeometry y=\"90\" width=\"250\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-10\" value=\"\" style=\"shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;\" parent=\"C-vyLk0tnHw3VtMMgP7b-9\" vertex=\"1\">&#xa; <mxGeometry width=\"30\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-11\" value=\"order_date date NOT NULL\" style=\"shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;\" parent=\"C-vyLk0tnHw3VtMMgP7b-9\" vertex=\"1\">&#xa; <mxGeometry x=\"30\" width=\"220\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-13\" value=\"Shipments\" style=\"shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;\" parent=\"1\" vertex=\"1\">&#xa; <mxGeometry x=\"450\" y=\"280\" width=\"250\" height=\"130\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-14\" value=\"\" style=\"shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;\" parent=\"C-vyLk0tnHw3VtMMgP7b-13\" vertex=\"1\">&#xa; <mxGeometry y=\"30\" width=\"250\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-15\" value=\"PK\" style=\"shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;\" parent=\"C-vyLk0tnHw3VtMMgP7b-14\" vertex=\"1\">&#xa; <mxGeometry width=\"30\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-16\" value=\"shipment_id int NOT NULL \" style=\"shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;\" parent=\"C-vyLk0tnHw3VtMMgP7b-14\" vertex=\"1\">&#xa; <mxGeometry x=\"30\" width=\"220\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-17\" value=\"\" style=\"shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"C-vyLk0tnHw3VtMMgP7b-13\" vertex=\"1\">&#xa; <mxGeometry y=\"60\" width=\"250\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-18\" value=\"FK1\" style=\"shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;\" parent=\"C-vyLk0tnHw3VtMMgP7b-17\" vertex=\"1\">&#xa; <mxGeometry width=\"30\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-19\" value=\"order_id int NOT NULL\" style=\"shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;\" parent=\"C-vyLk0tnHw3VtMMgP7b-17\" vertex=\"1\">&#xa; <mxGeometry x=\"30\" width=\"220\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-20\" value=\"\" style=\"shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"C-vyLk0tnHw3VtMMgP7b-13\" vertex=\"1\">&#xa; <mxGeometry y=\"90\" width=\"250\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-21\" value=\"\" style=\"shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;\" parent=\"C-vyLk0tnHw3VtMMgP7b-20\" vertex=\"1\">&#xa; <mxGeometry width=\"30\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-22\" value=\"shipment_date date NOT NULL\" style=\"shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;\" parent=\"C-vyLk0tnHw3VtMMgP7b-20\" vertex=\"1\">&#xa; <mxGeometry x=\"30\" width=\"220\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-23\" value=\"Customers\" style=\"shape=table;startSize=30;container=1;collapsible=1;childLayout=tableLayout;fixedRows=1;rowLines=0;fontStyle=1;align=center;resizeLast=1;\" parent=\"1\" vertex=\"1\">&#xa; <mxGeometry x=\"120\" y=\"120\" width=\"250\" height=\"100\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-24\" value=\"\" style=\"shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=1;\" parent=\"C-vyLk0tnHw3VtMMgP7b-23\" vertex=\"1\">&#xa; <mxGeometry y=\"30\" width=\"250\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-25\" value=\"PK\" style=\"shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;fontStyle=1;\" parent=\"C-vyLk0tnHw3VtMMgP7b-24\" vertex=\"1\">&#xa; <mxGeometry width=\"30\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-26\" value=\"customer_id int NOT NULL \" style=\"shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;fontStyle=5;\" parent=\"C-vyLk0tnHw3VtMMgP7b-24\" vertex=\"1\">&#xa; <mxGeometry x=\"30\" width=\"220\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-27\" value=\"\" style=\"shape=partialRectangle;collapsible=0;dropTarget=0;pointerEvents=0;fillColor=none;points=[[0,0.5],[1,0.5]];portConstraint=eastwest;top=0;left=0;right=0;bottom=0;\" parent=\"C-vyLk0tnHw3VtMMgP7b-23\" vertex=\"1\">&#xa; <mxGeometry y=\"60\" width=\"250\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-28\" value=\"\" style=\"shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;\" parent=\"C-vyLk0tnHw3VtMMgP7b-27\" vertex=\"1\">&#xa; <mxGeometry width=\"30\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; <mxCell id=\"C-vyLk0tnHw3VtMMgP7b-29\" value=\"customer_name char(50) NOT NULL\" style=\"shape=partialRectangle;overflow=hidden;connectable=0;fillColor=none;top=0;left=0;bottom=0;right=0;align=left;spacingLeft=6;\" parent=\"C-vyLk0tnHw3VtMMgP7b-27\" vertex=\"1\">&#xa; <mxGeometry x=\"30\" width=\"220\" height=\"30\" as=\"geometry\"/>&#xa; </mxCell>&#xa; </root>&#xa; </mxGraphModel>&#xa; </diagram>&#xa;</mxfile>","toolbar":"pages zoom layers lightbox"}"></div>
<a style="position:absolute;top:50%;left:50%;margin-top:-128px;margin-left:-64px;" href="https://app.diagrams.net/?libs=general;er#Hconnorpwilliams%2Fdraw.io%2Fmaster%2FDB%20Example.drawio.html" target="_blank"><img border="0" src="https://app.diagrams.net/images/drawlogo128.png"/></a>
</body>
</html>