/var/www/greso.tech/server/nsm/models
Edit: /var/www/greso.tech/server/nsm/models/inventoryExtras.js (1653B)
module.exports = (sequelize, Sequelize) => {
const InventoryExtras = sequelize.define(
'inventoryExtras',
{
id: {
type: Sequelize.UUID,
defaultValue: Sequelize.UUIDV4,
allowNull: false,
primaryKey: true
},
orderInventoryId: {
type: Sequelize.UUID,
},
extraId: {
type: Sequelize.UUID,
},
name: {
type: Sequelize.STRING,
allowNull: false,
defaultValue: ''
},
description: {
type: Sequelize.STRING,
allowNull: false,
defaultValue: ''
},
type: {
allowNull: false,
type: Sequelize.ENUM('weight', 'volume', 'fixed', 'manual', 'item_weight', 'item_volume','steps','days','hours','distance'),
defaultValue: 'manual'
},
direction: {
allowNull: false,
type: Sequelize.ENUM('origin', 'destination'),
defaultValue: 'origin'
},
minSumm: {
type: Sequelize.DECIMAL(10, 2),
allowNull: false,
defaultValue: 0.0
},
price: {
type: Sequelize.DECIMAL(10, 2),
allowNull: false,
defaultValue: 0.0
},
value: {
type: Sequelize.DECIMAL(10, 2),
allowNull: false,
defaultValue: 0.0
},
comment: {
type: Sequelize.STRING,
allowNull: false,
defaultValue: '',
},
createdAt: {
allowNull: false,
type: Sequelize.DATE
},
updatedAt: {
allowNull: false,
type: Sequelize.DATE
}
},
{
timestamps: true,
tableName: 'inventory_extras'
}
)
return InventoryExtras
}