elsa-workflows / elsa-workflows/elsa-studio

[FEAT] Database Table Creation and Modification Module from UI

Open
#648 0 comments 0 reactions 0 assignees View on GitHub
enhancement triaged
Dominant language
C#
Stars
301
Forks
181
Avg merge
17h 12m
Merged PRs (30d)
42

Description

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.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.