Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 HASREGISTRANTSANDOPTIONS bit   Default = 1 Indicates if this event tracks registrants.
 HASSPEAKERS bit   Default = 1 Indicates if this event tracks speakers.
 HASEXPENSES bit   Default = 1 Indicates if this event tracks expenses.
 HASINVITATIONS bit   Default = 1 Indicates if this event tracks invitations.
 HASDOCUMENTATION bit   Default = 1 Indicates if this event tracks documentation.
 HASLODGINGOPTIONS bit   Default = 1 Indicates if this event tracks lodging options.
 HASJOBOCCURRENCES bit   Default = 1 Indicates if this event tracks job occurrences.
 HASAPPEALS bit   Default = 1 Indicates if this event tracks appeals.
 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.
 HASTASKSANDCOORDINATORS bit   Default = 1 Indicates if this event tracks tasks.
 HASCAMPAIGNS bit   Default = 1 Indicates if this level tracks campaigns.

Foreign Key Field Type Null Notes Description
 EVENTMANAGEMENTLEVELINSTANCEID uniqueidentifier EVENTMANAGEMENTLEVELINSTANCE.ID FK to EVENTMANAGEMENTLEVELINSTANCE
 EVENTID uniqueidentifier   EVENT.ID FK to EVENT
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_EVENTMANAGEMENTOPTIONS_DATEADDED DATEADDED    
 IX_EVENTMANAGEMENTOPTIONS_DATECHANGED DATECHANGED      
 PK_EVENTMANAGEMENTOPTIONS ID  
 UIX_EVENTMANAGEMENTOPTIONS_EVENTID EVENTID    

Trigger Name Description
 TR_EVENTMANAGEMENTOPTIONS_AUDIT_UPDATE
 TR_EVENTMANAGEMENTOPTIONS_AUDIT_DELETE

Entity-Relationship diagram of this table