dd
Tables (16)
cart_items
- cart_item_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.유저 — NOT NULL
- option_id — BIGINT — Foreign key → product_options.option_id — NOT NULL
- quantity — INT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
categories
- category_id — BIGINT — Primary key — NOT NULL
- parent_id — BIGINT — Foreign key → categories.category_id
- name — VARCHAR(100) — NOT NULL
- depth — SMALLINT — NOT NULL
- sort_order — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
coupons
- coupon_id — BIGINT — Primary key — NOT NULL
- code — VARCHAR(30) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- discount_type — VARCHAR(10) — NOT NULL
- discount_value — NUMERIC(12,0) — NOT NULL
- min_order_amount — NUMERIC(12,0) — NOT NULL
- max_discount — NUMERIC(12,0)
- valid_from — TIMESTAMPTZ — NOT NULL
- valid_until — TIMESTAMPTZ — NOT NULL
- total_quantity — INT
- issued_count — INT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
inventories
- option_id — BIGINT — Foreign key → product_options.option_id — NOT NULL
- quantity — INT — NOT NULL
- reserved_qty — INT — NOT NULL
- safety_stock — INT — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
order_items
- order_item_id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → orders.order_id — NOT NULL
- option_id — BIGINT — Foreign key → product_options.option_id — NOT NULL
- product_name — VARCHAR(200) — NOT NULL
- option_name — VARCHAR(100) — NOT NULL
- unit_price — NUMERIC(12,0) — NOT NULL
- quantity — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
orders
- order_id — BIGINT — Primary key — NOT NULL
- order_no — VARCHAR(30) — NOT NULL
- user_id — BIGINT — Foreign key → users.유저 — NOT NULL
- user_coupon_id — BIGINT — Foreign key → user_coupons.user_coupon_id
- status — VARCHAR(20) — NOT NULL
- total_amount — NUMERIC(12,0) — NOT NULL
- discount_amount — NUMERIC(12,0) — NOT NULL
- shipping_fee — NUMERIC(12,0) — NOT NULL
- pay_amount — NUMERIC(12,0) — NOT NULL
- recipient_name — VARCHAR(50) — NOT NULL
- recipient_phone — VARCHAR(20) — NOT NULL
- zip_code — VARCHAR(10) — NOT NULL
- address1 — VARCHAR(200) — NOT NULL
- address2 — VARCHAR(200)
- delivery_memo — VARCHAR(200)
- ordered_at — TIMESTAMPTZ — NOT NULL
- cancelled_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
payments
- payment_id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → orders.order_id — NOT NULL
- pg_provider — VARCHAR(30) — NOT NULL
- pg_tid — VARCHAR(100)
- method — VARCHAR(20) — NOT NULL
- amount — NUMERIC(12,0) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- approved_at — TIMESTAMPTZ
- cancelled_at — TIMESTAMPTZ
- fail_reason — VARCHAR(500)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
point_histories
- point_history_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.유저 — NOT NULL
- order_id — BIGINT — Foreign key → orders.order_id
- amount — INT — NOT NULL
- reason — VARCHAR(20) — NOT NULL
- balance_after — INT — NOT NULL
- expires_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
product_options
- option_id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → products.product_id — NOT NULL
- sku — VARCHAR(50) — NOT NULL
- option_name — VARCHAR(100) — NOT NULL
- extra_price — NUMERIC(12,0) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
products
- product_id — BIGINT — Primary key — NOT NULL
- seller_id — BIGINT — Foreign key → sellers.seller_id — NOT NULL
- category_id — BIGINT — Foreign key → categories.category_id — NOT NULL
- name — VARCHAR(200) — NOT NULL
- description — TEXT
- list_price — NUMERIC(12,0) — NOT NULL
- sale_price — NUMERIC(12,0) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- thumbnail_url — VARCHAR(500)
- view_count — BIGINT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
reviews
- review_id — BIGINT — Primary key — NOT NULL
- order_item_id — BIGINT — Foreign key → order_items.order_item_id — NOT NULL
- user_id — BIGINT — Foreign key → users.유저 — NOT NULL
- product_id — BIGINT — Foreign key → products.product_id — NOT NULL
- rating — SMALLINT — NOT NULL
- content — TEXT — NOT NULL
- image_urls — TEXT
- is_hidden — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
sellers
- seller_id — BIGINT — Primary key — NOT NULL
- business_no — VARCHAR(20) — NOT NULL
- company_name — VARCHAR(100) — NOT NULL
- ceo_name — VARCHAR(50) — NOT NULL
- contact_email — VARCHAR(255) — NOT NULL
- contact_phone — VARCHAR(20) — NOT NULL
- commission_rate — NUMERIC(5,2) — NOT NULL — 판매 수수료율 (%)
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
shipments
- shipment_id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → orders.order_id — NOT NULL
- carrier — VARCHAR(30) — NOT NULL
- tracking_no — VARCHAR(50)
- status — VARCHAR(20) — NOT NULL
- shipped_at — TIMESTAMPTZ
- delivered_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
user_addresses
- address_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.유저 — NOT NULL
- alias — VARCHAR(50) — NOT NULL
- recipient_name — VARCHAR(50) — NOT NULL
- recipient_phone — VARCHAR(20) — NOT NULL
- zip_code — VARCHAR(10) — NOT NULL
- address1 — VARCHAR(200) — NOT NULL
- address2 — VARCHAR(200)
- is_default — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
user_coupons
- user_coupon_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.유저 — NOT NULL
- coupon_id — BIGINT — Foreign key → coupons.coupon_id — NOT NULL
- issued_at — TIMESTAMPTZ — NOT NULL
- used_at — TIMESTAMPTZ
users
- 유저 (user_id) — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
- birth_date — DATE
- gender — CHAR(1)
- grade — VARCHAR(20) — NOT NULL — 회원 등급 (구매 실적 기반 배치 갱신)
- status — VARCHAR(20) — NOT NULL
- marketing_agree — BOOLEAN — NOT NULL
- last_login_at — TIMESTAMPTZ
- withdrawn_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL