Skip to main content

​
Module Map

The SecurAtlas database is organized into domain-specific modules. Each module owns a set of tables, views, and RPC functions.

Tenants & Partners

12+ tables

Controls

6+ tables

Frameworks

4+ tables

Evidence

8+ tables

Integrations

10+ tables

Policies

5+ tables

Assessments

6+ tables

Billing

5+ tables

Risk

4+ tables

​
Tenants and Partners

The multi-tenancy foundation. MSP partners manage multiple tenants; solo organizations are single-tenant.
TablePurpose
accountsMakerKit base account table
tenantsExtended tenant profile (industry, size, settings)
partnersMSP partner organizations
tenant_membershipsUser-to-tenant role assignments
partner_membershipsUser-to-partner role assignments
partner_tenant_linksWhich partner manages which tenant
profilesUser profiles linked to auth.users
invitationsPending invites to tenants/partners

​
Controls

270+ unified controls mapped across multiple compliance frameworks. 
-- Core tables
unified_controls        -- Master control definitions (270+)
tenant_controls         -- Per-tenant control status and maturity
control_framework_map   -- Maps controls → framework requirements
control_evidence_links  -- Maps controls → evidence items
The v_controls_overview view joins tenant controls with their framework mappings and evidence counts. Use it for dashboard queries instead of manual joins.

​
Frameworks

Six or more compliance frameworks (SOC 2, ISO 27001, NIST CSF, HIPAA, GDPR, CIS Controls).
TablePurpose
compliance_frameworksFramework definitions
framework_requirementsIndividual requirements per framework
control_framework_mapLinks unified_controls to requirements
tenant_framework_selectionsWhich frameworks a tenant has enabled
The v_framework_readiness view computes per-framework compliance percentage for a tenant.

​
Evidence

Evidence items are uploaded manually or auto-collected from integrations. 
tenant_evidence_items       -- Core evidence records
evidence_objects             -- Storage references (files, screenshots)
evidence_validations         -- Review workflow (accepted/rejected)
evidence_certificates        -- Generated compliance certificates
control_evidence_links       -- Links evidence → controls
integration_evidence_items   -- Auto-materialized from integrations

​
Integrations

Provider-agnostic integration engine for pulling data from cloud services.
TablePurpose
integration_providersProvider registry (Azure AD, Google Workspace, AWS)
integration_provider_displayUI metadata (icons, descriptions)
integration_connectionsOAuth connections per tenant
integration_entitiesSynced objects (users, groups, policies)
integration_findingsDetected issues from synced data
integration_sync_jobsJob queue with status tracking
integration_sync_logDetailed sync execution logs
The v_integration_hub view aggregates connection status, entity counts, and finding counts per provider per tenant.

​
Policies

Policy document management with version control and employee acknowledgment tracking. 
tenant_policies             -- Policy documents
tenant_policy_versions      -- Versioned snapshots
tenant_policy_acknowledgments -- Employee sign-offs
policy_templates            -- Starter templates

​
Assessments

Self-assessment questionnaires that can convert into full tenant onboarding.
TablePurpose
assessment_templatesQuestionnaire templates
assessment_template_questionsQuestions within templates
assessmentsIn-progress or completed assessments
assessment_responsesIndividual question answers
assessment_resultsComputed scores and recommendations

​
Billing

Stripe-backed subscription management for tenants and partners. 
billing_customers    -- Stripe customer records
subscriptions        -- Active subscriptions
orders               -- One-time purchases
billing_events       -- Webhook event log (audit trail)
The v_partner_billing view summarizes billing status across all tenants managed by a partner.

​
Risk

Risk scoring and trending over time.
TablePurpose
tenant_risk_snapshotsPoint-in-time risk scores
v_tenant_top_risk_driversView: top factors driving risk
risk_categoriesCategory definitions for breakdown

​
Key Views Summary

ViewPurpose
v_controls_overviewControls + framework mappings + evidence counts
v_framework_readinessPer-framework compliance percentage
v_partner_billingPartner-level billing aggregation
v_integration_hubIntegration status dashboard
v_tenant_top_risk_driversTop risk factors per tenant