/var/www/qr4y.kz/server/delivery/models
Edit: /var/www/qr4y.kz/server/delivery/models/product.js (1460B)
module.exports = (sequelize, Sequelize) => {
const Product = sequelize.define('product', {
id: {
type: Sequelize.BIGINT,
autoIncrement: true,
allowNull: false,
primaryKey: true,
},
uid: {
type: Sequelize.UUID,
defaultValue: Sequelize.UUIDV4,
},
position: {
type: Sequelize.INTEGER,
allowNull: true,
defaultValue: null,
},
remote_id: {
type: Sequelize.BIGINT,
allowNull: false,
defaultValue: 0,
},
active: {
allowNull: false,
type: Sequelize.BOOLEAN,
defaultValue: 1,
},
active_delivery: {
allowNull: false,
type: Sequelize.BOOLEAN,
defaultValue: 1,
},
name: {
type: Sequelize.STRING,
allowNull: false,
},
tag: {
type: Sequelize.STRING(100),
allowNull: false,
defaultValue: '',
},
article: {
type: Sequelize.STRING(30),
allowNull: true,
},
description: {
type: Sequelize.STRING,
allowNull: true,
},
old_cost: {
type: Sequelize.DECIMAL(10, 2),
allowNull: true,
defaultValue: 0.0
},
cost: {
type: Sequelize.DECIMAL(10, 2),
allowNull: true,
defaultValue: 0.0
},
rating:{
type: Sequelize.DECIMAL(10, 2),
allowNull: false,
defaultValue: 0.0
},
createdAt: {
allowNull: false,
type: Sequelize.DATE,
defaultValue: new Date(),
},
updatedAt: {
allowNull: false,
type: Sequelize.DATE,
defaultValue: new Date(),
},
},
{
tableName: 'products',
paranoid: true
})
return Product
}