유레카 쇼핑몰
테이블 (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