From Dev.to
Index billing invoices by scope and document identity, not the seat roster
A seat roster is a poor primary key for an invoice archive. In a design scenario, a team adds seats after an annual renewal, then finance asks for the period's documents. Building the expected invoice...