src/models/VendorConfig.ts

import { Model, DataTypes } from 'sequelize';
import { sequelize } from './index';

export class VendorConfig extends Model {
  public id!: number;
  public vendorId!: number;
  public singleLineItem!: boolean;
}

VendorConfig.init({
  id: {
    type: DataTypes.INTEGER,
    autoIncrement: true,
    primaryKey: true,
  },
  pw_vendor_id: {
    type: DataTypes.BIGINT,
    allowNull: false,
    unique: true,
  },
  single_line_item: {
    type: DataTypes.BOOLEAN,
    defaultValue: false,
  },
}, {
    sequelize,
    tableName: 'vendor_configs',
    underscored: true,  
    freezeTableName: true,
    timestamps: true,
    createdAt: 'created_at',
    updatedAt: 'updated_at',
});