s

Tables (6)

cart_items

  • cart_item_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → members.member_id — NOT NULL
  • product_id — bigint — Foreign key → products.product_id — NOT NULL
  • quantity — int — NOT NULL

categories

  • category_id — bigint — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL — 카테고리명
  • display_order — int — NOT NULL — 표시 순서
  • is_active — tinyint(1) — NOT NULL — 활성 여부
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

members

  • member_id — bigint — Primary key — NOT NULL
  • username — varchar(40) — NOT NULL
  • password_hash — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • phone — varchar(30) — NOT NULL

order_items

  • order_item_id — bigint — Primary key — NOT NULL
  • order_id — bigint — Foreign key → orders.order_id — NOT NULL
  • product_id — bigint — Foreign key → products.product_id — NOT NULL
  • quantity — int — NOT NULL

orders

  • order_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → members.member_id — NOT NULL
  • payment_token — varchar(255)
  • paid_at — datetime — NOT NULL
  • shipping_address — varchar(255) — NOT NULL
  • total_amount — decimal(12,0) — NOT NULL

products

  • product_id — bigint — Primary key — NOT NULL
  • name — varchar(120) — NOT NULL
  • price — decimal(10, 0) — NOT NULL
  • stock_qty — int — NOT NULL
  • category_id — bigint — Foreign key → categories.category_id — 카테고리 ID
  • options — varchar(10)
  • image_file_name — varchar(255)
  • updated_at — timestamp
  • created_at — timestamp