Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 GENDERCODE tinyint   Default = 0 Indicates the gender this relationship type applies to
 GENDER nvarchar(6) (Computed) CASE [GENDERCODE] WHEN 0 THEN N'Any' WHEN 1 THEN N'Male' WHEN 2 THEN N'Female' END Provides a translation for the 'GENDERCODE' field.
 APPLIESTOINDIVIDUALS bit   Default = 0 Indicates this relationship type applies to individual constituents.
 APPLIESTOORGANIZATIONS bit   Default = 0 Indicates this relationship type applies to organization constituents.
 APPLIESTOGROUPS bit   Default = 0 Indicates this relationship type applies to group constituents.
 RELATESTOINDIVIDUALS bit   Default = 0 Indicates this relationship type relates to individual constituents.
 RELATESTOORGANIZATIONS bit   Default = 0 Indicates this relationship type relates to organization constituents.
 RELATESTOGROUPS bit   Default = 0 Indicates this relationship type relates to group constituents.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 ISPEERRELATIONSHIPTYPE bit   Default = 0 Indicates this relationship type is used for peer relationships.
 APPLIESTOSTUDENTS bit   Default = 0 Indicates this relationship type applies to student constituents.
 RELATESTOSTUDENTS bit   Default = 0 Indicates this relationship type relates to student constituents.

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   RELATIONSHIPTYPECODE.ID Primary Key.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_RELATIONSHIPCONFIGURATION_DATEADDED DATEADDED    
 IX_RELATIONSHIPCONFIGURATION_DATECHANGED DATECHANGED      
 PK_RELATIONSHIPCONFIGURATION ID  

Trigger Name Description
 TR_RELATIONSHIPCONFIGURATION_AUDIT_UPDATE
 TR_RELATIONSHIPCONFIGURATION_AUDIT_DELETE

Entity-Relationship diagram of this table