ddmshop

Tables (16)

cart

  • cart_id — BIGINT
  • user_id — BIGINT
  • created_at — TIMESTAMP

cart_item

  • cart_item_id — BIGINT
  • cart_id — BIGINT
  • product_id — BIGINT
  • quantity — INT — NOT NULL
  • created_at — TIMESTAMP

category

  • category_id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • parent_category_id — BIGINT

coupon

  • coupon_id — BIGINT
  • code — VARCHAR(50) — NOT NULL
  • discount_amount — DECIMAL(10, 2)
  • expiry_date — DATE
  • created_at — TIMESTAMP

favorite_product

  • favorite_id — BIGINT
  • product_id — BIGINT
  • created_at — TIMESTAMP

notification

  • notification_id — BIGINT
  • user_id — BIGINT
  • message — TEXT
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

order_item

  • order_item_id — BIGINT
  • order_id — BIGINT
  • product_id — BIGINT
  • quantity — INT — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL

orders

  • order_id — BIGINT
  • user_id — BIGINT
  • total_price — DECIMAL(10, 2) — NOT NULL
  • status — ENUM('주문완료', '배송준비중', '배송중', '배송완료')
  • created_at — TIMESTAMP

product

  • product_id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • price — DECIMAL(10, 2) — NOT NULL
  • image_url — VARCHAR(255)
  • stock — INT
  • category_id — BIGINT
  • created_at — TIMESTAMP

product_option

  • option_id — BIGINT
  • product_id — BIGINT
  • option_name — VARCHAR(255)
  • option_value — VARCHAR(255)
  • stock — INT

review

  • review_id — BIGINT
  • product_id — BIGINT
  • user_id — BIGINT
  • rating — INT
  • content — TEXT
  • created_at — TIMESTAMP

review_reply

  • reply_id — BIGINT
  • review_id — BIGINT
  • user_id — BIGINT
  • content — TEXT
  • created_at — TIMESTAMP

reward_points

  • reward_id — BIGINT
  • user_id — BIGINT
  • points — INT — NOT NULL
  • created_at — TIMESTAMP

shipment

  • shipment_id — BIGINT
  • order_id — BIGINT
  • status — ENUM('배송준비중', '배송중', '배송완료')
  • tracking_number — VARCHAR(255)
  • created_at — TIMESTAMP

user

  • user_id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255)
  • profile_image_url — VARCHAR(255)
  • address — VARCHAR(255)
  • phone_number — VARCHAR(20)
  • created_at — TIMESTAMP

user_coupon

  • user_coupon_id — BIGINT
  • user_id — BIGINT
  • coupon_id — BIGINT
  • used — BOOLEAN
  • created_at — TIMESTAMP