Backend-POS/Model/StoreModel.js

const sequelize = require('sequelize')
const db = require('../Config/db')

const StoreModel = db.define(
    'TDSTINFO',
    {
        DB_CODE: {
            type: sequelize.STRING,
            primaryKey: true
        },
        DB_NAME: {
            type: sequelize.STRING
        },
        DATE_DEFAULT: {
            type: sequelize.CHAR
        },
        DATE_FORMAT: {
            type: sequelize.STRING
        },
        SA_DECIMAL: {
            type: sequelize.INTEGER
        },
        SB_DECICMA: {
            type: sequelize.INTEGER
        },
        DEC_SEP: {
            type: sequelize.CHAR
        },
        THO_SEP: {
            type: sequelize.CHAR
        },
        DB_STAT: {
            type: sequelize.CHAR
        },
        USER_CREA: {
            type: sequelize.STRING
        },
        DATE_CREA: {
            type: sequelize.STRING
        },
        USER_UPDT: {
            type: sequelize.STRING
        },
        DATE_UPDT: {
            type: sequelize.STRING
        },
        MAP: {
            type: sequelize.STRING
        },
        DB_LOC: {
            type: sequelize.STRING
        }

    },
    {
        timestamps: false,
        freezeTableName: true,
    }
)


StoreModel.removeAttribute('id')
module.exports = StoreModel;