DIAGRAMMATIC
save your work locally, this app is going away soon!
Login with GitHub
CODE
dejan
/
Jaffle shop
(public)
erDiagram CUSTOMERS { int id PK "Unique identifier" string first_name "Customer's first name" string last_name "Customer's last name" string email "Customer's email address" } ORDERS { int id PK "Unique identifier" int customer_id FK "References CUSTOMERS" date order_date "Date of the order" float amount "Total amount of the order" } PAYMENTS { int id PK "Unique identifier" int order_id FK "References ORDERS" string payment_method "Method of payment" date payment_date "Date of payment" float payment_amount "Amount paid" } CUSTOMERS ||--o{ ORDERS : "places" ORDERS ||--o{ PAYMENTS : "has"
PREVIEW
PNG
SVG
Auto-save OFF
Saving
You can change the code, but you won't be able to save it as you are not the owner.
mermaid