Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
NAME | nvarchar(100) | Default = '' | ||
ALLOWCOMPANIESJOINFROMGROUPPAGE | bit | Default = 0 | ||
ALLOWOTHERSJOINFROMGROUPPAGE | bit | Default = 0 | ||
TOTALREVENUEGOAL | money | Default = 0 | ||
DATEADDED | datetime | Default = getdate() | ||
DATECHANGED | datetime | Default = getdate() | ||
TS | timestamp | |||
TSLONG | bigint (Computed) | CONVERT(bigint, TS) | ||
ALLOWGROUPSCHOOSEHIERARCHYLEVEL | bit | Default = 0 | ||
TOTALDONORSGOAL | int | Default = 0 | ||
PARTICIPANTSRECRECRUITMENTGOAL | int | Default = 0 | ||
PARTICIPANTSRETAINEDGOAL | decimal(9, 1) | Default = 0 | ||
FAFGROUPSRECRUITMENTGOAL | int | Default = 0 | ||
FAFGROUPSRETAINEDGOAL | decimal(9, 1) | Default = 0 | ||
COMMUNICATIONSTOSEND | int | Default = 0 |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
GROUPCONSTITUENTID | uniqueidentifier | CONSTITUENT.LOCALID | ||
CAMPAIGNID | uniqueidentifier | FAFPROGRAM.ID | ||
ORGANIZATIONCONSTITUENTID | uniqueidentifier | CONSTITUENT.LOCALID | ||
NFGTYPECODEID | uniqueidentifier | FAFNFGTYPECODE.ID | ||
CONTACTID | uniqueidentifier | CONSTITUENT.LOCALID | ||
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | ||
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_FAFNFGCAMPAIGN_CAMPAIGNID | CAMPAIGNID | |||
IX_FAFNFGCAMPAIGN_CONTACTID | CONTACTID | |||
IX_FAFNFGCAMPAIGN_DATEADDED | DATEADDED | |||
IX_FAFNFGCAMPAIGN_DATECHANGED | DATECHANGED | |||
IX_FAFNFGCAMPAIGN_GROUPCONSTITUENTID | GROUPCONSTITUENTID | |||
IX_FAFNFGCAMPAIGN_ORGANIZATIONCONSTITUENTID | ORGANIZATIONCONSTITUENTID | |||
PK_FAFNFGCAMPAIGN | ID | |||
UIX_FAFNFGCAMPAIGN_GROUPCONSTITUENTID_CAMPAIGNID | GROUPCONSTITUENTID, CAMPAIGNID |
Trigger Name | Description |
---|---|
TR_FAFNFGCAMPAIGN_AUDIT_UPDATE | |
TR_FAFNFGCAMPAIGN_AUDIT_DELETE |
Referenced by | Field |
---|---|
FAFNFGCAMPAIGNDISPLAYSITE | NFGCAMPAIGNID |
FAFNFGCAMPAIGNLEVEL | NFGCAMPAIGNID |
FAFNFGLEVELSUMMARY | NFGID |