황금단

테이블 (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)