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')