Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
ATTENDED | bit | Default = 0 | Designates whether or not the registrant attended the event. | |
WILLNOTATTEND | bit | Default = 0 | Designates whether or not the registrant will attend or is only registered to allow guests. | |
EVENTSEATINGNOTE | nvarchar(250) | Default = '' | ||
BENEFITSWAIVED | bit | Default = 0 | Indicates if this registrant has waived benefits. | |
ONLINEREGISTRANT | bit | Default = 0 | Indicates if this registrant registered through NetCommunity. | |
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. | |
ISCANCELLED | bit | Default = 0 | Designates whether or not the registrant has cancelled. | |
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 'evreg-' + CAST(SEQUENCEID AS nvarchar(20)) ELSE CUSTOMIDENTIFIER END) | Unique identifer that supports user defined values as well as system generated values. | |
NOTES | nvarchar(255) | Default = '' | This column contains notes about a registrant. | |
ISWALKIN | bit | Default = 0 | ||
USERMARKEDATTENDANCE | bit | Default = 0 |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
EVENTID | uniqueidentifier | EVENT.ID | FK to EVENT | |
CONSTITUENTID | uniqueidentifier | CONSTITUENT.LOCALID | FK to CONSTITUENT | |
GUESTOFREGISTRANTID | uniqueidentifier | REGISTRANT.ID | Indicates that this registrant is a guest of another registrant. | |
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_REGISTRANT_CONSTITUENTID | CONSTITUENTID | |||
IX_REGISTRANT_DATEADDED | DATEADDED | |||
IX_REGISTRANT_DATECHANGED | DATECHANGED | |||
IX_REGISTRANT_EVENTID | EVENTID | |||
IX_REGISTRANT_GUESTOFREGISTRANTID | GUESTOFREGISTRANTID | |||
IX_REGISTRANT_ID | ID | |||
PK_REGISTRANT | ID | |||
UC_REGISTRANT_LOOKUPID | LOOKUPID |
Referenced by | Field |
---|---|
BATCHREVENUEAPPLICATION | REGISTRANTID |
CREDITITEMEVENTREGISTRATION | REGISTRANTID |
EVENTDONOR | REGISTRANTID |
EVENTGROUPMEMBER | REGISTRANTID |
EVENTREGISTRANTITINERARY | ID |
EVENTREGISTRANTPAYMENT | REGISTRANTID |
EVENTSEATINGSEAT | REGISTRANTID |
FAFADDRESSBOOKCUSTOMTYPE | REGISTRANTID |
FAFCOMMENTS | REGISTRANTID |
FAFEVENTCOMMUNICATIONCHANNELREGISTRANT | REGISTRANTID |
FAFEVENTSOCIALNETWORKPOST | REGISTRANTID |
FAFRSSFEED | REGISTRANTID |
PARTICIPANTWIDGET | REGISTRANTID |
REGISTRANTBENEFIT | REGISTRANTID |
REGISTRANTBENEFITEXTENSION | REGISTRANTID |
REGISTRANTDESIGNATION | REGISTRANTID |
REGISTRANTDONATION | REGISTRANTID |
REGISTRANTEXTENSION | REGISTRANTID |
REGISTRANTPREFERENCE | REGISTRANTID |
REGISTRANTREGISTRATION | REGISTRANTID |
REGISTRANTREGISTRATIONMAP | REGISTRANTID |
REGISTRANTRESTRICTIONOPTION | REGISTRANTID |
REGISTRANTROLE | REGISTRANTID |
REVENUEOFFLINEDONATION | REGISTRANTID |
SALESORDERITEMEVENTREGISTRATION | REGISTRANTID |
SALESORDERITEMTICKETREGISTRANT | REGISTRANTID |
STORY | REGISTRANTID |
Entity-Relationship diagram of this table (REGISTRANTEXTENSION-STORY)