asset_risk

Column Type PK Required Default
asset_risk_id TEXT Yes Yes
asset_risk_type_id TEXT No Yes
asset_id TEXT No Yes
threat_event_id TEXT No Yes
relevance_id TEXT No No
likelihood_id TEXT No No
impact TEXT No Yes
created_at TIMESTAMPTZ No No CURRENT_TIMESTAMP
created_by TEXT No No 'UNKNOWN'
updated_at TIMESTAMPTZ No No
updated_by TEXT No No
deleted_at TIMESTAMPTZ No No
deleted_by TEXT No No
activity_log TEXT No No

Foreign Keys

Column Name Foreign Key
likelihood_id likelihood_id references probability.code
relevance_id relevance_id references severity.code
threat_event_id threat_event_id references threat_event.threat_event_id
asset_id asset_id references asset.asset_id
asset_risk_type_id asset_risk_type_id references asset_risk_type.asset_risk_type_id

Indexes

Column Name Index Name
asset_risk_id sqlite_autoindex_asset_risk_1

SQL DDL

CREATE TABLE "asset_risk" (
    "asset_risk_id" TEXT PRIMARY KEY NOT NULL,
    "asset_risk_type_id" TEXT NOT NULL,
    "asset_id" TEXT NOT NULL,
    "threat_event_id" TEXT NOT NULL,
    "relevance_id" TEXT,
    "likelihood_id" TEXT,
    "impact" TEXT NOT NULL,
    "created_at" TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP,
    "created_by" TEXT DEFAULT 'UNKNOWN',
    "updated_at" TIMESTAMPTZ,
    "updated_by" TEXT,
    "deleted_at" TIMESTAMPTZ,
    "deleted_by" TEXT,
    "activity_log" TEXT,
    FOREIGN KEY("asset_risk_type_id") REFERENCES "asset_risk_type"("asset_risk_type_id"),
    FOREIGN KEY("asset_id") REFERENCES "asset"("asset_id"),
    FOREIGN KEY("threat_event_id") REFERENCES "threat_event"("threat_event_id"),
    FOREIGN KEY("relevance_id") REFERENCES "severity"("code"),
    FOREIGN KEY("likelihood_id") REFERENCES "probability"("code")
)
;