/var/www/qr4y.kz/server/delivery/models
Edit: /var/www/qr4y.kz/server/delivery/models/tableReserv.js (1453B)
module.exports = (sequelize, Sequelize) => {
const TableReserv = sequelize.define(
'tableReserv',
{
id: {
type: Sequelize.BIGINT,
autoIncrement: true,
allowNull: false,
primaryKey: true
},
uid: {
type: Sequelize.UUID,
defaultValue: Sequelize.UUIDV4
},
branchId: {
type: Sequelize.BIGINT,
allowNull: false,
},
tableId: {
type: Sequelize.BIGINT,
allowNull: true,
},
userId: {
type: Sequelize.BIGINT,
allowNull: false
},
date: {
allowNull: false,
type: Sequelize.DATE
},
places:{
type: Sequelize.INTEGER,
allowNull: false,
defaultValue: 1
},
duration: { // продолжительность резерва стола в минутах
type: Sequelize.BIGINT,
defaultValue: 0,
allowNull: false
},
status:{
allowNull: false,
type: Sequelize.ENUM(
'new',
'reserved',
'canceled'
),
defaultValue: 'new'
},
comment:{
type: Sequelize.STRING,
allowNull: false,
defaultValue: ''
},
createdAt: {
allowNull: false,
type: Sequelize.DATE
},
updatedAt: {
allowNull: false,
type: Sequelize.DATE
}
},
{
timestamps: true,
paranoid: true,
tableName: 'table_reserv'
}
)
return TableReserv
}