Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' Name of the sponsorship project
 DESCRIPTION nvarchar(255)   Default = '' The description of the sponsorship project.
 STARTDATE date Date that the project sponsorship was established or became effective
 ENDDATE date Date that the project sponsorship was dissolved or ceased to be effective
 GOAL money   Default = 0
 SPONSORGOAL int   Default = 0
 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.
 ORGANIZATIONAMOUNT money   Default = 0 The amount of the project goal in organization currency.

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   SPONSORSHIPOPPORTUNITY.ID Primary Key.
 SPROPPPROJECTCATEGORYCODEID uniqueidentifier SPROPPPROJECTCATEGORYCODE.ID The category of the project.
 DESIGNATIONID uniqueidentifier   DESIGNATION.ID A designation for the project
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this project goal.
 ORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert from goal amount to organization amount.

Index Name Field(s) Unique Primary Clustered
 IX_SPONSORSHIPOPPORTUNITYPROJECT_BASECURRENCYID BASECURRENCYID      
 IX_SPONSORSHIPOPPORTUNITYPROJECT_DATEADDED DATEADDED    
 IX_SPONSORSHIPOPPORTUNITYPROJECT_DATECHANGED DATECHANGED      
 IX_SPONSORSHIPOPPORTUNITYPROJECT_DESIGNATIONID DESIGNATIONID      
 IX_SPONSORSHIPOPPORTUNITYPROJECT_ORGANIZATIONEXCHANGERATEID ORGANIZATIONEXCHANGERATEID      
 IX_SPONSORSHIPOPPORTUNITYPROJECT_SPROPPPROJECTCATEGORYCODEID SPROPPPROJECTCATEGORYCODEID      
 PK_SPONSORSHIPOPPORTUNITYPROJECT ID  
 UC_SPONSORSHIPOPPORTUNITYPROJECT_NAME NAME    

Trigger Name Description
 TR_SPONSORSHIPOPPORTUNITYPROJECT_INSERTUPDATE_CURRENCY
 TR_SPONSORSHIPOPPORTUNITYPROJECT_AUDIT_UPDATE
 TR_SPONSORSHIPOPPORTUNITYPROJECT_AUDIT_DELETE

Entity-Relationship diagram of this table