ext_table Table (318)

• 2 minutes to read
 • 2 minutes to read

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

Fields

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

ext_table table relationship diagram

Indexes

Fields Types Description
id PK Clustered, Unique
ext_datasource FK Index
parent_table FK Index
child_table FK Index

Relationships

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.

Replication Flags

  • None

Security Flags

  • No access control via user's Role.