ReferralFunctionalSyndromeClassificationTypes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CareID int 4 null
tblMAIN_REFERRALS.CARE_ID FK_ReferralFunctionalSyndromeClassificationTypes_CareIDR
FunctionalSyndromeClassificationTypeID int 4 null
FunctionalSyndromeClassificationType.ID FK_ReferralFunctionalSyndromeClassificationTypes_FunctionalSyndromeClassificationTypeIDR
DisplayOrder int 4 null
OtherText nvarchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_ReferralFunctionalSyndromeClassificationTypes Primary key Asc/Asc CareID + DisplayOrder

Relationships

Close relationships within degrees of separation