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 |
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)