1.3.1. Data-table

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.

[Screenshot Datentabelle]

*A data table could consist of company as the table columns: name, street, postal code, and city. The columns could consist of the machines: name, serial number and purchase price.

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.

*There can be no view which table columns of data basefrom the data tables represent companies and machines in a common view. However, if there are common table columns in both data tables, such as the location, these common table columns can be displayed in a common view.

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.