황금단
테이블 (24)
banners
- banner_id — SERIAL
- image_url — VARCHAR(255) — NOT NULL
- link_url — VARCHAR(255) — NOT NULL
- status — VARCHAR(50)
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
cart
- product_id — SERIAL — 외래 키 → products.product_id — NOT NULL
- user_id — SERIAL — 외래 키 → users.user_id — NOT NULL
- cart_id — SERIAL
- quantity — INTEGER
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
- options — TEXT
category_option_groups
- option_group_id — SERIAL — 외래 키 → option_groups.option_group_id — NOT NULL
- category_option_group_id — SERIAL
- category — TEXT — NOT NULL
comments
- community_id — SERIAL — 외래 키 → community.community_id — NOT NULL
- user_id — SERIAL — 외래 키 → community.user_id — NOT NULL
- comment_id — SERIAL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
community
- community_id — SERIAL — 기본 키 — NOT NULL
- user_id — SERIAL — 외래 키 → users.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- type — VARCHAR(255)
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
- status — VARCHAR(50)
- view_count — INTEGER
- images — TEXT
- map_id — TEXT
- sub_type — VARCHAR(255)
- is_pinned — BOOLEAN
customer_service_requests
- user_id — SERIAL — 외래 키 → users.user_id — NOT NULL
- request_id — SERIAL
- issue — TEXT — NOT NULL
- status — VARCHAR(50)
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
notifications
- user_id — SERIAL — 외래 키 → users.user_id — NOT NULL
- notification_id — SERIAL
- title — VARCHAR(255) — NOT NULL
- message — TEXT — NOT NULL
- type — VARCHAR(50) — NOT NULL
- is_read — BOOLEAN
- created_at — TIMESTAMP(6)
option_groups
- option_group_id — SERIAL — 기본 키 — NOT NULL
- name — VARCHAR(255)
- is_required — BOOLEAN
option_prices
- option_price_id — SERIAL
- option_id — INTEGER
- additional_price — DECIMAL(10,2)
options
- option_group_id (option_group_id2) — SERIAL — 외래 키 → option_groups.option_group_id — NOT NULL
- option_id — SERIAL
- option_group_id — INTEGER
- value — VARCHAR(255) — NOT NULL
- additional_price — DECIMAL(10,0)
order_items
- order_id — SERIAL — 외래 키 → orders.order_id — NOT NULL
- product_id — SERIAL — 외래 키 → products.product_id — NOT NULL
- user_id — SERIAL — 외래 키 → orders.user_id — NOT NULL
- order_item_id — SERIAL
- quantity — INTEGER — NOT NULL
- price — INTEGER — NOT NULL
- created_at — TIMESTAMP(6)
- options — TEXT
- etc — TEXT
orders
- order_id — SERIAL — 기본 키 — NOT NULL
- user_id — SERIAL — 외래 키 → users.user_id — NOT NULL
- total_amount — INTEGER — NOT NULL
- shipping_address — TEXT
- recipient_name — TEXT
- phone_number — TEXT
- message — TEXT
- order_status — VARCHAR(50)
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
- tracking_number — VARCHAR(255)
- delivery_service — VARCHAR(255)
- order_group_date — DATE
- valid_order_id — VARCHAR(64)
payments
- order_id — SERIAL — 외래 키 → orders.order_id — NOT NULL
- user_id (user_id2) — SERIAL — 외래 키 → orders.user_id — NOT NULL
- payment_id — SERIAL
- payment_status — VARCHAR(50)
- payment_method — VARCHAR(50)
- payment_date — TIMESTAMP(6)
- payment_amount — DECIMAL(10,2) — NOT NULL
- transaction_id — VARCHAR(255)
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
product_details
- product_id — SERIAL — 외래 키 → products.product_id — NOT NULL
- detail_id — SERIAL
- dimensions — JSONB — NOT NULL
- options — JSONB — NOT NULL
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
product_inquiries
- product_id — SERIAL — 외래 키 → products.product_id — NOT NULL
- user_id — SERIAL — 외래 키 → users.user_id — NOT NULL
- inquiry_id — SERIAL
- question — TEXT — NOT NULL
- answer — TEXT
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
product_options
- product_id — SERIAL — 외래 키 → products.product_id — NOT NULL
- option_group_id — SERIAL — 외래 키 → option_groups.option_group_id — NOT NULL
- product_option_id — SERIAL
products
- product_id — SERIAL — 기본 키 — NOT NULL
- name — VARCHAR(255)
- price — INTEGER
- images — TEXT
- description — TEXT
- detail_images — TEXT
- category — VARCHAR(255)
- tags — TEXT
- default_etc — TEXT
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
- unique_code — BIGINT
- price_top — INTEGER
- price_bottom — INTEGER
- is_displayed — BOOLEAN
- is_sold_out — BOOLEAN
promotions
- promotion_id — SERIAL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- start_date — TIMESTAMP(6) — NOT NULL
- end_date — TIMESTAMP(6) — NOT NULL
- status — VARCHAR(50)
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
refund_requests
- order_id — SERIAL — 외래 키 → orders.order_id — NOT NULL
- product_id — SERIAL — 외래 키 → products.product_id — NOT NULL
- user_id — SERIAL — 외래 키 → orders.user_id — NOT NULL
- request_id — SERIAL
- reason — TEXT — NOT NULL
- status — VARCHAR(50)
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
reviews
- product_id — SERIAL — 외래 키 → products.product_id — NOT NULL
- user_id — SERIAL — 외래 키 → users.user_id — NOT NULL
- review_id — SERIAL
- rating — INTEGER
- comment — TEXT — EX
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
- image_url — TEXT
- title — TEXT
shipping_info
- order_id — SERIAL — 외래 키 → orders.order_id — NOT NULL
- user_id (user_id2) — SERIAL — 외래 키 → orders.user_id — NOT NULL
- shipping_id — SERIAL
- shipping_address — TEXT — NOT NULL
- tracking_number — VARCHAR(255)
- shipping_date — TIMESTAMP(6)
- delivery_date — TIMESTAMP(6)
- shipping_status — VARCHAR(50)
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
site_settings
- setting_id — SERIAL
- setting_key — VARCHAR(255) — NOT NULL
- setting_value — TEXT — NOT NULL
- created_at — TIMESTAMP(6)
- updated_at — TIMESTAMP(6)
users
- user_id — SERIAL — 기본 키 — NOT NULL
- username — VARCHAR(255) — NOT NULL
- email — VARCHAR(255)
- phone — VARCHAR(20)
- password — VARCHAR(255)
- created_at — TIMESTAMP(6)
- refresh_token — TEXT
- is_admin — BOOLEAN
- providers — TEXT
- social_ids — TEXT
wishlist
- product_id — SERIAL — 외래 키 → products.product_id — NOT NULL
- user_id — SERIAL — 외래 키 → users.user_id — NOT NULL
- wishlist_id — SERIAL
- created_at — TIMESTAMP(6)