ext_datasource table

ext_datasource Table (317)

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

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
name	An alias for this datasource.	String(64)	Yes
datatype	An enum indicating the type/protocol for this datasource.	String(32)	Yes
database_type	The database type (DbType).	Int	Yes
dbname	The name used for accessing the datasource.	String(32)	Yes
hostname	The hostname for accessing the datasource.	String(255)	Yes
port	The port used for accessing the datasource.	Int	Yes
path	Path to the datasource.	String(255)	Yes
username	The username used for authenticating against the datasource.	String(64)	Yes
password	The poassword used for authenticating against the datasource.	String(64)	Yes
flags	Bitmask of flags.	Int	Yes
next_update	Next time the update process starts	DateTime	Yes
update_interval	Number of hours between each database update	Int	Yes
update_customer_count	Number of customers updated so far	Int	Yes
update_company_count	Number of companies updated so far	Int	Yes
update_lock	Lock to make sure not 2 updates are done simultaniously	DateTime	Yes
last_update	When did the last update occur?.	DateTime	Yes
update_completion_time	The last update completion time in minutes.	Int	Yes
update_error_message	The last error message from datasource update.	Clob	Yes
last_access	The last time this datasource was accessed.	DateTime	Yes
sql_init	The SQL init used for configure the server before fetching external data.	Clob	Yes
unix_socket	Unix socket used with Mysql connections on Linux	String(255)	Yes

Fields	Types	Description

Table	Description
ext_table	This table contains entries used for mapping an external table to an internal table (customer or cust_company) for database integration.