/var/www/greso.tech/server/nsm/models
Edit: /var/www/greso.tech/server/nsm/models/branch.js (1680B)
module.exports = (sequelize, Sequelize) => {
const Branch = sequelize.define(
'branch',
{
id: {
type: Sequelize.UUID,
defaultValue: Sequelize.UUIDV4,
allowNull: false,
primaryKey: true
},
active: {
allowNull: false,
type: Sequelize.BOOLEAN,
defaultValue: true,
},
agent: {
allowNull: false,
type: Sequelize.BOOLEAN,
defaultValue: false,
},
name: {
type: Sequelize.STRING(100),
allowNull: false,
defaultValue: ''
},
short_name: {
type: Sequelize.STRING(50),
allowNull: false,
defaultValue: '',
},
dba: {
type: Sequelize.STRING(100),
allowNull: false,
defaultValue: '',
},
phone: {
type: Sequelize.STRING(15),
allowNull: true,
defaultValue: ''
},
email: {
type: Sequelize.STRING(100),
allowNull: true,
defaultValue: ''
},
site: {
type: Sequelize.STRING(100),
allowNull: true,
defaultValue: ''
},
description: {
type: Sequelize.STRING,
allowNull: false,
defaultValue: ''
},
usdot: {
type: Sequelize.STRING(30),
allowNull: true,
defaultValue: ''
},
mc: {
type: Sequelize.STRING(30),
allowNull: true,
defaultValue: ''
},
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()
}
},
{
timestamps: true,
paranoid: true
}
)
return Branch
}