Domain models

Brand (client company)
  └── CampaignContract (formal agreement)
        └── Campaign (content initiative)
              └── CampaignSubmission (placement/content)

User (creator)
  └── BrandCreatorMembership (roster spot)
        └── CreatorSocial (connected account)
              └── CreatorSocialBrand (brand link)

class Brand < ApplicationRecord
  has_many :campaign_contracts
  has_many :campaigns
  has_many :brand_creator_memberships
  has_many :creators, through: :brand_creator_memberships, source: :user
end

class CampaignContract < ApplicationRecord
  belongs_to :brand
  has_many :campaigns
end

class Campaign < ApplicationRecord
  belongs_to :brand
  belongs_to :campaign_contract, optional: true
  has_many :campaign_submissions
end

pending → active → finished
            ↓
          paused

class User < ApplicationRecord
  has_many :brand_creator_memberships
  has_many :brands, through: :brand_creator_memberships
  has_many :creator_socials
end

class BrandCreatorMembership < ApplicationRecord
  belongs_to :brand
  belongs_to :user, foreign_key: :user_id, primary_key: :auth_user_id
end

# Unique key: [brand_id, user_id]
# A creator can have one membership per brand

class CampaignSubmission < ApplicationRecord
  belongs_to :campaign
  belongs_to :creator_social, optional: true
end

class CreatorSocial < ApplicationRecord
  belongs_to :user, foreign_key: :user_id, primary_key: :auth_user_id
  has_many :creator_social_brands
end

# Both records required for ingestion:
CreatorSocial.create!(user_id: user.auth_user_id, platform: "tt", handle: "example")
CreatorSocialBrand.create!(creator_social: social, brand: brand, user_id: user.auth_user_id)