MBGermlineTesting


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
MBGermlineTestOffer.GermlineTestingID FK_MBGermlineTestOffer_MBGermlineTestingR
CareID int 4 null
tblMAIN_REFERRALS.CARE_ID FK_MBGermlineTesting_CareIDR
OfferStatus int 4 √ null
GermlineTestingOfferStatus.ID FK_MBGermlineTesting_OfferStatusR
OfferDate date 20 √ null
ReportingLabOrganisation int 4 √ null
OrganisationSites.ID FK_MBGermlineTesting_ReportingLabOrganisationR
OtherTestOffered varchar 30 √ null
ClinicalGeneticistReferralStatus int 4 √ null
ClinicalGeneticistOfferStatus.ID FK_MBGermlineTesting_ClinicalGeneticistReferralStatusR
ACTION_ID int 4 √ null
ExtId uniqueidentifier 16 (newid())

Indexes

Constraint Name Type Sort Column(s)
PK_MBGermlineTesting Primary key Asc Id
IX_MBGermlineTesting Must be unique Asc ExtId

Relationships

Close relationships within degrees of separation