Class ConfigTableInfo

Table 'config': This table contains certain system-wide configuration values.

Inheritance

object

TableInfo

ConfigTableInfo

Implements

ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(params FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(string)

TableInfo.ProtAll

TableInfo.HashCheckFields

TableInfo.TableName

TableInfo.DbName

TableInfo.IsDictionaryTable

TableInfo.All

TableInfo.this[string]

TableInfo.PrimaryKeyField

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

[DatabaseTable("config")]
public class ConfigTableInfo : TableInfo, ICloneable

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

Fields

DictionaryTableName

Conceptual name of table Config in the database dictionary: config

Declaration

public const string DictionaryTableName = "config"

Field Value

Type	Description
string

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

Properties

AdminMail

Field 'admin_mail' in table 'config': Dictionary type String[256], .NET type: string

The email address to the administrator of the system. E.g. ejournal-admin@company.com.

Declaration

public StringFieldInfo AdminMail { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

AttachmentPath

Field 'attachment_path' in table 'config': Dictionary type String[256], .NET type: string

The path to the folder containing the attachments.

Declaration

public StringFieldInfo AttachmentPath { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

Autologout

Field 'autologout' in table 'config': Dictionary type Int, .NET type: int

The number of minutes if idle time before a user is logged ut. A zero value means no autologout.

Declaration

public Int32FieldInfo Autologout { get; }

Property Value

Type	Description
Int32FieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

CgiBin

Field 'cgi_bin' in table 'config': Dictionary type String[256], .NET type: string

The cgi-bin alias used to access the executables through HTTP. E.g. '/bin'

Declaration

public StringFieldInfo CgiBin { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

CgiUrl

Field 'cgi_url' in table 'config': Dictionary type String[256], .NET type: string

The base URL to the system. E.g. 'http://ejournal.company.com'.

Declaration

public StringFieldInfo CgiUrl { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

CgiUrlInternal

Field 'cgi_url_internal' in table 'config': Dictionary type String[256], .NET type: string

The internal base URL to the system. E.g. 'http://ejournal.company.com'.

Declaration

public StringFieldInfo CgiUrlInternal { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

ConfigId

Field 'id' in table 'config': Dictionary type PK, .NET type: int

The primary key (auto-incremented)

Declaration

public Int32FieldInfo ConfigId { get; }

Property Value

Type	Description
Int32FieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

DebugFlags

Field 'debug_flags' in table 'config': Dictionary type Int, .NET type: int

A default bitmask of flags controlling debug logging.

Declaration

public Int32FieldInfo DebugFlags { get; }

Property Value

Type	Description
Int32FieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

DefaultMail

Field 'default_mail' in table 'config': Dictionary type String[256], .NET type: string

The default from address in emails being sent from the system. E.g. support@company.com.

Declaration

public StringFieldInfo DefaultMail { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration

public override SoTable Definition { get; }

Property Value

Type	Description
SoTable

Overrides

TableInfo.Definition

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

DictionaryTableNumber

Table number for table Config in the database dictionary; potentially changes between databases, but always the same over the lifetime of any single database

Declaration

public int DictionaryTableNumber { get; }

Property Value

Type	Description
int

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

FeatureToggle

Field 'feature_toggle' in table 'config': Dictionary type Clob, .NET type: string

Temporary values used for feature toggles

Declaration

public StringFieldInfo FeatureToggle { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

Flags

Field 'flags' in table 'config': Dictionary type Int, .NET type: int

A bitmask of flags controlling various options.

Declaration

public Int32FieldInfo Flags { get; }

Property Value

Type	Description
Int32FieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

GfxUrl

Field 'gfx_url' in table 'config': Dictionary type String[256], .NET type: string

The base URL to the graphics files.

Declaration

public StringFieldInfo GfxUrl { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

InstalledAt

Field 'installed_at' in table 'config': Dictionary type DateTime, .NET type: DateTime

The timestamp of when the system was installed, or last upgraded.

Declaration

public DateTimeFieldInfo InstalledAt { get; }

Property Value

Type	Description
DateTimeFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

InstalledBy

Field 'installed_by' in table 'config': Dictionary type String[256], .NET type: string

Whoever installed the software.

Declaration

public StringFieldInfo InstalledBy { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

Language

Field 'language' in table 'config': Dictionary type String[6], .NET type: string

The systemlanguage. 'no' or 'en'.

Declaration

public StringFieldInfo Language { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

Mailheader

Field 'mailheader' in table 'config': Dictionary type String[256], .NET type: string

The default header used (i.e. line 1) in outbound email.

Declaration

public StringFieldInfo Mailheader { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

MbMaxValue

Field 'mb_max_value' in table 'config': Dictionary type Int, .NET type: int

This is the upper (initial) value for the spam-control algorithm, which makes sure that a single email address does not recieve too many emails.

Declaration

public Int32FieldInfo MbMaxValue { get; }

Property Value

Type	Description
Int32FieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

MbModifier

Field 'mb_modifier' in table 'config': Dictionary type Int, .NET type: int

This is the 'cost' of sending an email, which is subtracted from the mb-value for the given email address. The mb-value is increased with 1 every second.

Declaration

public Int32FieldInfo MbModifier { get; }

Property Value

Type	Description
Int32FieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

MbThreshold

Field 'mb_threshold' in table 'config': Dictionary type Int, .NET type: int

This is the treshold value for the spam-contol algorithm. When the value for a given email address is below this value, emails will be blocked.

Declaration

public Int32FieldInfo MbThreshold { get; }

Property Value

Type	Description
Int32FieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

PanicMail

Field 'panic_mail' in table 'config': Dictionary type String[256], .NET type: string

The email address to where error messages are sent. Normally error@superoffice.com.

Declaration

public StringFieldInfo PanicMail { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration

[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }

Property Value

Type	Description
SoTable

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

Simautologout

Field 'simautologout' in table 'config': Dictionary type Int, .NET type: int

The number of minutes if idle time before a simultaneus user is logged ut. A zero value means no autologout.

Declaration

public Int32FieldInfo Simautologout { get; }

Property Value

Type	Description
Int32FieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

SmtpHost

Field 'smtp_host' in table 'config': Dictionary type String[256], .NET type: string

The hostname or IP-address of the SMTP server used for sending email.

Declaration

public StringFieldInfo SmtpHost { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

SmtpPort

Field 'smtp_port' in table 'config': Dictionary type Int, .NET type: int

The port of the SMTP server used for sending email.

Declaration

public Int32FieldInfo SmtpPort { get; }

Property Value

Type	Description
Int32FieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

Tag

Field 'tag' in table 'config': Dictionary type String[33], .NET type: string

The tag used as ticket id identificator in the subject of emails.

Declaration

public StringFieldInfo Tag { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

TempLicense

Field 'temp_license' in table 'config': Dictionary type String[256], .NET type: string

Temporary license key created for this session.

Declaration

public StringFieldInfo TempLicense { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

TemplatePath

Field 'template_path' in table 'config': Dictionary type String[256], .NET type: string

The path to the templates used for the customer front-end.

Declaration

public StringFieldInfo TemplatePath { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

TextPath

Field 'text_path' in table 'config': Dictionary type String[256], .NET type: string

The path to the text-folder containing the emailBackup, trashbin, etc. subfolders.

Declaration

public StringFieldInfo TextPath { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

UniqueId

Field 'unique_id' in table 'config': Dictionary type String[33], .NET type: string

An ID that should be unique for all eJournal installations.

Declaration

public StringFieldInfo UniqueId { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

Version

Field 'version' in table 'config': Dictionary type String[33], .NET type: string

The version of the installed software.

Declaration

public StringFieldInfo Version { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

Warning

Field 'warning' in table 'config': Dictionary type String[256], .NET type: string

The path + leading filename for the warning logfiles.

Declaration

public StringFieldInfo Warning { get; }

Property Value

Type	Description
StringFieldInfo

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetConfigInfo().

Implements

ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)