ideas-generator/server/models/ResponseSession.js
DJP ca4ed4976d Add dual-agent system with file upload support and compact UI
- Implement dual-agent architecture supporting both Chat Completions and Responses API
- Add comprehensive file upload functionality for responses agents with image and PDF support
- Integrate OpenAI Conversations API for persistent file context across messages
- Add compact UI design with reduced font sizes and tighter spacing for better chat focus
- Include vector store management, document upload system, and admin dashboard enhancements
- Fix conversation persistence ensuring uploaded files remain accessible in follow-up questions

🤖 Generated with [Claude Code](https://claude.ai/code)

Co-Authored-By: Claude <noreply@anthropic.com>
2025-09-04 14:45:25 -04:00

78 lines
No EOL
1.8 KiB
JavaScript

const { DataTypes } = require('sequelize');
const { sequelize } = require('../config/database');
const ResponseSession = sequelize.define('ResponseSession', {
id: {
type: DataTypes.UUID,
defaultValue: DataTypes.UUIDV4,
primaryKey: true,
},
openaiResponseId: {
type: DataTypes.STRING,
allowNull: false,
unique: true,
comment: 'OpenAI response ID from Responses API'
},
conversationId: {
type: DataTypes.UUID,
allowNull: false,
references: {
model: 'conversations',
key: 'id',
},
onUpdate: 'CASCADE',
onDelete: 'CASCADE',
},
assistantId: {
type: DataTypes.UUID,
allowNull: false,
references: {
model: 'assistants',
key: 'id',
},
onUpdate: 'CASCADE',
onDelete: 'CASCADE',
},
userId: {
type: DataTypes.UUID,
allowNull: false,
references: {
model: 'users',
key: 'id',
},
onUpdate: 'CASCADE',
onDelete: 'CASCADE',
},
status: {
type: DataTypes.ENUM('in_progress', 'completed', 'failed', 'cancelled'),
defaultValue: 'in_progress',
allowNull: false,
},
backgroundProcessing: {
type: DataTypes.BOOLEAN,
defaultValue: false,
allowNull: false,
},
toolsUsed: {
type: DataTypes.JSONB,
defaultValue: [],
comment: 'Array of tools used in this response session'
},
metadata: {
type: DataTypes.JSONB,
defaultValue: {},
},
}, {
tableName: 'response_sessions',
timestamps: true,
indexes: [
{ fields: ['openaiResponseId'], unique: true },
{ fields: ['conversationId'] },
{ fields: ['assistantId'] },
{ fields: ['userId'] },
{ fields: ['status'] },
{ fields: ['createdAt'] },
],
});
module.exports = ResponseSession;