Second code re-evaluation pass. Added API token prefix column to users — allows the auth filter to do a prefix-indexed lookup instead of scanning the full token table. Social ad spend table added. Normalised email column on leads for deduplication across channels.
Small migrations, but each one addresses a real scalability concern. The token prefix approach means auth lookups stay fast even as the user table grows. Normalised email on leads means we never create duplicate lead records from the same email arriving through different channels.