GermlineTesting


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 √ null
GermlineTestsOffered.GermlineTestSet FK_GermlineTestsOffered_GermlineTestingR
CareID int 4 null
tblINITIAL_ASSESSMENT.CARE_ID FK_GermlineTesting_tblINITIAL_ASSESSMENTR
OfferStatus int 4 null
GermlineTestingOfferStatus.ID FK_GermlineTesting_GermlineTestingOfferStatusR
OfferDate date 20 √ null
ReportingLabOrganisation int 4 √ null
OrganisationSites.ID FK_GermlineTesting_OrganisationSitesR
OtherTestOffered varchar 30 √ null
ClinicalGeneticistReferralStatus int 4 √ null
ClinicalGeneticistOfferStatus.ID FK_GermlineTesting_ClinicalGeneticistOfferStatusR
IsDeleted bit 1 ((0))

Indexes

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

Relationships

Close relationships within degrees of separation