/var/www/qr4y.gr/server/delivery/models
Edit: /var/www/qr4y.gr/server/delivery/models/shippingRate.js (1810B)
module.exports = (sequelize, Sequelize) => {
const ShippingRate = sequelize.define(
'shippingRate',
{
id: {
type: Sequelize.BIGINT,
autoIncrement: true,
allowNull: false,
primaryKey: true
},
uid: {
type: Sequelize.UUID,
defaultValue: Sequelize.UUIDV4
},
name: {
type: Sequelize.STRING,
allowNull: false,
defaultValue: ''
},
description: {
type: Sequelize.STRING,
allowNull: false,
defaultValue: ''
},
image: {
type: Sequelize.STRING,
allowNull: true
},
initialCost: {
type: Sequelize.DECIMAL(10,2),
allowNull: false,
defaultValue: 0.0
},
costPerKm: {
type: Sequelize.DECIMAL(10,2),
allowNull: false,
defaultValue: 0.0
},
freeKm: {
type: Sequelize.DECIMAL(10,2),
allowNull: false,
defaultValue: 0.0
},
costPerMinute: {
type: Sequelize.DECIMAL(10,2),
allowNull: false,
defaultValue: 0.0
},
freeMinutes: {
type: Sequelize.INTEGER,
allowNull: false,
defaultValue: 0
},
freeMinCost: {
type: Sequelize.DECIMAL(10,2),
allowNull: false,
defaultValue: 0.0
},
timeOfDelivery: {
type: Sequelize.INTEGER,
allowNull: false,
defaultValue: 0.0
},
reservShowRooms: {
type: Sequelize.BOOLEAN,
allowNull: false,
defaultValue: false
},
reservMaxDays: {
type: Sequelize.INTEGER,
allowNull: false,
defaultValue: 0
},
createdAt: {
allowNull: false,
type: Sequelize.DATE,
defaultValue: new Date()
},
updatedAt: {
allowNull: false,
type: Sequelize.DATE,
defaultValue: new Date()
}
},
{
timestamps: true,
paranoid: true,
tableName: 'shipping_rates'
}
)
return ShippingRate
}