CRUD Generator

                Instructions: Paste your Sequelize model definition below and click generate to create CRUD operations.
            

Model Name (e.g., Banner, User, Product)

Primary Key Field

Sequelize Model Code

const DataTypes = require("sequelize");
const sequelize = require('../config/db.config');

module.exports = (sequelize, Sequelize) => {
    const banner = sequelize.define('Banner', {
        BannerId: {
            type: DataTypes.INTEGER,
            primaryKey: true,
            autoIncrement: true,
        },
        BannerImgurl: {
            type: DataTypes.STRING(255),
            allowNull: false,
        },
        BannerTitle: {
            type: DataTypes.STRING(100),
            allowNull: false,
        },
        Active: {
            type: DataTypes.STRING(1),
            defaultValue: "T",
            allowNull: false,
        },
        Deleted: {
            type: DataTypes.STRING(1),
            defaultValue: "F",
            allowNull: false,
        },
        CreatedBy: {
            type: DataTypes.INTEGER
        },
        UpdatedBy: {
            type: DataTypes.INTEGER,
        },
        CreatedDate: {
            type: DataTypes.DATE,
            defaultValue: DataTypes.NOW,
        },
        UpdatedDate: {
            type: DataTypes.DATE,
            defaultValue: DataTypes.NOW,
        },
    }, {
        tableName: 'Banner',
        timestamps: false,
    });
    return banner;
};