Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the event.
 DESCRIPTION nvarchar(255)   Default = '' The description of the event.
 STARTDATE date   Starting date of the event.
 STARTTIME UDT_HOURMINUTE   Default = '' Starting time of the event.
 ENDDATE date   Ending date of the event.
 ENDTIME UDT_HOURMINUTE   Default = '' Ending time of the event.
 CAPACITY int   Default = 0 The maximum number of registrants allowed for the event.
 ISACTIVE bit   Default = 1
 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.
 SCHEDULEID uniqueidentifier Uniquely identifies the scheduling run
 PUBLICDESCRIPTIONTEXT nvarchar(max)   Default = '' The plain text public description.
 PUBLICDESCRIPTIONHTML nvarchar(max)   Default = '' The HTML public description.
 STARTDATETIMEWITHOFFSET datetimeoffset Event start date and time stored with UTC offset
 ENDDATETIMEWITHOFFSET datetimeoffset Event end date and time stored with UTC offset
 CUSTOMIDENTIFIER nvarchar(100)   Default = '' User-definable custom identifier.
 SEQUENCEID int   Identity column used to increment the default lookupid.
 LOOKUPID nvarchar(100) (Computed) (CASE LEN(CUSTOMIDENTIFIER) WHEN 0 THEN '8-' + CAST(SEQUENCEID AS nvarchar(20)) ELSE CUSTOMIDENTIFIER END) Unique identifer that supports user defined values as well as system generated values.
 HIDEFROMCALENDAR bit   Default = 0 Determines whether or not to hide this item from the event calendar.
 DESIGNATIONSONFEES bit   Default = 0 Determines whether or not event allows designations on fees.
 SUPERCEDESPROGRAMPUBLICDESCRIPTION bit   Default = 0 For program events, determines whether or not to use the event public description in place of the program public description.
 ISPROCESSED bit   Default = 0
 STARTDATETIME datetime (Computed) dateadd(mi, convert(tinyint, substring(STARTTIME, 3, 2)), dateadd(hh, convert(tinyint, substring(STARTTIME, 1, 2)), convert(datetime, STARTDATE)))
 ENDDATETIME datetime (Computed) dateadd(mi, convert(tinyint, substring(ENDTIME, 3, 2)), dateadd(hh, convert(tinyint, substring(ENDTIME, 1, 2)), convert(datetime, ENDDATE)))

Foreign Key Field Type Null Notes Description
 EVENTLOCATIONID uniqueidentifier EVENTLOCATION.ID FK to EVENTLOCATION
 MAINEVENTID uniqueidentifier EVENT.ID Designates the main event for supporting events.
 EVENTLOCATIONCONTACTID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 APPEALID uniqueidentifier APPEAL.LOCALID Designates the appeal linked to a team fundraising event.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 EVENTCATEGORYCODEID uniqueidentifier EVENTCATEGORYCODE.LOCALID Category that an event is linked to.
 QUICKCOMPAREEVENTID uniqueidentifier EVENT.ID FK to EVENT
 PROGRAMID uniqueidentifier PROGRAM.ID FK to PROGRAM
 EVENTLOCATIONROOMID uniqueidentifier EVENTLOCATIONROOM.ID FK to EVENTLOCATIONROOM
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this event.

Index Name Field(s) Unique Primary Clustered
 IX_EVENT_APPEALID APPEALID      
 IX_EVENT_BASECURRENCYID BASECURRENCYID      
 IX_EVENT_DATEADDED DATEADDED    
 IX_EVENT_DATECHANGED DATECHANGED      
 IX_EVENT_ENDDATETIMEWITHOFFSET ENDDATETIMEWITHOFFSET      
 IX_EVENT_ID ID      
 IX_EVENT_MAINEVENTID_EVENTLOCATIONCONTACTID_EVENTLOCATIONID_EVENTCATEGORYCODEID MAINEVENTID, EVENTLOCATIONCONTACTID, EVENTLOCATIONID, EVENTCATEGORYCODEID      
 IX_EVENT_PROGRAMID PROGRAMID      
 IX_EVENT_STARTDATETIMEWITHOFFSET STARTDATETIMEWITHOFFSET      
 PK_EVENT ID  
 UC_EVENT_LOOKUPID LOOKUPID    

Trigger Name Description
 TR_EVENT_AUDIT_UPDATE
 TR_EVENT_AUDIT_DELETE
 TR_EVENT_DELETE_BBNCEVENTIDMAP
 TR_EVENT_INSERT_BBNCEVENTIDMAP
 TR_EVENT_MARKEVENTCONTACTASCONSTITUENT
 TR_EVENT_UPDATE_STARTDATETIMEWITHOFFSET
 TR_EVENT_UPDATE_ENDDATETIMEWITHOFFSET
 TR_EVENT_AUDIT_ETLDELETEDID
 TR_EVENT_INSERT_BASECURRENCYID
 TR_EVENT_UPDATE_DELETELINKEDDESIGNATIONS

Referenced by Field
 BATCHAMPROIMPORT EVENTID
 BATCHEVENTREGISTRANT EVENTID
 BATCHEVENTSPONSORSHIP EVENTID
 BATCHINTERACTION EVENTID
 BATCHMEMBERSHIPDUES EVENTID
 BATCHREVENUEREGISTRANT EVENTID
 BATCHSTEWARDSHIPPLANSTEPUPDATE EVENTID
 COMMENT_TEXT EVENTID
 DAILYSALEITEMEVENTREGISTRATION EVENTID
 DEFAULTATTRIBUTECATEGORIES EVENTID
 DONATIONBATCH EVENTID
 EMAILJOBEXTENSION EVENTID
 EVENTAPPEAL EVENTID
 EVENTATTACHMENT EVENTID
 EVENTATTRIBUTES EVENTID
 EVENTAUCTION ID
 EVENTAUTOMATCHSITE EVENTID
 EVENTBATCH EVENTID
 EVENTCAMPAIGN EVENTID
 EVENTCOORDINATOR EVENTID
 EVENTDESIGNATION EVENTID
 EVENTDONOR EVENTID
 EVENTEMAILTEMPLATE EVENTID
 EVENTEXPENSE EVENTID
 EVENTEXTENSION EVENTID
 EVENTEXTENSION PRIORYEAREVENTID
 EVENTFAFCONFIG EVENTID
 EVENTGLMAPPING ID
 EVENTGOAL EVENTID
 EVENTGROUP EVENTID
 EVENTHIERARCHY ID
 EVENTHOLDLIST EVENTID
 EVENTIMPORT ID
 EVENTINSTRUCTOR EVENTID
 EVENTLABEL EVENTID
 EVENTLODGING EVENTID
 EVENTMANAGEMENTOPTIONS EVENTID
 EVENTMEDIALINK EVENTID
 EVENTNOTE EVENTID
 EVENTPREFERENCEGROUP EVENTID
 EVENTPRICE EVENTID
 EVENTPRICELIST EVENTID
 EVENTRESOURCE EVENTID
 EVENTSALESMETHOD EVENTID
 EVENTSEATING ID
 EVENTSITE EVENTID
 EVENTSPEAKER EVENTID
 EVENTSPONSOR EVENTID
 EVENTSPONSORSHIPTYPE EVENTID
 EVENTSTAFFRESOURCE EVENTID
 EVENTTASK EVENTID
 EVENTTEAMFAFCONFIG EVENTID
 EVENTWIDGET EVENTID
 FAFADDRESSBOOKCUSTOMTYPE EVENTID
 FAFCOMMENTS EVENTID
 FAFCOMMUNICATIONSLOG EVENTID
 FAFDONATION EVENTID
 FAFEVENTADHOCQUERY EVENTID
 FAFEVENTBATCH COPYFROMEVENTID
 FAFEVENTBATCH PREVIOUSYEAREVENTID
 FAFEVENTDONATIONOPTIONSCONFIG EVENTID
 FAFEVENTEMAIL EVENTID
 FAFEVENTEMAILREADY EVENTID
 FAFEVENTFORMTEMPLATE EVENTID
 FAFEVENTINQUIRY EVENTID
 FAFEVENTPAGETEMPLATE EVENTID
 FAFEVENTSOCIALNETWORKPROPERTY EVENTID
 FAFGIFTACKNOWLEDGEMENT EVENTID
 FAFGROUPDIRECTHIERARCHY EVENTID
 FAFGROUPSUMMARYINFORMATION EVENTID
 FAFGROUPSUMMARYINFORMATION_CATEGORIZED EVENTID
 FAFIMAGES EVENTID
 FAFINCENTIVELEVEL EVENTID
 FAFOFFLINEFORMTEMPLATE EVENTID
 FAFORGANIZATIONINDIVIDUALRELATION EVENTID
 FAFPARTICIPANTGALLERYIMAGES EVENTID
 FAFRAISEDTOTAL EVENTID
 FAFRAISEDTOTAL_CATEGORIZED EVENTID
 FAFREGISTRANTBENEFITSUMMARY EVENTID
 FAFREGISTRANTPENDINGSUMMARY EVENTID
 FAFREGISTRANTPREVIOUSSUMMARY EVENTID
 FAFRSSFEED EVENTID
 FAFTOPFUNDRAISERDISPLAYOPTION EVENTID
 GIFTAIDDISQUALIFIEDBYEVENT ID
 INTERACTION EVENTID
 INVITATION EVENTID
 INVITATIONHISTORY EVENTID
 INVITEE EVENTID
 INVITEEHISTORY EVENTID
 ITINERARYITEM EVENTID
 JOBOCCURRENCE EVENTID
 PARTICIPANTEMAILTEMPLATE EVENTID
 PROGRAMEVENTLOCATION EVENTID
 PROGRAMEVENTPRICE EVENTID
 PROSPECTRESEARCHREQUEST EVENTID
 REGISTRANT EVENTID
 REGISTRANTBATCH EVENTID
 REGISTRANTLODGING MAINEVENTID
 REGISTRANTLODGING EVENTID
 REGISTRANTTRAVEL MAINEVENTID
 REGISTRATIONPACKAGE EVENTID
 REGISTRATIONWAIVER EVENTID
 REVENUEOFFLINEDONATION EVENTID
 REVENUESCHEDULE EVENTID
 REVENUESPLITORDER EVENTID
 SALESORDERITEMTICKET EVENTID
 STEWARDSHIPPLANSTEP EVENTID
 STORY EVENTID
 TEAMEXTENSION EVENTID
 TICKET EVENTID
 VIDEO EVENTID

Entity-Relationship diagram of this table (APPEAL-EVENTAUCTION)
Entity-Relationship diagram of this table (EVENTAUTOMATCHSITE-EVENTLABEL)
Entity-Relationship diagram of this table (EVENTLOCATION-EVENTTEAMFAFCONFIG)
Entity-Relationship diagram of this table (EVENTWIDGET-FAFIMAGES)
Entity-Relationship diagram of this table (FAFINCENTIVELEVEL-JOBOCCURRENCE)
Entity-Relationship diagram of this table (PARTICIPANTEMAILTEMPLATE-TICKET)
Entity-Relationship diagram of this table (VIDEO)