Page History

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

Classification by purpose

According to the purpose, the tables can be divided into three groups:

• System tables support the operation of the SimpleOne platform and its tools. They are supplied by the vendor and are protected from changes by the end-users 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 the configurations of these tables.
• User tables are created by the end-users with administrator rights (admin role) the admin role and used to perform solve their business tasks. 

Classification by the type of processed data

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

• Configuration
• Reference
• Transactional
• Journal

Configuration tables

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

These tables 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 are an integral part of a platform engine. They contain records with information , that determines these engines and the implemented business logic. These tables and their columns are protected from modification  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 information that determines the business logic implemented within an application. The application tables supplied by the vendor are protected by a special security policy. The application tables created by the users or business solution developers can be unprotected.
  Examples: Event Rules (itsm_event_rule), Monitoring Rules (itsm_monitoring_rule).

Reference tables

The reference tables contain master data which that define the business entities information objects an enterprise organization is dealing with. Such business entitiesinformation objects, depending on the area of activitiesindustry, may include clients, suppliers, products, services, invoices, etcand others. The reference tables are used in various business processes of on an organization that are automated with the use means of the platform. In addition to Besides the information directly describing a business entitythat describes a certain information objects, the reference tables describe the relations between these entities objects and their hierarchy.

Besides master data, the The reference tables also contain specific parameters , that are used when for performing business transaction, such as transactions. For example, time zones, countries, languages, etcand others. These data seldom change.

Examples:

• 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 enterpriseorganization. Business transactions are actions or sets of actions reflected actions that are displayed in the system and are a part of a business process. For  For example, for the service department of a company it is providing provides services, registering registers and processing processes requests, planning plans and approving approves work, notification of final an end-user and responsible person, etc. Reference  Reference tables are extensively commonly used when performing when the business transactions are performed.

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

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

Journal tables

The journal tables contain data related to the system operation and to the processing of transactional and reference tables. They can be used 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).