70 lines
3.3 KiB
Python
70 lines
3.3 KiB
Python
# import db object from flask app
|
|
from app import db
|
|
|
|
# database tables
|
|
class In_borrower_detail(db.Model):
|
|
id = db.Column(db.Integer, primary_key =True)
|
|
losid = db.Column(db.String, nullable = False)
|
|
ReferenceNumber = db.Column(db.String, nullable = False)
|
|
ConsumerNameField1 = db.Column(db.String, nullable = False)
|
|
ConsumerNameField2 = db.Column(db.String, nullable = False)
|
|
ConsumerNameField3 = db.Column(db.String, nullable = False)
|
|
ConsumerNameField4 = db.Column(db.String, nullable = False)
|
|
ConsumerNameField5 = db.Column(db.String, nullable = False)
|
|
PAN = db.Column(db.String, nullable = False)
|
|
cibil_type = db.Column(db.String, nullable = False)
|
|
|
|
class In_credit_facility(db.Model):
|
|
AccountTranDetailsID = db.Column(db.Integer, primary_key =True)
|
|
losid = db.Column(db.String, nullable = False)
|
|
ReferenceNumber = db.Column(db.String, nullable = False)
|
|
cibil_type = db.Column(db.String, nullable = False)
|
|
month_bucket_index = db.Column(db.Integer, nullable = False)
|
|
AccountType = db.Column(db.String, nullable = False)
|
|
WrittenOffAndSettledStatus = db.Column(db.String, nullable = False)
|
|
OwnershipIndicator = db.Column(db.DateTime, nullable = False)
|
|
DateOpenedDisbursed = db.Column(db.DateTime, nullable = False)
|
|
DateClosed = db.Column(db.DateTime, nullable = False)
|
|
DateReportedAndCertified = db.Column(db.DateTime, nullable = False)
|
|
HighCreditSanctionedAmount = db.Column(db.Numeric, nullable = False)
|
|
CurrentBalance = db.Column(db.Numeric, nullable = False)
|
|
AmountOverdue = db.Column(db.Numeric, nullable = False)
|
|
CreditLimit = db.Column(db.Numeric, nullable = False)
|
|
RepaymentTenure = db.Column(db.Numeric, nullable = False)
|
|
EMIAmount = db.Column(db.Numeric, nullable = False)
|
|
grp_str = db.Column(db.String, nullable = False)
|
|
|
|
|
|
|
|
class In_dpd_transaction_detail(db.Model):
|
|
id = db.Column(db.Integer, primary_key =True)
|
|
# losid = db.Column(db.String, nullable = False)
|
|
AccountTranDetailsID = db.Column(db.Integer, nullable = False)
|
|
ReferenceNumber = db.Column(db.String, nullable = False)
|
|
cibil_type = db.Column(db.Integer, nullable = False)
|
|
month_bucket_index = db.Column(db.Integer, nullable = False)
|
|
StartDate = db.Column(db.DateTime, nullable = False)
|
|
Code = db.Column(db.String, nullable = False)
|
|
# DateOpenedDisbursed = db.Column(db.DateTime, nullable = False)
|
|
# DateReportedAndCertified = db.Column(db.DateTime, nullable = False)
|
|
# HighCreditSanctionedAmount = db.Column(db.Numeric, nullable = False)
|
|
# CurrentBalance = db.Column(db.Numeric, nullable = False)
|
|
# AmountOverdue = db.Column(db.Numeric, nullable = False)
|
|
# CreditLimit = db.Column(db.Numeric, nullable = False)
|
|
# RepaymentTenure = db.Column(db.Numeric, nullable = False)
|
|
# EMIAmount = db.Column(db.Numeric, nullable = False)
|
|
|
|
class In_enquiry_detail(db.Model):
|
|
id = db.Column(db.Integer, primary_key =True)
|
|
losid = db.Column(db.String, nullable = False)
|
|
ReferenceNumber = db.Column(db.String, nullable = False)
|
|
cibil_type = db.Column(db.Integer, nullable = False)
|
|
month_bucket_index = db.Column(db.Integer, nullable = False)
|
|
DateOfEnquiry = db.Column(db.Date, nullable = False)
|
|
EnquiryPurpose = db.Column(db.String, nullable = False)
|
|
EnquiryAmount = db.Column(db.Numeric, nullable = False)
|
|
grp_str = db.Column(db.String, nullable = False)
|
|
|
|
|
|
|