Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 RE7RECORDID int   The old ID value from the PARTICIPANTS table

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   REGISTRANT.ID The new guid-based ID value

Index Name Field(s) Unique Primary Clustered
 PK_RE7MAPPARTICIPANTS ID  
 UIX_RE7MAPPARTICIPANTS_RE7RECORDID RE7RECORDID  

Entity-Relationship diagram of this table