/var/www/greso.tech/server/nsm/models
Edit: /var/www/greso.tech/server/nsm/models/orderMovement.js (1529B)
module.exports = (sequelize, Sequelize) => {
const OrderMovement = sequelize.define(
'orderMovement',
{
id: {
type: Sequelize.UUID,
defaultValue: Sequelize.UUIDV4,
allowNull: false,
primaryKey: true
},
orderId: {
type: Sequelize.UUID,
primaryKey: true
},
warehouseId: {
type: Sequelize.UUID,
},
warehouseIdDest: {
type: Sequelize.UUID,
},
branchId: {
type: Sequelize.UUID,
},
branchConfirm: {
type: Sequelize.BOOLEAN,
defaultValue: false,
allowNull: true
},
truckId: {
type: Sequelize.UUID,
},
workerId: {
type: Sequelize.UUID,
},
rate: {
type: Sequelize.DECIMAL(10, 2),
allowNull: false,
defaultValue: 0.0
},
volume: {
type: Sequelize.DECIMAL(10, 2),
allowNull: false,
defaultValue: 0.0
},
status: {
allowNull: false,
type: Sequelize.ENUM('new', 'loading', 'loaded', 'unloading', 'unloaded'),
defaultValue: 'new'
},
createdAt: {
allowNull: false,
type: Sequelize.DATE,
},
loadingAt: {
type: Sequelize.DATE,
},
loadedAt: {
type: Sequelize.DATE,
},
unloadingAt: {
type: Sequelize.DATE,
},
unloadedAt: {
type: Sequelize.DATE,
},
updatedAt: {
allowNull: false,
type: Sequelize.DATE,
},
},
{
timestamps: true,
tableName: 'orders_movements',
}
)
return OrderMovement
}