Cases

    ---
title: Cases in VIPER
---
classDiagram
    CaseStatusTypes <|-- CaseReviews : caseStatusTypeId
    Cases <|-- CaseReviews : caseId
    ViperUser <|-- CaseReviews : viperUserId
    note for ViperUser "ViperUser defined on Reviewers diagram"
    BCRPrimarySites <|-- Cases : bcrPrimarySiteId
    BCRInstitutionalDXes <|-- Cases : bcrInstitutionalDxId
    BPCPrimarySites <|-- Cases : bpcPrimarySiteId
    BPCInstitutionalDXes <|-- Cases : bpcInstitutionalDxId
    Forms <|-- Cases: formId
    note for Forms "Forms is defined on the Forms diagram"
    Patients <|--Cases : patientId
    SlideDirectories <|-- Cases : slideDirectoryId
    Cases <|-- CaseSlides : CaseId
    Slides <|-- CaseSlides : SlideId
    SpecimenTypes <|-- Slides : specimenTypeId
    StainTypes <|-- Slides : stainTypeId

    class Cases{
        +int CaseId
        +int ProjectId
        +nvarchar comments
        +int SlideDirectoryId
        +datetime CreatedAt
        +datetime UpdatedAt
        +nvarchar PathReportFileName
        +nvarchar name
        +int formId
        +int patientId
        +int bcrInstitutionalDxId
        +int bpcInstitutionalDxId
        +nvarchar institutionalDxOther
        +nvarchar institutionComments
        +int bpcPrimarySiteId
        +int bcrPrimarySiteId
        +nvarchar grade
        +nvarchar stage
        +nvarchar procedure
    }
    class CaseSlides{
        +int CaseId
        +int SlideId
    }
    class Slides{
        +int SlideId
        +int SlideDirectoryId
        +nvarchar FileName
        +datetime CreatedAt
        +datetime UpdatedAt
        +int timepointId
        +int specimenTypeId
        +nvarchar spid
        +nvarchar block
        +int stainTypeId
    }
    class SpecimenTypes {
        +int specimenTypeId
        +nvarchar name
        +nvarchar description
        +datetime createdAt
        +datetime updatedAt
    }
    class StainTypes {
        +int stainTypeId
        +nvarchar name
        +nvarchar alias
        +datetime createdAt
        +datetime updatedAt
    }
    class CaseStatusTypes {
        +int caseStatusTypeId
        +nvarchar name
        +datetime createdAt
        +datetime updatedAt
    }
    note for CaseStatusTypes "No foreign keys"