import Sequelize from "sequelize";
import sequelize from "../config/database.config.js";
import sequelizePaginate from "sequelize-paginate";

const Groups = sequelize.define(
  "groups",
  {
    id: {
      type: Sequelize.INTEGER,
      primaryKey: true,
      autoIncrement: true,
      allowNull: false,
    },
    group_name: {
      type: Sequelize.STRING,
    },
    created_by: {
      type: Sequelize.BIGINT
    },
    group_code: {
      type: Sequelize.INTEGER
    },
    group_profile: {
      type: Sequelize.STRING
    },
    is_active: {
      type: Sequelize.TINYINT,
      defaultValue: 0,
      comment: "0 = active, 1 = inactive"
    },
    created_at: {
      type: Sequelize.INTEGER
    },
    updated_at: {
      type: Sequelize.INTEGER
    },

  },
  {
    tableName: 'groups',
    timestamps: false,
  }
);
sequelizePaginate.paginate(Groups);
export default Groups;