Class DBC.FreeTextIndexFields

Fields for FreeTextIndex, This is the index table for the free text search function. Each word in FreeTextWords can have multiple occurrences in this table. Each record in this table points to one occurrence of the word, and points to both the table in which the word occurs (which might be contact or text), and also a pointer to the owner table (which is one of contact, person, project, appointment or sale).

Inheritance

Object

DBC.FreeTextIndexFields

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

public static class FreeTextIndexFields : Object

Fields

ContactId

FreeTextIndex.ContactId: Set for contacts and person records to allow cross-table free-text searches. 0 for non-contact, non-person

Declaration

public const string ContactId = "contact_id"

Field Value

Type	Description
String

FreetextindexId

FreeTextIndex.FreetextindexId: Primary key

Declaration

public const string FreetextindexId = "freetextindex_id"

Field Value

Type	Description
String

FreetextwordsId

FreeTextIndex.FreetextwordsId: Reference to word

Declaration

public const string FreetextwordsId = "freetextwords_id"

Field Value

Type	Description
String

Infile

FreeTextIndex.Infile: Word found in file (0=word found in database)

Declaration

public const string Infile = "infile"

Field Value

Type	Description
String

OwnerrecordId

FreeTextIndex.OwnerrecordId: Logical source record. The contact, project, sale that the source belongs to.

Declaration

public const string OwnerrecordId = "ownerrecord_id"

Field Value

Type	Description
String

OwnertableId

FreeTextIndex.OwnertableId: Logical source table (high-level), like contact or project

Declaration

public const string OwnertableId = "ownertable_id"

Field Value

Type	Description
String

RecordId

FreeTextIndex.RecordId: Source record - the row that contains the word. Might be contact record, or an address or phone

Declaration

public const string RecordId = "record_id"

Field Value

Type	Description
String

TableId

FreeTextIndex.TableId: Source table number - could be main (contact, person, etc) or sub-tables like address, email

Declaration

public const string TableId = "table_id"

Field Value

Type	Description
String