Implementation Questions

erDiagram
    STATE ||--o{ COUNTY : contains
    COUNTY ||--o{ BROKER_COUNTY : covered_by
    BROKER ||--o{ BROKER_COUNTY : covers
    BROKER ||--o{ PARTNER : employs
    COUNTY ||--o{ LEAD : generates
    LEAD ||--o{ LEAD_ASSIGNMENT : assigned_via
    BROKER ||--o{ LEAD_ASSIGNMENT : receives

    STATE {
        int id PK
        string name
        string abbreviation
    }

    COUNTY {
        int id PK
        string fips UK
        string name
        int state_id FK
        decimal centroid_lat
        decimal centroid_lng
        text area_blurb
        text highlights
        string photo_url
    }

    BROKER {
        int id PK
        string name
        string phone
        string email
        string website
        string logo_url
        string franchise_affiliation
        boolean va_loans
        boolean military_specialist
        string stripe_customer_id
        datetime created_at
    }

    BROKER_COUNTY {
        int id PK
        int broker_id FK
        int county_id FK
        enum tier
        enum status
        string stripe_subscription_id
        date enrollment_date
        date past_due_date
        boolean is_featured
        datetime created_at
    }

    PARTNER {
        int id PK
        int broker_id FK
        string name
        string email
        string phone
        boolean is_lead_recipient
        enum status
        datetime created_at
    }

    LEAD {
        int id PK
        int county_id FK
        string first_name
        string last_name
        string email
        string phone
        string moving_from
        string moving_to
        text message
        string source
        enum status
        datetime created_at
    }

    LEAD_ASSIGNMENT {
        int id PK
        int lead_id FK
        int broker_id FK
        datetime assigned_at
        enum status
        text notes
    }