marketit

테이블 (4)

상품정보 (product)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (name) — varchar(255)
  • Field (description) — text
  • Field (stock) — int
  • Field (price) — int
  • Field (createdAt) — datetime
  • Field (updatedAt) — datetime
  • Field (deletedAt) — datetime

유저정보 (user)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (name) — varchar(20)
  • Field (admin) — tinyint(1)
  • Field (createdAt) — datetime
  • Field2 (updatedAt) — datetime
  • Field3 (deletedAt) — datetime

주문정보 (order)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (user_id) — int — 외래 키 → 유저정보.Key — NOT NULL
  • Field (permit) — TINYINT(1)
  • Field (createdAt) — datetime
  • Field (updatedAt) — datetime
  • Field (deletedAt) — datetime

주문정보_상품정보 (order_product)

  • Key (order_id) — int — 외래 키 → 주문정보.Key — NOT NULL
  • Key (product_id) — int — 외래 키 → 상품정보.Key — NOT NULL
  • Field (count) — int
  • Field (createdAt) — datetime
  • Field (updatedAt) — datetime
  • Field (deletedAt) — datetime