COSMIC AI-Risk Dashboard, Diagram Preview

Database Entity Model

erDiagram
    PROJECTS ||--o{ LIFECYCLE_PHASES : has
    PROJECTS ||--o{ RISKS : contains
    PROJECTS ||--o{ INDICATORS : defines
    PROJECTS ||--o{ MEASUREMENT_RECORDS : records
    PROJECTS ||--o{ EXPERIMENTS : tracks
    PROJECTS ||--o{ DEPLOYMENT_GATES : evaluates
    PROJECTS ||--o{ EVIDENCE_ARTIFACTS : stores
    PROJECTS ||--o{ AUDIT_EVENTS : logs
    PROJECTS ||--o{ TRELLO_MAPPINGS : maps
    USERS ||--o{ RISKS : owns
    USERS ||--o{ MITIGATION_ACTIONS : owns
    ROLES ||--o{ USERS : grants
    RISKS ||--o{ RISK_SCORES : has
    RISKS ||--o{ MITIGATION_ACTIONS : mitigated_by
    RISKS ||--o{ EVIDENCE_ARTIFACTS : supported_by
    INDICATORS ||--o{ MEASUREMENT_RECORDS : measured_by
    EVIDENCE_ARTIFACTS ||--o{ MEASUREMENT_RECORDS : supports
    EXPERIMENTS ||--o{ MODEL_METRICS : has
    DEPLOYMENT_GATES ||--o{ GATE_CRITERIA : contains
    DEPLOYMENT_GATES ||--o{ GATE_DECISIONS : results_in
    PROJECTS {
        string id PK
        string name
        string project_type
        string current_lifecycle_phase
        number risk_appetite
        string status
    }
    RISKS {
        string id PK
        string project_id FK
        string owner_user_id FK
        string title
        string dimension
        string domain
        number probability
        number impact
        number detectability
        string status
        string approval_status
    }
    RISK_SCORES {
        string id PK
        string risk_id FK
        number raw_score
        number normalized_score
        number residual_score
        string risk_level
    }
    MITIGATION_ACTIONS {
        string id PK
        string risk_id FK
        string owner_user_id FK
        string status
        number progress_percent
        number effectiveness_percent
    }
    INDICATORS {
        string id PK
        string project_id FK
        string name
        string measurand
        string unit
        string interpretation_rule
    }
    MEASUREMENT_RECORDS {
        string id PK
        string project_id FK
        string indicator_id FK
        string evidence_id FK
        string value_text
        number numeric_value
        string status
    }
    EXPERIMENTS {
        string id PK
        string project_id FK
        string name
        string model_name
        string dataset_version
        boolean selected
        string reproducibility_status
    }
    MODEL_METRICS {
        string id PK
        string experiment_id FK
        string metric_name
        number metric_value
        number threshold_value
        string status
    }
    DEPLOYMENT_GATES {
        string id PK
        string project_id FK
        string status
        string summary
        string evaluated_by_user_id FK
    }
    GATE_CRITERIA {
        string id PK
        string gate_id FK
        string name
        string actual_value
        string expected_rule
        string status
        boolean blocking
    }
    GATE_DECISIONS {
        string id PK
        string gate_id FK
        string decision
        string reason
        string approved_by_user_id FK
    }
    EVIDENCE_ARTIFACTS {
        string id PK
        string project_id FK
        string risk_id FK
        string type
        string title
        string uri
    }
    USERS {
        string id PK
        string display_name
        string email
        string role_id FK
        boolean active
    }
    ROLES {
        string id PK
        string name
        string permissions_json
    }
    AUDIT_EVENTS {
        string id PK
        string project_id FK
        string actor_user_id FK
        string entity_type
        string entity_id
        string action
    }
    TRELLO_MAPPINGS {
        string id PK
        string project_id FK
        string trello_board_id
        string trello_card_id
        string local_entity_type
        string local_entity_id
        string sync_status
    }