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