Class DBC.ForeignKeyFields

Fields for ForeignKey, Foreign Key - enables storage of arbitrary extra key information for every table/row in SuperOffice. You may use this table to store your extra information instead of using the dictionary SDK to create your own tables.

Inheritance

Object

DBC.ForeignKeyFields

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

public static class ForeignKeyFields : Object

Fields

ForeigndeviceId

ForeignKey.ForeigndeviceId: Reference to device definition

Declaration

public const string ForeigndeviceId = "foreigndevice_id"

Field Value

Type	Description
String

ForeignkeyId

ForeignKey.ForeignkeyId: Primary key

Declaration

public const string ForeignkeyId = "foreignkey_id"

Field Value

Type	Description
String

RecordId

ForeignKey.RecordId: Record in the referenced table

Declaration

public const string RecordId = "record_id"

Field Value

Type	Description
String

Registered

ForeignKey.Registered: Registered when

Declaration

public const string Registered = "registered"

Field Value

Type	Description
String

RegisteredAssociateId

ForeignKey.RegisteredAssociateId: Registered by whom

Declaration

public const string RegisteredAssociateId = "registered_associate_id"

Field Value

Type	Description
String

Seqno

ForeignKey.Seqno: Sequence number, order of subkeys within one key

Declaration

public const string Seqno = "seqno"

Field Value

Type	Description
String

Subkey

ForeignKey.Subkey: Subkey (optional)

Declaration

public const string Subkey = "subkey"

Field Value

Type	Description
String

Subvalue

ForeignKey.Subvalue: Key value

Declaration

public const string Subvalue = "subvalue"

Field Value

Type	Description
String

TableId

ForeignKey.TableId: SuperOffice table reference

Declaration

public const string TableId = "table_id"

Field Value

Type	Description
String

Updated

ForeignKey.Updated: Last updated when

Declaration

public const string Updated = "updated"

Field Value

Type	Description
String

UpdatedAssociateId

ForeignKey.UpdatedAssociateId: Last updated by whom

Declaration

public const string UpdatedAssociateId = "updated_associate_id"

Field Value

Type	Description
String

UpdatedCount

ForeignKey.UpdatedCount: Number of updates made to this record

Declaration

public const string UpdatedCount = "updatedCount"

Field Value

Type	Description
String