Cases and Forms
classDiagram
Forms <|-- Cases : formId
SpecimenTypes <|-- FormResponses : specimenTypeId
StainTypes <|--FormResponses : stainTypeId
Slides <|--FormResponses : slideId
Cases <|-- CaseSlides : CaseId
Slides <|-- CaseSlides : SlideId
Timepoints <|-- FormResponses : timepointId
Cases <|-- CaseReviews: caseId
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 Forms {
+int id
+nvarchar name
+datetime CreatedAt
+datetime UpdatedAt
+int sponsorGroupId
}
class FormResponses {
+int FormResponseId
+int ReviewFormInstanceId
+nvarchar DataText
+int DataInt
+float DataDecimal
+bit DataBoolean
+datetime DataDate
+datetime DataDateTime
+datetime CreatedAt
+datetime UpdatedAt
+int formFieldId
+int slideId
+nvarchar slideName
+nvarchar DataMappedValueText
+nvarchar spid
+nvarchar block
+int timepointId
+int specimenTypeId
+int stainTypeId
}