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