/var/www/greso.tech/server/nsm/models
Edit: /var/www/greso.tech/server/nsm/models/inventoryItemsPackages.js (1483B)
module.exports = (sequelize, Sequelize) => {
const InventoryItemsPackages = sequelize.define(
'inventoryItemsPackages',
{
id: {
type: Sequelize.UUID,
defaultValue: Sequelize.UUIDV4,
allowNull: false,
primaryKey: true
},
inventoryItemId: {
type: Sequelize.UUID,
allowNull: false,
},
name: {
type: Sequelize.STRING,
allowNull: false,
defaultValue: ''
},
count: {
type: Sequelize.DECIMAL,
allowNull: false,
defaultValue: 0.0
},
isItem: {
allowNull: false,
type: Sequelize.BOOLEAN,
defaultValue: false,
},
isPacking: {
allowNull: false,
type: Sequelize.BOOLEAN,
defaultValue: false,
},
isUnpacking: {
allowNull: false,
type: Sequelize.BOOLEAN,
defaultValue: false,
},
item_price: {
type: Sequelize.DECIMAL,
allowNull: false,
defaultValue: 0.0
},
packing_price: {
type: Sequelize.DECIMAL,
allowNull: false,
defaultValue: 0.0
},
unpacking_price: {
type: Sequelize.DECIMAL,
allowNull: false,
defaultValue: 0.0
},
createdAt: {
allowNull: false,
type: Sequelize.DATE
},
updatedAt: {
allowNull: false,
type: Sequelize.DATE
}
},
{
timestamps: true,
tableName: 'inventory_items_packages'
}
)
return InventoryItemsPackages
}