A table is a method way of organizing data organizing that uses the model of vertical columns and horizontal rows. An intersection of a row and a column is called a cell. A table contains a definite number of columns, but can have any number of records. Each row is unambiguously is identified by one or several more unique values , taken by its cells from a specific particular subset of columns. A The subset of columns which uniquely that uniquely identifies a row is called an identifier (ID).
FurthermoreMoreover, a table in the SimpleOne system is also , in essence, a record in the Table (sys_db_table) table.
Table properties
Table properties are used to configure tables and determine their relations with other tables. In terms of data structure, the following properties are important:
- Name – determines a system name of a table used in the business logic. Table names follow specific The table name is set according to the following rules.
- Is extendable – determines whether a child the table can be created from the tableextended with child tables.
- Parent – the property of child tables that determines from which table it a child table inherits its columns and business logic.
- Is VCS enabled – determines whether the table is processed by the version control system.
Relations between tables
The SimpleOne system supports the "one-to-many" and "many-to-many" relations between tables.
...
This relation type is used when it is required to describe relations between two tables where a record in the first table can be related to multiple records in the second table but . But any record in the second table can be related to only one record in the first table. For example, a record in the User (user) table can be related to multiple records in the Incident (itsm_incident) table via the Assigned user field, but . But each Incident can only be assigned to a single one user only. The The "one-to-many" relation is implemented in the system with the use of Reference type columns.
"Many-to-many" relation
...
When building the data structure This type is used when it is sometimes required necessary to describe complex relations between the records of any two tables, where a record . With such a relation, records in one table may be related to a number of records in the other, an vice versa. can be correlated with multiple records in another table. For example, the User (user) and Group (sys_group) tables can contain multiple records of users and groups respectively. A user can be in more than one group and a group can contain multiple users. In this case these two tables must be related using the "many-to-many" relation. In the SimpleOne system these relations are represented as separate tables describing SimpleOne, the "many-to-many" relation is implemented as a separate table, that describes the way the records in two tables are related to each other. These tables are also used in the extended data model as well: they are used to create attribute collections.
Table Classification
This article describes how the tables are classified by according to their purpose purposes and the type of stored data they store.