Vintib

Tables (23)

auction

  • id — BIGINT — Primary key — NOT NULL
  • live_id — BIGINT — Foreign key → live.id — NOT NULL
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • start_price — BIGINT — NOT NULL
  • bid_unit — BIGINT — NOT NULL
  • duration_seconds — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • current_price — BIGINT — NOT NULL
  • top_bidder_id — BIGINT — Foreign key → member.id
  • started_at — TIMESTAMPTZ
  • scheduled_end_at — TIMESTAMPTZ
  • ended_at — TIMESTAMPTZ
  • extension_count — SMALLINT — NOT NULL
  • winner_id — BIGINT — Foreign key → member.id
  • final_price — BIGINT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

bid

  • id — BIGINT — Primary key — NOT NULL
  • auction_id — BIGINT — Foreign key → auction.id — NOT NULL
  • bidder_id — BIGINT — Foreign key → member.id — NOT NULL
  • bid_price — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

brand

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL

business_info

  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • business_number — VARCHAR(20) — NOT NULL
  • certificate_url — VARCHAR(500) — NOT NULL
  • verification_status — VARCHAR(20) — NOT NULL
  • submitted_at — TIMESTAMPTZ — NOT NULL
  • verified_at — TIMESTAMPTZ

category

  • id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → category.id
  • name — VARCHAR(100) — NOT NULL
  • depth — SMALLINT — NOT NULL

chat_message

  • id — BIGINT — Primary key — NOT NULL
  • live_id — BIGINT — Foreign key → live.id — NOT NULL
  • member_id — BIGINT — Foreign key → member.id
  • sender_type — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • is_blocked — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

follow

  • follower_id — BIGINT — Foreign key → member.id — NOT NULL
  • following_id — BIGINT — Foreign key → member.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

live

  • id — BIGINT — Primary key — NOT NULL
  • host_id — BIGINT — Foreign key → member.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • thumbnail_url — VARCHAR(500)
  • status — VARCHAR(20) — NOT NULL
  • scheduled_at — TIMESTAMPTZ
  • started_at — TIMESTAMPTZ
  • ended_at — TIMESTAMPTZ
  • openvidu_room — VARCHAR(100)
  • peak_viewer_count — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

live_product

  • id — BIGINT — Primary key — NOT NULL
  • live_id — BIGINT — Foreign key → live.id — NOT NULL
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • sort_order — SMALLINT — NOT NULL
  • added_at — TIMESTAMPTZ — NOT NULL
  • removed_at — TIMESTAMPTZ

member

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • nickname — VARCHAR(30) — NOT NULL
  • name — VARCHAR(50)
  • phone — VARCHAR(20)
  • member_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • onboarding_done — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

member_body_profile

  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • body_photo_url — VARCHAR(500)
  • height_cm — SMALLINT
  • weight_kg — SMALLINT
  • updated_at — TIMESTAMPTZ — NOT NULL

member_interest_brand

  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • brand_id — BIGINT — Foreign key → brand.id — NOT NULL

member_interest_category

  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • category_id — BIGINT — Foreign key → category.id — NOT NULL

member_social_account

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • provider — VARCHAR(30) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

notification

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • type — VARCHAR(40) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • body — VARCHAR(500)
  • ref_type — VARCHAR(30)
  • ref_id — BIGINT
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

order_shipment

  • order_id — BIGINT — Foreign key → orders.id — NOT NULL
  • recipient_name — VARCHAR(50) — NOT NULL
  • recipient_phone — VARCHAR(20) — NOT NULL
  • zipcode — VARCHAR(10) — NOT NULL
  • address1 — VARCHAR(255) — NOT NULL
  • address2 — VARCHAR(255)
  • courier — VARCHAR(50)
  • tracking_number — VARCHAR(50)
  • shipped_at — TIMESTAMPTZ
  • delivered_at — TIMESTAMPTZ

orders

  • id — BIGINT — Primary key — NOT NULL
  • buyer_id — BIGINT — Foreign key → member.id — NOT NULL
  • seller_id — BIGINT — Foreign key → member.id — NOT NULL
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • auction_id — BIGINT — Foreign key → auction.id
  • order_price — BIGINT — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • auto_confirm_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

point_account

  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • available — BIGINT — NOT NULL
  • bid_held — BIGINT — NOT NULL
  • trade_escrow — BIGINT — NOT NULL
  • settling — BIGINT — NOT NULL
  • withdrawing — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

point_hold

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • auction_id — BIGINT — Foreign key → auction.id — NOT NULL
  • bid_id — BIGINT — Foreign key → bid.id — NOT NULL
  • amount — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • released_at — TIMESTAMPTZ

point_transaction

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • amount — BIGINT — NOT NULL
  • balance_after — BIGINT — NOT NULL
  • ref_type — VARCHAR(30)
  • ref_id — BIGINT
  • created_at — TIMESTAMPTZ — NOT NULL

product

  • id — BIGINT — Primary key — NOT NULL
  • seller_id — BIGINT — Foreign key → member.id — NOT NULL
  • category_id — BIGINT — Foreign key → category.id
  • brand_id — BIGINT — Foreign key → brand.id
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • condition_grade — VARCHAR(20)
  • size_label — VARCHAR(50)
  • sale_type — VARCHAR(20) — NOT NULL
  • sale_status — VARCHAR(30) — NOT NULL
  • price — BIGINT
  • view_count — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

product_image

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • sort_order — SMALLINT — NOT NULL
  • is_primary — BOOLEAN — NOT NULL

wish

  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • product_id — BIGINT — Foreign key → product.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL