Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 FINDERNUMBER bigint   Default = ((0))
 ORIGINALCONSTITUENTID uniqueidentifier  

Foreign Key Field Type Null Notes Description
 SEGMENTATIONID uniqueidentifier   MKTSEGMENTATION.ID

Index Name Field(s) Unique Primary Clustered
 IX_MKTSEGMENTATIONMERGEDORIGINALCONSTITUENTS_SEGMENTATIONID SEGMENTATIONID      
 PK_MKTSEGMENTATIONMERGEDORIGINALCONSTITUENTS ID
 UIX_MKTSEGMENTATIONMERGEDORIGINALCONSTITUENTS_FINDERNUMBER FINDERNUMBER    

Entity-Relationship diagram of this table