gaonnuri_ex_shop

Tables (4)

order_item (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL — PK
  • quantity (Field3) — INT — NOT NULL
  • price (Field4) — INT — NOT NULL
  • product_id (id) — BIGINT — Foreign key → product.id — NOT NULL — FK
  • orders_id (Key2) — BIGINT — Foreign key → orders.id — NOT NULL — FK

orders (Untitled3)

  • id (Key) — BIGINT — Primary key — NOT NULL — PK
  • total_price (Field2)
  • created_at (Field3)
  • user_id (id) — BIGINT — Foreign key → user.id — NOT NULL — FK

product

  • id — BIGINT — Primary key — NOT NULL — PK
  • name — VARCHAR(100) — NOT NULL
  • price (Field) — INT — NOT NULL
  • created_at (Field2) — DATATIME

user

  • id — BIGINT — Primary key — NOT NULL — PK
  • Field (name) — VARCHAR(50) — NOT NULL
  • Key (email) — VARCHAR(100) — NOT NULL — UNIQUE
  • Field (created_at) — DATETIME
  • Field (updated_at) — DATETIME