dmb 홈페이지

테이블 (13)

business_profile

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • company_name — VARCHAR(200) — NOT NULL
  • biz_reg_no — VARCHAR(20) — NOT NULL
  • ceo_name — VARCHAR(100)
  • biz_address1 — VARCHAR(255)
  • biz_address2 — VARCHAR(255)
  • biz_license_file_key — VARCHAR(500)
  • approval_status — ENUM — NOT NULL
  • approved_at — DATETIME
  • approved_by — BIGINT
  • reject_reason — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

cart

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

cart_item

  • id — BIGINT
  • cart_id — BIGINT — 외래 키 → cart.id — NOT NULL
  • product_id — BIGINT — 외래 키 → product.id — NOT NULL
  • qty — INT — NOT NULL

category

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • parent_id — BIGINT — 외래 키 → category.id
  • sort_order — INT
  • is_active — TINYINT(1)

email_token

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • purpose — ENUM — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • used_at — DATETIME
  • created_at — DATETIME — NOT NULL

order_item

  • id — BIGINT
  • order_id — BIGINT — 외래 키 → orders.id — NOT NULL
  • product_id — BIGINT — 외래 키 → product.id — NOT NULL
  • qty — INT — NOT NULL
  • unit_price — INT — NOT NULL
  • line_amount — INT — NOT NULL

orders

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • order_no — VARCHAR(50) — NOT NULL
  • status — ENUM — NOT NULL
  • member_type_snapshot — ENUM — NOT NULL
  • total_amount — INT — NOT NULL
  • shipping_fee — INT
  • receiver_name — VARCHAR(100) — NOT NULL
  • receiver_phone — VARCHAR(30) — NOT NULL
  • zipcode — VARCHAR(10) — NOT NULL
  • address1 — VARCHAR(255) — NOT NULL
  • address2 — VARCHAR(255)
  • memo — VARCHAR(200)
  • created_at — DATETIME — NOT NULL
  • paid_at — DATETIME

payment

  • id — BIGINT
  • order_id — BIGINT — 외래 키 → orders.id — NOT NULL
  • pg_provider — VARCHAR(30) — NOT NULL
  • method — VARCHAR(30) — NOT NULL
  • status — ENUM — NOT NULL
  • pg_tid — VARCHAR(100)
  • approved_at — DATETIME
  • raw_response_json — JSON

product

  • id — BIGINT
  • category_id — BIGINT — 외래 키 → category.id — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • summary — VARCHAR(300)
  • description — LONGTEXT
  • is_active — TINYINT(1)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

product_image

  • id — BIGINT
  • product_id — BIGINT — 외래 키 → product.id — NOT NULL
  • image_key — VARCHAR(500) — NOT NULL
  • sort_order — INT
  • is_thumbnail — TINYINT(1)

product_price

  • id — BIGINT
  • product_id — BIGINT — 외래 키 → product.id — NOT NULL
  • member_type — ENUM — NOT NULL
  • price — INT — NOT NULL

social_account

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • provider — ENUM — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • provider_email — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(30)
  • member_type — ENUM — NOT NULL
  • status — ENUM — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL