Database Schema Editor¶

The "Database Schema Editor" administrative task provides a comprehensive interface for managing process-defined databases and their constituent tables, alongside the ability to browse database content.

It is crucial to differentiate this editor from the one found within the Process Designer. In the Process Designer, actions such as deleting a table or column do not result in their physical removal from the database. Instead, these actions merely sever the logical connection between the process and the database entity, safeguarding against accidental data loss.

Conversely, the administrative Database Schema Editor enacts permanent modifications directly to the underlying database. Any deletions of tables or columns performed here are irreversible and lead to the permanent removal of data from the database.

Upon accessing this editor, administrators are presented with a view of all process-defined databases and tables without inherent restrictions on visibility. However, Emakin's internally defined Human Resources ( HR) database tables are specifically restricted from editing through this interface to maintain system integrity.

Caution: Due to the direct and permanent nature of modifications made through this editor, extreme caution is advised before executing any changes. Incorrect operations can lead to irreversible data loss and system instability. Furthermore, this editor provides the capability to view the contents of all databases, which presents significant implications for data security and confidentiality. Ensure that access to this tool is limited to highly authorized personnel only.