ext_table table

ext_table Table (318)

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

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
ext_datasource	The reference to the associated datasource.	FK ext_datasource	Yes
parent_table	The reference to the parent table.	FK ext_table	Yes
child_table	The reference to the child table.	FK ext_table	Yes
name	The name for this field	String(64)	Yes
target	Enum indicating the target table (customer or cust_company).	Int	Yes
priority	TODO: depreciated?	Int	Yes
ldap_search_base2	LDAP search base, multiple search bases are seperated by new line	Clob	Yes
ldap_search_filter	LDAP search query	String(255)	Yes
ldap_search_result	Select which data to return from LDAP	String(255)	Yes
sql_query	The SQL query used for fetching the external data.	Clob	Yes
sql_query2	The SQL query used for fetching the external data. Part 2	Clob	Yes
primary_key	The name of the primary key. TODO: depreciated?	String(64)	Yes
sql_limit	Used for LIMIT optimiziation of the search query	Int	Yes

Table	Description
ext_datasource	This table contains external datasources, used for databaseintegration of customers and companies.
ext_field	This table contains entries mapping an external field to an internal field. Used for database integration.
ext_table	This table contains entries used for mapping an external table to an internal table (customer or cust_company) for database integration.