betagouv/service-national-universel

const { DataTypes } = require("sequelize");
const { db } = require("../services/databases/postgresql.service");

const OBJ = db.define(
  "log_applications",
  {
    evenement_nom: DataTypes.TEXT,
    evenement_valeur: DataTypes.TEXT,
    evenement_type: DataTypes.TEXT,
    candidature_id: DataTypes.TEXT,
    candidature_user_id: DataTypes.TEXT,
    candidature_mission_id: DataTypes.TEXT,
    candidature_structure_id: DataTypes.TEXT,
    candidature_status: DataTypes.TEXT,
    date: DataTypes.DATE,
    raw_data: DataTypes.JSONB,
  },
  {
    defaultScope: {
      attributes: { exclude: ["createdAt", "updatedAt", "raw_data"] },
    },
  },
);

module.exports = OBJ;