const sequelize = require("sequelize")
const db = require("../Config/db");

const SupplierItem = db.define(
    'TDITEMSP',
    {
        ITEM_CODE: {
            type: sequelize.STRING,
        },
        DB_CODE: {
            type: sequelize.STRING
        },
        SUPP_CODE: {
            type: sequelize.STRING
        },
        SUPP_COST: {
            type: sequelize.NUMERIC
        },
        SUPP_UNIT: {
            type: sequelize.STRING
        }

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

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