ShoppingMall
Tables (16)
cart
- cart_id — BIGINT
- user_id — BIGINT — Foreign key
- guest_id — BIGINT — Foreign key
- created_at — DATETIME
- CHECK — ( (user_id IS NOT NULL AND guest_id IS NULL) — NOT NULL
cart_item
- cart_item_id — BIGINT
- cart_id — BIGINT — Foreign key → cart.cart_id — NOT NULL
- option_item_id — BIGINT — Foreign key → product_option_item.option_item_id — NOT NULL
- quantity — INT — NOT NULL
coupon
- coupon_id — BIGINT
- type — ENUM('FIXED','RATE') — NOT NULL
- discount_value — INT — NOT NULL
- min_order_price — INT — NOT NULL
- expired_at — DATETIME — NOT NULL
guest
- guest_id — BIGINT
- session_key — VARCHAR(64) — NOT NULL
- expired_at — DATETIME — NOT NULL
order_item
- order_item_id — BIGINT
- order_id — BIGINT — Foreign key → orders.order_id — NOT NULL
- option_item_id — BIGINT — Foreign key → product_option_item.option_item_id — NOT NULL
- price — INT — NOT NULL
- quantity — INT — NOT NULL
orders
- order_id — BIGINT
- user_id — BIGINT — Foreign key
- guest_id — BIGINT — Foreign key
- total_price — INT — NOT NULL
- status — ENUM('READY','PAID','CANCELLED','COMPLETED') — NOT NULL
- created_at — DATETIME
- CHECK — ( (user_id IS NOT NULL AND guest_id IS NULL) — NOT NULL
payment
- payment_id — BIGINT
- order_id — BIGINT — NOT NULL
- pay_method — ENUM('CARD','VIRTUAL_ACCOUNT','TRANSFER','EASY_PAY') — NOT NULL
- pg_provider — VARCHAR(50) — NOT NULL
- pg_payment_key — VARCHAR(255) — NOT NULL
- amount — INT — NOT NULL
- status — ENUM('READY','SUCCESS','FAILED','CANCELLED') — NOT NULL
- approved_at — DATETIME
- created_at — DATETIME
payment_log
- payment_log_id — BIGINT
- payment_id — BIGINT — NOT NULL
- event_type — ENUM( 'REQUEST', 'PG_CALLBACK', 'CONFIRM_SUCCESS', 'CONFIRM_FAIL', 'CANCEL_REQUEST', 'CANCEL_SUCCESS', 'CANCEL_FAIL' ) — NOT NULL
- message — TEXT
- raw_data — JSON
- created_at — DATETIME
product
- product_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- base_price — INT — NOT NULL
- status — ENUM('SALE','SOLD_OUT','HIDDEN') — NOT NULL
- seller_id — BIGINT
- created_at — DATETIME
product_option
- option_id — BIGINT
- product_id — BIGINT — Foreign key → product.product_id — NOT NULL
- option_name — VARCHAR(50) — NOT NULL
- option_value — VARCHAR(50) — NOT NULL
product_option_item
- option_item_id — BIGINT
- product_id — BIGINT — Foreign key → product.product_id — NOT NULL
- price — INT — NOT NULL
- stock — INT — NOT NULL
refund
- refund_id — BIGINT
- payment_id — BIGINT — NOT NULL
- amount — INT — NOT NULL
- reason — VARCHAR(255)
- status — ENUM('REQUESTED','COMPLETED','FAILED') — NOT NULL
- created_at — DATETIME
user_coupon
- user_coupon_id — BIGINT
- user_id — BIGINT — Foreign key — NOT NULL
- coupon_id — BIGINT — Foreign key → coupon.coupon_id — NOT NULL
- used_at — DATETIME
users
- user_id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — ENUM('USER','ADMIN') — NOT NULL
- created_at — DATETIME
wishlist
- wishlist_id — BIGINT
- user_id — BIGINT — Foreign key — NOT NULL
- created_at — DATETIME
wishlist_item
- wishlist_item_id — BIGINT
- wishlist_id — BIGINT — Foreign key → wishlist.wishlist_id — NOT NULL
- product_id — BIGINT — Foreign key → product.product_id — NOT NULL