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).
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class FreeTextIndexFields
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 |