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