bello
Tables (23)
brands
- id — uuid — Primary key — NOT NULL
- name — character varying(255) — NOT NULL
- slug — character varying(255) — NOT NULL
- created_at — timestamp with time zone — NOT NULL
- name_en — character varying(255)
- origin_country — character varying(10)
categories
- id — uuid — Primary key — NOT NULL
- is_active — boolean — NOT NULL
- sort_order — integer — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
- deleted_at — timestamp(6) with time zone
- emoji — character varying(10) — NOT NULL
- name — character varying(255) — NOT NULL
- name_en — character varying(255)
drop_brands
- brand_id — uuid — Foreign key → brands.id — NOT NULL
- drop_id — uuid — Foreign key → drops.id — NOT NULL
- sort_order — integer — NOT NULL
drop_event_logs
- id — uuid — Primary key — NOT NULL
- drop_id — uuid — Foreign key → drops.id — NOT NULL
- event_type — character varying(50) — NOT NULL
- user_id — uuid — Foreign key → users.id
- occurred_at — timestamp with time zone — NOT NULL
drop_images
- id — uuid — Primary key — NOT NULL
- sort_order — integer — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
- drop_id — uuid — Foreign key → drops.id — NOT NULL
- image_url — text — NOT NULL
drop_links
- id — uuid — Primary key — NOT NULL
- sort_order — integer — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
- sale_end_at — timestamp(6) with time zone
- sale_start_at — timestamp(6) with time zone
- drop_id — uuid — Foreign key → drops.id — NOT NULL
- label — character varying(255) — NOT NULL
- url — text — NOT NULL
- seller_id — uuid — Foreign key → sellers.id
- link_type_id — uuid — Foreign key → link_types.id — NOT NULL
- seller_country — character varying(10)
drop_prices
- id — uuid — Primary key — NOT NULL
- drop_id — uuid — Foreign key → drops.id — NOT NULL
- currency — character varying(10) — NOT NULL
- price — integer — NOT NULL
drop_suggestions
- id — uuid — Primary key — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
- deleted_at — timestamp(6) with time zone
- reviewed_at — timestamp(6) with time zone
- category_id — uuid — Foreign key → categories.id — NOT NULL
- user_id — uuid — Foreign key → users.id — NOT NULL
- brand — character varying(255)
- product_name — character varying(255) — NOT NULL
- status — character varying(255) — NOT NULL
- url — text — NOT NULL
drops
- id — uuid — Primary key — NOT NULL
- is_published — boolean — NOT NULL
- likes_count — integer — NOT NULL
- notifications_count — integer — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
- deleted_at — timestamp(6) with time zone
- release_at — timestamp(6) with time zone
- category_id — uuid — Foreign key → categories.id — NOT NULL
- description — text
- product_name — character varying(255) — NOT NULL
- release_precision — character varying(255) — NOT NULL
- product_name_en — character varying(255)
- origin_country — character varying(10)
link_click_daily_stats
- stat_date — date — Primary key — NOT NULL
- drop_link_id — uuid — Foreign key → drop_links.id — NOT NULL
- click_count — integer — NOT NULL
link_click_logs
- id — uuid — Primary key — NOT NULL
- drop_link_id — uuid — Foreign key → drop_links.id — NOT NULL
- user_id — uuid — Foreign key → users.id
- clicked_at — timestamp with time zone — NOT NULL
link_types
- id — uuid — Primary key — NOT NULL
- name — character varying(50) — NOT NULL
- label — character varying(100) — NOT NULL
- purpose — character varying(20) — NOT NULL
- created_at — timestamp with time zone — NOT NULL
notification_logs
- id — uuid — Primary key — NOT NULL
- user_id — uuid — Foreign key → users.id — NOT NULL
- drop_id — uuid — Foreign key → drops.id
- category_id — uuid — Foreign key → categories.id
- notification_type — character varying(50) — NOT NULL
- sent_at — timestamp with time zone — NOT NULL
seller_categories
- category_id — uuid — Foreign key → categories.id — NOT NULL
- seller_id — uuid — Foreign key → sellers.id — NOT NULL
- created_at — timestamp with time zone — NOT NULL
seller_invitations
- id — uuid — Primary key — NOT NULL
- seller_id — uuid — Foreign key → sellers.id — NOT NULL
- email — character varying(255) — NOT NULL
- role — character varying(50) — NOT NULL
- created_at — timestamp with time zone — NOT NULL
- expires_at — timestamp with time zone — NOT NULL
seller_members
- seller_id — uuid — Foreign key → sellers.id — NOT NULL
- user_id — uuid — Foreign key → users.id — NOT NULL
- role — character varying(50) — NOT NULL
- created_at — timestamp with time zone — NOT NULL
seller_types
- id — uuid — Primary key — NOT NULL
- name — character varying(50) — NOT NULL
- label — character varying(100) — NOT NULL
- created_at — timestamp with time zone — NOT NULL
sellers
- id — uuid — Primary key — NOT NULL
- store_name — character varying(255) — NOT NULL
- commission_rate — numeric(5,2) — NOT NULL
- settlement_bank — character varying(100)
- settlement_account — character varying(100)
- status — character varying(50) — NOT NULL
- created_at — timestamp with time zone — NOT NULL
- deleted_at — timestamp with time zone
- type_id — uuid — Foreign key → seller_types.id — NOT NULL
- profile_image_url — character varying(500)
user_category_subscriptions
- category_id — uuid — Foreign key → categories.id — NOT NULL
- user_id — uuid — Foreign key → users.id — NOT NULL
- notify_new_drop — boolean — NOT NULL
user_drop_likes
- drop_id — uuid — Foreign key → drops.id — NOT NULL
- user_id — uuid — Foreign key → users.id — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
user_drop_notifications
- drop_id — uuid — Foreign key → drops.id — NOT NULL
- user_id — uuid — Foreign key → users.id — NOT NULL
- created_at — timestamp with time zone — NOT NULL
user_fcm_tokens
- id — uuid — Primary key — NOT NULL
- user_id — uuid — Foreign key → users.id — NOT NULL
- device_id — character varying(255) — NOT NULL
- fcm_token — character varying(500) — NOT NULL
- created_at — timestamp with time zone — NOT NULL
users
- id — uuid — Primary key — NOT NULL
- created_at — timestamp(6) with time zone — NOT NULL
- deleted_at — timestamp(6) with time zone
- display_name — character varying(255)
- email — character varying(255) — NOT NULL
- firebase_uid — character varying(255) — NOT NULL
- profile_image_url — text
- is_admin — boolean — NOT NULL
- last_active_at — timestamp with time zone