import { DataTypes, Sequelize } from 'sequelize';
import sequelize from '../config/sequelize-config.js';

const FormData = sequelize.define(
  'formData',
  {
    id: {
      primaryKey: true,
      type: DataTypes.INTEGER,
      autoIncrement: true,
    },
    user_id: {
      type: DataTypes.UUID,
      allowNull: false, // Assuming the user must be associated with the event
    },
    Data: {
      type: DataTypes.JSON,
      allowNull: true, // Assuming the user must be associated with the event
    },
    userData: {
      type: DataTypes.JSON,
      allowNull: true, // Assuming the user must be associated with the event
    },
    status: {
      type: DataTypes.ENUM('pending', 'processing', 'completed'),
      defaultValue: 'pending',
    },
    Datastatus: {
      type: DataTypes.ENUM('0', '1'), // ENUM values should be strings
      defaultValue: '0', // Default value should match the ENUM type
    },
    createdAt: {
      type: DataTypes.DATE,
      allowNull: false,
      defaultValue: Sequelize.literal('CURRENT_TIMESTAMP'),
    },
    updatedAt: {
      type: DataTypes.DATE,
      allowNull: false,
      defaultValue: Sequelize.literal('CURRENT_TIMESTAMP'),
      onUpdate: Sequelize.literal('CURRENT_TIMESTAMP'),
    },
  },
  {
    timestamps: true,
  }
);

FormData.associate = (models) => {
  FormData.belongsTo(models.user, {
    foreignKey: 'user_id',
  });
};

export default FormData;