test

Tables (4)

cart

  • cart_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.member_id

cart_item

  • cart_item_id — bigint — Primary key — NOT NULL
  • count — int — NOT NULL
  • cart_id — bigint — Foreign key → cart.cart_id
  • item_id — bigint — Foreign key → item.item_id

item

  • item_id — bigint — Primary key — NOT NULL
  • price — int — NOT NULL
  • stock_number — int — NOT NULL
  • reg_time — datetime(6)
  • update_time — datetime(6)
  • item_nm — varchar(50) — NOT NULL
  • item_sell_status — enum('SELL','SOLD_OUT')
  • item_detail — tinytext — NOT NULL

member

  • member_id — bigint — Primary key — NOT NULL
  • address — varchar(255)
  • email — varchar(255)
  • name — varchar(255)
  • password — varchar(255)
  • role — enum('ADMIN','USER')