You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
31 lines
610 B
31 lines
610 B
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; |