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