Risk Assessment Adaptive Logic ERD

erDiagram
    QUESTION_BANK ||--o{ QUESTION : contains
    QUESTION_BANK ||--o{ RISK_CATEGORIES : includes
    QUESTION ||--o{ ASSESSMENT_RESPONSE : answers
    TENANT ||--o{ ASSESSMENT : performs
    ASSESSMENT ||--|{ ASSESSMENT_RESPONSE : captures
    ASSESSMENT ||--|| RISK_PROFILE : generates

    TENANT {
        string id
        string companyName
        string naicsCode
        string subscriptionType
        string ownerUID
    }

    RISK_CATEGORIES {
        json categoryQuestions
        string name
        string description
    }

    QUESTION {
        string id
        string text
        string[] naicsTarget
        string riskCategory
        json dependencyLogic
    }

    RISK_PROFILE {
        string id
        map categoryScores
        int totalScore
        timestamp generatedAt
    }