# 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)