35 lines
1.2 KiB
JavaScript
35 lines
1.2 KiB
JavaScript
'use strict'
|
|
const { Model } = require('sequelize')
|
|
module.exports = (sequelize, DataTypes) => {
|
|
class FinancialInformation extends Model {
|
|
|
|
}
|
|
FinancialInformation.init(
|
|
{
|
|
pd_id: { type: DataTypes.INTEGER },
|
|
fy: { type: DataTypes.STRING },
|
|
sales_revenue: { type: DataTypes.INTEGER },
|
|
net_profit: { type: DataTypes.INTEGER },
|
|
income_considered: { type: DataTypes.INTEGER },
|
|
income_assessment_program_recommended: { type: DataTypes.STRING },
|
|
fixed_obligations: { type: DataTypes.INTEGER },
|
|
equipment_contribution_turnover: { type: DataTypes.STRING },
|
|
net_profit_net_loss_to_sales : { type: DataTypes.INTEGER },
|
|
income_considered_per_month : { type: DataTypes.INTEGER },
|
|
sales_over_py : { type: DataTypes.STRING },
|
|
net_profit_over_py : { type: DataTypes.STRING },
|
|
net_profit_percentage_over_py : { type: DataTypes.STRING },
|
|
|
|
createdby: { type: DataTypes.INTEGER },
|
|
updatedby: { type: DataTypes.INTEGER }
|
|
|
|
},
|
|
{
|
|
sequelize,
|
|
tableName: 'sales_financial_information',
|
|
modelName: 'FinancialInformation',
|
|
}
|
|
)
|
|
|
|
return FinancialInformation
|
|
} |