ext_field Table (319)
Some tooltip text!
• 1 minute to read
• 1 minute to read
This table contains entries mapping an external field to an internal field. Used for database integration.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| ext_table | The reference to the associated ext_table | FK ext_table | ● |
| seq_order | The column number for this field. Strictly ascending. | Int | ● |
| name | The name for this field. | String(255) | ● |
| target | The target for this field. E.g. 'customer.name'. | String(64) | ● |
| flags | Bitmap for flags for this entry. | Int | ● |
| datatype | The datatype for this field. TODO: depreciated? | Int | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| ext_table | FK | Index |
Relationships
| 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. |
Replication Flags
- None
Security Flags
- No access control via user's Role.