Open soltecsis-iortega opened 5 days ago
To support OpenAPI integration and future scalability, two new tables need to be created in the database:
ai
ai_models
This structure ensures the flexibility to add new AI models in the future and allows the UI to dynamically display available models for configuration.
[ ] Create the ai table with the following fields:
id
name
api_key
selected_model_id
created_at
updated_at
[ ] Create the ai_models table with the following fields:
endpoint
[ ] Implement migration scripts to:
ai.selected_model_id
ai_models.id
To support OpenAPI integration and future scalability, two new tables need to be created in the database:
ai: Stores user-specific AI configuration details, including the API key and the selected model.ai_models: Stores information about the available AI models, including their name and endpoint.This structure ensures the flexibility to add new AI models in the future and allows the UI to dynamically display available models for configuration.
[ ] Create the
aitable with the following fields:id: Primary Key.name: String, a descriptive name for the user's AI configuration.api_key: String, encrypted, to securely store the user's API key.selected_model_id: Foreign Key, references theai_modelstable, indicating the model selected by the user.created_at: Timestamp, automatic creation time.updated_at: Timestamp, automatic update time.[ ] Create the
ai_modelstable with the following fields:id: Primary Key.name: String, the name of the model (e.g., ChatGPT).endpoint: String, the endpoint URL for the model.created_at: Timestamp, automatic creation time.updated_at: Timestamp, automatic update time.[ ] Implement migration scripts to:
ai.selected_model_idandai_models.id.