DAG Assessment Entity-Relationship Diagram

erDiagram
    TENANTS {
        string id PK "UID of owner"
        string companyName
        string naicsCode
        string ownerUID
        number userCounter
    }

    USERS {
        string id PK "UID from Auth"
        string tenantId FK
        string email
        string firstName
        string lastName
        string_array roles
    }

    QUESTION_DAGS {
        string id PK "e.g., risk-assessment-v2.1"
        string version
        string description
        object_array nodes
        object_array edges
    }

    RISK_ASSESSMENTS {
        string id PK "Unique assessment ID"
        string tenantId FK
        string userId FK
        string dagVersion FK
        string status
        timestamp expiresAt
    }

    RISK_MODELS {
        string id PK "e.g., default-v1"
        map sizeMultipliers
        map socialImpactMultipliers
    }

    ASSESSMENT_AUDIT_TRAILS {
        string id PK "Unique log ID"
        string assessmentId FK
        string nodeId
        string rule
        map inputs
        string outcome
    }

    TENANTS ||--o{ USERS : "has"
    TENANTS ||--o{ RISK_ASSESSMENTS : "contains"
    USERS ||--o{ RISK_ASSESSMENTS : "takes"

    QUESTION_DAGS ||--o{ RISK_ASSESSMENTS : "is taken as"
    RISK_MODELS ||--o{ RISK_ASSESSMENTS : "provides scoring for"

    RISK_ASSESSMENTS ||--o{ ASSESSMENT_AUDIT_TRAILS : "generates"