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