lecture
Tables (7)
cart
- cart_id — BIGINT
- member_id — BIGINT
cart_item
- cart_item_id — BIGINT
- cart_id — BIGINT
- item_id — BIGINT
- count — INT
item
- item_id — BIGINT
- itemNm — VARCHAR(50) — NOT NULL
- price — INT — NOT NULL
- stockNumber — INT — NOT NULL
- itemDetail — TEXT — NOT NULL
- itemSellStatus — ENUM('SELL', 'STOP', 'SOLD_OUT') — NOT NULL
item_img
- item_img_id — BIGINT
- imgName — VARCHAR(255)
- oriImgName — VARCHAR(255)
- imgUrl — VARCHAR(255)
- repimgYn — CHAR(1)
- item_id — BIGINT
member
- member_id — BIGINT
- name — VARCHAR(255)
- email — VARCHAR(255)
- password — VARCHAR(255)
- address — VARCHAR(255)
- role — ENUM('ADMIN', 'USER')
order_item
- order_item_id — BIGINT
- item_id — BIGINT
- order_id — BIGINT
- orderPrice — INT
- count — INT
orders
- order_id — BIGINT
- member_id — BIGINT
- orderDate — TIMESTAMP
- orderStatus — ENUM('ORDER', 'CANCEL')