CloudSketch AI Logo
FeaturesTemplatesPricingEnterpriseAboutContactLog in
🌙☀️
Log inStart free
Home/Templates/Cybersecurity

🔐 Cybersecurity · Database ERD

Security Asset and Risk Register Schema

Tables for an asset inventory and risk register: assets, owners, vulnerabilities, risks, controls and exceptions.

More Cybersecurity templates

Opening a template is free and never counts toward your daily diagrams. Asking the AI to change it counts as one.

Drawing diagram…

What this diagram shows

  • Every risk links to the assets it affects
  • Controls can mitigate several risks
  • Exceptions have an approver and an expiry

Prompt used

Security risk register database: assets (servers, applications, data stores) have an owner and criticality; vulnerabilities are found on assets; risks describe threats to assets with likelihood and impact; controls mitigate risks through a many-to-many link; exceptions record accepted risks with approver and expiry.

Mermaid code
erDiagram
  OWNER ||--o{ ASSET : owns
  ASSET ||--o{ VULNERABILITY : "found on"
  ASSET ||--o{ RISK_ASSET : "exposed in"
  RISK ||--|{ RISK_ASSET : affects
  RISK ||--o{ RISK_CONTROL : "mitigated by"
  CONTROL ||--o{ RISK_CONTROL : mitigates
  RISK ||--o{ EXCEPTION : "accepted via"
  OWNER {
    int id PK
    string name
    string team
  }
  ASSET {
    int id PK
    int owner_id FK
    string name
    string type
    string criticality
  }
  VULNERABILITY {
    int id PK
    int asset_id FK
    string cve_id
    decimal cvss
    string status
  }
  RISK {
    int id PK
    string title
    int likelihood
    int impact
  }
  RISK_ASSET {
    int risk_id PK, FK
    int asset_id PK, FK
  }
  CONTROL {
    int id PK
    string framework_ref
    string description
  }
  RISK_CONTROL {
    int risk_id PK, FK
    int control_id PK, FK
  }
  EXCEPTION {
    int id PK
    int risk_id FK
    string approver
    date expires_on
  }

Inside this diagram

An entity relationship diagram with 8 tables, 28 columns and 7 relationships.

Tables and their columns

  • OWNER: id (PK), name, team
  • ASSET: id (PK), owner_id (FK), name, type, criticality
  • VULNERABILITY: id (PK), asset_id (FK), cve_id, cvss, status
  • RISK_ASSET: risk_id (PK,FK), asset_id (PK,FK)
  • RISK: id (PK), title, likelihood, impact
  • RISK_CONTROL: risk_id (PK,FK), control_id (PK,FK)
  • CONTROL: id (PK), framework_ref, description
  • EXCEPTION: id (PK), risk_id (FK), approver, expires_on

Relationships

  • OWNER owns ASSET: each OWNER has zero or more ASSET, each ASSET belongs to exactly one OWNER
  • ASSET found on VULNERABILITY: each ASSET has zero or more VULNERABILITY, each VULNERABILITY belongs to exactly one ASSET
  • ASSET exposed in RISK_ASSET: each ASSET has zero or more RISK_ASSET, each RISK_ASSET belongs to exactly one ASSET
  • RISK affects RISK_ASSET: each RISK has one or more RISK_ASSET, each RISK_ASSET belongs to exactly one RISK
  • RISK mitigated by RISK_CONTROL: each RISK has zero or more RISK_CONTROL, each RISK_CONTROL belongs to exactly one RISK
  • CONTROL mitigates RISK_CONTROL: each CONTROL has zero or more RISK_CONTROL, each RISK_CONTROL belongs to exactly one CONTROL
  • RISK accepted via EXCEPTION: each RISK has zero or more EXCEPTION, each EXCEPTION belongs to exactly one RISK

Make your own diagram like this

Describe your own system in plain English and the AI ER diagram generator draws it in seconds, in the same style as this template.

Related templates

C4 ArchitectureProCybersecurity

Zero Trust Architecture

A zero trust access model: every request to an internal app is checked for user identity, device health and policy, whether it comes from the office or home.

FlowchartCybersecurity

Security Incident Response Workflow

A security incident response process based on the NIST lifecycle: detect, triage, contain, eradicate, recover and learn.

Data FlowCybersecurity

SIEM Log Pipeline

How security logs from across an organisation reach the SIEM: collection, parsing, enrichment, detection rules and alerts for the SOC.

SequenceCybersecurity

SAML Single Sign-On Login

How SAML single sign-on works when an employee opens a SaaS app: redirect to the company identity provider, MFA and a signed assertion.

NetworkCybersecurity

DMZ Network Architecture

A classic secure network layout: internet-facing services in a DMZ between two firewalls, with internal systems and databases never exposed directly.

MindmapCybersecurity

Threat Model Mindmap (STRIDE)

A STRIDE threat model for a web application, listing example threats in each category with the main mitigations.