REGISTRANTREGISTRATIONINFORMATION

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
TEXTVALUE	nvarchar(max)		Default = ''
BOOLEANVALUE	bit		Default = 0
PERSONDETAILTYPECODE	tinyint		Default = 0
PERSONDETAILTYPE	nvarchar(14) (Computed)	yes	CASE [PERSONDETAILTYPECODE] WHEN 0 THEN N'(Not a Person)' WHEN 1 THEN N'First Name' WHEN 2 THEN N'Last Name' WHEN 3 THEN N'Phone' WHEN 4 THEN N'Phone 2' WHEN 5 THEN N'Email' END
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
REGISTRANTID	uniqueidentifier		REGISTRANT.ID
REGISTRATIONINFORMATIONID	uniqueidentifier		REGISTRATIONINFORMATION.ID
REGISTRATIONINFORMATIONOPTIONID	uniqueidentifier	yes	REGISTRATIONINFORMATIONOPTION.ID
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_REGISTRANTREGISTRATIONINFORMATION_DATEADDED	DATEADDED			yes
IX_REGISTRANTREGISTRATIONINFORMATION_DATECHANGED	DATECHANGED
IX_REGISTRANTREGISTRATIONINFORMATION_REGISTRANTID	REGISTRANTID
IX_REGISTRANTREGISTRATIONINFORMATION_REGISTRATIONINFORMATIONID	REGISTRATIONINFORMATIONID
PK_REGISTRANTREGISTRATIONINFORMATION	ID	yes	yes

Triggers

Trigger Name	Description
TR_REGISTRANTREGISTRATIONINFORMATION_AUDIT_UPDATE
TR_REGISTRANTREGISTRATIONINFORMATION_AUDIT_DELETE