3-4-1
Tables (3)
Untitled (Product)
- Key (id) — Long — Primary key — NOT NULL
- id (name) — String — NOT NULL
- Field5 (price) — Int — NOT NULL
- Field (filePath) — String — NOT NULL
Untitled (Order)
- Key (id) — Long — Primary key — NOT NULL
- Field (email) — String — NOT NULL
- Field2 (created_at) — DateTime — NOT NULL
- Field (state) — String — NOT NULL
- Field2 (address) — String — NOT NULL
- Field3 (post_code) — String — NOT NULL
- Field (total_price) — Int — NOT NULL
Untitled (Product_Order)
- Key (id) — Long — Primary key — NOT NULL
- Key (product_id) — Long — Foreign key → Untitled.Key — NOT NULL
- Key (order_id) — Long — Foreign key → Untitled.Key — NOT NULL
- Field3 (amount) — Int — NOT NULL