REGISTRATIONINFORMATION

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
NAME	nvarchar(100)		Default = ''
TYPECODE	tinyint		Default = 1
DISPLAYONLINE	bit		Default = 1
ONLINEHTML	nvarchar(max)		Default = ''
RESPONSETYPECODE	tinyint		Default = 0
INACTIVE	bit		Default = 0
ALLPRICETYPES	bit		Default = 1
ASKPERSONPHONE2	bit		Default = 0
ASKPERSONEMAIL	bit		Default = 0
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)
RESPONSETYPE	nvarchar(17) (Computed)	yes	CASE [RESPONSETYPECODE] WHEN 0 THEN N'Text' WHEN 1 THEN N'Multi-line text' WHEN 2 THEN N'Dropdown list' WHEN 3 THEN N'Checkbox (Yes/No)' WHEN 4 THEN N'Name/phone/email' END
TYPE	nvarchar(17) (Computed)	yes	CASE [TYPECODE] WHEN 0 THEN N'Notice/disclaimer' WHEN 1 THEN N'Question' END

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_REGISTRATIONINFORMATION_DATEADDED	DATEADDED			yes
IX_REGISTRATIONINFORMATION_DATECHANGED	DATECHANGED
PK_REGISTRATIONINFORMATION	ID	yes	yes
UC_REGISTRATIONINFORMATION_NAME	NAME	yes

Triggers

Trigger Name	Description
TR_REGISTRATIONINFORMATION_AUDIT_UPDATE
TR_REGISTRATIONINFORMATION_AUDIT_DELETE

Referenced by

Referenced by	Field
PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION	REGISTRATIONINFORMATIONID
REGISTRANTREGISTRATIONINFORMATION	REGISTRATIONINFORMATIONID
REGISTRATIONINFORMATIONOPTION	REGISTRATIONINFORMATIONID
REGISTRATIONINFORMATIONPRICETYPE	REGISTRATIONINFORMATIONID