Stage 4: FORGE — FirstDate Architecture

// FirstDateApp.swift — role switching via isAdmin
if profile?.isAdmin == true {
    HostTabView()      // Mohamed's experience
} else {
    PublicTabView()     // Women's / audience experience
}

// Models/Application.swift
struct Application: Codable, Identifiable {
    let id: String
    let profileId: String          // FK → fd_profiles
    var status: ApplicationStatus  // pending, reviewing, shortlisted, selected, passed
    var whyMe: String              // Free text: "Why should Mohamed take you on a date?"
    var instagramHandle: String    // Required
    var videoIntroUrl: String?     // Optional hosted video link
    var consentAcknowledged: Bool  // Acknowledged filming consent info
    let episodeId: String?         // Linked when selected for an episode
    var reviewedAt: String?
    let createdAt: String
}

enum ApplicationStatus: String, Codable {
    case pending, reviewing, shortlisted, selected, passed
}

// Models/Episode.swift — unified with Deal
struct Episode: Codable, Identifiable {
    let id: String
    var weekNumber: Int            // 1-10
    var title: String              // "Week 3: Coconut Grove"
    var status: EpisodeStatus      // planning, casting, scheduled, filmed, editing, published

    // Deal fields (restaurant sponsorship)
    var restaurantId: String       // FK → fd_restaurants
    var dealTier: DealTier?        // comp_meal, logo_placement, title_sponsor
    var dealValue: Double?         // Cash value of sponsorship
    var dealContactName: String?
    var dealContactEmail: String?
    var dealNotes: String?
    var pitchedAt: String?
    var confirmedAt: String?
    var invoicedAt: String?
    var paidAt: String?

    // Talent fields
    var applicationId: String?     // FK → fd_applications (selected woman)
    var talentName: String?
    var talentInstagram: String?

    // Production fields
    var scheduledFor: String?
    var timeSlot: String?          // brunch, lunch, dinner
    var filmedAt: String?
    var consentRecordId: String?   // FK → fd_consent_records

    // Content fields
    var tiktokUrl: String?
    var instagramUrl: String?
    var youtubeUrl: String?
    var thumbnailUrl: String?
    var publishedAt: String?

    // Metrics (updated manually or via content platform APIs later)
    var viewCount: Int?
    var likeCount: Int?
    var commentCount: Int?

    let createdAt: String
    var updatedAt: String
}

enum EpisodeStatus: String, Codable, CaseIterable {
    case planning, casting, scheduled, filmed, editing, published
}

enum DealTier: String, Codable {
    case compMeal = "comp_meal"
    case logoPlacement = "logo_placement"
    case titleSponsor = "title_sponsor"
}

// Models/ConsentRecord.swift
struct ConsentRecord: Codable, Identifiable {
    let id: String
    let episodeId: String
    let participantProfileId: String
    var consentType: String        // "filming_and_distribution"
    var signatureImageUrl: String  // Supabase Storage URL
    var signedAt: String
    var deviceInfo: String         // iPhone model + iOS version
    var ipAddress: String?
    let createdAt: String
}

// Models/LedgerEntry.swift
struct LedgerEntry: Codable, Identifiable {
    let id: String
    var type: LedgerType           // income or expense
    var category: LedgerCategory
    var amount: Double
    var description: String
    var episodeId: String?         // Which episode this relates to
    var receiptUrl: String?        // Photo of receipt (Supabase Storage)
    var date: String
    var taxDeductible: Bool
    let createdAt: String
}

enum LedgerType: String, Codable {
    case income, expense
}

enum LedgerCategory: String, Codable, CaseIterable {
    // Income
    case sponsorshipCash = "sponsorship_cash"
    case sponsorshipComp = "sponsorship_comp"
    case affiliateRevenue = "affiliate_revenue"
    case contentMonetization = "content_monetization"
    case brandDeal = "brand_deal"
    // Expense
    case food, transport, wardrobe, production, appInfra = "app_infra", misc
}

// Models/WardrobeItem.swift
struct WardrobeItem: Codable, Identifiable {
    let id: String
    var name: String               // "Navy Slim Chinos"
    var brand: String              // "Zara"
    var category: String           // top, bottom, shoes, accessories, fragrance
    var cost: Double
    var isSponsored: Bool
    var sponsorName: String?
    var photoUrl: String?
    var episodesWorn: [String]     // Episode IDs
    let createdAt: String
}

// Models/Outfit.swift
struct Outfit: Codable, Identifiable {
    let id: String
    var episodeId: String
    var wardrobeItemIds: [String]
    var photoUrl: String?          // Full outfit photo
    var notes: String?
    let createdAt: String
}

// Restaurant — add sponsorship fields
struct Restaurant: Codable, Identifiable {
    // ... existing fields ...
    var sponsorshipTier: DealTier?     // NEW
    var featuredInEpisode: Int?         // NEW — episode week number
    var partnerContactName: String?    // NEW
    var partnerContactEmail: String?   // NEW
    var filmingPermission: Bool?       // NEW
    var lightingNotes: String?         // NEW
    var bestTableDescription: String?  // NEW
}

-- fd_applications
CREATE TABLE fd_applications (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    profile_id UUID REFERENCES fd_profiles(id),
    status TEXT DEFAULT 'pending',
    why_me TEXT NOT NULL,
    instagram_handle TEXT NOT NULL,
    video_intro_url TEXT,
    consent_acknowledged BOOLEAN DEFAULT false,
    episode_id UUID,
    reviewed_at TIMESTAMPTZ,
    created_at TIMESTAMPTZ DEFAULT now()
);

-- fd_episodes (unified deal + episode)
CREATE TABLE fd_episodes (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    week_number INTEGER NOT NULL CHECK (week_number BETWEEN 1 AND 20),
    title TEXT,
    status TEXT DEFAULT 'planning',
    restaurant_id UUID REFERENCES fd_restaurants(id),
    deal_tier TEXT,
    deal_value NUMERIC(10,2),
    deal_contact_name TEXT,
    deal_contact_email TEXT,
    deal_notes TEXT,
    pitched_at TIMESTAMPTZ,
    confirmed_at TIMESTAMPTZ,
    invoiced_at TIMESTAMPTZ,
    paid_at TIMESTAMPTZ,
    application_id UUID REFERENCES fd_applications(id),
    talent_name TEXT,
    talent_instagram TEXT,
    scheduled_for TIMESTAMPTZ,
    time_slot TEXT,
    filmed_at TIMESTAMPTZ,
    consent_record_id UUID,
    tiktok_url TEXT,
    instagram_url TEXT,
    youtube_url TEXT,
    thumbnail_url TEXT,
    published_at TIMESTAMPTZ,
    view_count INTEGER DEFAULT 0,
    like_count INTEGER DEFAULT 0,
    comment_count INTEGER DEFAULT 0,
    created_at TIMESTAMPTZ DEFAULT now(),
    updated_at TIMESTAMPTZ DEFAULT now()
);

-- fd_consent_records
CREATE TABLE fd_consent_records (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    episode_id UUID REFERENCES fd_episodes(id),
    participant_profile_id UUID REFERENCES fd_profiles(id),
    consent_type TEXT DEFAULT 'filming_and_distribution',
    signature_image_url TEXT NOT NULL,
    signed_at TIMESTAMPTZ NOT NULL,
    device_info TEXT,
    ip_address TEXT,
    created_at TIMESTAMPTZ DEFAULT now()
);

-- fd_ledger_entries
CREATE TABLE fd_ledger_entries (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    type TEXT NOT NULL CHECK (type IN ('income', 'expense')),
    category TEXT NOT NULL,
    amount NUMERIC(10,2) NOT NULL,
    description TEXT,
    episode_id UUID REFERENCES fd_episodes(id),
    receipt_url TEXT,
    date DATE NOT NULL,
    tax_deductible BOOLEAN DEFAULT false,
    created_at TIMESTAMPTZ DEFAULT now()
);

-- fd_wardrobe_items
CREATE TABLE fd_wardrobe_items (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    name TEXT NOT NULL,
    brand TEXT,
    category TEXT,
    cost NUMERIC(10,2) DEFAULT 0,
    is_sponsored BOOLEAN DEFAULT false,
    sponsor_name TEXT,
    photo_url TEXT,
    episodes_worn UUID[] DEFAULT '{}',
    created_at TIMESTAMPTZ DEFAULT now()
);

-- fd_outfits
CREATE TABLE fd_outfits (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    episode_id UUID REFERENCES fd_episodes(id),
    wardrobe_item_ids UUID[] NOT NULL,
    photo_url TEXT,
    notes TEXT,
    created_at TIMESTAMPTZ DEFAULT now()
);

-- Add columns to fd_restaurants
ALTER TABLE fd_restaurants ADD COLUMN IF NOT EXISTS sponsorship_tier TEXT;
ALTER TABLE fd_restaurants ADD COLUMN IF NOT EXISTS featured_in_episode INTEGER;
ALTER TABLE fd_restaurants ADD COLUMN IF NOT EXISTS partner_contact_name TEXT;
ALTER TABLE fd_restaurants ADD COLUMN IF NOT EXISTS partner_contact_email TEXT;
ALTER TABLE fd_restaurants ADD COLUMN IF NOT EXISTS filming_permission BOOLEAN;
ALTER TABLE fd_restaurants ADD COLUMN IF NOT EXISTS lighting_notes TEXT;
ALTER TABLE fd_restaurants ADD COLUMN IF NOT EXISTS best_table_description TEXT;

static let fdIvory = Color(hex: "f5f0e8")    // Warm text on dark (replaces pure white)
static let fdChampagne = Color(hex: "e8d5b7") // Luxury accent
static let fdOnyx = Color(hex: "0d0d14")      // Deepest dark