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