Class DBC.PersonInterestFields

Fields for PersonInterest, Note: If you add or remove rows in this table, you will need to update the interestCount field in the person table accordingly. This field should always reflect the number of interest records a person has, to enable the correct setting of the interest indicator on the tab in the person dialog. Replication note: The combination of person_id and pinterest_idx is unique. If a duplicate is made on a replicated database, the system will replace the record in the target database with the one derived from the source database during replication. Therefore, do not assume that a record in this table will retain its ID indefinitely, even if the person keeps the interest.

Inheritance
Object
DBC.PersonInterestFields
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class PersonInterestFields

Fields

EndDate

PersonInterest.EndDate: End date for this interest - no GUI

Declaration
public const string EndDate = "endDate"
Field Value
Type Description
String

Flags

PersonInterest.Flags: Spare flag field

Declaration
public const string Flags = "flags"
Field Value
Type Description
String

PersonId

PersonInterest.PersonId: Owning person

Declaration
public const string PersonId = "person_id"
Field Value
Type Description
String

PersoninterestId

PersonInterest.PersoninterestId: Primary key

Declaration
public const string PersoninterestId = "personinterest_id"
Field Value
Type Description
String

PinterestIdx

PersonInterest.PinterestIdx: Person interest link

Declaration
public const string PinterestIdx = "pinterest_idx"
Field Value
Type Description
String

Registered

PersonInterest.Registered: Registered when

Declaration
public const string Registered = "registered"
Field Value
Type Description
String

RegisteredAssociateId

PersonInterest.RegisteredAssociateId: Registered by whom

Declaration
public const string RegisteredAssociateId = "registered_associate_id"
Field Value
Type Description
String

StartDate

PersonInterest.StartDate: Start date for this interest - no GUI

Declaration
public const string StartDate = "startDate"
Field Value
Type Description
String

Updated

PersonInterest.Updated: Last updated when

Declaration
public const string Updated = "updated"
Field Value
Type Description
String

UpdatedAssociateId

PersonInterest.UpdatedAssociateId: Last updated by whom

Declaration
public const string UpdatedAssociateId = "updated_associate_id"
Field Value
Type Description
String

UpdatedCount

PersonInterest.UpdatedCount: Number of updates made to this record

Declaration
public const string UpdatedCount = "updatedCount"
Field Value
Type Description
String