유레카 쇼핑몰

테이블 (16)

admins

  • admin_id — BIGINT — 기본 키 — NOT NULL
  • login_id — VARCHAR(30) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • role — VARCHAR(15) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

audit_logs

  • log_id — BIGINT — 기본 키 — NOT NULL
  • admin_id — BIGINT — 외래 키 → admins.admin_id — NOT NULL
  • action — VARCHAR(100) — NOT NULL
  • target_type — VARCHAR(50)
  • target_id — BIGINT
  • detail — TEXT
  • created_at — DATETIME — NOT NULL

cart_items

  • cart_item_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • product_id — BIGINT — 외래 키 → products.product_id — NOT NULL
  • quantity — INT — NOT NULL

categories

  • category_id — BIGINT — 기본 키 — NOT NULL
  • category_name — VARCHAR(50) — NOT NULL

coupons

  • coupon_id — BIGINT — 기본 키 — NOT NULL
  • coupon_name — VARCHAR(100) — NOT NULL
  • discount_type — VARCHAR(10) — NOT NULL
  • discount_value — INT — NOT NULL
  • min_order_amount — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • started_at — DATETIME — NOT NULL
  • expired_at — DATETIME — NOT NULL
  • total_quantity — INT

disposal_histories

  • disposal_id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — 외래 키 → products.product_id — NOT NULL
  • admin_id — BIGINT — 외래 키 → admins.admin_id — NOT NULL
  • disposal_qty — INT — NOT NULL
  • reason — VARCHAR(500) — NOT NULL
  • disposed_at — DATETIME — NOT NULL

notifications

  • notification_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id
  • admin_id — BIGINT — 외래 키 → admins.admin_id
  • type — VARCHAR(20) — NOT NULL
  • channel — VARCHAR(10) — NOT NULL
  • content — TEXT — NOT NULL
  • is_sent — TINYINT(1) — NOT NULL
  • sent_at — DATETIME
  • created_at — DATETIME — NOT NULL

order_items

  • order_item_id — BIGINT — 기본 키 — NOT NULL
  • order_id — BIGINT — 외래 키 → orders.order_id — NOT NULL
  • product_id — BIGINT — 외래 키 → products.product_id — NOT NULL
  • option_id — BIGINT
  • product_name — VARCHAR(100) — NOT NULL
  • option_name — VARCHAR(100)
  • unit_price — INT — NOT NULL
  • quantity — INT — NOT NULL
  • subtotal — INT — NOT NULL

orders

  • order_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • total_amount — INT — NOT NULL
  • delivery_fee — INT — NOT NULL
  • discount_amount — INT — NOT NULL
  • point_used — INT — NOT NULL
  • final_amount — INT — NOT NULL
  • point_earned — INT — NOT NULL
  • user_coupon_id — BIGINT — 외래 키 → user_coupons.user_coupon_id
  • payment_method — VARCHAR(15) — NOT NULL
  • status — VARCHAR(25) — NOT NULL
  • recipient — VARCHAR(30) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • delivery_message — VARCHAR(200)
  • ordered_at — DATETIME — NOT NULL

product_images

  • image_id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — 외래 키 → products.product_id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL

products

  • product_id — BIGINT — 기본 키 — NOT NULL
  • category_id — BIGINT — 외래 키 → categories.category_id — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • price — INT — NOT NULL
  • stock — INT — NOT NULL
  • description — TEXT
  • supplier — VARCHAR(100)
  • expiry_date — DATE
  • status — VARCHAR(15) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

qnas

  • qna_id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — 외래 키 → products.product_id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • is_public — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

returns

  • return_id — BIGINT — 기본 키 — NOT NULL
  • order_id — BIGINT — 외래 키 → orders.order_id — NOT NULL
  • reason — VARCHAR(500) — NOT NULL
  • reason_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(15) — NOT NULL
  • refund_amount — INT
  • image_url — VARCHAR(500)
  • requested_at — DATETIME — NOT NULL
  • processed_at — DATETIME

reviews

  • review_id — BIGINT — 기본 키 — NOT NULL
  • order_item_id — BIGINT — 외래 키 → order_items.order_item_id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • product_id — BIGINT — 외래 키 → products.product_id — NOT NULL
  • title — VARCHAR(100)
  • content — TEXT — NOT NULL
  • rating — TINYINT — NOT NULL
  • is_public — TINYINT(1) — NOT NULL
  • image_url — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

user_coupons

  • user_coupon_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • coupon_id — BIGINT — 외래 키 → coupons.coupon_id — NOT NULL
  • is_used — TINYINT(1) — NOT NULL
  • used_at — DATETIME

users

  • user_id — BIGINT — 기본 키 — NOT NULL
  • login_id — VARCHAR(16) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • address — VARCHAR(255)
  • point — INT — NOT NULL
  • marketing_agree — TINYINT(1) — NOT NULL