# import db object from flask app
from app import db

# database tables
class Op_sanction_amount_frequency(db.Model):
   id = db.Column(db.Integer, primary_key =True)
   temp_id = db.Column(db.Integer, nullable = False)
   ApplicationRefno = db.Column(db.Numeric, nullable = False)
   BorrowerCurrentDetailsID = db.Column(db.Integer, nullable = False)
   CFHistory24Monthsmonth = db.Column(db.DateTime, nullable = False)
   CFHistory24MonthsACorDPD = db.Column(db.String, nullable = False)
   CFHistory24MonthsOSAmount = db.Column(db.Numeric, nullable = False)
   # [id]
   #    ,[sanction_amount_count_cedit_facility]
   #    ,[sanction_amount_count_1]
   #    ,[sanction_amount_count_2_to_3]
   #    ,[sanction_amount_count_4_to_6]
   #    ,[sanction_amount_count_7_to_12]
   #    ,[sanction_amount_count_13_to_24]
   #    ,[sanction_amount_count_25_to_36]
   #    ,[sanction_amount_count_greater_than_36]
   #    ,[sanction_amount_count_total]
   #    ,[is_active]
   #    ,[createdAt]
   #    ,[createdby]
   #    ,[updatedAt]
   #    ,[updatedby]