Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
DATEADDED | datetime | Default = getdate() | ||
DATECHANGED | datetime | Default = getdate() | ||
TS | timestamp | |||
TSLONG | bigint (Computed) | CONVERT(bigint, TS) | ||
TYPECODE | tinyint | Default = 0 | ||
TYPE | nvarchar(12) (Computed) | CASE [TYPECODE] WHEN 0 THEN N'Donation' WHEN 1 THEN N'Registration' WHEN 2 THEN N'Sponsor' END |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
REVENUEID | uniqueidentifier | FINANCIALTRANSACTION.ID | ||
INDIVIDUALCONSTITUENTID | uniqueidentifier | CONSTITUENT.LOCALID | ||
ORGANIZATIONCONSTITUENTID | uniqueidentifier | CONSTITUENT.LOCALID | ||
EVENTID | uniqueidentifier | EVENT.ID | ||
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | ||
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_FAFORGANIZATIONINDIVIDUALRELATION_DATEADDED | DATEADDED | |||
IX_FAFORGANIZATIONINDIVIDUALRELATION_DATECHANGED | DATECHANGED | |||
IX_FAFORGANIZATIONINDIVIDUALRELATION_REVENUEID_EVENTID_INDIVIDUALCONSTITUENTID_ORGANIZATIONCONSTITUENTID | REVENUEID, EVENTID, INDIVIDUALCONSTITUENTID, ORGANIZATIONCONSTITUENTID | |||
PK_FAFORGANIZATIONINDIVIDUALRELATION | ID |
Trigger Name | Description |
---|---|
TR_FAFORGANIZATIONINDIVIDUALRELATION_AUDIT_UPDATE | |
TR_FAFORGANIZATIONINDIVIDUALRELATION_AUDIT_DELETE |