shop

Tables (6)

Cart

  • id — BIGINT — Primary key — NOT NULL
  • id (member_id) — BIGINT — Foreign key → Member.id — NOT NULL

CartItem

  • cart_item_id (id) — BIGINT — Primary key — NOT NULL
  • id (cart_id) — BIGINT — Foreign key → Cart.id — NOT NULL
  • id (item_id) — BIGINT — Foreign key → Untitled.id — NOT NULL
  • count — BIGINT

Member

  • id — BIGINT — Primary key — NOT NULL
  • name — varchar
  • email — varchar
  • password — varchar
  • address — varchar
  • role — varchar

Untitled (Item)

  • id — BIGINT — Primary key — NOT NULL
  • name — varchar
  • price — BIGINT
  • stock_number — BIGINT
  • detail — varchar
  • sell_status — varchar

Untitled (Orders)

  • id — BIGINT — Primary key — NOT NULL
  • id (member_id) — BIGINT — Foreign key → Member.id — NOT NULL
  • date — DATETIME
  • status — varchar

Untitled (OrderItem)

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → Untitled.id — NOT NULL
  • id (item_id) — BIGINT — Foreign key → Untitled.id — NOT NULL
  • price — BIGINT
  • count — BIGINT