/var/www/greso.tech/server/nsm/models
Edit: /var/www/greso.tech/server/nsm/models/orderHistory.js (1140B)
module.exports = (sequelize, Sequelize) => {
const OrderHistory = sequelize.define(
'orderHistory',
{
id: {
type: Sequelize.UUID,
defaultValue: Sequelize.UUIDV4,
allowNull: false,
primaryKey: true
},
orderId: {
type: Sequelize.UUID,
},
userId: {
type: Sequelize.UUID,
allowNull: true,
},
status: {
allowNull: true,
type: Sequelize.ENUM(
'new',
'estimate',
'booked',
'confirmed',
'onsite',
'pickup',
'picked_up',
'warehouse_unloading',
'warehouse',
'storage',
'loading',
'enroute',
'arrived',
'unloading',
'completed',
'cancel',
'deleted'
)
},
comment: {
type: Sequelize.STRING,
allowNull: false,
defaultValue: '',
},
createdAt: {
allowNull: true,
type: Sequelize.DATE
},
updatedAt: {
allowNull: true,
type: Sequelize.DATE
}
},
{
timestamps: true,
paranoid: true,
tableName: 'orders_history'
}
)
return OrderHistory
}