smc_cet_salespd_backend/app/models/InstitutionDetails.js
2022-09-22 09:50:01 +05:30

37 lines
1.2 KiB
JavaScript

'use strict'
const { Model } = require('sequelize')
module.exports = (sequelize, DataTypes) => {
class InstitutionDetail extends Model {
}
InstitutionDetail.init(
{
pd_id: { type: DataTypes.INTEGER },
institution_type: { type: DataTypes.STRING },
about_locality: { type: DataTypes.STRING },
instituion_vitage: { type: DataTypes.STRING },
opening_new_branch: { type: DataTypes.STRING },
property_ownership: { type: DataTypes.STRING },
area_sq_feet: { type: DataTypes.STRING },
floor: { type: DataTypes.STRING },
how_many_beds : {type: DataTypes.STRING},
occupancy_ratio : {type: DataTypes.STRING},
tot_doctors : {type: DataTypes.STRING},
permanent_doctors : {type: DataTypes.STRING},
temp_doctors : {type: DataTypes.STRING},
business_activity_seen : {type: DataTypes.STRING},
staff_observer_number: { type: DataTypes.STRING },
createdby: { type: DataTypes.INTEGER },
updatedby: { type: DataTypes.INTEGER }
},
{
sequelize,
tableName: 'sales_institution_details',
modelName: 'InstitutionDetail',
}
)
return InstitutionDetail
}