Primary Key Field Type
 ID int

Field Field Type Null Notes Description
 BackOfficeID int  
 Name nvarchar(50)  
 IsDefault bit   Default = 0
 BackOfficeIDGUID uniqueidentifier
 DisplayOrder int   Default = 0

Foreign Key Field Type Null Notes Description
 ClientDonationsID int   ClientDonations.ID

Index Name Field(s) Unique Primary Clustered
 IX_DonationDesignations_ClientDonationsID ClientDonationsID      
 PK_DonationDesignations ID

Entity-Relationship diagram of this table