FAFPROGRAM

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
NAME	nvarchar(100)		Default = ''
DESCRIPTION	nvarchar(255)		Default = ''
CUSTOMIDENTIFIER	nvarchar(100)		Default = ''
SEQUENCEID	int
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)
LOOKUPID	nvarchar(100) (Computed)	yes	(CASE LEN(CUSTOMIDENTIFIER) WHEN 0 THEN '8-' + CAST(SEQUENCEID AS nvarchar(20)) ELSE CUSTOMIDENTIFIER END)
ISACTIVE	bit		Default = 1

Foreign Keys

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_FAFPROGRAM_DATEADDED	DATEADDED			yes
IX_FAFPROGRAM_DATECHANGED	DATECHANGED
PK_FAFPROGRAM	ID	yes	yes
UC_FAFPROGRAM_LOOKUPID	LOOKUPID	yes
UC_FAFPROGRAM_NAME	NAME	yes

Triggers

Trigger Name	Description
TR_FAFPROGRAM_AUDIT_UPDATE
TR_FAFPROGRAM_AUDIT_DELETE

Referenced by

Referenced by	Field
EVENTEXTENSION	FAFPROGRAMID
FAFEVENTBATCH	EVENTPROGRAMID
FAFNFGCAMPAIGN	CAMPAIGNID
FAFNFGLEVELSUMMARY	CAMPAIGNID
FAFPROGRAMSITE	FAFPROGRAMID