smc_cet_creditpd_backend/app/models/CreditAddressDetail.js
suseendhiran17 5c8669ea32 susee
2023-07-14 10:42:10 +05:30

39 lines
1.3 KiB
JavaScript

'use strict'
const { Model } = require('sequelize')
module.exports = (sequelize, DataTypes) => {
class CreditAddressDetail extends Model {
}
CreditAddressDetail.init(
{
pd_id: { type: DataTypes.INTEGER },
initiated_address: { type: DataTypes.STRING },
is_pd_done_on_initiated_address: { type: DataTypes.STRING },
alternative_address: { type: DataTypes.STRING },
state_name: { type: DataTypes.STRING },
city_name: { type: DataTypes.STRING },
pincode: { type: DataTypes.STRING },
address_type: { type: DataTypes.STRING },
address_type_others: { type: DataTypes.STRING },
pd_locality: { type: DataTypes.STRING },
locality_other: { type: DataTypes.STRING },
pd_location: { type: DataTypes.STRING }, // gen info
comment_locality: { type: DataTypes.STRING },
business_estimated_area: { type: DataTypes.INTEGER },
uom: { type: DataTypes.STRING },
uom_specify: { type: DataTypes.STRING },
common_remarks: { type: DataTypes.STRING },
createdby: { type: DataTypes.INTEGER },
updatedby: { type: DataTypes.INTEGER }
},
{
sequelize,
tableName: 'credit_address_details',
modelName: 'CreditAddressDetail',
}
)
return CreditAddressDetail
}