/var/www/greso.tech/server/nsm/models
Edit: /var/www/greso.tech/server/nsm/models/address.js (1316B)
module.exports = (sequelize, Sequelize) => {
const Address = sequelize.define(
'address',
{
id: {
type: Sequelize.UUID,
defaultValue: Sequelize.UUIDV4,
allowNull: false,
primaryKey: true
},
name: { type: Sequelize.STRING, allowNull: true },
city: { type: Sequelize.STRING(40), allowNull: true },
state: { type: Sequelize.STRING(40), allowNull: true },
street: { type: Sequelize.STRING(100), allowNull: true },
street_number: { type: Sequelize.STRING(10), allowNull: true },
number: { type: Sequelize.STRING(10), allowNull: true },
zip: { type: Sequelize.STRING(6), allowNull: true },
comment: { type: Sequelize.STRING, allowNull: true },
doorbell: { type: Sequelize.STRING(50), allowNull: true },
floor: { type: Sequelize.STRING(10), allowNull: true },
latitude: {
type: Sequelize.STRING(15),
allowNull: false,
defaultValue: '0.0'
},
longitude: {
type: Sequelize.STRING(15),
allowNull: false,
defaultValue: '0.0'
},
createdAt: {
allowNull: false,
type: Sequelize.DATE,
},
updatedAt: {
allowNull: false,
type: Sequelize.DATE,
},
},
{
timestamps: true,
paranoid: true,
tableName: 'addresses',
}
)
return Address
}