System Entity Relationship Map

Core data entities owned by each Tenant. Note: a Company can belong to multiple Sectors simultaneously.

Tenant

Sector1 : N

CompanyN : M

User1 : N

Category1 : N

Reporting Period1 : N

Submission1 : N

Estimate1 : N

BAZG Import1 : N

Report1 : N

Notification1 : N

Audit Log1 : N

Relationship note: Companies ↔ Sectors is a many-to-many (N:M) relationship. One company can report in multiple sectors simultaneously, and one sector contains many companies. Submissions, Estimates and BAZG Imports all feed into Reports. Every mutating action writes to the Audit Log.