Event Table

Column Name Type Allow Nulls Notes
EventID int No Primary Key
EventName varchar(256) No  
EventDesc varchar(256) Yes  
OrganizationID int No  
CampID int No  
EventYear varchar(8) No  
EventStartDate datetime No  
EventEndDate datetime No  
EventRegistrationStartDate datetime Yes  
EventRegistrationEndDate datetime Yes  
ActiveFlag varchar(1) No  
EarlyRegistrationEndDate datetime Yes Currently Not Used
EventRegistrationType varchar(128) No  
AllowUnitAutoAssignment bit No Currently Not Used
EventEarlyRegDiscountType varchar(128) Yes Currently Not Used
EventEarlyRegDiscountAmount varchar(40) Yes Currently Not Used
Attribute1 varchar(128) Yes  
Attribute2 varchar(128) Yes  
Attribute3 varchar(128) Yes  
Attribute4 varchar(128) Yes  
Attribute5 varchar(128) Yes  
Attribute6 varchar(128) Yes  
Attribute7 varchar(128) Yes  
Attribute8 varchar(128) Yes  
Attribute9 varchar(128) Yes  
Attribute10 varchar(128) Yes  
CreationDate datetime No  
LastUpdateDate datetime No  
LastUpdatedBy nvarchar(256) No  
EventDisplayStartDate datetime Yes  
EventDisplayEndDate datetime Yes