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