One row per person, with what they can open in each product. Creating someone here records the grant centrally and provisions it into that product. Each product's own admin portal keeps working — this sits above them.
The operator, the asset owners and the clients. Linking a tenant to its CivilSnap workspace and its PermitSnap organisation is what lets a grant be provisioned into those products.
A proposal is a document behind a gate. Upload the HTML here and it goes into private storage — a viewer only ever gets a signed link to it, and only once you have approved them.
Every access change, append only — the database refuses updates and deletes on this table, so what is here is what happened.
The Tier-1 clients every workspace can switch on. These are global — adding one here makes it appear in every customer's Customers screen with no code change. The key is what the library, roles and submissions reference, so it cannot be changed once in use.
Monthly recurring revenue is calculated from these rates. Nothing in the database records what a company actually pays, so this is only as accurate as what you enter. Companies on trial are excluded.