elsa-core icon indicating copy to clipboard operation
elsa-core copied to clipboard

[FEAT] Database Table Creation and Modification Module from UI

Open sfmskywalker opened this issue 5 months ago • 0 comments

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.

sfmskywalker avatar Sep 13 '24 21:09 sfmskywalker