Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 STARTDATE datetime Date that the relationship was established or became effective
 ENDDATE datetime Date that the relationship was dissolved or ceased to be effective
 ISSPOUSE bit   Default = 0 Designates the relationship as a spouse record
 ISPRIMARYBUSINESS bit   Default = 0 Designates the relationship as a primary business record
 ISCONTACT bit   Default = 0 Designates the relationship as a contact record
 POSITION nvarchar(100)   Default = '' Store the position value for records marked as contacts
 ISMATCHINGGIFTRELATIONSHIP bit   Default = 0 The organization in the relationship will match the individual's gifts.
 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.
 ISPRIMARYCONTACT bit   Default = 0 Indicates whether the contact is a primary contact
 COMMENTS nvarchar(max)   Default = ''
 ISEMERGENCYCONTACT bit   Default = 0 Indicates this relation is an emergency contact.
 RECEIVESREPORTCARD bit   Default = 0 Indicates this relation receives report cards for the student.
 DESCRIPTION nvarchar(700) (Computed) dbo.UFN_RELATIONSHIP_DESCRIPTION(ID) Provides a translation field for the relationship record

Foreign Key Field Type Null Notes Description
 RELATIONSHIPCONSTITUENTID uniqueidentifier   CONSTITUENT.LOCALID Stores the ID of the relationship constituent
 RECIPROCALCONSTITUENTID uniqueidentifier   CONSTITUENT.LOCALID Stores the ID of the reciprocal relationship constituent
 RELATIONSHIPTYPECODEID uniqueidentifier   RELATIONSHIPTYPECODE.ID Stores the relationship type for the relationship record
 RECIPROCALTYPECODEID uniqueidentifier   RELATIONSHIPTYPECODE.ID Stores the relationship type for the reciprocal relationship record
 CONTACTTYPECODEID uniqueidentifier CONTACTTYPECODE.LOCALID Stores the contact type for records marked as contacts
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 RELATIONSHIPSETID uniqueidentifier RELATIONSHIPSET.ID Stores the category of the job for this relationship

Index Name Field(s) Unique Primary Clustered
 IX_RELATIONSHIP_DATEADDED DATEADDED    
 IX_RELATIONSHIP_DATECHANGED DATECHANGED      
 IX_RELATIONSHIP_RECIPROCALCONSTITUENTID RECIPROCALCONSTITUENTID      
 IX_RELATIONSHIP_RELATIONSHIPCONSTITUENTID RELATIONSHIPCONSTITUENTID      
 IX_RELATIONSHIP_RELATIONSHIPTYPECODEID RELATIONSHIPTYPECODEID      
 PK_RELATIONSHIP ID  
 UIX_RELATIONSHIP_RELATIONSHIPCONSTITUENTID_RECIPROCALCONSTITUENTID_RELATIONSHIPTYPECODEID_RECIPROCALTYPECODEID RELATIONSHIPCONSTITUENTID, RECIPROCALCONSTITUENTID, RELATIONSHIPTYPECODEID, RECIPROCALTYPECODEID    

Trigger Name Description
 TR_RELATIONSHIP_DELETE_BBNCRELATIONSHIPIDMAP
 TR_RELATIONSHIP_INSERT_BBNCRELATIONSHIPIDMAP
 TR_RELATIONSHIP_INSERT
 TR_RELATIONSHIP_UPDATE
 TR_RELATIONSHIP_DELETE
 TR_RELATIONSHIP_AUDIT_UPDATE
 TR_RELATIONSHIP_AUDIT_DELETE
 TR_RELATIONSHIP_AUDIT_ETLDELETEDID

Referenced by Field
 ADDRESS RELATIONSHIPID
 BATCHREVENUE MGRELATIONSHIPID
 BATCHREVENUEENHANCEDMATCHINGGIFTS RELATIONSHIPID
 EMAILADDRESS RELATIONSHIPID
 GRANTOR CONTACTID
 PHONE RELATIONSHIPID
 PLANNEDGIFTRELATIONSHIP RELATIONSHIPID
 RELATIONSHIPBYMARRIAGE MARRIAGERELATIONSHIPID
 RELATIONSHIPBYMARRIAGE RELATIONSHIPID
 REVENUEMATCHINGGIFT RELATIONSHIPID
 SALESORDER CONTACTRELATIONSHIPID

Entity-Relationship diagram of this table