Navigation to this function
This eTASK internal table is created with every update and lists all relationships between tables within the data model.
Core data
This group comprises the basic identification and assignment features for foreign key entries. It forms the basis for linking and managing data records across table boundaries.| Property | Description |
| Traffic light | ⚠️ This property will be removed in one of the next releases. Please do not use it anymore. The traffic light column gives a colored indication of the status of the stored data. See the associated notes for further information |
| Note | ⚠️ This property will be removed in one of the next releases. Please do not use it anymore. The note in this column gives you further information on the displayed traffic light color. Follow the instructions to be able to change red and yellow traffic lights in particular. |
| Product Owner | This is the name of the person responsible for this product at eTASK. |
| Menu path | Here you can find the entry in the eTASK menu. |
| Support article link | Display of the link to the support article |
| Sequence for the foreign key | The order serves as a general sorting of the entries in this list, based on the main menu in eTASK. |
| Forms involved | This output combines the start and finish form into a readable and analyzable text. |
| Start form | The name of the form from which the foreign key is created. |
| Info area | ⚠️ This property will be removed in one of the next releases. Please do not use it anymore. The name of the area in the start table in which the characteristic for the foreign key is stored. |
| Sequence area | This specifies the number of the area within the form in which the characteristic for the foreign key is located. |
| Feature | The name of the feature in the start table from which the foreign key originates. |
| Feature Sequence | Specifies the position of the characteristic within the info area. Dyn. characteristics can influence and overwrite this fixed configuration. |
| Target form | Specification of the form to which this foreign key leads. |
| Target form canceled | Here you can see whether the target form to which this feature leads has been discontinued and will be removed from eTASK in the future. In this case, do not use the feature. |
| Target form - application discontinued | Here you can see whether the use of this feature has been discontinued and whether it will be removed from eTASK in the future. In this case, do not use the feature. |
| Feature type | Depending on whether the foreign key is formed via an ID or a GUID value, the characteristic type can be an ENumberField or an ETextField. |
| Application | The name of the application in eTASK to which this foreign key is assigned. |
| System name for the foreign key | The unique technical system name of the target feature in eTASK. |
| Tables involved | Outputs the technical names of the tables between which the foreign key exists. |
| Technical name | Returns the technical name of the foreign key in the database. |
| Form tooltip | The tooltip of the start form from which the foreign key originates is displayed here. |
| Form tooltip length | Specifies how many words the tooltip for the form contains. A quality feature. |
| Feature tooltip | The tooltip of the characteristic from which the foreign key originates is displayed here. |
| Feature Tooltip length | Shows the length of the tooltip for the feature (in number of words). A quality characteristic. |
| Column discontinued | Here you can see whether this feature has been discontinued and will be removed from eTASK in the future. In this case, do not use the feature. |
| Mandatory field? | Specifies whether this foreign key is a mandatory field or may remain empty. |
| "visible" for the foreign key | Specifies whether this foreign key is visible or not displayed in the form. |
| editable? | ⚠️ This property will be removed in one of the next releases. Please do not use it anymore. Specifies whether this foreign key can be edited or is displayed as a "read only" value. |
| NULL values allowed? | Here you can see whether this connection is mandatory or can be left blank. |
| Data type | The data type of the respective characteristic as it is specified in the database. |
| Data type eTASK | The different data types in the database are condensed into fewer and more standardized data types in eTASK. The result can be seen here. |
| Product/Product | Here you can see which eTASK products use this connection. |
| Included in product suite(s) | Here you can see which eTASK suites use this connection. |
| Internal ID (Data ID) | The internal ID, or data ID, is used within the application to uniquely identify the data record. |
Foreign key IDs
This info area collects the UIDs of the foreign keys for the tables involved.| Property | Description |
| UID primary key table | The internal UID of the primary key table. |
| UID table tooltip | The internal UID of the tooltip for the form in the text table. |
| UID column | The internal UID of the column. |
| UID info area | The internal UID of the info area in which this foreign key is arranged |
| UID table label | The internal UID of the label for the form in the text table |
| UID column label | The internal UID of the label for this column in the text table. |
| UID column tooltip | The internal key of the tooltip for this column |
| UID table | Internal UID of the table from which the foreign key is called. |
| Internal cache ID | The ID of the foreign key in the eTASK cache. |