Skip to main content

Table Relationship Diagrams (ERD)

High-Level Overview​

The schema is organized into four major subsystems, each detailed in the diagrams below. This overview shows only the top-level entities and how the subsystems connect.

Instance & Database Hierarchy​

Shows how SQL Server instances, databases, schemas, objects, and columns relate. Includes the cross-module instance registry and asymmetric keys.

Principals & Permissions​

Shows server-level and database-level principals, role memberships, permissions, and their shared lookup tables.

Audit Events​

Shows the star-schema audit event fact table and all its dimension/lookup tables. The Events table is a heap (no PK) with 11 foreign keys.

Sensitive Data Discovery (SDD)​

Shows the SDD subsystem: criteria definitions, scannable resources, match aggregates, individual match hits, subject profile linkage, and scan history.