1
Tables (8)
cart
- cart_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id
- reg_time — DATETIME(6)
- update_time — DATETIME(6)
- created_by — VARCHAR(255)
- modified_by — VARCHAR(255)
- member_id (member_id2) — BIGINT — Foreign key → member.member_id — NOT NULL
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
- reg_time — DATETIME(6)
- update_time — DATETIME(6)
- created_by — VARCHAR(255)
- modified_by — VARCHAR(255)
- INDEX — `FK1uobyhgl1wvgt1jpccia8xxs3`
- INDEX — `FKdljf497fwm1f8eb1h8t6n50u9`
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')
- reg_time — DATETIME(6)
- update_time — DATETIME(6)
- created_by — VARCHAR(255)
- modified_by — VARCHAR(255)
member_item
- item_id — BIGINT — Foreign key → member.member_id — NOT NULL
- member_id — BIGINT — Foreign key → item.item_id — NOT NULL
- INDEX — `FKi40mw84oey77jn8rrgug1lpii`
- INDEX — `FKnqigcxnpt4inuo1ogt2c2fcgx`
order_item
- order_item_id — BIGINT — Primary key — NOT NULL
- count — INT — NOT NULL
- order_price — INT — NOT NULL
- item_id — BIGINT — Foreign key → item.item_id
- order_id — BIGINT — Foreign key → orders.order_id
- reg_time — DATETIME(6)
- update_time — DATETIME(6)
- created_by — VARCHAR(255)
- modified_by — VARCHAR(255)
- INDEX — `FKija6hjjiit8dprnmvtvgdp6ru`
- INDEX — `FKt4dc2r9nbvbujrljv3e23iibt`
orders
- order_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id
- order_date — DATETIME(6)
- reg_time — DATETIME(6)
- update_time — DATETIME(6)
- created_by — VARCHAR(255)
- modified_by — VARCHAR(255)
- order_status — ENUM('CANCEL', 'ORDER')
- INDEX — `FKpktxwhj3x9m4gth5ff6bkqgeb`