Database Schema Editor¶
Use Database Schema Editor when you need to inspect or directly modify process-defined databases at the domain level. This tool is powerful and should only be used by administrators who understand the impact of structural database changes.
Warning: Changes made here affect the physical database directly. Deleting a table or column from this editor permanently removes data and cannot be undone.
When to Use This Page¶
This editor is intended for administrative maintenance of process-defined databases and tables, and for browsing their content when investigation or recovery work is required.
It is different from the database editor inside Process Designer:
- In Process Designer, deleting a table or column removes the logical connection from the process definition but does not physically delete the database object.
- In Database Schema Editor, the same action directly modifies the underlying database.
Access and Visibility¶
When you open this editor, all process-defined databases and tables are shown without the visibility restrictions that normally apply inside process design tools.
Emakin's internal Human Resources database tables are intentionally not editable from this interface.
Note: Access to this page should be limited to highly authorised personnel because it exposes both structure and data across the domain.
Recommended Workflow¶
- Confirm that the required change cannot be handled safely from the process design tools.
- Review the target database and identify the exact table or column that needs attention.
- Export or back up the affected data before making structural changes.
- Apply the change in Database Schema Editor.
- Re-check dependent processes, queries, and integrations after the update.
What This Editor Provides¶
- Administrative access to process-defined databases and tables
- Direct structural changes to tables and columns
- Content browsing for existing database rows
- Unrestricted inspection of process-defined database objects within the domain