def lms_limits_master_model():
db = postgres_db_init()
Base = declarative_base(bind=db)
Session = sessionmaker(bind=db)
class LmsLimitsMaster(Base):
__tablename__ = 'lms_limits_master'
source_id = Column(Text, nullable=False)
available_limit = Column(Float(53), nullable=False)
blocked_limit = Column(Float(53))
business_id = Column(Text, nullable=False, primary_key=True)
created_at = Column(Text)
lending_org_name = Column(Text)
limit_amount_sanctioned = Column(Float(53), nullable=False)
limit_amount_utilized = Column(Float(53), nullable=False)
limits_under_clearing = Column(Float(53))
org_name = Column(Text, nullable=False)
retailer_id = Column(Text)
status = Column(Text, nullable=False)
updated_at = Column(Text)
version = Column(BigInteger)
Base.metadata.drop_all(bind=db)
Base.metadata.create_all()
session = Session()
return session, LmsLimitsMaster
def lms_loan_repayment_model():
db = postgres_db_init()
Base = declarative_base(bind=db)
Session = sessionmaker(bind=db)
class LmsLoanRepayment(Base):
__tablename__ = 'lms_loan_repayment'
source_id = Column(Text, nullable=False)
business_id = Column(Text, nullable=False)
created_at_pretty = Column(Text)
created_by = Column(Text)
initiator = Column(Text)
installment_number = Column(Text)
loan_account_id = Column(Text)
org_name = Column(Text)
payment_ref_no = Column(Text)
preclosure = Column(Text)
remarks = Column(Text)
reason = Column(Text)
repayment_amount = Column(Float(53), nullable=False)
repayment_date = Column(Text, nullable=False)
repayment_id = Column(Text, primary_key=True)
repayment_mode = Column(Text, nullable=False)
repayment_type = Column(Text, nullable=False)
status = Column(Text, nullable=False)
check_id = Column(Text)
Base.metadata.drop_all(bind=db)
Base.metadata.create_all()
session = Session()
return session, LmsLoanRepayment
def scf_invoice_model():
db = postgres_db_init()
Base = declarative_base(bind=db)
Session = sessionmaker(bind=db)
class ScfInvoice(Base):
__tablename__ = 'scf_invoice'
source_id = Column(Text, nullable=False)
batch_id = Column(Float(53))
business_id = Column(Text, nullable=False)
check_amount = Column(Float(53))
check_id = Column(Text)
check_no = Column(Text)
check_status = Column(Text)
created_at = Column(Float(53))
created_at_pretty = Column(Text)
created_by = Column(Text)
credit_product = Column(Text, nullable=False)
credit_risk_notes = Column(Text)
credit_risk_status = Column(Text)
disbursement_date = Column(Text, nullable=False)
invoice_due_date = Column(Text, nullable=False)
invoice_id = Column(Text,
nullable=False,
unique=True,
primary_key=True)
invoice_issue_date = Column(Text, nullable=False)
initiator = Column(Text)
invoice_no = Column(Text, nullable=False)
lending_org_name = Column(Text, nullable=False)
loan_type = Column(Text, nullable=False)
master_invoice_id = Column(Text, nullable=False)
mode_of_repayment = Column(Text, nullable=False)
org_name = Column(Text, nullable=False)
overdrawn_percentage = Column(Float(53))
program_id = Column(Text)
remarks = Column(Text)
retailer_id = Column(Text)
status = Column(Text, nullable=False)
total_amt_util_post_invoice = Column(Float(53))
total_invoice_amount = Column(Float(53))
ifsc_code = Column(Text)
Base.metadata.drop_all(bind=db)
Base.metadata.create_all()
session = Session()
return session, ScfInvoice
def lms_check_details_model():
db = postgres_db_init()
Base = declarative_base(bind=db)
Session = sessionmaker(bind=db)
class LmsCheckDetail(Base):
__tablename__ = 'lms_check_details'
source_id = Column(Text, nullable=False)
business_id = Column(Text, primary_key=True)
check_amount = Column(Float(53), nullable=False)
check_id = Column(Text, nullable=False)
check_no = Column(Text, nullable=False)
ifsc_code = Column(Text)
reason = Column(Text)
repayment_id = Column(Text)
status = Column(Text)
Base.metadata.drop_all(bind=db)
Base.metadata.create_all()
session = Session()
return session, LmsCheckDetail
def lms_loan_model():
db = postgres_db_init()
Base = declarative_base(bind=db)
Session = sessionmaker(bind=db)
class LmsLoanInstallment(Base):
__tablename__ = 'lms_loan_installments'
source_id = Column(Text, nullable=False)
cashback_amount = Column(Float(53))
cashback_paid = Column(Float(53))
cashback_rate = Column(Text)
cashback_type = Column(Text)
check_id = Column(Text)
from_date = Column(Text, nullable=False)
installment_amount = Column(Float(53), nullable=False)
installment_number = Column(Float(53),
primary_key=True,
nullable=False)
interest_amount_accrued = Column(Float(53), nullable=False)
interest_amount_outstanding = Column(Float(53), nullable=False)
interest_days = Column(Float(53), nullable=False)
interest_rate = Column(Text, nullable=False)
interest_rate_definition_method = Column(Text)
interest_repaid = Column(Float(53), nullable=False)
interest_scheduled_to_be_repaid = Column(Float(53), nullable=False)
interest_under_clearing = Column(Float(53))
last_interest_applied_date = Column(Text)
loan_overdue_date = Column(Text)
loan_principal_outstanding = Column(Float(53))
overdue_duration = Column(BigInteger)
overdue_interest_amount = Column(Float(53), nullable=False)
overdue_interest_repaid = Column(Float(53), nullable=False)
overdue_outstanding = Column(Float(53), nullable=False)
overdue_under_clearing = Column(Float(53))
principal_expected = Column(Float(53), nullable=False)
principal_outstanding = Column(Float, nullable=False)
principal_repaid = Column(Float(53), nullable=False)
principal_under_clearing = Column(Float(53))
repayment_due_date = Column(Text, nullable=False)
repayment_mode = Column(Text)
repayment_ref_no = Column(Text)
status = Column(Text, nullable=False)
to_date = Column(Text, nullable=False)
loan_account_id = Column(ForeignKey('lms_loan.loan_account_id',
ondelete='cascade'),
primary_key=True)
class LmsLoan(Base):
__tablename__ = 'lms_loan'
source_id = Column(Text, nullable=False)
business_id = Column(Text)
cashback_amount = Column(Float(53))
cashback_paid = Column(Float(53))
created_at = Column(Text)
fee_amount = Column(Float(53))
fee_amount_outstanding = Column(Float(53))
fee_amount_paid = Column(Float(53))
fee_amount_waived = Column(Float(53))
fee_under_clearing = Column(Float(53))
interest_amount_accrued = Column(Float(53))
interest_amount_outstanding = Column(Float(53), nullable=False)
interest_repaid = Column(Float(53), nullable=False)
last_modified_date = Column(Text)
last_repayment_date = Column(Text)
lending_org_name = Column(Text, nullable=False)
loan_account_id = Column(Text, nullable=False, primary_key=True)
loan_closed_date = Column(Text)
loan_type = Column(Text, nullable=False)
master_loan_account_id = Column(Text, nullable=False)
maturity_date = Column(Text, nullable=False)
org_name = Column(Text, nullable=False)
overdue_duration = Column(BigInteger, nullable=False)
overdue_interest_amount = Column(Float(53), nullable=False)
overdue_interest_repaid = Column(Float(53), nullable=False)
overdue_outstanding = Column(Float(53), nullable=False)
principal_disbursed = Column(Float(53), nullable=False)
principal_expected = Column(Float(53), nullable=False)
principal_outstanding = Column(Float, nullable=False)
principal_repaid = Column(Float(53), nullable=False)
product_code = Column(Text, nullable=False)
retailer_id = Column(Text)
start_date = Column(Text, nullable=False)
status = Column(Text, nullable=False)
sub_status = Column(Text, nullable=False)
installments = relationship(
LmsLoanInstallment,
backref='lms_loan',
cascade="save-update, merge, delete, delete-orphan",
lazy='dynamic',
passive_deletes=True)
Base.metadata.drop_all(bind=db)
Base.metadata.create_all()
session = Session()
return session, LmsLoan, LmsLoanInstallment
def cas_business_model():
db = postgres_db_init()
Base = declarative_base(bind=db)
Session = sessionmaker(bind=db)
class CasBusinessPartner(Base):
__tablename__ = 'cas_business_partners'
id = Column(BigInteger, Sequence('id'))
aadhaar_no = Column(Text)
address_line_1 = Column(Text)
address_line_3 = Column(Text)
applicant_type = Column(Text)
city_name = Column(Text)
city_pin_code = Column(Text)
date_of_birth = Column(Text)
educational_qualification = Column(Text)
email_address = Column(Text)
first_name = Column(Text)
gender = Column(Text)
individual_address_geolocation = Column(Text)
individual_address_google_geocoder = Column(Text)
individual_address_lat = Column(Float)
individual_address_lng = Column(Float)
last_name = Column(Text)
main_applicant = Column(Text)
marital_status = Column(Text)
mobile_number = Column(BigInteger)
pan_no = Column(Text, primary_key=True, nullable=False)
residence_ownership = Column(Text)
source_id = Column(Text, nullable=False)
country_name = Column(Text)
email_id = Column(Text)
state_name = Column(Text)
image_uploaded = Column(Text)
aadhaar_qr_scan = Column(Text)
business_id = Column(ForeignKey('cas_business.business_id',
ondelete='cascade'),
primary_key=True)
class CasBusiness(Base):
__tablename__ = 'cas_business'
id = Column(BigInteger, Sequence('id'))
annual_turnover = Column(Text, nullable=False)
bank_od_cc_limit = Column(Text, nullable=False)
business_address_geolocation = Column(Text)
business_address_google_geocoder = Column(Text)
business_address_lat = Column(Float)
business_address_lng = Column(Float)
business_category_code = Column(Text, nullable=False)
business_id = Column(Text, unique=True, primary_key=True)
business_mobile_no = Column(BigInteger)
business_name = Column(Text, nullable=False)
business_ownership = Column(Text, nullable=False)
business_pan = Column(Text, nullable=False)
business_type_code = Column(Text, nullable=False)
created_at = Column(Numeric, nullable=False)
created_at_pretty = Column(Text, nullable=False)
created_by = Column(Text, nullable=False)
gstin_no = Column(Text)
initiator = Column(Text, nullable=False)
migrated = Column(Text)
no_of_employees = Column(BigInteger, nullable=False)
no_of_partners = Column(BigInteger, nullable=False)
old_business_id = Column(Text)
operating_since_month = Column(Text, nullable=False)
operating_since_year = Column(BigInteger, nullable=False)
operating_type_code = Column(Text, nullable=False)
org_name = Column(Text, nullable=False)
primary_address_line_1 = Column(Text, nullable=False)
primary_address_line_3 = Column(Text)
primary_city_name = Column(Text, nullable=False)
primary_pin_code = Column(BigInteger, nullable=False)
retailer_id = Column(Text, nullable=False)
version = Column(BigInteger)
source_id = Column(Text, nullable=False)
primary_state_name = Column(Text)
business_partners = relationship(
CasBusinessPartner,
backref='cas_business',
cascade="save-update, merge, delete, delete-orphan",
lazy='dynamic',
passive_deletes=True)
Base.metadata.drop_all(bind=db)
Base.metadata.create_all()
session = Session()
return session, CasBusiness, CasBusinessPartner