BLOOM

Tables (12)

admins

  • id — UUID — Foreign key
  • first_name — VARCHAR(100)
  • last_name — VARCHAR(100)
  • perm_level — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

amazon_tokens

  • id — UUID
  • brand_id — UUID — Foreign key — NOT NULL
  • selling_partner_id — VARCHAR(255) — NOT NULL
  • refresh_token — TEXT — NOT NULL
  • region — VARCHAR(10)

brand_assignments

  • id — UUID
  • admin_id — UUID — Foreign key — NOT NULL
  • brand_id — UUID — Foreign key — NOT NULL
  • assigned_by — UUID — Foreign key
  • assigned_at — TIMESTAMP — NOT NULL

campaign_applications

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • campaign_id — INT — Foreign key → campaigns.id — NOT NULL
  • status — TEXT — NOT NULL
  • applied_at — TIMESTAMPTZ

campaign_favorites

  • id — UUID
  • user_id — UUID — Foreign key — NOT NULL
  • campaign_id — INT — Foreign key — NOT NULL
  • created_at — TIMESTAMP

campaign_posts

  • id — UUID
  • user_id — UUID — Foreign key — NOT NULL
  • campaign_id — INT — Foreign key — NOT NULL
  • title — VARCHAR(255)
  • status — VARCHAR(50)
  • tiktok_video_url — TEXT
  • posted_at — TIMESTAMP

campaigns

  • id — SERIAL
  • name — TEXT
  • brand_owner_id — UUID — Foreign key → users.id
  • created_by — UUID — Foreign key → users.id
  • asin — TEXT
  • max_applicants — INT
  • created_at — TIMESTAMPTZ

notifications

  • id — UUID
  • user_id — UUID — NOT NULL
  • type — TEXT — NOT NULL
  • is_read — BOOLEAN
  • created_at — TIMESTAMPTZ

products

  • id — UUID
  • brand_id — UUID — Foreign key — NOT NULL
  • sku — VARCHAR(100)
  • asin — VARCHAR(100)
  • name_kor — VARCHAR(255)
  • price — DECIMAL

tiktok_tokens

  • id — UUID
  • user_id — UUID — Foreign key — NOT NULL
  • access_token — TEXT — NOT NULL
  • refresh_token — TEXT — NOT NULL
  • access_token_expires_at — TIMESTAMP — NOT NULL

user_profiles

  • user_id — UUID — Foreign key
  • first_name — VARCHAR(100)
  • last_name — VARCHAR(100)
  • brand_name — VARCHAR(255)
  • agency_name — VARCHAR(255)
  • agency_id — UUID — Foreign key
  • membership_level — VARCHAR(50)
  • tiktok_username — VARCHAR(100)
  • tiktok_followers_count — INT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — UUID
  • email — TEXT — NOT NULL
  • role — TEXT — NOT NULL
  • is_verified — BOOLEAN
  • created_at — TIMESTAMPTZ