hard20 pts · first answer countsdata-modellingmulti-tenancy

Invoices pointing at another tenant

A multi-tenant schema has tenant_id on every table. A bug let an invoice in tenant A reference a customer in tenant B. Which model change prevents this?

A.A composite foreign key on (tenant_id, customer_id)B.An index on the invoices.tenant_id columnC.A globally unique customer_id columnD.Tenant checks in the application code only

Discussion 0

Join free to post in the discussion.

Invoices pointing at another tenant

Discussion 0

Related questions