Class DBC.ExtDatasourceFields

Fields for ExtDatasource, This table contains external datasources, used for databaseintegration of customers and companies.

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

Fields

DatabaseType

ExtDatasource.DatabaseType: The database type (DbType).

Declaration
public const string DatabaseType = "database_type"
Field Value
Type Description
String

Datatype

ExtDatasource.Datatype: An enum indicating the type/protocol for this datasource.

Declaration
public const string Datatype = "datatype"
Field Value
Type Description
String

Dbname

ExtDatasource.Dbname: The name used for accessing the datasource.

Declaration
public const string Dbname = "dbname"
Field Value
Type Description
String

ExtDatasourceId

ExtDatasource.ExtDatasourceId: The primary key (auto-incremented)

Declaration
public const string ExtDatasourceId = "id"
Field Value
Type Description
String

Flags

ExtDatasource.Flags: Bitmask of flags.

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

Hostname

ExtDatasource.Hostname: The hostname for accessing the datasource.

Declaration
public const string Hostname = "hostname"
Field Value
Type Description
String

LastAccess

ExtDatasource.LastAccess: The last time this datasource was accessed.

Declaration
public const string LastAccess = "last_access"
Field Value
Type Description
String

LastUpdate

ExtDatasource.LastUpdate: When did the last update occur?.

Declaration
public const string LastUpdate = "last_update"
Field Value
Type Description
String

Name

ExtDatasource.Name: An alias for this datasource.

Declaration
public const string Name = "name"
Field Value
Type Description
String

NextUpdate

ExtDatasource.NextUpdate: Next time the update process starts

Declaration
public const string NextUpdate = "next_update"
Field Value
Type Description
String

Password

ExtDatasource.Password: The poassword used for authenticating against the datasource.

Declaration
public const string Password = "password"
Field Value
Type Description
String

Path

ExtDatasource.Path: Path to the datasource.

Declaration
public const string Path = "path"
Field Value
Type Description
String

Port

ExtDatasource.Port: The port used for accessing the datasource.

Declaration
public const string Port = "port"
Field Value
Type Description
String

SqlInit

ExtDatasource.SqlInit: The SQL init used for configure the server before fetching external data.

Declaration
public const string SqlInit = "sql_init"
Field Value
Type Description
String

UnixSocket

ExtDatasource.UnixSocket: Unix socket used with Mysql connections on Linux

Declaration
public const string UnixSocket = "unix_socket"
Field Value
Type Description
String

UpdateCompanyCount

ExtDatasource.UpdateCompanyCount: Number of companies updated so far

Declaration
public const string UpdateCompanyCount = "update_company_count"
Field Value
Type Description
String

UpdateCompletionTime

ExtDatasource.UpdateCompletionTime: The last update completion time in minutes.

Declaration
public const string UpdateCompletionTime = "update_completion_time"
Field Value
Type Description
String

UpdateCustomerCount

ExtDatasource.UpdateCustomerCount: Number of customers updated so far

Declaration
public const string UpdateCustomerCount = "update_customer_count"
Field Value
Type Description
String

UpdateErrorMessage

ExtDatasource.UpdateErrorMessage: The last error message from datasource update.

Declaration
public const string UpdateErrorMessage = "update_error_message"
Field Value
Type Description
String

UpdateInterval

ExtDatasource.UpdateInterval: Number of hours between each database update

Declaration
public const string UpdateInterval = "update_interval"
Field Value
Type Description
String

UpdateLock

ExtDatasource.UpdateLock: Lock to make sure not 2 updates are done simultaniously

Declaration
public const string UpdateLock = "update_lock"
Field Value
Type Description
String

Username

ExtDatasource.Username: The username used for authenticating against the datasource.

Declaration
public const string Username = "username"
Field Value
Type Description
String