General Information about Database

There are 2 types of databases: system and personal.

General information about system database

System database is created automatically with creating a server project. It stores all data about project tags. It contains several tables:

• FLOAT_TAG_HISTORY (it contains the following fields ID, TAG_ID, DATETIME, QUALITY, VALUE) /// It stores information about tags where floating-point numbers are written
• INTEGER_TAG_HISTORY (it contains the following fields ID, TAG_ID, DATETIME, QUALITY, VALUE) /// It stores information about tags where integer numbers are written
• QUALITY_LIST (it contains the following field ID, NAME)
• STRING_TAG_HISTORY (it contains the following fields ID, TAG_ID, DATETIME, QUALITY, VALUE) /// It stores information about tags where stlings are written
• TAGS_PASSPORT (it contains the following fields TAG_ID, TAG_TYPE, NAME, STATUS) /// It stores information about tag settings
• TAG_STATUSES (it contains the following fields ID, NAME) /// It stores information about tag status
• TAG_TYPES_LIST (it contains the following fields ID, NAME, TABLE_NAME) /// It stores information about tag location in the database

Note: Data can't be written in the database manually (via script). The database can only be read and requests can be sent to the base.

General information about personal database

Personal database can be created to store infromation about tags. The database consists of numerous tables, that can be connected with each other. The tables can be created, edited, read, requests can be sent to the database and can be deleted.

When a new project is uploaded, the system database is not cleared. It stores information about all project tags that were changed.