Database with different data
An application usually consists of several different types of databases with different data. Each type of database is stored in the application in its own data table. The data of a database are stored line by line in the table columns of the respective data table. Any number of records of the same type can be stored in a data table.
Depending on the type of data that is stored in the columns, different data types (eg text, integer, date / time) are available. Via validations, you define rules for the data (for example the rule that a company always needs a name).
Common tabular columns
A special role is played by shared table columns. These table columns are offered across all data tables across the table and defined by the “Common fields of table entities” selection list. If you want to display records of multiple data sources together, only common table columns can be displayed. The common table columns are only virtual and can only be displayed.
Basic data strukturell
Data tables determine the basic data structure of an application. They are usually never displayed directly to users, but are only made accessible via masks or views. Via appropriate interfaces, you can also work with data tables without masks or views, while ensuring the validations as well as working with masks and views.
Data tables from the application can be read in MS Excel, changed and then re-played. The validations are also considered here, i.e. no company is created without a name.