/var/www/qr4y.com/server/delivery/models
Edit: /var/www/qr4y.com/server/delivery/models/company.js (2370B)
module.exports = (sequelize, Sequelize) => {
const Company = sequelize.define('company', {
id: {
type: Sequelize.UUID,
defaultValue: Sequelize.UUIDV4,
allowNull: false,
primaryKey: true
},
enabled: {
allowNull: false,
type: Sequelize.BOOLEAN,
defaultValue: 0,
},
active: {
allowNull: false,
type: Sequelize.BOOLEAN,
defaultValue: 1,
},
countryCodeId: {
type: Sequelize.UUID,
},
deliveryServerId: {
type: Sequelize.UUID,
},
image: {
type: Sequelize.STRING,
allowNull: false,
defaultValue: '',
},
name: {
type: Sequelize.STRING(100),
allowNull: false,
defaultValue: '',
},
tag: {
type: Sequelize.STRING(100),
allowNull: false,
defaultValue: '',
},
currency: {
type: Sequelize.STRING(10),
allowNull: false,
defaultValue: '',
},
description: {
type: Sequelize.STRING,
allowNull: false,
defaultValue: '',
},
phones: {
type: Sequelize.STRING,
allowNull: false,
defaultValue: '',
},
iban: {
type: Sequelize.STRING,
allowNull: false,
defaultValue: '',
},
rating:{
type: Sequelize.DECIMAL(10, 2),
allowNull: false,
defaultValue: 0.0
},
dataVersion: {
type: Sequelize.INTEGER,
allowNull: false,
defaultValue: 0
},
countClients: {
type: Sequelize.INTEGER,
allowNull: false,
defaultValue: 0
},
countCompanyReviews: {
type: Sequelize.INTEGER,
allowNull: false,
defaultValue: 0
},
countBranchReviews: {
type: Sequelize.INTEGER,
allowNull: false,
defaultValue: 0
},
countProductReviews: {
type: Sequelize.INTEGER,
allowNull: false,
defaultValue: 0
},
ordersCreated: {
type: Sequelize.INTEGER,
allowNull: false,
defaultValue: 0
},
ordersCompleted: {
type: Sequelize.INTEGER,
allowNull: false,
defaultValue: 0
},
ordersCanceled: {
type: Sequelize.INTEGER,
allowNull: false,
defaultValue: 0
},
planExpiredAt: {
allowNull: true,
type: Sequelize.DATE,
// defaultValue: new Date(),
},
createdAt: {
allowNull: false,
type: Sequelize.DATE,
// defaultValue: new Date(),
},
updatedAt: {
allowNull: false,
type: Sequelize.DATE,
// defaultValue: new Date(),
},
billingAt: {
allowNull: true,
type: Sequelize.DATE,
},
},
{
timestamps: true,
paranoid: true,
})
return Company
}