elsa-core
elsa-core copied to clipboard
[FEAT] Database Table Creation and Modification Module from UI
Implement a module that allows users to create and modify database tables directly from the user interface. The module should provide functionality to define table schemas, including columns, data types, and constraints. Once a table is defined, the changes should be applied to a pre-configured database.
Key Features:
- UI for defining new tables (table name, columns, data types, constraints).
- UI for modifying existing tables (add/drop columns, modify column properties).
- Validation to ensure proper schema definition.
- Apply changes to the configured database automatically.
- Support for common databases (SQL Server, PostgreSQL, MySQL, etc.).
Goals:
- Simplify database management for users without requiring direct SQL.
- Enable quick updates to database structure directly from the UI.
Notes:
- Ensure schema changes are transactional to prevent partial updates.
- Consider versioning to allow rollback of schema changes.