SomaticTesting


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 √ null
SomaticTestingColorectal.SomaticTestSetID FK_SomaticTestingColorectal_SomaticTestingR
SomaticTestingHaematology.SomaticTestSetID FK_SomaticTestingHaematology_SomaticTestingR
SomaticTestingLung.SomaticTestSetID FK_SomaticTestingLung_SomaticTestingR
SomaticTestingPaediatric.SomaticTestSetID FK_SomaticTestingPaediatric_SomaticTestingR
SomaticTestsPerformed.SomaticTestSetID FK_SomaticTestsPerformed_SomaticTestingR
CareID int 4 null
tblINITIAL_ASSESSMENT.CARE_ID FK_SomaticTesting_tblINITIAL_ASSESSMENTR
StratifiedTestPerformedID int 4 null
SomaticPerformedStatus.ID FK_SomaticTesting_SomaticPerformedStatusR
DateAnalyzed date 20 √ null
OtherBiomarkerAnalyzed varchar 30 √ null
ReportingOrganisationID int 4 √ null
OrganisationSites.ID FK_SomaticTesting_OrganisationSitesR
IsDeleted bit 1 ((0))

Indexes

Constraint Name Type Sort Column(s)
PK_SomaticTesting Primary key Asc ID

Relationships

Close relationships within degrees of separation