Page History

All tables in the SimpleOne system may can be classified by according to the type of data processed data and by their purpose.

Classification by purpose

By According to the purpose, the tables can be divided into:

• System tables – support the operation of the SimpleOne platform and its tools. They are supplied by the vendor , and are protected against modification from changes by the end-userusers and system administrators. These tables can be distinguished by the sys_ prefix in their system name.
• Application tables are created by the vendor or business solution developer within an application and implement its business logic. These tables can be distinguished by the application prefix in their system names. For example, the itsm_ prefix is used for all tables related to the ITSM application. It is not recommended to change these tables.
• User tables are used created by users in the process of operation of the SimpleOne systemthe end-users with administrator rights (admin role) and used to perform their business tasks. 

Classification by the type of processed data

By According to the type of processed data, the tables can be divided into:

• Configuration
• Reference
• Transactional
• Journal

Configuration tables

Configuration The configuration tables contain records with the information on the current configuration on of a SimpleOne platform instance and are used as the primary source of input parameters, determining the operation and functionality of the platform itself and developed applications developed on its base. For example, the Tables Table (sys_db_table) table contains records with configuration information on all tables of an instance, including itself, as well as on the virtual root table for all tables.

These tables are normally versioned, i.e. they are always processed by the version control system.

The configuration tables can be further subdivided into the following subclasses:

• System configuration tables are supplied by the vendor , and constitute an integral part of a platform engine, and . They contain records with directive information for , that determines these engines or for and the implemented business logic implemented using the platform capabilities. These tables and their columns are protected from modification with special policies (дать ссылку) by a special security policy to prevent users from changing the platform behavior.
  Examples: Business Rules (sys_busines_rule), Columns (sys_db_column), Access Control List (ACL) (sys_security_acl).
  
• Application configuration tables contain records with directive information for that determines the business logic implemented using the platform capabilities within the limits of an application. The application configuration tables supplied by the vendor are protected by special policies as the system configuration tablesa special security policy. The application configuration tables created and modified by the users or business solution developers for their purposes can be unprotected.
  Examples: Event Rules (itsm_event_rule), Monitoring Rules (itsm_monitoring_rule).

Reference tables

The reference tables contain master data which define the business entities an enterprise is dealing with. Such business entities, depending on the area of activities, may include clients, suppliers, products, services, contracts, invoices, patients, etc. The reference tables are used in various business processes of on organization automated with the use of the platform. In addition to the information directly describing a business entity, the reference tables describe relations between these entities and hierarchies. For example, for the purposes of finding additional sales opportunities, it may be important to identify explicit and implicit relations between persons.

Examples: Employees (sys_employee), Company (org_company), Content Item (content_item).

their hierarchy.

Besides master data, the reference tables contain specific parameters, used when performing business transaction, such as time zonesThe data of the reference table contain reference data, which determine values of specific entities, used when performing transactions within the limits of the whole enterprise. These entities include timezones, countries, languages, etc. The reference These data seldom change.

Examples: Timezone пояс

• Employees (sys_employee)
• Company (org_company)
• Timezone (sys_timezome)

• Language (sys_language)

Transactional tables

The transactional tables contain the data , generated as a result of business transactions , carried out by an enterprise. Business transactions are actions or sets of actions reflected in the system and are a part of a business process. For example, for the service department of a company it is providing services, registering and processing requests, planning and approving work, notification of final user and responsible person, etc. The transactional systems make a wide use of reference tables when carrying out Reference tables are extensively used when performing business transactions.

The records of transactional tables are the object of create, read, update, and delete (CRUD) transactions within automated business processes and procedures.

Examples: Tasks (task), Approval (sys_approval).

Journal tables

The journal tables contain data that include historical transaction related to the system operation and to the processing of transactional and reference datatables. They are can be used to for solving various analytical tasks and making management decisions.

Examples: 

• History (sys_history)

• Activity Feed Item (sys_activity_feed_item)

• Main Log (sys_log)

• Email (sys_email).