# This is an auto-generated Django model module.
# You'll have to do the following manually to clean this up:
#   * Rearrange models' order
#   * Make sure each model has one field with primary_key=True
#   * Make sure each ForeignKey and OneToOneField has `on_delete` set to the desired behavior
#   * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table
# Feel free to rename the models, but don't rename db_table values or field names.
import os

from django.db import models


class Lenders(models.Model):
    name = models.CharField(max_length=191)
    logo = models.TextField()
    cin = models.CharField(max_length=191)
    email = models.CharField(max_length=191)
    website = models.CharField(max_length=191)
    signature = models.TextField()
    signed_by = models.CharField(max_length=191)
    address = models.CharField(max_length=191)
    state = models.IntegerField()
    city = models.CharField(max_length=191)
    country = models.CharField(max_length=191)
    pincode = models.CharField(max_length=191)
    agreement = models.CharField(max_length=191, blank=True, null=True)
    status = models.CharField(max_length=8)
    created_by = models.IntegerField()
    updated_by = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    registaration_date = models.DateField(blank=True, null=True)
    subregistrar = models.CharField(db_column='SubRegistrar', max_length=191, blank=True, null=True)  # Field name made lowercase.
    vide_registration = models.CharField(max_length=191, blank=True, null=True)
    firstpage = models.IntegerField(blank=True, null=True)
    lastpage = models.IntegerField(blank=True, null=True)
    gst = models.CharField(max_length=191, blank=True, null=True)
    pan = models.CharField(max_length=191, blank=True, null=True)
    phone = models.CharField(max_length=191, blank=True, null=True)
    companies_act = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'lenders'


class AbflBreDecision(models.Model):
    account_id = models.CharField(max_length=191)
    async_id = models.CharField(max_length=191)
    abfl_application_id = models.CharField(max_length=191)
    loan_amount = models.IntegerField()
    roi = models.CharField(max_length=6)
    tenure = models.IntegerField()
    ccc_id = models.CharField(max_length=191)
    risk_flag = models.CharField(max_length=6)
    pep_flag = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'abfl_bre_decision'


class AbflDocuments(models.Model):
    application_id = models.IntegerField()
    consumer_application_file_id = models.IntegerField()
    response = models.TextField()
    status = models.CharField(max_length=191)
    user_id = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'abfl_documents'


class AbflDrawdownWrapper(models.Model):
    application_id = models.IntegerField()
    loan_no = models.CharField(max_length=191)
    loan_id = models.CharField(max_length=191)
    user_id = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'abfl_drawdown_wrapper'


class AbflKyc(models.Model):
    application_id = models.IntegerField()
    result = models.CharField(max_length=191)
    doc_age_check = models.CharField(max_length=191)
    user_id = models.IntegerField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'abfl_kyc'


class AbflSanctionWrapper(models.Model):
    application_id = models.IntegerField()
    account_state = models.CharField(max_length=191)
    kyc_mode = models.CharField(max_length=191)
    approved_offer_limit = models.CharField(max_length=191)
    account_creation_date = models.CharField(max_length=191)
    deal_no = models.CharField(max_length=191)
    deal_id = models.CharField(max_length=191)
    user_id = models.IntegerField(blank=True, null=True)
    batch_id = models.CharField(max_length=191, blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'abfl_sanction_wrapper'


class AbflUtrUpdate(models.Model):
    account_id = models.IntegerField()
    utr = models.CharField(max_length=191)
    amount = models.CharField(max_length=191)
    lan = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'abfl_utr_update'


class AbflWebhook(models.Model):
    application_id = models.IntegerField()
    caller = models.CharField(max_length=30, blank=True, null=True)
    data = models.TextField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'abfl_webhook'


class AcceptableData(models.Model):
    user_id = models.IntegerField()
    application_id = models.IntegerField()
    applicant_age = models.CharField(max_length=191, blank=True, null=True)
    loan_term = models.CharField(max_length=191, blank=True, null=True)
    monthly_income = models.CharField(max_length=191, blank=True, null=True)
    income_proof = models.CharField(max_length=191, blank=True, null=True)
    loan_amount = models.CharField(max_length=191, blank=True, null=True)
    foir = models.CharField(max_length=191, blank=True, null=True)
    credit_score = models.CharField(max_length=191, blank=True, null=True)
    work_experience = models.CharField(max_length=191, blank=True, null=True)
    bank_statement_file = models.CharField(max_length=191, blank=True, null=True)
    abb_emi = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    work_experience_other = models.CharField(max_length=191, blank=True, null=True)
    product_verification = models.CharField(max_length=191, blank=True, null=True)
    negative_profession = models.CharField(max_length=191, blank=True, null=True)
    negative_profession_other = models.CharField(max_length=191, blank=True, null=True)
    applicant_age_other = models.CharField(max_length=191, blank=True, null=True)
    blood_relative_other = models.CharField(max_length=191, blank=True, null=True)
    blood_relative = models.CharField(max_length=191, blank=True, null=True)
    loan_term_other = models.CharField(max_length=191, blank=True, null=True)
    monthly_income_other = models.CharField(max_length=191, blank=True, null=True)
    income_proof_other = models.CharField(max_length=191, blank=True, null=True)
    salary = models.CharField(max_length=191, blank=True, null=True)
    salary_other = models.CharField(max_length=191, blank=True, null=True)
    bank_statement_file_other = models.CharField(max_length=191, blank=True, null=True)
    out_cb_eb_other = models.CharField(max_length=191, blank=True, null=True)
    out_cb_eb = models.CharField(max_length=191, blank=True, null=True)
    abb_emi_other = models.CharField(max_length=191, blank=True, null=True)
    min_balance_charge = models.CharField(max_length=191, blank=True, null=True)
    min_balance_charge_other = models.CharField(max_length=191, blank=True, null=True)
    suspicious_file_input = models.CharField(max_length=191, blank=True, null=True)
    suspicious_file_input_other = models.CharField(max_length=191, blank=True, null=True)
    credit_score_other = models.CharField(max_length=191, blank=True, null=True)
    foir_other = models.CharField(max_length=191, blank=True, null=True)
    writeen_settled_suit = models.CharField(max_length=191, blank=True, null=True)
    writeen_settled_suit_other = models.CharField(max_length=191, blank=True, null=True)
    dpd = models.CharField(max_length=191, blank=True, null=True)
    dpd_other = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'acceptable_data'


class AdminLoginLogs(models.Model):
    user_id = models.IntegerField()
    ip = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'admin_login_logs'


class AdviserServiceUpdate(models.Model):
    user_id = models.IntegerField()
    service_id = models.IntegerField()
    service_id_type = models.CharField(max_length=191)
    service_type = models.CharField(max_length=191)
    check_in_at = models.DateTimeField()
    check_out_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    check_in_longitude = models.CharField(max_length=191, blank=True, null=True)
    check_in_latitude = models.CharField(max_length=191, blank=True, null=True)
    check_out_longitude = models.CharField(max_length=191, blank=True, null=True)
    check_out_latitude = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'adviser_service_update'


class AdvisorLogs(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    previous_advisor_id = models.IntegerField(blank=True, null=True)
    current_advisor_id = models.IntegerField(blank=True, null=True)
    created_by = models.IntegerField(blank=True, null=True)
    status = models.IntegerField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'advisor_logs'


class AgencyApplication(models.Model):
    application_id = models.IntegerField()
    agreement_number = models.CharField(max_length=191, blank=True, null=True)
    name = models.CharField(max_length=191, blank=True, null=True)
    merchant_name = models.CharField(max_length=191, blank=True, null=True)
    agency_id = models.IntegerField()
    feedback = models.CharField(max_length=191, blank=True, null=True)
    amount = models.IntegerField(blank=True, null=True)
    created_by = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'agency_application'


class AppRating(models.Model):
    rating = models.CharField(max_length=191)
    feedback = models.TextField()
    user_id = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'app_rating'


class ApplicationDataLogs(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    data = models.TextField()
    status = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    user_id = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'application_data_logs'


class ApplicationRatings(models.Model):
    application_id = models.IntegerField()
    user_id = models.IntegerField()
    advisorissue = models.IntegerField(db_column='advisorIssue', blank=True, null=True)  # Field name made lowercase.
    disbtime = models.IntegerField(db_column='disbTime', blank=True, null=True)  # Field name made lowercase.
    docissue = models.IntegerField(db_column='docIssue', blank=True, null=True)  # Field name made lowercase.
    feedback = models.TextField(blank=True, null=True)
    rating = models.CharField(max_length=191, blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'application_ratings'


class ApprovalStatus(models.Model):
    application_id = models.IntegerField()
    negativeprofile = models.IntegerField(db_column='negativeProfile')  # Field name made lowercase.
    checkduplicates = models.IntegerField(db_column='checkDuplicates')  # Field name made lowercase.
    loan_amount = models.IntegerField()
    tenure = models.CharField(max_length=100)
    monthly_income = models.IntegerField()
    score = models.CharField(max_length=191)
    ageatlastemi = models.IntegerField(db_column='ageAtLastEMI')  # Field name made lowercase.
    age = models.IntegerField()
    abovethreeyear = models.IntegerField(db_column='aboveThreeYear')  # Field name made lowercase.
    threeyear = models.IntegerField(db_column='threeYear')  # Field name made lowercase.
    pastdues = models.IntegerField(db_column='pastDues')  # Field name made lowercase.
    termloan = models.IntegerField(db_column='termLoan')  # Field name made lowercase.
    casetype = models.CharField(db_column='caseType', max_length=100, blank=True, null=True)  # Field name made lowercase.
    status = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    error = models.IntegerField(blank=True, null=True)
    is_credit_card = models.IntegerField(blank=True, null=True)
    credit_limit_five_times = models.IntegerField(blank=True, null=True)
    accounttype = models.IntegerField(db_column='AccountType', blank=True, null=True)  # Field name made lowercase.
    foir = models.IntegerField(blank=True, null=True)
    cf_foir = models.IntegerField(blank=True, null=True)
    rejected = models.IntegerField(blank=True, null=True)
    guarantor = models.CharField(max_length=191, blank=True, null=True)
    downpayment = models.CharField(max_length=100, blank=True, null=True)
    address_status = models.CharField(max_length=100, blank=True, null=True)
    negative_area = models.CharField(max_length=100, blank=True, null=True)
    black_list = models.IntegerField()
    product_loan_amount = models.IntegerField()
    approved_pin = models.IntegerField(blank=True, null=True)
    last_payment_date = models.IntegerField(blank=True, null=True)
    amount_paid = models.IntegerField()
    amount_paid_cr = models.IntegerField()
    employee_status = models.CharField(max_length=191, blank=True, null=True)
    bank_validation = models.IntegerField()
    epf_verification = models.IntegerField()
    fetch_gst = models.IntegerField()
    indebtedness = models.IntegerField()
    experience = models.IntegerField()
    track_record = models.IntegerField()
    request_id = models.CharField(max_length=191, blank=True, null=True)
    reason = models.CharField(max_length=191, blank=True, null=True)
    dpdcountrejection = models.IntegerField(db_column='dpdCountRejection', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'approval_status'


class ApprovedPinCodes(models.Model):
    pin_codes = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    user_id = models.IntegerField(blank=True, null=True)
    agency_name = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'approved_pin_codes'


class ApprovedPinCodes20221100(models.Model):
    pin_codes = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    user_id = models.IntegerField(blank=True, null=True)
    agency_name = models.CharField(max_length=191, db_collation='utf8mb4_unicode_ci', blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'approved_pin_codes_2022_11_00'


class ApprovedPinCodes20221125(models.Model):
    pin_codes = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    user_id = models.IntegerField(blank=True, null=True)
    agency_name = models.CharField(max_length=191, db_collation='utf8mb4_unicode_ci', blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'approved_pin_codes_2022_11_25'


class ApprovedPinCodesTemp(models.Model):
    id = models.IntegerField(primary_key=True)
    pin_codes = models.IntegerField(blank=True, null=True)
    agency_name = models.CharField(max_length=200, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'approved_pin_codes_temp'


class AutoReject(models.Model):
    grade_id = models.IntegerField()
    min_score = models.CharField(max_length=191, blank=True, null=True)
    max_score = models.CharField(max_length=191, blank=True, null=True)
    past_dues = models.CharField(max_length=191, blank=True, null=True)
    foir = models.CharField(max_length=191, blank=True, null=True)
    max_dpd = models.CharField(max_length=191, blank=True, null=True)
    monthly_income = models.CharField(max_length=191, blank=True, null=True)
    age = models.CharField(max_length=191, blank=True, null=True)
    negative_area = models.IntegerField(blank=True, null=True)
    approved_pincode = models.IntegerField(blank=True, null=True)
    for_consumer = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'auto_reject'


class AutoRejectLock(models.Model):
    grade_id = models.IntegerField()
    min_score = models.CharField(max_length=191, blank=True, null=True)
    max_score = models.CharField(max_length=191, blank=True, null=True)
    past_dues = models.CharField(max_length=191, blank=True, null=True)
    foir = models.CharField(max_length=191, blank=True, null=True)
    max_dpd = models.CharField(max_length=191, blank=True, null=True)
    monthly_income = models.CharField(max_length=191, blank=True, null=True)
    age = models.CharField(max_length=191, blank=True, null=True)
    negative_area = models.IntegerField(blank=True, null=True)
    approved_pincode = models.IntegerField(blank=True, null=True)
    for_consumer = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    update_by = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'auto_reject_lock'


class AutoRejectLogs(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    reason = models.CharField(max_length=151, blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    request_id = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'auto_reject_logs'


class AutoWaiver(models.Model):
    waive_off_amt = models.CharField(max_length=191, blank=True, null=True)
    created_by = models.CharField(max_length=191, blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'auto_waiver'


class AvanseBreDecision(models.Model):
    partner_registration = models.CharField(max_length=191)
    decision = models.CharField(max_length=191)
    criteria_bureau_score_cutoff = models.CharField(max_length=191)
    criteria_bureau_90dpd_12mon = models.CharField(max_length=191)
    criteria_bureau_overdue = models.CharField(max_length=191)
    criteria_bureau_derog = models.CharField(max_length=191)
    criteria_geo_location = models.CharField(max_length=191)
    criteria_min_age = models.CharField(max_length=191)
    criteria_max_age = models.CharField(max_length=191)
    criteria_max_requested_loan_amount = models.CharField(max_length=191)
    criteria_min_requested_loan_amount = models.CharField(max_length=191)
    criteria_max_requested_loan_tenure = models.CharField(max_length=191)
    criteria_min_requested_loan_tenure = models.CharField(max_length=191)
    criteria_income = models.CharField(max_length=191)
    criteria_abb = models.CharField(max_length=191)
    criteria_politically_exposed_profile = models.CharField(max_length=191)
    criteria_real_estate_profile = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    application_id = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'avanse_bre_decision'


class AvanseCustomers(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    applicant_id = models.IntegerField()
    cif = models.IntegerField(blank=True, null=True)
    primaryrelationofficer = models.IntegerField(db_column='primaryRelationOfficer')  # Field name made lowercase.
    dedupreq = models.IntegerField(db_column='dedupReq')  # Field name made lowercase.
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    user_id = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'avanse_customers'


class AvanseDisbursement(models.Model):
    application_id = models.IntegerField()
    paymentid = models.CharField(db_column='paymentId', max_length=191)  # Field name made lowercase.
    finreference = models.CharField(db_column='finReference', max_length=191)  # Field name made lowercase.
    disbparty = models.CharField(db_column='disbParty', max_length=191)  # Field name made lowercase.
    disbtype = models.CharField(db_column='disbType', max_length=191)  # Field name made lowercase.
    disbdate = models.CharField(db_column='disbDate', max_length=191)  # Field name made lowercase.
    disbamount = models.CharField(db_column='disbAmount', max_length=191)  # Field name made lowercase.
    partnerbankid = models.CharField(db_column='partnerBankId', max_length=191)  # Field name made lowercase.
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'avanse_disbursement'


class AvanseDisbursementStatus(models.Model):
    application_id = models.IntegerField()
    finreference = models.CharField(db_column='finReference', max_length=191)  # Field name made lowercase.
    response = models.TextField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'avanse_disbursement_status'


class AvanseDocuments(models.Model):
    application_id = models.IntegerField()
    consumer_application_file_id = models.IntegerField()
    response = models.TextField()
    returntext = models.CharField(db_column='returnText', max_length=191, blank=True, null=True)  # Field name made lowercase.
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'avanse_documents'


class DocumentDetails(models.Model):
    consumer_file_id = models.IntegerField()
    application_id = models.IntegerField()
    doc_type = models.CharField(max_length=7, blank=True, null=True)
    json_data = models.JSONField()
    created_by = models.IntegerField()
    deleted_by = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'document_details'


class AvanseEarlySettlement(models.Model):
    application_id = models.IntegerField()
    response = models.TextField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'avanse_early_settlement'


class AvanseFeeDueInsuranceStep(models.Model):
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'avanse_fee_due_insurance_step'


class AvanseFees(models.Model):
    finance_id = models.IntegerField()
    feecategory = models.CharField(db_column='feeCategory', max_length=191)  # Field name made lowercase.
    feecode = models.CharField(db_column='feeCode', max_length=191)  # Field name made lowercase.
    feeamount = models.CharField(db_column='feeAmount', max_length=191)  # Field name made lowercase.
    waiveramount = models.CharField(db_column='waiverAmount', max_length=191)  # Field name made lowercase.
    paidamount = models.CharField(db_column='paidAmount', max_length=191)  # Field name made lowercase.
    feemethod = models.CharField(db_column='feeMethod', max_length=191)  # Field name made lowercase.
    scheduleterms = models.CharField(db_column='scheduleTerms', max_length=191)  # Field name made lowercase.
    feebalance = models.CharField(db_column='feeBalance', max_length=191)  # Field name made lowercase.
    finfeereceipts = models.TextField(db_column='finFeeReceipts')  # Field name made lowercase.
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'avanse_fees'


class AvanseFinSummary(models.Model):
    finance_id = models.IntegerField()
    effectiverateofreturn = models.CharField(db_column='effectiveRateOfReturn', max_length=191)  # Field name made lowercase.
    totalgracepft = models.CharField(db_column='totalGracePft', max_length=191)  # Field name made lowercase.
    totalgracecpz = models.CharField(db_column='totalGraceCpz', max_length=191)  # Field name made lowercase.
    totalgrossgrcpft = models.CharField(db_column='totalGrossGrcPft', max_length=191)  # Field name made lowercase.
    totalcpz = models.CharField(db_column='totalCpz', max_length=191)  # Field name made lowercase.
    totalprofit = models.CharField(db_column='totalProfit', max_length=191)  # Field name made lowercase.
    totalrepayamt = models.CharField(db_column='totalRepayAmt', max_length=191)  # Field name made lowercase.
    feechargeamount = models.CharField(db_column='feeChargeAmount', max_length=191)  # Field name made lowercase.
    numberofterms = models.CharField(db_column='numberOfTerms', max_length=191)  # Field name made lowercase.
    loantenor = models.CharField(db_column='loanTenor', max_length=191)  # Field name made lowercase.
    maturitydate = models.CharField(db_column='maturityDate', max_length=191)  # Field name made lowercase.
    firstemiamount = models.CharField(db_column='firstEmiAmount', max_length=191)  # Field name made lowercase.
    nextschdate = models.CharField(db_column='nextSchDate', max_length=191)  # Field name made lowercase.
    nextrepayamount = models.CharField(db_column='nextRepayAmount', max_length=191)  # Field name made lowercase.
    futureinst = models.CharField(db_column='futureInst', max_length=191)  # Field name made lowercase.
    futuretenor = models.CharField(db_column='futureTenor', max_length=191)  # Field name made lowercase.
    firstinstdate = models.CharField(db_column='firstInstDate', max_length=191)  # Field name made lowercase.
    paidtotal = models.CharField(db_column='paidTotal', max_length=191)  # Field name made lowercase.
    paidpri = models.CharField(db_column='paidPri', max_length=191)  # Field name made lowercase.
    paidpft = models.CharField(db_column='paidPft', max_length=191)  # Field name made lowercase.
    lastrepaydate = models.CharField(db_column='lastRepayDate', max_length=191)  # Field name made lowercase.
    outstandingtotal = models.CharField(db_column='outstandingTotal', max_length=191)  # Field name made lowercase.
    outstandingpri = models.CharField(db_column='outstandingPri', max_length=191)  # Field name made lowercase.
    outstandingpft = models.CharField(db_column='outstandingPft', max_length=191)  # Field name made lowercase.
    overduetotal = models.CharField(db_column='overdueTotal', max_length=191)  # Field name made lowercase.
    overduepri = models.CharField(db_column='overduePri', max_length=191)  # Field name made lowercase.
    overduepft = models.CharField(db_column='overduePft', max_length=191)  # Field name made lowercase.
    overdueinst = models.CharField(db_column='overdueInst', max_length=191)  # Field name made lowercase.
    overduecharges = models.TextField(db_column='overdueCharges')  # Field name made lowercase.
    advpaymentamount = models.CharField(db_column='advPaymentAmount', max_length=191)  # Field name made lowercase.
    finactivestatus = models.CharField(db_column='finActiveStatus', max_length=191)  # Field name made lowercase.
    fullydisb = models.CharField(db_column='fullyDisb', max_length=191)  # Field name made lowercase.
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'avanse_fin_summary'


class AvanseFinance(models.Model):
    application_id = models.IntegerField()
    finreference = models.CharField(db_column='finReference', max_length=191)  # Field name made lowercase.
    collateraloverride = models.CharField(db_column='collateralOverride', max_length=5)  # Field name made lowercase.
    outstandingpri = models.CharField(db_column='outstandingPri', max_length=191)  # Field name made lowercase.
    isupfrontauto = models.CharField(db_column='isUpfrontAuto', max_length=5)  # Field name made lowercase.
    receiptid = models.IntegerField(db_column='receiptId')  # Field name made lowercase.
    stp = models.CharField(max_length=5)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'avanse_finance'


class AvanseFinanceDetail(models.Model):
    finance_id = models.IntegerField()
    applicationno = models.CharField(db_column='applicationNo', max_length=191)  # Field name made lowercase.
    cif = models.IntegerField()
    fintype = models.CharField(db_column='finType', max_length=191)  # Field name made lowercase.
    finccy = models.CharField(db_column='finCcy', max_length=191)  # Field name made lowercase.
    finbranch = models.CharField(db_column='finBranch', max_length=191)  # Field name made lowercase.
    profitdaysbasis = models.CharField(db_column='profitDaysBasis', max_length=191)  # Field name made lowercase.
    finamount = models.CharField(db_column='finAmount', max_length=191)  # Field name made lowercase.
    finassetvalue = models.CharField(db_column='finAssetValue', max_length=191)  # Field name made lowercase.
    downpaybank = models.CharField(db_column='downPayBank', max_length=191)  # Field name made lowercase.
    downpaysupl = models.CharField(db_column='downPaySupl', max_length=191)  # Field name made lowercase.
    finrepaymethod = models.CharField(db_column='finRepayMethod', max_length=191)  # Field name made lowercase.
    finstartdate = models.CharField(db_column='finStartDate', max_length=191)  # Field name made lowercase.
    allowgrcperiod = models.CharField(db_column='allowGrcPeriod', max_length=191)  # Field name made lowercase.
    tdsapplicable = models.CharField(db_column='tdsApplicable', max_length=191)  # Field name made lowercase.
    manualschedule = models.CharField(db_column='manualSchedule', max_length=191)  # Field name made lowercase.
    plandefercount = models.CharField(db_column='planDeferCount', max_length=191)  # Field name made lowercase.
    stepfinance = models.CharField(db_column='stepFinance', max_length=191)  # Field name made lowercase.
    alwmanualsteps = models.CharField(db_column='alwManualSteps', max_length=191)  # Field name made lowercase.
    grcterms = models.CharField(db_column='grcTerms', max_length=191)  # Field name made lowercase.
    grcperiodenddate = models.CharField(db_column='grcPeriodEndDate', max_length=191)  # Field name made lowercase.
    grcratebasis = models.CharField(db_column='grcRateBasis', max_length=191)  # Field name made lowercase.
    grcpftrate = models.CharField(db_column='grcPftRate', max_length=191)  # Field name made lowercase.
    grcmargin = models.CharField(db_column='grcMargin', max_length=191)  # Field name made lowercase.
    grcprofitdaysbasis = models.CharField(db_column='grcProfitDaysBasis', max_length=191)  # Field name made lowercase.
    nextgrcpftrvwdate = models.CharField(db_column='nextGrcPftRvwDate', max_length=191)  # Field name made lowercase.
    nextgrccpzdate = models.CharField(db_column='nextGrcCpzDate', max_length=191)  # Field name made lowercase.
    allowgrcrepay = models.CharField(db_column='allowGrcRepay', max_length=191)  # Field name made lowercase.
    grcschdmthd = models.CharField(db_column='grcSchdMthd', max_length=191)  # Field name made lowercase.
    grcminrate = models.CharField(db_column='grcMinRate', max_length=191)  # Field name made lowercase.
    grcmaxrate = models.CharField(db_column='grcMaxRate', max_length=191)  # Field name made lowercase.
    grcmaxamount = models.CharField(db_column='grcMaxAmount', max_length=191)  # Field name made lowercase.
    grcadvpftrate = models.CharField(db_column='grcAdvPftRate', max_length=191)  # Field name made lowercase.
    grcadvmargin = models.CharField(db_column='grcAdvMargin', max_length=191)  # Field name made lowercase.
    numberofterms = models.CharField(db_column='numberOfTerms', max_length=191)  # Field name made lowercase.
    reqrepayamount = models.CharField(db_column='reqRepayAmount', max_length=191)  # Field name made lowercase.
    repayratebasis = models.CharField(db_column='repayRateBasis', max_length=191)  # Field name made lowercase.
    repaypftrate = models.CharField(db_column='repayPftRate', max_length=191)  # Field name made lowercase.
    repaymargin = models.CharField(db_column='repayMargin', max_length=191)  # Field name made lowercase.
    schedulemethod = models.CharField(db_column='scheduleMethod', max_length=191)  # Field name made lowercase.
    repayfrq = models.CharField(db_column='repayFrq', max_length=191)  # Field name made lowercase.
    nextrepaydate = models.CharField(db_column='nextRepayDate', max_length=191)  # Field name made lowercase.
    repaypftfrq = models.CharField(db_column='repayPftFrq', max_length=191)  # Field name made lowercase.
    nextrepaypftdate = models.CharField(db_column='nextRepayPftDate', max_length=191)  # Field name made lowercase.
    repayrvwfrq = models.CharField(db_column='repayRvwFrq', max_length=191)  # Field name made lowercase.
    nextrepayrvwdate = models.CharField(db_column='nextRepayRvwDate', max_length=191)  # Field name made lowercase.
    nextrepaycpzdate = models.CharField(db_column='nextRepayCpzDate', max_length=191)  # Field name made lowercase.
    maturitydate = models.CharField(db_column='maturityDate', max_length=191)  # Field name made lowercase.
    finrepaypftonfrq = models.CharField(db_column='finRepayPftOnFrq', max_length=191)  # Field name made lowercase.
    repayminrate = models.CharField(db_column='repayMinRate', max_length=191)  # Field name made lowercase.
    repaymaxrate = models.CharField(db_column='repayMaxRate', max_length=191)  # Field name made lowercase.
    repayadvpftrate = models.CharField(db_column='repayAdvPftRate', max_length=191)  # Field name made lowercase.
    repayadvmargin = models.CharField(db_column='repayAdvMargin', max_length=191)  # Field name made lowercase.
    supplementrent = models.CharField(db_column='supplementRent', max_length=191)  # Field name made lowercase.
    increasedcost = models.CharField(db_column='increasedCost', max_length=191)  # Field name made lowercase.
    dsacode = models.CharField(db_column='dsaCode', max_length=191)  # Field name made lowercase.
    accountsofficer = models.CharField(db_column='accountsOfficer', max_length=191)  # Field name made lowercase.
    dmacode = models.CharField(db_column='dmaCode', max_length=191)  # Field name made lowercase.
    quickdisb = models.CharField(db_column='quickDisb', max_length=191)  # Field name made lowercase.
    unplanemihlockperiod = models.CharField(db_column='unPlanEMIHLockPeriod', max_length=191)  # Field name made lowercase.
    unplanemicpz = models.CharField(db_column='unPlanEMICpz', max_length=191)  # Field name made lowercase.
    reagecpz = models.CharField(db_column='reAgeCpz', max_length=191)  # Field name made lowercase.
    maxunplannedemi = models.CharField(db_column='maxUnplannedEmi', max_length=191)  # Field name made lowercase.
    maxreageholidays = models.CharField(db_column='maxReAgeHolidays', max_length=191)  # Field name made lowercase.
    alwbpitreatment = models.CharField(db_column='alwBpiTreatment', max_length=191)  # Field name made lowercase.
    dftbpitreatment = models.CharField(db_column='dftBpiTreatment', max_length=191)  # Field name made lowercase.
    planemihalw = models.CharField(db_column='planEMIHAlw', max_length=191)  # Field name made lowercase.
    planemihmethod = models.CharField(db_column='planEMIHMethod', max_length=191)  # Field name made lowercase.
    planemihmaxperyear = models.CharField(db_column='planEMIHMaxPerYear', max_length=191)  # Field name made lowercase.
    planemihmax = models.CharField(db_column='planEMIHMax', max_length=191)  # Field name made lowercase.
    planemihlockperiod = models.CharField(db_column='planEMIHLockPeriod', max_length=191)  # Field name made lowercase.
    planemicpz = models.CharField(db_column='planEMICpz', max_length=191)  # Field name made lowercase.
    grcadvterms = models.CharField(db_column='grcAdvTerms', max_length=191)  # Field name made lowercase.
    advterms = models.CharField(db_column='advTerms', max_length=191)  # Field name made lowercase.
    advtype = models.CharField(db_column='advType', max_length=191)  # Field name made lowercase.
    advstage = models.CharField(db_column='advStage', max_length=191)  # Field name made lowercase.
    fixedratetenor = models.CharField(db_column='fixedRateTenor', max_length=191)  # Field name made lowercase.
    fixedtenorrate = models.CharField(db_column='fixedTenorRate', max_length=191)  # Field name made lowercase.
    fincurrassetvalue = models.CharField(db_column='finCurrAssetValue', max_length=191)  # Field name made lowercase.
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'avanse_finance_detail'


class AvanseMandate(models.Model):
    application_id = models.IntegerField()
    applicant_id = models.IntegerField()
    useexisting = models.CharField(db_column='useExisting', max_length=6)  # Field name made lowercase.
    mandateid = models.CharField(db_column='mandateID', max_length=191)  # Field name made lowercase.
    mandateref = models.CharField(db_column='mandateRef', max_length=191)  # Field name made lowercase.
    openmandate = models.CharField(db_column='openMandate', max_length=6)  # Field name made lowercase.
    status = models.CharField(max_length=191)
    partnerbankid = models.IntegerField(db_column='partnerBankId')  # Field name made lowercase.
    swap = models.CharField(max_length=6)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'avanse_mandate'


class AvanseManualPaymentLogs(models.Model):
    bulk_id = models.IntegerField(blank=True, null=True)
    application_id = models.IntegerField()
    status = models.IntegerField()
    message = models.TextField()
    response = models.TextField()
    attempt = models.IntegerField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'avanse_manual_payment_logs'


class AvanseNoc(models.Model):
    application_id = models.CharField(max_length=191)
    is_available = models.IntegerField()
    execution_status = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'avanse_noc'


class AvanseRequests(models.Model):
    message_id = models.CharField(max_length=191)
    application_id = models.IntegerField()
    api = models.CharField(max_length=191)
    request = models.TextField()
    response = models.TextField()
    headers = models.TextField(blank=True, null=True)
    start_time = models.DateTimeField(blank=True, null=True)
    end_time = models.DateTimeField(blank=True, null=True)
    user_id = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'avanse_requests'


class AvanseSchedules(models.Model):
    finance_id = models.IntegerField()
    schdate = models.CharField(db_column='schDate', max_length=191)  # Field name made lowercase.
    pftamount = models.CharField(db_column='pftAmount', max_length=191)  # Field name made lowercase.
    schdpft = models.CharField(db_column='schdPft', max_length=191)  # Field name made lowercase.
    schdpftpaid = models.CharField(db_column='schdPftPaid', max_length=191)  # Field name made lowercase.
    schdpri = models.CharField(db_column='schdPri', max_length=191)  # Field name made lowercase.
    schdpripaid = models.CharField(db_column='schdPriPaid', max_length=191)  # Field name made lowercase.
    feeschd = models.CharField(db_column='feeSchd', max_length=191)  # Field name made lowercase.
    tdsamount = models.CharField(db_column='tDSAmount', max_length=191)  # Field name made lowercase.
    totalamount = models.CharField(db_column='totalAmount', max_length=191)  # Field name made lowercase.
    endbal = models.CharField(db_column='endBal', max_length=191)  # Field name made lowercase.
    limitdrop = models.CharField(db_column='limitDrop', max_length=191)  # Field name made lowercase.
    droplinelimit = models.CharField(db_column='dropLineLimit', max_length=191)  # Field name made lowercase.
    availablelimit = models.CharField(db_column='availableLimit', max_length=191)  # Field name made lowercase.
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'avanse_schedules'


class AvanseWebhook(models.Model):
    application_id = models.IntegerField()
    caller = models.CharField(max_length=191, blank=True, null=True)
    data = models.TextField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'avanse_webhook'


class Bank(models.Model):
    user_id = models.IntegerField(blank=True, null=True)
    applicant_type = models.IntegerField()
    application_id = models.IntegerField(blank=True, null=True)
    name = models.CharField(max_length=191, blank=True, null=True)
    account_type = models.CharField(max_length=191, blank=True, null=True)
    bank_name = models.CharField(max_length=191)
    account_number = models.CharField(max_length=191)
    branch_name = models.CharField(max_length=191)
    ifsc_code = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    karza_response = models.TextField(blank=True, null=True)
    bank_ifsc_code = models.CharField(max_length=191, blank=True, null=True)
    beneficiary_id = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'bank'


class Blacklist(models.Model):
    user_id = models.CharField(max_length=191)
    document_value = models.TextField()
    document_type = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'blacklist'


class BorrowerRules(models.Model):
    category_id = models.CharField(max_length=7, blank=True, null=True)
    interest_rate = models.IntegerField(blank=True, null=True)
    tenure = models.IntegerField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'borrower_rules'


class BounceTransactions(models.Model):
    finbit_uid = models.CharField(max_length=191)
    application_id = models.IntegerField()
    transsaction_type = models.CharField(max_length=191)
    date = models.CharField(max_length=191, blank=True, null=True)
    amount = models.CharField(max_length=191, blank=True, null=True)
    description = models.CharField(max_length=191, blank=True, null=True)
    balance = models.CharField(max_length=191, blank=True, null=True)
    category = models.CharField(max_length=191, blank=True, null=True)
    remark = models.CharField(max_length=191, blank=True, null=True)
    transactiontype = models.CharField(db_column='transactionType', max_length=191, blank=True, null=True)  # Field name made lowercase.
    bank = models.CharField(max_length=191, blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'bounce_transactions'


class BulkPayments(models.Model):
    from_field = models.CharField(db_column='from', max_length=191)  # Field renamed because it was a Python reserved word.
    payload = models.TextField()
    application_id = models.IntegerField()
    is_available = models.IntegerField(blank=True, null=True)
    execution_status = models.TextField(blank=True, null=True)
    available_at = models.DateTimeField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    send_to_lender = models.IntegerField()
    communication = models.IntegerField()
    communication_data = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'bulk_payments'


class Bureau(models.Model):
    unique_id = models.CharField(max_length=119, blank=True, null=True)
    application_id = models.IntegerField()
    bureau_name = models.CharField(max_length=119, blank=True, null=True)
    raw_bureau_data = models.TextField(blank=True, null=True)
    converted_bureau_data = models.TextField(blank=True, null=True)
    applicant_type = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'bureau'


class CallLogs(models.Model):
    user_id = models.IntegerField()
    field_id = models.IntegerField(db_column='_id')  # Field renamed because it started with '_'.
    id_type = models.CharField(max_length=191)
    to = models.CharField(max_length=191)
    from_field = models.CharField(db_column='from', max_length=191)  # Field renamed because it was a Python reserved word.
    message = models.CharField(max_length=191, blank=True, null=True)
    error = models.CharField(max_length=191, blank=True, null=True)
    description = models.TextField(blank=True, null=True)
    recording = models.TextField(blank=True, null=True)
    sid = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    direction = models.CharField(max_length=191, blank=True, null=True)
    status = models.CharField(max_length=191, blank=True, null=True)
    starttime = models.DateTimeField(db_column='startTime', blank=True, null=True)  # Field name made lowercase.
    endtime = models.DateTimeField(db_column='endTime', blank=True, null=True)  # Field name made lowercase.
    duration = models.CharField(max_length=191, blank=True, null=True)
    purpose = models.CharField(max_length=191, blank=True, null=True)
    received_by = models.CharField(max_length=191, blank=True, null=True)
    s3 = models.IntegerField(blank=True, null=True)
    missed_call_alert = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'call_logs'


class CallbackRequests(models.Model):
    mobile_number = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'callback_requests'


class Campaign(models.Model):
    campaign_name = models.CharField(max_length=191)
    query = models.TextField()
    schedule = models.CharField(max_length=191)
    is_schedule = models.IntegerField(blank=True, null=True)
    message = models.TextField()
    total = models.IntegerField(blank=True, null=True)
    sms = models.IntegerField(blank=True, null=True)
    whatsapp = models.IntegerField(blank=True, null=True)
    email = models.IntegerField(blank=True, null=True)
    campaigned_by = models.IntegerField()
    re_promoted_count = models.IntegerField(blank=True, null=True)
    re_promoted_campaign_id = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    non_english = models.IntegerField(blank=True, null=True)
    from_email = models.CharField(max_length=191, blank=True, null=True)
    attachments = models.TextField(blank=True, null=True)
    exceldata = models.TextField(db_column='excelData', blank=True, null=True)  # Field name made lowercase.
    fcm_notification = models.IntegerField(blank=True, null=True)
    tracking_url = models.CharField(max_length=191, blank=True, null=True)
    template_id = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'campaign'


class CampaignTracking(models.Model):
    campaign_id = models.IntegerField()
    payload = models.TextField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    impression = models.IntegerField(blank=True, null=True)
    user_id = models.IntegerField(blank=True, null=True)
    source = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'campaign_tracking'


class CampaignsJobs(models.Model):
    from_field = models.CharField(db_column='from', max_length=191)  # Field renamed because it was a Python reserved word.
    payload = models.TextField()
    application_id = models.IntegerField()
    available_at = models.DateTimeField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    is_available = models.IntegerField(blank=True, null=True)
    applicant_type = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'campaigns_jobs'


class CancellationDisbursement(models.Model):
    application_id = models.IntegerField()
    merchant_id = models.IntegerField(blank=True, null=True)
    cancellation_interest_charges = models.CharField(max_length=191)
    cancellation_fixed_charges = models.CharField(max_length=191, blank=True, null=True)
    total_amount_adjusted = models.CharField(max_length=191)
    total_amount_before_adjusted = models.CharField(max_length=191, blank=True, null=True)
    adjusted_by = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    adjusted_to = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'cancellation_disbursement'


class Careers(models.Model):
    title = models.CharField(max_length=191)
    department_id = models.IntegerField()
    status = models.CharField(max_length=191)
    location = models.CharField(max_length=191)
    requirement = models.TextField()
    expectation = models.TextField()
    description = models.TextField()
    user_id = models.IntegerField()
    updated_by = models.IntegerField(blank=True, null=True)
    deleted_by = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'careers'


class Centers(models.Model):
    merchant_id = models.IntegerField()
    name = models.CharField(max_length=191)
    city = models.CharField(max_length=191)
    area = models.CharField(max_length=191)
    pincode = models.IntegerField()
    status = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'centers'


class CfPayoutBeneficiary(models.Model):
    beneid = models.CharField(db_column='beneId', max_length=191, blank=True, null=True)  # Field name made lowercase.
    name = models.CharField(max_length=191)
    groupname = models.CharField(db_column='groupName', max_length=191)  # Field name made lowercase.
    email = models.CharField(max_length=191)
    phone = models.CharField(max_length=191)
    bankaccount = models.CharField(db_column='bankAccount', max_length=191)  # Field name made lowercase.
    ifsc = models.CharField(max_length=191)
    address = models.CharField(max_length=200)
    city = models.CharField(max_length=191)
    state = models.CharField(max_length=191)
    pincode = models.CharField(max_length=191)
    status = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'cf_payout_beneficiary'


class CfPayoutDirectTransfer(models.Model):
    application_id = models.IntegerField()
    transferid = models.CharField(db_column='transferId', max_length=191)  # Field name made lowercase.
    referenceid = models.CharField(db_column='referenceId', max_length=191)  # Field name made lowercase.
    utr = models.CharField(max_length=191)
    acknowledged = models.IntegerField()
    message = models.CharField(max_length=191, blank=True, null=True)
    retry = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    is_refund = models.IntegerField()
    phase = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'cf_payout_direct_transfer'


class CfPayoutPreserve(models.Model):
    api = models.TextField()
    request = models.TextField()
    response = models.TextField()
    user_id = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'cf_payout_preserve'


class CfPayoutRequestTransfer(models.Model):
    application_id = models.IntegerField()
    beneid = models.CharField(db_column='beneId', max_length=191)  # Field name made lowercase.
    amount = models.CharField(max_length=191)
    transferid = models.CharField(db_column='transferId', max_length=191)  # Field name made lowercase.
    referenceid = models.CharField(db_column='referenceId', max_length=191)  # Field name made lowercase.
    utr = models.CharField(max_length=191)
    acknowledged = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'cf_payout_request_transfer'


class CfPayoutRequestTransferStatus(models.Model):
    application_id = models.IntegerField()
    referenceid = models.IntegerField(db_column='referenceId')  # Field name made lowercase.
    transferid = models.CharField(db_column='transferId', max_length=191, blank=True, null=True)  # Field name made lowercase.
    bankaccount = models.CharField(db_column='bankAccount', max_length=191)  # Field name made lowercase.
    beneid = models.CharField(db_column='beneId', max_length=191)  # Field name made lowercase.
    amount = models.CharField(max_length=191)
    status = models.CharField(max_length=191)
    utr = models.CharField(max_length=191, blank=True, null=True)
    addedon = models.CharField(db_column='addedOn', max_length=191)  # Field name made lowercase.
    processedon = models.CharField(db_column='processedOn', max_length=191)  # Field name made lowercase.
    acknowledged = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'cf_payout_request_transfer_status'


class CfPayoutWebhook(models.Model):
    event = models.CharField(max_length=191)
    transferid = models.CharField(db_column='transferId', max_length=191)  # Field name made lowercase.
    referenceid = models.CharField(db_column='referenceId', max_length=191)  # Field name made lowercase.
    acknowledged = models.IntegerField()
    eventtime = models.DateTimeField(db_column='eventTime')  # Field name made lowercase.
    utr = models.CharField(max_length=191)
    signature = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'cf_payout_webhook'


class ChargedInvoices(models.Model):
    application_id = models.IntegerField()
    invoice_id = models.CharField(max_length=191, blank=True, null=True)
    lender_id = models.IntegerField(blank=True, null=True)
    amount = models.CharField(max_length=191)
    igst = models.CharField(max_length=191)
    cgst = models.CharField(max_length=191)
    sgst = models.CharField(max_length=191)
    invoice_date = models.CharField(max_length=191)
    type = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    version = models.CharField(max_length=191, blank=True, null=True)
    gst_filing_confirmed = models.DateTimeField(blank=True, null=True)
    gst_filing_confirmed_by = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'charged_invoices'


class Checklist(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    linkedin = models.CharField(max_length=255, blank=True, null=True)
    facebook = models.CharField(max_length=255, blank=True, null=True)
    tele_verification = models.IntegerField(blank=True, null=True)
    writeen_settled_suit = models.IntegerField(blank=True, null=True)
    salary = models.IntegerField(blank=True, null=True)
    no_debit_chq_bounce_ecs = models.IntegerField(blank=True, null=True)
    regular_high_value = models.IntegerField(blank=True, null=True)
    average_balance = models.IntegerField(blank=True, null=True)
    joining_date = models.DateTimeField(blank=True, null=True)
    residing = models.IntegerField(blank=True, null=True)
    designation = models.CharField(max_length=255, blank=True, null=True)
    verify_pro_crt = models.IntegerField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    blood_relative = models.IntegerField()
    reference_taken = models.IntegerField()
    pl_gl_taken = models.IntegerField()
    bank_statement_file = models.IntegerField()
    out_cb_eb = models.IntegerField()
    abb_emi = models.IntegerField()
    in_cb = models.IntegerField()
    min_balance_charge = models.IntegerField()
    utility_bill_verified = models.IntegerField(blank=True, null=True)
    cpv_ic = models.IntegerField(blank=True, null=True)
    negative_profession = models.IntegerField(blank=True, null=True)
    experience = models.IntegerField(blank=True, null=True)
    permanent_address_document = models.IntegerField()
    current_address_document = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'checklist'


class CibilBureau(models.Model):
    application_id = models.IntegerField()
    srno = models.IntegerField(db_column='srNo')  # Field name made lowercase.
    remarks = models.CharField(max_length=191)
    band = models.IntegerField()
    totalobligation = models.IntegerField(db_column='totalObligation')  # Field name made lowercase.
    past30daysenq = models.IntegerField(db_column='past30daysEnq')  # Field name made lowercase.
    past12monthsenq = models.IntegerField(db_column='past12MonthsEnq')  # Field name made lowercase.
    past24monthsenq = models.IntegerField(db_column='past24MonthsEnq')  # Field name made lowercase.
    description = models.CharField(max_length=191)
    additionalmatch = models.CharField(db_column='additionalMatch', max_length=191)  # Field name made lowercase.
    response = models.TextField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    applicant_type = models.IntegerField(blank=True, null=True)
    dpd30_12month = models.CharField(max_length=191, blank=True, null=True)
    dpd90_12month = models.CharField(max_length=191, blank=True, null=True)
    total_overdue = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'cibil_bureau'


class Cities(models.Model):
    name = models.CharField(max_length=191)
    state_id = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'cities'


class CoApplicateValidationLogs(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    user_id = models.IntegerField(blank=True, null=True)
    co_applicant_type = models.CharField(max_length=191, blank=True, null=True)
    previous_tatus = models.CharField(max_length=191, blank=True, null=True)
    new_status = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'co_applicate_validation_logs'


class Comments(models.Model):
    application_id = models.IntegerField()
    user_id = models.IntegerField()
    comment = models.TextField()
    show_consumer = models.IntegerField(blank=True, null=True)
    show_merchant = models.IntegerField(blank=True, null=True)
    created_at = models.DateTimeField()
    updated_at = models.DateTimeField()
    type = models.CharField(max_length=255, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    date_reminder = models.CharField(max_length=191, blank=True, null=True)
    whom_to = models.CharField(max_length=191, blank=True, null=True)
    sms = models.IntegerField(blank=True, null=True)
    whatsapp = models.IntegerField(blank=True, null=True)
    email = models.IntegerField(blank=True, null=True)
    request_review = models.IntegerField(blank=True, null=True)
    show_avanse = models.IntegerField()
    slack = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'comments'


class CommunicationMapping(models.Model):
    merchant_id = models.IntegerField()
    type_ids = models.CharField(max_length=191, blank=True, null=True)
    communication_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'communication_mapping'


class Company(models.Model):
    category = models.CharField(max_length=100, blank=True, null=True)
    company = models.CharField(max_length=200, blank=True, null=True)
    # cin = models.CharField(max_length=191, blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'company'


class ConsentLog(models.Model):
    application_id = models.IntegerField()
    ips = models.CharField(max_length=191)
    latitude = models.CharField(max_length=191)
    longitude = models.CharField(max_length=191)
    status = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'consent_log'


class ConsumerApiRequests(models.Model):
    uri = models.TextField(blank=True, null=True)
    enc = models.TextField(blank=True, null=True)
    enc_r = models.TextField(blank=True, null=True)
    dec_r = models.TextField(blank=True, null=True)
    dec = models.TextField(blank=True, null=True)
    token = models.TextField(blank=True, null=True)
    user_id = models.IntegerField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    source = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'consumer_api_requests'


class ConsumerApplication(models.Model):
    user_id = models.IntegerField(blank=True, null=True)
    merchant_id = models.IntegerField(blank=True, null=True)
    merchant_location_id = models.IntegerField(blank=True, null=True)
    name = models.CharField(max_length=191, blank=True, null=True)
    email = models.CharField(max_length=191, blank=True, null=True)
    mobile_number = models.CharField(max_length=191, blank=True, null=True)
    gender = models.CharField(max_length=6, blank=True, null=True)
    tenure = models.IntegerField(blank=True, null=True)
    purpose = models.CharField(max_length=191, blank=True, null=True)
    loan_amount = models.CharField(max_length=191, blank=True, null=True)
    # lender_id = models.IntegerField(blank=True, null=True)
    lender = models.OneToOneField(Lenders, on_delete=models.CASCADE)
    approved_amount = models.BigIntegerField()
    src_merchant_name = models.CharField(max_length=200, blank=True, null=True)
    src_representative_name = models.CharField(max_length=191, blank=True, null=True)
    # official_email = models.CharField(max_length=191, blank=True, null=True)
    # facebook_link = models.CharField(max_length=191, blank=True, null=True)
    # linkedin_link = models.CharField(max_length=191, blank=True, null=True)
    pan_card = models.CharField(max_length=255, blank=True, null=True)
    aadhaar_card = models.CharField(max_length=255, blank=True, null=True)
    dob = models.DateField(blank=True, null=True)
    marital_status = models.CharField(max_length=7, blank=True, null=True)
    current_address_line_1 = models.CharField(max_length=191, blank=True, null=True)
    current_address_state = models.CharField(max_length=191, blank=True, null=True)
    current_address_city = models.CharField(max_length=191, blank=True, null=True)
    current_address_pincode = models.CharField(max_length=191, blank=True, null=True)
    current_address_landmark = models.CharField(max_length=191, blank=True, null=True)
    current_address_status = models.CharField(max_length=18, blank=True, null=True)
    permanent_address_line_1 = models.CharField(max_length=191, blank=True, null=True)
    permanent_address_state = models.CharField(max_length=191, blank=True, null=True)
    permanent_address_city = models.CharField(max_length=191, blank=True, null=True)
    permanent_address_pincode = models.CharField(max_length=191, blank=True, null=True)
    permanent_address_landmark = models.CharField(max_length=191, blank=True, null=True)
    permanent_address_status = models.CharField(max_length=18, blank=True, null=True)
    employee_status = models.CharField(max_length=28, blank=True, null=True)
    monthly_income = models.IntegerField(blank=True, null=True)
    company_name = models.CharField(max_length=191, blank=True, null=True)
    company_number = models.CharField(max_length=191, blank=True, null=True)
    experience = models.IntegerField(blank=True, null=True)
    contact_address = models.CharField(max_length=191, blank=True, null=True)
    work_address_line_1 = models.CharField(max_length=191, blank=True, null=True)
    work_address_state = models.CharField(max_length=191, blank=True, null=True)
    work_address_city = models.CharField(max_length=191, blank=True, null=True)
    work_address_pincode = models.CharField(max_length=191, blank=True, null=True)
    work_address_landmark = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_name = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_relationship = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_dob = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_gender = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_pan_card = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_aadhaar_card = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_email = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_mobile_number = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_address_line_1 = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_address_state = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_address_pincode = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_address_city = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_address_landmark = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_required = models.IntegerField(blank=True, null=True)
    state = models.CharField(max_length=191, blank=True, null=True)
    completed_stage = models.IntegerField(blank=True, null=True)
    additional_docs_list = models.CharField(max_length=1023, blank=True, null=True)
    assigned_to = models.CharField(max_length=191, blank=True, null=True)
    additional_docs = models.IntegerField(blank=True, null=True)
    file_income_proof = models.CharField(max_length=1023, blank=True, null=True)
    file_bank_statement = models.CharField(max_length=1023, blank=True, null=True)
    file_pan_card = models.CharField(max_length=1023, blank=True, null=True)
    file_aadhaar_card = models.CharField(max_length=1023, blank=True, null=True)
    file_electricity_bill = models.CharField(max_length=1023, blank=True, null=True)
    credit_score = models.CharField(max_length=191, blank=True, null=True)
    rejection_reason = models.CharField(max_length=191, blank=True, null=True)
    misc_info = models.CharField(max_length=191, blank=True, null=True)
    updated_by = models.CharField(max_length=191, blank=True, null=True)
    remember_token = models.CharField(max_length=100, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    is_deleted = models.IntegerField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    alt_contact_number = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_address_status = models.CharField(max_length=13, blank=True, null=True)
    co_applicant_employee_status = models.CharField(max_length=10, blank=True, null=True)
    co_applicant_monthly_income = models.IntegerField(blank=True, null=True)
    co_applicant_company_name = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_company_number = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_experience = models.IntegerField(blank=True, null=True)
    # joining_date = models.DateField(blank=True, null=True)
    created_by = models.IntegerField(blank=True, null=True)
    offer_id = models.IntegerField(blank=True, null=True)
    pre_created_by = models.IntegerField(blank=True, null=True)
    applicant_id = models.IntegerField(blank=True, null=True)
    co_applicant_id = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'consumer_application'


class ConsumerApplicationArchive(models.Model):
    user_id = models.IntegerField(blank=True, null=True)
    merchant_id = models.IntegerField(blank=True, null=True)
    merchant_location_id = models.IntegerField(blank=True, null=True)
    name = models.CharField(max_length=191, blank=True, null=True)
    email = models.CharField(max_length=191, blank=True, null=True)
    mobile_number = models.CharField(max_length=191, blank=True, null=True)
    gender = models.CharField(max_length=6, blank=True, null=True)
    tenure = models.IntegerField(blank=True, null=True)
    purpose = models.CharField(max_length=191, blank=True, null=True)
    loan_amount = models.CharField(max_length=191, blank=True, null=True)
    lender_id = models.IntegerField(blank=True, null=True)
    approved_amount = models.BigIntegerField()
    src_merchant_name = models.CharField(max_length=200, blank=True, null=True)
    src_representative_name = models.CharField(max_length=191, blank=True, null=True)
    official_email = models.CharField(max_length=191, blank=True, null=True)
    facebook_link = models.CharField(max_length=191, blank=True, null=True)
    linkedin_link = models.CharField(max_length=191, blank=True, null=True)
    pan_card = models.CharField(max_length=255, blank=True, null=True)
    aadhaar_card = models.CharField(max_length=255, blank=True, null=True)
    dob = models.DateField(blank=True, null=True)
    marital_status = models.CharField(max_length=7, blank=True, null=True)
    current_address_line_1 = models.CharField(max_length=191, blank=True, null=True)
    current_address_state = models.CharField(max_length=191, blank=True, null=True)
    current_address_city = models.CharField(max_length=191, blank=True, null=True)
    current_address_pincode = models.CharField(max_length=191, blank=True, null=True)
    current_address_landmark = models.CharField(max_length=191, blank=True, null=True)
    current_address_status = models.CharField(max_length=18, blank=True, null=True)
    permanent_address_line_1 = models.CharField(max_length=191, blank=True, null=True)
    permanent_address_state = models.CharField(max_length=191, blank=True, null=True)
    permanent_address_city = models.CharField(max_length=191, blank=True, null=True)
    permanent_address_pincode = models.CharField(max_length=191, blank=True, null=True)
    permanent_address_landmark = models.CharField(max_length=191, blank=True, null=True)
    permanent_address_status = models.CharField(max_length=18, blank=True, null=True)
    employee_status = models.CharField(max_length=28, blank=True, null=True)
    monthly_income = models.IntegerField(blank=True, null=True)
    company_name = models.CharField(max_length=191, blank=True, null=True)
    company_number = models.CharField(max_length=191, blank=True, null=True)
    experience = models.IntegerField(blank=True, null=True)
    contact_address = models.CharField(max_length=191, blank=True, null=True)
    work_address_line_1 = models.CharField(max_length=191, blank=True, null=True)
    work_address_state = models.CharField(max_length=191, blank=True, null=True)
    work_address_city = models.CharField(max_length=191, blank=True, null=True)
    work_address_pincode = models.CharField(max_length=191, blank=True, null=True)
    work_address_landmark = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_name = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_relationship = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_dob = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_gender = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_pan_card = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_aadhaar_card = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_email = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_mobile_number = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_address_line_1 = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_address_state = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_address_pincode = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_address_city = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_address_landmark = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_required = models.IntegerField(blank=True, null=True)
    state = models.CharField(max_length=191, blank=True, null=True)
    completed_stage = models.IntegerField(blank=True, null=True)
    additional_docs_list = models.CharField(max_length=1023, blank=True, null=True)
    assigned_to = models.CharField(max_length=191, blank=True, null=True)
    additional_docs = models.IntegerField(blank=True, null=True)
    file_income_proof = models.CharField(max_length=1023, blank=True, null=True)
    file_bank_statement = models.CharField(max_length=1023, blank=True, null=True)
    file_pan_card = models.CharField(max_length=1023, blank=True, null=True)
    file_aadhaar_card = models.CharField(max_length=1023, blank=True, null=True)
    file_electricity_bill = models.CharField(max_length=1023, blank=True, null=True)
    credit_score = models.CharField(max_length=191, blank=True, null=True)
    rejection_reason = models.CharField(max_length=191, blank=True, null=True)
    misc_info = models.CharField(max_length=191, blank=True, null=True)
    updated_by = models.CharField(max_length=191, blank=True, null=True)
    remember_token = models.CharField(max_length=100, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    is_deleted = models.IntegerField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    alt_contact_number = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_address_status = models.CharField(max_length=13, blank=True, null=True)
    co_applicant_employee_status = models.CharField(max_length=10, blank=True, null=True)
    co_applicant_monthly_income = models.IntegerField(blank=True, null=True)
    co_applicant_company_name = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_company_number = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_experience = models.IntegerField(blank=True, null=True)
    joining_date = models.DateField(blank=True, null=True)
    created_by = models.IntegerField(blank=True, null=True)
    offer_id = models.IntegerField(blank=True, null=True)
    pre_created_by = models.IntegerField(blank=True, null=True)
    applicant_id = models.IntegerField(blank=True, null=True)
    co_applicant_id = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'consumer_application_archive'


class ConsumerApplicationElement(models.Model):
    application = models.OneToOneField(ConsumerApplication, on_delete=models.CASCADE)
    # application_id = models.IntegerField(blank=True, null=True)
    industry = models.IntegerField(blank=True, null=True)
    profession_type = models.IntegerField(blank=True, null=True)
    co_applicant_industry = models.IntegerField(blank=True, null=True)
    co_applicant_profession_type = models.IntegerField(blank=True, null=True)
    negative_profile = models.IntegerField(blank=True, null=True)
    work_email = models.CharField(max_length=255, blank=True, null=True)
    center_id = models.IntegerField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    gst_number = models.CharField(max_length=191, blank=True, null=True)
    current_address_lat_long = models.CharField(max_length=100, blank=True, null=True)
    permanent_address_lat_long = models.CharField(max_length=100, blank=True, null=True)
    current_address_text = models.TextField(blank=True, null=True)
    current_formatted_text = models.TextField(blank=True, null=True)
    permanent_address_text = models.TextField(blank=True, null=True)
    permanent_formatted_text = models.TextField(blank=True, null=True)
    designation = models.CharField(max_length=191, blank=True, null=True)
    department = models.CharField(max_length=191, blank=True, null=True)
    contact = models.CharField(max_length=191, blank=True, null=True)
    is_auto_approved = models.IntegerField(blank=True, null=True)
    telecom_response = models.TextField(blank=True, null=True)
    product_name = models.CharField(max_length=191, blank=True, null=True)
    foreclosure_date = models.DateField(blank=True, null=True)
    is_reviewed = models.IntegerField(blank=True, null=True)
    preferred_language = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_for_signing = models.IntegerField(blank=True, null=True)
    co_applicant_for_income = models.IntegerField(blank=True, null=True)
    bank_id = models.IntegerField(blank=True, null=True)
    mandatory_document_list = models.TextField(blank=True, null=True)
    auto_document_rule_id = models.IntegerField(blank=True, null=True)
    amount_over_due = models.IntegerField(blank=True, null=True)
    total_amount_due = models.IntegerField(blank=True, null=True)
    last_emi_date = models.DateField(blank=True, null=True)
    emi_paid = models.IntegerField(blank=True, null=True)
    emi_pending = models.IntegerField(blank=True, null=True)
    pre_approval_id = models.IntegerField(blank=True, null=True)
    agreement_version = models.IntegerField(blank=True, null=True)
    product_id = models.CharField(max_length=191, blank=True, null=True)
    duration = models.CharField(max_length=20, blank=True, null=True)
    collection_advisor = models.IntegerField()
    payment_transfer_date = models.CharField(max_length=191, blank=True, null=True)
    hold_amount = models.CharField(max_length=191, blank=True, null=True)
    withhold_adjusted = models.IntegerField()
    reason_for_loan = models.CharField(max_length=191, blank=True, null=True)
    is_payout = models.IntegerField()
    reference_name_1 = models.CharField(max_length=191, blank=True, null=True)
    reference_name_2 = models.CharField(max_length=191, blank=True, null=True)
    reference_contact_1 = models.CharField(max_length=191, blank=True, null=True)
    reference_contact_2 = models.CharField(max_length=191, blank=True, null=True)
    reference_relation_1 = models.CharField(max_length=191, blank=True, null=True)
    reference_relation_2 = models.CharField(max_length=191, blank=True, null=True)
    onfido_skip = models.IntegerField()
    agreement_resign = models.IntegerField()
    nominee_salutation = models.CharField(max_length=3, blank=True, null=True)
    nominee_full_name = models.CharField(max_length=191, blank=True, null=True)
    nominee_dob = models.CharField(max_length=10, blank=True, null=True)
    nominee_gender = models.IntegerField(blank=True, null=True)
    nominee_relationship = models.CharField(max_length=191, blank=True, null=True)
    nominee_mobile_number = models.CharField(max_length=191, blank=True, null=True)
    soft_lead = models.IntegerField()
    video_kyc = models.CharField(max_length=191, blank=True, null=True)
    reference_number = models.CharField(max_length=191, blank=True, null=True)
    disbursement_sent = models.IntegerField()
    co_app_onfido_skip = models.IntegerField()
    merchant_representative_name = models.CharField(max_length=191, blank=True, null=True)
    merchant_representative_mobile = models.CharField(max_length=191, blank=True, null=True)
    merchant_representative_email = models.CharField(max_length=191, blank=True, null=True)
    babyready_user_id = models.IntegerField(blank=True, null=True)
    unique_id_number = models.CharField(max_length=191, blank=True, null=True)
    avanse_customer_id = models.IntegerField(blank=True, null=True)
    co_applicant_designation = models.CharField(max_length=191, blank=True, null=True)
    admission_status = models.CharField(max_length=191, blank=True, null=True)
    is_consent = models.IntegerField()
    is_bnpl = models.IntegerField()
    principal_due = models.IntegerField()
    total_principal_due = models.IntegerField()
    father_name = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_father_name = models.CharField(max_length=191, blank=True, null=True)
    repayment_type = models.IntegerField()
    disb_query_reasons = models.TextField(blank=True, null=True)
    multi_tranche_exception_list = models.TextField(blank=True, null=True)
    vendor_id = models.IntegerField(blank=True, null=True)
    inverter = models.CharField(max_length=191, blank=True, null=True)
    inverter_model_description = models.CharField(max_length=191, blank=True, null=True)
    inverter_monthly_power_bill = models.IntegerField(blank=True, null=True)
    inverter_kw_installation = models.IntegerField(db_column='inverter_KW_installation', blank=True, null=True)  # Field name made lowercase.
    inverter_gross_project_amount = models.IntegerField(blank=True, null=True)
    inverter_subsidy_amount = models.IntegerField(blank=True, null=True)
    inverter_power_savings = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'consumer_application_element'


class ConsumerApplicationElementArchive(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    industry = models.IntegerField(blank=True, null=True)
    profession_type = models.IntegerField(blank=True, null=True)
    co_applicant_industry = models.IntegerField(blank=True, null=True)
    co_applicant_profession_type = models.IntegerField(blank=True, null=True)
    negative_profile = models.IntegerField(blank=True, null=True)
    work_email = models.CharField(max_length=255, blank=True, null=True)
    center_id = models.IntegerField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    gst_number = models.CharField(max_length=191, blank=True, null=True)
    current_address_lat_long = models.CharField(max_length=100, blank=True, null=True)
    permanent_address_lat_long = models.CharField(max_length=100, blank=True, null=True)
    current_address_text = models.TextField(blank=True, null=True)
    current_formatted_text = models.TextField(blank=True, null=True)
    permanent_address_text = models.TextField(blank=True, null=True)
    permanent_formatted_text = models.TextField(blank=True, null=True)
    designation = models.CharField(max_length=191, blank=True, null=True)
    department = models.CharField(max_length=191, blank=True, null=True)
    contact = models.CharField(max_length=191, blank=True, null=True)
    is_auto_approved = models.IntegerField(blank=True, null=True)
    telecom_response = models.TextField(blank=True, null=True)
    product_name = models.CharField(max_length=191, blank=True, null=True)
    foreclosure_date = models.DateField(blank=True, null=True)
    is_reviewed = models.IntegerField(blank=True, null=True)
    preferred_language = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_for_signing = models.IntegerField(blank=True, null=True)
    co_applicant_for_income = models.IntegerField(blank=True, null=True)
    bank_id = models.IntegerField(blank=True, null=True)
    mandatory_document_list = models.TextField(blank=True, null=True)
    auto_document_rule_id = models.IntegerField(blank=True, null=True)
    amount_over_due = models.IntegerField(blank=True, null=True)
    total_amount_due = models.IntegerField(blank=True, null=True)
    last_emi_date = models.DateField(blank=True, null=True)
    emi_paid = models.IntegerField(blank=True, null=True)
    emi_pending = models.IntegerField(blank=True, null=True)
    pre_approval_id = models.IntegerField(blank=True, null=True)
    agreement_version = models.IntegerField(blank=True, null=True)
    product_id = models.CharField(max_length=191, blank=True, null=True)
    duration = models.CharField(max_length=20, blank=True, null=True)
    collection_advisor = models.IntegerField()
    payment_transfer_date = models.CharField(max_length=191, blank=True, null=True)
    hold_amount = models.CharField(max_length=191, blank=True, null=True)
    withhold_adjusted = models.IntegerField()
    reason_for_loan = models.CharField(max_length=191, blank=True, null=True)
    is_payout = models.IntegerField()
    reference_name_1 = models.CharField(max_length=191, blank=True, null=True)
    reference_name_2 = models.CharField(max_length=191, blank=True, null=True)
    reference_contact_1 = models.CharField(max_length=191, blank=True, null=True)
    reference_contact_2 = models.CharField(max_length=191, blank=True, null=True)
    reference_relation_1 = models.CharField(max_length=191, blank=True, null=True)
    reference_relation_2 = models.CharField(max_length=191, blank=True, null=True)
    onfido_skip = models.IntegerField()
    agreement_resign = models.IntegerField()
    nominee_salutation = models.CharField(max_length=3, blank=True, null=True)
    nominee_full_name = models.CharField(max_length=191, blank=True, null=True)
    nominee_dob = models.CharField(max_length=10, blank=True, null=True)
    nominee_gender = models.IntegerField(blank=True, null=True)
    nominee_relationship = models.CharField(max_length=191, blank=True, null=True)
    nominee_mobile_number = models.CharField(max_length=191, blank=True, null=True)
    soft_lead = models.IntegerField()
    video_kyc = models.CharField(max_length=191, blank=True, null=True)
    reference_number = models.CharField(max_length=191, blank=True, null=True)
    disbursement_sent = models.IntegerField()
    co_app_onfido_skip = models.IntegerField()
    merchant_representative_name = models.CharField(max_length=191, blank=True, null=True)
    merchant_representative_mobile = models.CharField(max_length=191, blank=True, null=True)
    merchant_representative_email = models.CharField(max_length=191, blank=True, null=True)
    babyready_user_id = models.IntegerField(blank=True, null=True)
    unique_id_number = models.CharField(max_length=191, blank=True, null=True)
    avanse_customer_id = models.IntegerField(blank=True, null=True)
    co_applicant_designation = models.CharField(max_length=191, blank=True, null=True)
    admission_status = models.CharField(max_length=191, blank=True, null=True)
    is_consent = models.IntegerField()
    is_bnpl = models.IntegerField()
    principal_due = models.IntegerField()
    total_principal_due = models.IntegerField()
    father_name = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_father_name = models.CharField(max_length=191, blank=True, null=True)
    repayment_type = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'consumer_application_element_archive'


class ConsumerApplicationFiles(models.Model):
    consumer_application_id = models.IntegerField(blank=True, null=True)
    bank_name = models.CharField(max_length=191, blank=True, null=True)
    password = models.CharField(max_length=191, blank=True, null=True)
    file_type = models.CharField(max_length=191, blank=True, null=True)
    file_path = models.CharField(max_length=191, blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    is_reviewed = models.IntegerField(blank=True, null=True)
    accounttype = models.CharField(max_length=191, blank=True, null=True)
    statementtype = models.CharField(max_length=191, blank=True, null=True)
    statemenfilettype = models.CharField(max_length=191, blank=True, null=True)
    accountuid = models.TextField(db_column='accountUID', blank=True, null=True)  # Field name made lowercase.
    created_by = models.IntegerField(blank=True, null=True)
    image_score = models.CharField(max_length=191, blank=True, null=True)
    deleted_by = models.CharField(max_length=191)
    provider = models.CharField(max_length=191, blank=True, null=True)
    customer_id = models.CharField(max_length=191, blank=True, null=True)
    bp_number = models.CharField(max_length=191, blank=True, null=True)
    is_masked = models.IntegerField(default=0)
    finbit_analysis_date = models.CharField(max_length=191, blank=True, null=True)
    applicant_type = models.IntegerField(blank=True, null=True)
    m_generated = models.IntegerField(default=0)
    bureau_report_type = models.CharField(max_length=191, blank=True, null=True)
    bureau_report_score = models.CharField(max_length=191, blank=True, null=True)
    cust_doc_no = models.CharField(max_length=191, blank=True, null=True)
    doc_category = models.CharField(max_length=191, blank=True, null=True)
    cust_doc_issued_country = models.CharField(max_length=191, blank=True, null=True)
    cust_doc_issued_auth = models.CharField(max_length=191, blank=True, null=True)
    doc_ref_id = models.CharField(max_length=191, blank=True, null=True)
    cust_doc_issued_on = models.CharField(max_length=191, blank=True, null=True)
    cust_doc_exp_date = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'consumer_application_files'


class ConsumerApplicationGrades(models.Model):
    application_id = models.IntegerField()
    grade_id = models.IntegerField()
    grade_alice = models.CharField(max_length=191)
    loan_amount = models.IntegerField()
    tenure = models.IntegerField()
    score = models.IntegerField()
    foir = models.IntegerField()
    cf_foir = models.IntegerField()
    monthly_income = models.IntegerField()
    age = models.CharField(max_length=191, blank=True, null=True)
    thin_file_loan_amount = models.IntegerField(blank=True, null=True)
    thin_file_tenure = models.IntegerField(blank=True, null=True)
    thin_file_foir = models.IntegerField(blank=True, null=True)
    thin_file_cf_foir = models.IntegerField(blank=True, null=True)
    thin_file_monthly_income = models.IntegerField(blank=True, null=True)
    thin_file_age = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'consumer_application_grades'


class ConsumerVerification(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    cibil_score = models.IntegerField(blank=True, null=True)
    complete_name = models.IntegerField(blank=True, null=True)
    complete_address = models.IntegerField(blank=True, null=True)
    complete_phone_number = models.IntegerField(blank=True, null=True)
    current_address = models.IntegerField(blank=True, null=True)
    identity_number = models.IntegerField(blank=True, null=True)
    id_expiry_date = models.IntegerField(blank=True, null=True)
    birth_date = models.IntegerField(blank=True, null=True)
    employment_information = models.IntegerField(blank=True, null=True)
    no_dpd = models.IntegerField(blank=True, null=True)
    crossed_credit_limit = models.IntegerField(blank=True, null=True)
    having_larger_monthly_outflows = models.IntegerField(blank=True, null=True)
    no_negative_factor = models.IntegerField(blank=True, null=True)
    maximum_number_of_enquiries = models.IntegerField(blank=True, null=True)
    age = models.IntegerField(blank=True, null=True)
    linkedin = models.IntegerField(blank=True, null=True)
    facebook = models.IntegerField(blank=True, null=True)
    no_of_dependent = models.IntegerField(blank=True, null=True)
    signature = models.IntegerField(blank=True, null=True)
    tele_verification = models.IntegerField(blank=True, null=True)
    collected_bank_account = models.IntegerField(blank=True, null=True)
    salary = models.IntegerField(blank=True, null=True)
    no_minimum_balance = models.IntegerField(blank=True, null=True)
    no_debit_chq_esc_bounce = models.IntegerField(blank=True, null=True)
    transaction_entries = models.IntegerField(blank=True, null=True)
    regular_high_value_transaction = models.IntegerField(blank=True, null=True)
    average_balance = models.IntegerField(blank=True, null=True)
    mca = models.IntegerField(blank=True, null=True)
    prode = models.IntegerField(blank=True, null=True)
    joining_date = models.IntegerField(blank=True, null=True)
    designation = models.IntegerField(blank=True, null=True)
    verify_professional_certificates = models.IntegerField(blank=True, null=True)
    official_email_id = models.IntegerField(blank=True, null=True)
    official_address = models.IntegerField(blank=True, null=True)
    itr_certificate_by_ca = models.IntegerField(blank=True, null=True)
    nature_of_business = models.IntegerField(blank=True, null=True)
    type_of_business = models.IntegerField(blank=True, null=True)
    itr_salary = models.IntegerField(blank=True, null=True)
    view_utilities_bill_online = models.IntegerField(blank=True, null=True)
    residing_in_negative_area = models.IntegerField(blank=True, null=True)
    valid_of_rental_agreement = models.IntegerField(blank=True, null=True)
    residence_visit_cpv_report = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'consumer_verification'


class CoronaHotspot(models.Model):
    city_name = models.CharField(max_length=191)
    pincode = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'corona_hotspot'


class Couriers(models.Model):
    courier_company = models.CharField(max_length=191)
    tracking_id = models.CharField(max_length=191)
    website = models.CharField(max_length=191, blank=True, null=True)
    recipient_id = models.IntegerField()
    couriered_at = models.DateTimeField()
    documents = models.TextField()
    user_id = models.IntegerField()
    received_by = models.IntegerField(blank=True, null=True)
    received_document = models.TextField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    receipt_ack = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'couriers'


class CpvMailer(models.Model):
    application_id = models.IntegerField()
    name = models.CharField(max_length=191)
    co_applicant_name = models.CharField(max_length=191, blank=True, null=True)
    co_applicant_number = models.CharField(max_length=191, blank=True, null=True)
    loan_application_number = models.CharField(max_length=191, blank=True, null=True)
    date_receipt = models.CharField(max_length=191, blank=True, null=True)
    current_address = models.CharField(max_length=191, blank=True, null=True)
    address_type = models.CharField(max_length=191, blank=True, null=True)
    mobile = models.CharField(max_length=191, blank=True, null=True)
    merchant_name = models.CharField(max_length=191, blank=True, null=True)
    asset = models.CharField(max_length=191, blank=True, null=True)
    remark = models.TextField(blank=True, null=True)
    date_time_visit = models.CharField(max_length=191, blank=True, null=True)
    user_id = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'cpv_mailer'


class CreditReport(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    score = models.IntegerField(db_column='Score', blank=True, null=True)  # Field name made lowercase.
    noofactiveaccounts = models.IntegerField(db_column='NoOfActiveAccounts', blank=True, null=True)  # Field name made lowercase.
    activecreditcardlimit = models.IntegerField(db_column='activeCreditCardLimit', blank=True, null=True)  # Field name made lowercase.
    sanctionamount = models.IntegerField(db_column='sanctionAmount', blank=True, null=True)  # Field name made lowercase.
    totalpastdue = models.IntegerField(db_column='TotalPastDue', blank=True, null=True)  # Field name made lowercase.
    past12months = models.IntegerField(db_column='Past12Months', blank=True, null=True)  # Field name made lowercase.
    past24months = models.IntegerField(db_column='Past24Months', blank=True, null=True)  # Field name made lowercase.
    totalenquiry = models.IntegerField(db_column='TotalEnquiry', blank=True, null=True)  # Field name made lowercase.
    zerobalanceaccount = models.IntegerField(db_column='zeroBalanceAccount', blank=True, null=True)  # Field name made lowercase.
    pastdueaccount = models.IntegerField(db_column='pastDueAccount', blank=True, null=True)  # Field name made lowercase.
    finalcategory = models.CharField(db_column='finalCategory', max_length=4, blank=True, null=True)  # Field name made lowercase.
    voterid = models.TextField(db_column='VoterID', blank=True, null=True)  # Field name made lowercase.
    contactinfolist = models.TextField(db_column='contactInfoList', blank=True, null=True)  # Field name made lowercase.
    panidslist = models.TextField(db_column='PANIdsList', blank=True, null=True)  # Field name made lowercase.
    nationalidslist = models.TextField(db_column='NationalIdsList', blank=True, null=True)  # Field name made lowercase.
    dateofbirth = models.DateField(db_column='DateOfBirth', blank=True, null=True)  # Field name made lowercase.
    addressinfolist = models.TextField(db_column='AddressInfoList', blank=True, null=True)  # Field name made lowercase.
    applicant_type = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    panvalidation = models.TextField(db_column='panValidation', blank=True, null=True)  # Field name made lowercase.
    foirnaincludingcfemi = models.CharField(db_column='foirNAIncludingCFEMI', max_length=191, blank=True, null=True)  # Field name made lowercase.
    foirincludingcfemi = models.CharField(db_column='foirIncludingCFEMI', max_length=191, blank=True, null=True)  # Field name made lowercase.
    loanoutstanding = models.IntegerField(db_column='loanOutstanding')  # Field name made lowercase.
    cffoir = models.CharField(db_column='cfFoir', max_length=191, blank=True, null=True)  # Field name made lowercase.
    bureau = models.CharField(max_length=10)
    panvendor = models.CharField(db_column='panVendor', max_length=10, blank=True, null=True)  # Field name made lowercase.
    ml_loan_amount = models.DecimalField(max_digits=9, decimal_places=2, blank=True, null=True)
    ml_eligible_emi_amount = models.DecimalField(max_digits=9, decimal_places=2, blank=True, null=True)
    foir_loan_amount = models.DecimalField(max_digits=9, decimal_places=2, blank=True, null=True)
    foir_eligible_emi_amount = models.DecimalField(max_digits=9, decimal_places=2, blank=True, null=True)
    predicted_loan_amount = models.DecimalField(max_digits=9, decimal_places=2, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'credit_report'


class CustomApprovalStatus(models.Model):
    application_id = models.IntegerField()
    log = models.TextField(blank=True, null=True)
    status = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'custom_approval_status'


class CustomGrades(models.Model):
    grade_id = models.IntegerField()
    condition = models.CharField(max_length=191)
    operator = models.CharField(max_length=191)
    value = models.CharField(max_length=191)
    user_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'custom_grades'


class CustomGradesBase(models.Model):
    rule = models.CharField(max_length=191)
    description = models.TextField()
    tables = models.TextField()
    user_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'custom_grades_base'


class Customers(models.Model):
    name = models.CharField(max_length=191, blank=True, null=True)
    email = models.CharField(max_length=191, blank=True, null=True)
    mobile_number = models.CharField(max_length=191, blank=True, null=True)
    gender = models.IntegerField(blank=True, null=True)
    pan_card = models.TextField(blank=True, null=True)
    aadhaar_card = models.TextField(blank=True, null=True)
    dob = models.DateField(blank=True, null=True)
    marital_status = models.CharField(max_length=7, blank=True, null=True)
    gst_number = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    is_verified = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'customers'


class DailyCalling(models.Model):
    application_id = models.IntegerField()
    email = models.CharField(max_length=191, blank=True, null=True)
    phone = models.CharField(max_length=191, blank=True, null=True)
    amount = models.CharField(max_length=191, blank=True, null=True)
    first_emi_date = models.CharField(max_length=191, blank=True, null=True)
    nach_status = models.CharField(max_length=191, blank=True, null=True)
    advisor = models.CharField(max_length=191, blank=True, null=True)
    status = models.CharField(max_length=191, blank=True, null=True)
    feedback = models.CharField(max_length=191, blank=True, null=True)
    paid_amount = models.CharField(max_length=191, blank=True, null=True)
    date = models.CharField(max_length=191, blank=True, null=True)
    payment_mode = models.CharField(max_length=191, blank=True, null=True)
    user_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    ptp_date = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'daily_calling'


class DailyDpdPosData(models.Model):
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'daily_dpd_pos_data'


class DecentroCkyc(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    ckyc_id = models.CharField(max_length=100, blank=True, null=True)
    result = models.CharField(max_length=100, blank=True, null=True)
    updateddate = models.CharField(db_column='updatedDate', max_length=100, blank=True, null=True)  # Field name made lowercase.
    responsedownload = models.TextField(db_column='responseDownload', blank=True, null=True)  # Field name made lowercase.
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    pan = models.CharField(db_column='Pan', max_length=100, blank=True, null=True)  # Field name made lowercase.
    dob = models.CharField(db_column='DOB', max_length=100, blank=True, null=True)  # Field name made lowercase.
    reference_id = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'decentro_ckyc'


class DelayPenalty(models.Model):
    application_id = models.IntegerField()
    emi_payment_id = models.IntegerField()
    delay_days = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'delay_penalty'


class DelinquencyLogs(models.Model):
    period = models.TextField(blank=True, null=True)
    offbookcore = models.TextField(db_column='offBookCore', blank=True, null=True)  # Field name made lowercase.
    offbooknoncore = models.TextField(db_column='offBookNonCore', blank=True, null=True)  # Field name made lowercase.
    onbookcore = models.TextField(db_column='onBookCore', blank=True, null=True)  # Field name made lowercase.
    onbooknoncore = models.TextField(db_column='onBookNonCore', blank=True, null=True)  # Field name made lowercase.
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'delinquency_logs'


class Devices(models.Model):
    user_id = models.IntegerField()
    manufacturer = models.CharField(max_length=191, blank=True, null=True)
    app_version = models.CharField(max_length=191, blank=True, null=True)
    sdk_version = models.CharField(max_length=191, blank=True, null=True)
    model = models.CharField(max_length=191, blank=True, null=True)
    brand = models.CharField(max_length=191, blank=True, null=True)
    device = models.CharField(max_length=191, blank=True, null=True)
    product = models.CharField(max_length=191, blank=True, null=True)
    fingerprint = models.CharField(max_length=191, blank=True, null=True)
    imei = models.CharField(max_length=191, blank=True, null=True)
    build_type = models.CharField(max_length=191, blank=True, null=True)
    time = models.TextField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    version_code = models.CharField(max_length=11, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'devices'


class DigitalSignDetails(models.Model):
    application_id = models.IntegerField()
    applicant = models.IntegerField()
    load_time = models.DateTimeField(blank=True, null=True)
    click_time = models.DateTimeField(blank=True, null=True)
    language = models.CharField(max_length=100, blank=True, null=True)
    merchant_esign_image = models.CharField(max_length=191, blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    isaddress = models.CharField(max_length=191, blank=True, null=True)
    isagreementsigned = models.IntegerField(blank=True, null=True)
    type = models.CharField(max_length=191, blank=True, null=True)
    client = models.TextField(blank=True, null=True)
    # esign_vendor = models.CharField(max_length=25)
    # vendor_doc_id = models.CharField(max_length=255, blank=True, null=True)
    # is_stamped = models.IntegerField()
    # stamp_tag = models.CharField(max_length=25, blank=True, null=True)
    # stamp_qty = models.PositiveSmallIntegerField()
    if os.environ.get("DJANGO_SETTINGS_MODULE") == 'backend.settings.prod':
        deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'digital_sign_details'


class DisbursementLog(models.Model):
    application_id = models.IntegerField()
    phase = models.IntegerField()
    disbursement_amount = models.CharField(max_length=191)
    created_by = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    partial_subvention_amount = models.IntegerField(blank=True, null=True)
    per_disbursement_amount = models.IntegerField(blank=True, null=True)
    day_from_disbursement_date = models.IntegerField(blank=True, null=True)
    disbursement_offer_id = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'disbursement_log'


class DisbursementOffers(models.Model):
    offer_id = models.IntegerField()
    phase = models.IntegerField()
    per_disbursement_amount = models.IntegerField(blank=True, null=True)
    day_from_disbursement_date = models.IntegerField(blank=True, null=True)
    created_by = models.IntegerField(blank=True, null=True)
    status = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'disbursement_offers'


class DisbursementOffersDisbursed(models.Model):
    offer_id = models.IntegerField()
    per_disbursement_amount = models.IntegerField(blank=True, null=True)
    day_from_disbursement_date = models.IntegerField(blank=True, null=True)
    phase = models.IntegerField(blank=True, null=True)
    application_id = models.IntegerField(blank=True, null=True)
    created_by = models.IntegerField(blank=True, null=True)
    status = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'disbursement_offers_disbursed'


class DisbursementOffersLock(models.Model):
    offer_id = models.IntegerField()
    per_disbursement_amount = models.IntegerField(blank=True, null=True)
    day_from_disbursement_date = models.IntegerField(blank=True, null=True)
    phase = models.IntegerField(blank=True, null=True)
    changed_by = models.IntegerField(blank=True, null=True)
    status = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'disbursement_offers_lock'


class DisbursementSchedule(models.Model):
    application_id = models.IntegerField()
    disbursement_summary_id = models.IntegerField()
    offer_id = models.IntegerField()
    emi_id = models.IntegerField()
    emi_date = models.CharField(max_length=191)
    amount = models.IntegerField()
    moratorium_amount = models.IntegerField()
    interest = models.CharField(max_length=191)
    principal = models.CharField(max_length=191)
    subvention = models.CharField(max_length=191)
    subvention_amount_balance = models.CharField(max_length=191)
    principal_outstanding = models.CharField(max_length=191)
    principal_outstanding_subvention = models.CharField(max_length=191)
    fore_closure_amount = models.CharField(max_length=191)
    payment_status = models.CharField(max_length=191)
    bounce_charges = models.CharField(max_length=191)
    delay_penalty = models.CharField(max_length=191)
    charges_waived = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'disbursement_schedule'


class DisbursementSummary(models.Model):
    application_id = models.IntegerField()
    loan_amount = models.IntegerField()
    loan_outstanding = models.IntegerField()
    tenure = models.IntegerField()
    remaining_emi = models.IntegerField()
    quoted_interest = models.CharField(max_length=191)
    interest = models.CharField(max_length=191)
    annualised_interest = models.CharField(max_length=191)
    irr = models.CharField(max_length=191)
    annualised_irr = models.CharField(max_length=191)
    subvention = models.CharField(max_length=191)
    processing_fee = models.CharField(max_length=191)
    emi = models.CharField(max_length=191)
    advance_due = models.CharField(max_length=191)
    net_disbursement_amount = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'disbursement_summary'


class Disbursements(models.Model):
    application_id = models.IntegerField()
    merchant_id = models.IntegerField(blank=True, null=True)
    disbursed = models.CharField(max_length=191, blank=True, null=True)
    emi_amount_adjusted = models.CharField(max_length=191, blank=True, null=True)
    total_amount_adjusted = models.CharField(max_length=191)
    upfront_from_credit_fair = models.CharField(max_length=191, blank=True, null=True)
    is_cancellation_adjusted = models.IntegerField()
    disbursement_data = models.TextField()
    adjusted_against = models.TextField(blank=True, null=True)
    emi_adjusted = models.CharField(max_length=191, blank=True, null=True)
    adjusted_amount = models.CharField(max_length=191, blank=True, null=True)
    pending_adjustable_amount = models.CharField(max_length=191, blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    created_by = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    withhold = models.CharField(max_length=191)

    class Meta:
        managed = False
        db_table = 'disbursements'


class DocumentRule(models.Model):
    grade_id = models.IntegerField()
    alice = models.CharField(max_length=191)
    score_from = models.CharField(max_length=191)
    score_to = models.CharField(max_length=191)
    negative_profile = models.IntegerField()
    negative_area = models.IntegerField()
    collateral_loan = models.IntegerField(blank=True, null=True)
    employment_type = models.CharField(max_length=191)
    foir_from = models.CharField(max_length=191)
    foir_to = models.CharField(max_length=191)
    loan_amount_from = models.CharField(max_length=191)
    loan_amount_to = models.CharField(max_length=191)
    income_from = models.CharField(max_length=191)
    income_to = models.CharField(max_length=191)
    disbursement_from = models.CharField(max_length=191)
    disbursement_to = models.CharField(max_length=191)
    document_set = models.CharField(max_length=191)
    status = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'document_rule'


class DocumentRuleLock(models.Model):
    grade_id = models.IntegerField()
    alice = models.CharField(max_length=191)
    score_from = models.CharField(max_length=191)
    score_to = models.CharField(max_length=191)
    negative_profile = models.IntegerField()
    negative_area = models.IntegerField()
    collateral_loan = models.IntegerField()
    employment_type = models.CharField(max_length=191)
    foir_from = models.CharField(max_length=191)
    foir_to = models.CharField(max_length=191)
    loan_amount_from = models.CharField(max_length=191)
    loan_amount_to = models.CharField(max_length=191)
    income_from = models.CharField(max_length=191)
    income_to = models.CharField(max_length=191)
    disbursement_from = models.CharField(max_length=191)
    disbursement_to = models.CharField(max_length=191)
    document_set = models.CharField(max_length=191)
    status = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    update_by = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'document_rule_lock'


class DocumentRuleLog(models.Model):
    application_id = models.IntegerField()
    net_disbursement = models.CharField(max_length=191, blank=True, null=True)
    monthly_income = models.CharField(max_length=191, blank=True, null=True)
    employee_status = models.CharField(max_length=191, blank=True, null=True)
    loan_amount = models.CharField(max_length=191, blank=True, null=True)
    foir = models.CharField(max_length=191, blank=True, null=True)
    score = models.CharField(max_length=191, blank=True, null=True)
    auto_document_rule_id = models.IntegerField(blank=True, null=True)
    status = models.IntegerField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    negative_profile = models.IntegerField(blank=True, null=True)
    collateral_loan = models.IntegerField(blank=True, null=True)
    negative_area = models.IntegerField(blank=True, null=True)
    black_list = models.IntegerField()
    request_id = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'document_rule_log'


class DocumentSets(models.Model):
    name = models.CharField(max_length=191)
    employment_type = models.CharField(max_length=191)
    document_type = models.CharField(max_length=191)
    documents = models.TextField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'document_sets'


class DpdLogs(models.Model):
    application_id = models.IntegerField()
    bucket = models.CharField(max_length=11, blank=True, null=True)
    dpd_days = models.IntegerField(blank=True, null=True)
    first_emi_date = models.DateTimeField(blank=True, null=True)
    last_emi_date = models.DateTimeField(blank=True, null=True)
    emi_amount = models.IntegerField(blank=True, null=True)
    no_of_emi_due = models.IntegerField(blank=True, null=True)
    total_due_with_penalties = models.IntegerField(blank=True, null=True)
    max_payable = models.IntegerField(blank=True, null=True)
    total_outstanding = models.IntegerField(blank=True, null=True)
    principal_outstanding = models.IntegerField(blank=True, null=True)
    last_payment_date = models.DateTimeField(blank=True, null=True)
    last_payment_amount = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'dpd_logs'


class EmiCalculation(models.Model):
    application = models.OneToOneField(ConsumerApplication, on_delete=models.CASCADE)
    # application_id = models.BigIntegerField()
    offer_id = models.IntegerField(blank=True, null=True)
    tenure = models.IntegerField()
    remaining_emi = models.IntegerField()
    advance_emi = models.BigIntegerField()
    interest_rate = models.FloatField()
    subvention = models.FloatField()
    processing_fee = models.BigIntegerField()
    emi = models.BigIntegerField()
    emi_date = models.DateTimeField(blank=True, null=True)
    upfront_from_customer = models.BigIntegerField()
    upfront_from_credit_fair = models.BigIntegerField()
    received_by_merchant = models.BigIntegerField()
    payable_by_customer = models.BigIntegerField()
    status = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    subvention_igst = models.BigIntegerField(blank=True, null=True)
    subvention_cgst = models.BigIntegerField(blank=True, null=True)
    subvention_sgst = models.BigIntegerField(blank=True, null=True)
    rate = models.CharField(max_length=191, blank=True, null=True)
    annualised_interest = models.CharField(max_length=191, blank=True, null=True)
    irr_rate = models.CharField(max_length=191, blank=True, null=True)
    annualised_irr = models.CharField(max_length=191, blank=True, null=True)
    payment_frequency = models.IntegerField(blank=True, null=True)
    disbursement_method = models.IntegerField(blank=True, null=True)
    net_loan_amount = models.DecimalField(max_digits=9, decimal_places=2, blank=True, null=True)
    # net_disbursement_amount = models.BigIntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'emi_calculation'


class EmiCalculationLock(models.Model):
    application_id = models.BigIntegerField()
    tenure = models.IntegerField()
    offer_id = models.IntegerField(blank=True, null=True)
    emi_date = models.DateTimeField(blank=True, null=True)
    remaining_emi = models.IntegerField()
    advance_emi = models.BigIntegerField()
    interest_rate = models.FloatField()
    subvention = models.FloatField()
    processing_fee = models.BigIntegerField()
    emi = models.BigIntegerField()
    upfront_from_customer = models.BigIntegerField()
    upfront_from_credit_fair = models.BigIntegerField()
    received_by_merchant = models.BigIntegerField()
    payable_by_customer = models.BigIntegerField()
    status = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    re_scheduled_by = models.IntegerField(blank=True, null=True)
    re_scheduled_type = models.IntegerField(blank=True, null=True)
    approved_amount = models.BigIntegerField(blank=True, null=True)
    subvention_igst = models.BigIntegerField(blank=True, null=True)
    subvention_cgst = models.BigIntegerField(blank=True, null=True)
    subvention_sgst = models.BigIntegerField(blank=True, null=True)
    rate = models.CharField(max_length=191, blank=True, null=True)
    annualised_interest = models.CharField(max_length=191, blank=True, null=True)
    irr_rate = models.CharField(max_length=191, blank=True, null=True)
    annualised_irr = models.CharField(max_length=191, blank=True, null=True)
    payment_frequency = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'emi_calculation_lock'


class EmiPaymentLogs(models.Model):
    emi_date = models.DateField()
    new_emi_date = models.DateField(blank=True, null=True)
    emi_amount = models.IntegerField()
    bounce_charges = models.IntegerField()
    delay_penalty = models.IntegerField()
    payment_mode = models.IntegerField(blank=True, null=True)
    charges_waived = models.IntegerField()
    payment_date = models.DateTimeField(blank=True, null=True)
    payment_status = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    online_payment_id = models.CharField(max_length=191, blank=True, null=True)
    application_id = models.IntegerField()
    bounce_charge_igst = models.CharField(max_length=191, blank=True, null=True)
    bounce_charge_cgst = models.CharField(max_length=191, blank=True, null=True)
    bounce_charge_sgst = models.CharField(max_length=191, blank=True, null=True)
    net_bounce_charge = models.CharField(max_length=191, blank=True, null=True)
    penal_interest_igst = models.CharField(max_length=191, blank=True, null=True)
    penal_interest_cgst = models.CharField(max_length=191, blank=True, null=True)
    penal_interest_sgst = models.CharField(max_length=191, blank=True, null=True)
    net_penal_interest = models.CharField(max_length=191, blank=True, null=True)
    final_bounce_charge = models.CharField(max_length=191, blank=True, null=True)
    final_penal_interest = models.CharField(max_length=191, blank=True, null=True)
    due_date = models.DateField(blank=True, null=True)
    total_payable = models.IntegerField(blank=True, null=True)
    amount_due = models.IntegerField(blank=True, null=True)
    delay_days = models.IntegerField(blank=True, null=True)
    rejected_date = models.CharField(max_length=191, blank=True, null=True)
    moratorium = models.IntegerField()
    moratorium_amount = models.CharField(max_length=191, blank=True, null=True)
    dpd_reason = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'emi_payment_logs'


class EmiPayments(models.Model):
    emi_date = models.DateField()
    emi_amount = models.IntegerField()
    bounce_charges = models.IntegerField()
    delay_penalty = models.IntegerField()
    payment_mode = models.IntegerField(blank=True, null=True)
    charges_waived = models.IntegerField()
    payment_date = models.DateTimeField(blank=True, null=True)
    payment_status = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    online_payment_id = models.CharField(max_length=256, blank=True, null=True)
    application_id = models.IntegerField()
    bounce_charge_igst = models.CharField(max_length=191, blank=True, null=True)
    bounce_charge_cgst = models.CharField(max_length=191, blank=True, null=True)
    bounce_charge_sgst = models.CharField(max_length=191, blank=True, null=True)
    net_bounce_charge = models.CharField(max_length=191, blank=True, null=True)
    penal_interest_igst = models.CharField(max_length=191, blank=True, null=True)
    penal_interest_cgst = models.CharField(max_length=191, blank=True, null=True)
    penal_interest_sgst = models.CharField(max_length=191, blank=True, null=True)
    net_penal_interest = models.CharField(max_length=191, blank=True, null=True)
    final_bounce_charge = models.CharField(max_length=191, blank=True, null=True)
    final_penal_interest = models.CharField(max_length=191, blank=True, null=True)
    due_date = models.DateField(blank=True, null=True)
    total_payable = models.IntegerField(blank=True, null=True)
    amount_due = models.IntegerField(blank=True, null=True)
    delay_days = models.IntegerField(blank=True, null=True)
    rejected_date = models.CharField(max_length=191, blank=True, null=True)
    moratorium = models.IntegerField()
    moratorium_amount = models.CharField(max_length=191, blank=True, null=True)
    dpd_reason = models.CharField(max_length=191, blank=True, null=True)
    auto_waiver_amt = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'emi_payments'


class EmploymentVerification(models.Model):
    application_id = models.IntegerField()
    data = models.TextField()
    entity_id = models.CharField(max_length=191, blank=True, null=True)
    email = models.CharField(max_length=191, blank=True, null=True)
    mobile = models.CharField(max_length=191, blank=True, null=True)
    employername = models.CharField(db_column='employerName', max_length=191, blank=True, null=True)  # Field name made lowercase.
    employeename = models.CharField(db_column='employeeName', max_length=191, blank=True, null=True)  # Field name made lowercase.
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    uan_no = models.CharField(max_length=191, blank=True, null=True)
    applicant_type = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'employment_verification'


class EquifaxAccounts(models.Model):
    equifax_report_id = models.IntegerField()
    reporteddate = models.CharField(db_column='ReportedDate', max_length=191, blank=True, null=True)  # Field name made lowercase.
    accountnumber = models.CharField(db_column='AccountNumber', max_length=191, blank=True, null=True)  # Field name made lowercase.
    institution = models.CharField(db_column='Institution', max_length=191, blank=True, null=True)  # Field name made lowercase.
    accounttype = models.CharField(db_column='AccountType', max_length=191, blank=True, null=True)  # Field name made lowercase.
    ownershiptype = models.CharField(db_column='OwnershipType', max_length=191, blank=True, null=True)  # Field name made lowercase.
    balance = models.CharField(db_column='Balance', max_length=191, blank=True, null=True)  # Field name made lowercase.
    open = models.CharField(db_column='Open', max_length=191, blank=True, null=True)  # Field name made lowercase.
    sanctionamount = models.CharField(db_column='SanctionAmount', max_length=191, blank=True, null=True)  # Field name made lowercase.
    datereported = models.CharField(db_column='DateReported', max_length=191, blank=True, null=True)  # Field name made lowercase.
    dateopened = models.CharField(db_column='DateOpened', max_length=191, blank=True, null=True)  # Field name made lowercase.
    reason = models.CharField(db_column='Reason', max_length=191, blank=True, null=True)  # Field name made lowercase.
    interestrate = models.CharField(db_column='InterestRate', max_length=191, blank=True, null=True)  # Field name made lowercase.
    repaymenttenure = models.CharField(db_column='RepaymentTenure', max_length=191, blank=True, null=True)  # Field name made lowercase.
    disputecode = models.CharField(db_column='DisputeCode', max_length=191, blank=True, null=True)  # Field name made lowercase.
    installmentamount = models.CharField(db_column='InstallmentAmount', max_length=191, blank=True, null=True)  # Field name made lowercase.
    termfrequency = models.CharField(db_column='TermFrequency', max_length=191, blank=True, null=True)  # Field name made lowercase.
    collateralvalue = models.CharField(db_column='CollateralValue', max_length=191, blank=True, null=True)  # Field name made lowercase.
    collateraltype = models.CharField(db_column='CollateralType', max_length=191, blank=True, null=True)  # Field name made lowercase.
    accountstatus = models.CharField(db_column='AccountStatus', max_length=191, blank=True, null=True)  # Field name made lowercase.
    assetclassification = models.CharField(db_column='AssetClassification', max_length=191, blank=True, null=True)  # Field name made lowercase.
    suitfiledstatus = models.CharField(db_column='SuitFiledStatus', max_length=191, blank=True, null=True)  # Field name made lowercase.
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'equifax_accounts'


class EquifaxAccountsHistory(models.Model):
    equifax_account_id = models.IntegerField()
    paymentstatus = models.CharField(db_column='PaymentStatus', max_length=191, blank=True, null=True)  # Field name made lowercase.
    suitfiledstatus = models.CharField(db_column='SuitFiledStatus', max_length=191, blank=True, null=True)  # Field name made lowercase.
    assetclassificationstatus = models.CharField(db_column='AssetClassificationStatus', max_length=191, blank=True, null=True)  # Field name made lowercase.
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'equifax_accounts_history'


class EquifaxReport(models.Model):
    field_id = models.IntegerField(db_column='_id')  # Field renamed because it started with '_'.
    id_type = models.CharField(max_length=191)
    applicant_type = models.IntegerField(blank=True, null=True)
    score = models.CharField(max_length=191, blank=True, null=True)
    noofaccounts = models.CharField(db_column='NoOfAccounts', max_length=191, blank=True, null=True)  # Field name made lowercase.
    noofactiveaccounts = models.CharField(db_column='NoOfActiveAccounts', max_length=191, blank=True, null=True)  # Field name made lowercase.
    noofwriteoffs = models.CharField(db_column='NoOfWriteOffs', max_length=191, blank=True, null=True)  # Field name made lowercase.
    totalpastdue = models.CharField(db_column='TotalPastDue', max_length=191, blank=True, null=True)  # Field name made lowercase.
    mostseverestatuswithin24months = models.CharField(db_column='MostSevereStatusWithIn24Months', max_length=191, blank=True, null=True)  # Field name made lowercase.
    singlehighestcredit = models.CharField(db_column='SingleHighestCredit', max_length=191, blank=True, null=True)  # Field name made lowercase.
    singlehighestsanctionamount = models.CharField(db_column='SingleHighestSanctionAmount', max_length=191, blank=True, null=True)  # Field name made lowercase.
    totalhighcredit = models.CharField(db_column='TotalHighCredit', max_length=191, blank=True, null=True)  # Field name made lowercase.
    averageopenbalance = models.CharField(db_column='AverageOpenBalance', max_length=191, blank=True, null=True)  # Field name made lowercase.
    singlehighestbalance = models.CharField(db_column='SingleHighestBalance', max_length=191, blank=True, null=True)  # Field name made lowercase.
    noofpastdueaccounts = models.CharField(db_column='NoOfPastDueAccounts', max_length=191, blank=True, null=True)  # Field name made lowercase.
    noofzerobalanceaccounts = models.CharField(db_column='NoOfZeroBalanceAccounts', max_length=191, blank=True, null=True)  # Field name made lowercase.
    recentaccount = models.CharField(db_column='RecentAccount', max_length=191, blank=True, null=True)  # Field name made lowercase.
    oldestaccount = models.CharField(db_column='OldestAccount', max_length=191, blank=True, null=True)  # Field name made lowercase.
    totalbalanceamount = models.CharField(db_column='TotalBalanceAmount', max_length=191, blank=True, null=True)  # Field name made lowercase.
    totalsanctionamount = models.CharField(db_column='TotalSanctionAmount', max_length=191, blank=True, null=True)  # Field name made lowercase.
    totalcreditlimit = models.CharField(db_column='TotalCreditLimit', max_length=191, blank=True, null=True)  # Field name made lowercase.
    totalmonthlypaymentamount = models.CharField(db_column='TotalMonthlyPaymentAmount', max_length=191, blank=True, null=True)  # Field name made lowercase.
    accountsdeliquent = models.CharField(db_column='AccountsDeliquent', max_length=191, blank=True, null=True)  # Field name made lowercase.
    accountsopened = models.CharField(db_column='AccountsOpened', max_length=191, blank=True, null=True)  # Field name made lowercase.
    totalinquiries = models.CharField(db_column='TotalInquiries', max_length=191, blank=True, null=True)  # Field name made lowercase.
    accountsupdated = models.CharField(db_column='AccountsUpdated', max_length=191, blank=True, null=True)  # Field name made lowercase.
    ageofoldesttrade = models.CharField(db_column='AgeOfOldestTrade', max_length=191, blank=True, null=True)  # Field name made lowercase.
    numberofopentrades = models.CharField(db_column='NumberOfOpenTrades', max_length=191, blank=True, null=True)  # Field name made lowercase.
    alllineseverwritten = models.CharField(db_column='AllLinesEVERWritten', max_length=191, blank=True, null=True)  # Field name made lowercase.
    alllineseverwrittenin9months = models.CharField(db_column='AllLinesEVERWrittenIn9Months', max_length=191, blank=True, null=True)  # Field name made lowercase.
    alllineseverwrittenin6months = models.CharField(db_column='AllLinesEVERWrittenIn6Months', max_length=191, blank=True, null=True)  # Field name made lowercase.
    enquirypurpose = models.CharField(db_column='EnquiryPurpose', max_length=191, blank=True, null=True)  # Field name made lowercase.
    enquirytotal = models.CharField(db_column='EnquiryTotal', max_length=191, blank=True, null=True)  # Field name made lowercase.
    enquirypast30days = models.CharField(db_column='EnquiryPast30Days', max_length=191, blank=True, null=True)  # Field name made lowercase.
    enquirypast12months = models.CharField(db_column='EnquiryPast12Months', max_length=191, blank=True, null=True)  # Field name made lowercase.
    enquirypast24months = models.CharField(db_column='EnquiryPast24Months', max_length=191, blank=True, null=True)  # Field name made lowercase.
    enquiryrecent = models.CharField(db_column='EnquiryRecent', max_length=191, blank=True, null=True)  # Field name made lowercase.
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'equifax_report'


class EquifaxReportContactInfo(models.Model):
    equifax_report_id = models.IntegerField()
    personalinfo = models.TextField(db_column='PersonalInfo', blank=True, null=True)  # Field name made lowercase.
    identityinfo = models.TextField(db_column='IdentityInfo', blank=True, null=True)  # Field name made lowercase.
    addressinfo = models.TextField(db_column='AddressInfo', blank=True, null=True)  # Field name made lowercase.
    phoneinfo = models.TextField(db_column='PhoneInfo', blank=True, null=True)  # Field name made lowercase.
    emailaddressinfo = models.TextField(db_column='EmailAddressInfo', blank=True, null=True)  # Field name made lowercase.
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'equifax_report_contact_info'


class ExposureCalculation(models.Model):
    merchant_id = models.IntegerField()
    date_of_transaction = models.CharField(max_length=191)
    type_of_transaction = models.CharField(max_length=191)
    category_id = models.IntegerField()
    amount = models.CharField(max_length=191)
    fldg = models.IntegerField()
    risk_exposure = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    type_of_fldg = models.IntegerField(blank=True, null=True)
    narration = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'exposure_calculation'


class FailedScoreRequests(models.Model):
    field_id = models.IntegerField(db_column='_id')  # Field renamed because it started with '_'.
    id_type = models.CharField(max_length=191)
    source = models.CharField(max_length=191)
    user_id = models.IntegerField(blank=True, null=True)
    name = models.CharField(max_length=191)
    score = models.CharField(max_length=191, blank=True, null=True)
    counter = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'failed_score_requests'


class FcmResponses(models.Model):
    request = models.TextField(blank=True, null=True)
    response = models.TextField(blank=True, null=True)
    multicast_id = models.CharField(max_length=191, blank=True, null=True)
    canonical_ids = models.CharField(max_length=191, blank=True, null=True)
    success = models.IntegerField(blank=True, null=True)
    failure = models.IntegerField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    field_id = models.IntegerField(db_column='_id', blank=True, null=True)  # Field renamed because it started with '_'.
    notification_type = models.CharField(max_length=255, blank=True, null=True)
    id_type = models.CharField(max_length=255, blank=True, null=True)
    created_by = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'fcm_responses'


class FinbitDatas(models.Model):
    finbit_uid = models.CharField(max_length=191)
    application_id = models.IntegerField()
    period_from = models.CharField(max_length=191, blank=True, null=True)
    period_too = models.CharField(max_length=191, blank=True, null=True)
    average_balance = models.CharField(max_length=191, blank=True, null=True)
    average_balance_three_months = models.CharField(max_length=191, blank=True, null=True)
    median_balance = models.CharField(max_length=191, blank=True, null=True)
    median_balance_three_months = models.CharField(max_length=191, blank=True, null=True)
    inwards_bounce_transaction = models.CharField(max_length=191, blank=True, null=True)
    outwards_bounce_transaction = models.CharField(max_length=191, blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    id_type = models.CharField(max_length=191)
    avg_emi_three_months = models.CharField(max_length=30, blank=True, null=True)
    salary = models.TextField()
    net_credit_txn = models.TextField(blank=True, null=True)
    net_debit_txn = models.TextField(blank=True, null=True)
    ecs_nach_txn = models.TextField(blank=True, null=True)
    applicant_type = models.IntegerField(blank=True, null=True)
    eod_balance_1 = models.CharField(max_length=151, blank=True, null=True)
    eod_balance_5 = models.CharField(max_length=151, blank=True, null=True)
    eod_balance_15 = models.CharField(max_length=151, blank=True, null=True)
    eod_balance_25 = models.CharField(max_length=151, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'finbit_datas'


class FldgCategories(models.Model):
    merchant_id = models.IntegerField()
    name = models.CharField(max_length=191)
    fldg = models.IntegerField()
    user_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    available_exposure = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'fldg_categories'


class FldgCategoriesLogs(models.Model):
    merchant_id = models.IntegerField()
    category_id = models.IntegerField()
    name = models.CharField(max_length=191)
    fldg = models.IntegerField()
    user_id = models.IntegerField()
    action = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'fldg_categories_logs'


class Foir(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    credit_id = models.IntegerField(blank=True, null=True)
    accounttype = models.CharField(db_column='AccountType', max_length=191, blank=True, null=True)  # Field name made lowercase.
    institution = models.CharField(db_column='Institution', max_length=191, blank=True, null=True)  # Field name made lowercase.
    ownershiptype = models.CharField(db_column='OwnershipType', max_length=191, blank=True, null=True)  # Field name made lowercase.
    approvedamount = models.CharField(db_column='ApprovedAmount', max_length=191, blank=True, null=True)  # Field name made lowercase.
    balance = models.CharField(db_column='Balance', max_length=191, blank=True, null=True)  # Field name made lowercase.
    interestrate = models.CharField(db_column='InterestRate', max_length=191, blank=True, null=True)  # Field name made lowercase.
    repaymenttenure = models.IntegerField(db_column='RepaymentTenure', blank=True, null=True)  # Field name made lowercase.
    installmentamount = models.CharField(db_column='InstallmentAmount', max_length=191, blank=True, null=True)  # Field name made lowercase.
    cc_loan = models.IntegerField(blank=True, null=True)
    isopened = models.IntegerField(db_column='isOpened', blank=True, null=True)  # Field name made lowercase.
    dateopened = models.DateTimeField(db_column='DateOpened', blank=True, null=True)  # Field name made lowercase.
    dateclosed = models.DateTimeField(db_column='DateClosed', blank=True, null=True)  # Field name made lowercase.
    lastpaymentdate = models.DateTimeField(db_column='LastPaymentDate', blank=True, null=True)  # Field name made lowercase.
    lastpayment = models.IntegerField(db_column='LastPayment', blank=True, null=True)  # Field name made lowercase.
    pastdueamount = models.IntegerField(db_column='PastDueAmount', blank=True, null=True)  # Field name made lowercase.
    dpd = models.TextField(blank=True, null=True)
    applicant_type = models.IntegerField(blank=True, null=True)
    updated_by = models.IntegerField(blank=True, null=True)
    created_by = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_by = models.IntegerField(blank=True, null=True)
    installmentamountold = models.CharField(db_column='InstallmentAmountOLD', max_length=191)  # Field name made lowercase.
    installmentamountnew = models.CharField(db_column='InstallmentAmountNEW', max_length=191)  # Field name made lowercase.
    reporteddate = models.DateTimeField(db_column='ReportedDate', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'foir'


class FraudReport(models.Model):
    consumer_application_file_id = models.CharField(max_length=191, blank=True, null=True)
    application_id = models.CharField(max_length=191, blank=True, null=True)
    accountdetailsforaccountlistpage = models.CharField(db_column='accountDetailsForAccountListPage', max_length=191, blank=True, null=True)  # Field name made lowercase.
    accountholder = models.CharField(db_column='accountHolder', max_length=191, blank=True, null=True)  # Field name made lowercase.
    accountlimit = models.CharField(db_column='accountLimit', max_length=191, blank=True, null=True)  # Field name made lowercase.
    accountno = models.CharField(db_column='accountNo', max_length=191, blank=True, null=True)  # Field name made lowercase.
    accounttype = models.CharField(db_column='accountType', max_length=191, blank=True, null=True)  # Field name made lowercase.
    address = models.CharField(max_length=191, blank=True, null=True)
    availablecashlimit = models.CharField(db_column='availableCashLimit', max_length=191, blank=True, null=True)  # Field name made lowercase.
    availablecreditlimit = models.CharField(db_column='availableCreditLimit', max_length=191, blank=True, null=True)  # Field name made lowercase.
    bank = models.CharField(max_length=191, blank=True, null=True)
    bankaccountuid = models.CharField(db_column='bankAccountUID', max_length=191, blank=True, null=True)  # Field name made lowercase.
    bankaddress = models.CharField(db_column='bankAddress', max_length=191, blank=True, null=True)  # Field name made lowercase.
    bankcredentialco = models.CharField(db_column='bankCredentialCO', max_length=191, blank=True, null=True)  # Field name made lowercase.
    banktransactionlist = models.CharField(db_column='bankTransactionList', max_length=191, blank=True, null=True)  # Field name made lowercase.
    branchaddress = models.CharField(db_column='branchAddress', max_length=191, blank=True, null=True)  # Field name made lowercase.
    cifnumber = models.CharField(db_column='cifNumber', max_length=191, blank=True, null=True)  # Field name made lowercase.
    client = models.CharField(max_length=191, blank=True, null=True)
    creditcardno = models.CharField(db_column='creditCardNo', max_length=191, blank=True, null=True)  # Field name made lowercase.
    creditlimit = models.CharField(db_column='creditLimit', max_length=191, blank=True, null=True)  # Field name made lowercase.
    crnno = models.CharField(db_column='crnNo', max_length=191, blank=True, null=True)  # Field name made lowercase.
    currentcashadvance = models.CharField(db_column='currentCashAdvance', max_length=191, blank=True, null=True)  # Field name made lowercase.
    currentpurchasecharges = models.CharField(db_column='currentPurchaseCharges', max_length=191, blank=True, null=True)  # Field name made lowercase.
    customer = models.CharField(max_length=191, blank=True, null=True)
    customerid = models.CharField(db_column='customerID', max_length=191, blank=True, null=True)  # Field name made lowercase.
    customerphoneno = models.CharField(db_column='customerPhoneNo', max_length=191, blank=True, null=True)  # Field name made lowercase.
    duedate = models.CharField(db_column='dueDate', max_length=191, blank=True, null=True)  # Field name made lowercase.
    email = models.CharField(max_length=191, blank=True, null=True)
    fromdate = models.CharField(db_column='fromDate', max_length=191, blank=True, null=True)  # Field name made lowercase.
    ifscode = models.CharField(db_column='ifsCode', max_length=191, blank=True, null=True)  # Field name made lowercase.
    isvalidbankstatement = models.CharField(db_column='isValidBankStatement', max_length=191, blank=True, null=True)  # Field name made lowercase.
    lastpaymentreceived = models.CharField(db_column='lastPaymentReceived', max_length=191, blank=True, null=True)  # Field name made lowercase.
    micrcode = models.CharField(db_column='micrCode', max_length=191, blank=True, null=True)  # Field name made lowercase.
    minamountdue = models.CharField(db_column='minAmountDue', max_length=191, blank=True, null=True)  # Field name made lowercase.
    openingbalance = models.CharField(db_column='openingBalance', max_length=191, blank=True, null=True)  # Field name made lowercase.
    pan = models.CharField(max_length=191, blank=True, null=True)
    pointsearned = models.CharField(db_column='pointsEarned', max_length=191, blank=True, null=True)  # Field name made lowercase.
    prevbalance = models.CharField(db_column='prevBalance', max_length=191, blank=True, null=True)  # Field name made lowercase.
    relationshipwithbank = models.CharField(db_column='relationshipWithBank', max_length=191, blank=True, null=True)  # Field name made lowercase.
    todate = models.CharField(db_column='toDate', max_length=191, blank=True, null=True)  # Field name made lowercase.
    totalamountdue = models.CharField(db_column='totalAmountDue', max_length=191, blank=True, null=True)  # Field name made lowercase.
    uploadbankstatementco = models.CharField(db_column='uploadBankStatementCO', max_length=191, blank=True, null=True)  # Field name made lowercase.
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'fraud_report'


class FraudReportBankTransactions(models.Model):
    fraud_report_id = models.IntegerField()
    rule = models.CharField(max_length=191, blank=True, null=True)
    monthandyear = models.CharField(db_column='monthAndYear', max_length=191, blank=True, null=True)  # Field name made lowercase.
    cashdepositamount = models.CharField(db_column='cashDepositAmount', max_length=191, blank=True, null=True)  # Field name made lowercase.
    monthgapwithprevious = models.CharField(db_column='monthGapWithPrevious', max_length=191, blank=True, null=True)  # Field name made lowercase.
    salarytransactionamount = models.CharField(db_column='salaryTransactionAmount', max_length=191, blank=True, null=True)  # Field name made lowercase.
    salarytransactionbalanceaftertransaction = models.CharField(db_column='salaryTransactionBalanceAfterTransaction', max_length=191, blank=True, null=True)  # Field name made lowercase.
    salarytransactionamountdatetime = models.CharField(db_column='salaryTransactionAmountDateTime', max_length=191, blank=True, null=True)  # Field name made lowercase.
    salarytransactionamountdescription = models.CharField(db_column='salaryTransactionAmountDescription', max_length=191, blank=True, null=True)  # Field name made lowercase.
    salarytransactionamountfirstlevelcategory = models.CharField(db_column='salaryTransactionAmountFirstLevelCategory', max_length=191, blank=True, null=True)  # Field name made lowercase.
    salarytransactionamountremark = models.CharField(db_column='salaryTransactionAmountRemark', max_length=191, blank=True, null=True)  # Field name made lowercase.
    salarytransactionamountsecondlevelcategory = models.CharField(db_column='salaryTransactionAmountSecondLevelCategory', max_length=191, blank=True, null=True)  # Field name made lowercase.
    salarytransactionamounttransactionnumber = models.CharField(db_column='salaryTransactionAmountTransactionNumber', max_length=191, blank=True, null=True)  # Field name made lowercase.
    salarytransactionamounttype = models.CharField(db_column='salaryTransactionAmountType', max_length=191, blank=True, null=True)  # Field name made lowercase.
    salarytransactionamountvaluedate = models.CharField(db_column='salaryTransactionAmountValueDate', max_length=191, blank=True, null=True)  # Field name made lowercase.
    debittransactionamount = models.CharField(db_column='debitTransactionAmount', max_length=191, blank=True, null=True)  # Field name made lowercase.
    debittransactionbalanceaftertransaction = models.CharField(db_column='debitTransactionBalanceAfterTransaction', max_length=191, blank=True, null=True)  # Field name made lowercase.
    debittransactionamountdatetime = models.CharField(db_column='debitTransactionAmountDateTime', max_length=191, blank=True, null=True)  # Field name made lowercase.
    debittransactionamountdescription = models.CharField(db_column='debitTransactionAmountDescription', max_length=191, blank=True, null=True)  # Field name made lowercase.
    debittransactionamountfirstlevelcategory = models.CharField(db_column='debitTransactionAmountFirstLevelCategory', max_length=191, blank=True, null=True)  # Field name made lowercase.
    debittransactionamountremark = models.CharField(db_column='debitTransactionAmountRemark', max_length=191, blank=True, null=True)  # Field name made lowercase.
    debittransactionamountsecondlevelcategory = models.CharField(db_column='debitTransactionAmountSecondLevelCategory', max_length=191, blank=True, null=True)  # Field name made lowercase.
    debittransactionamounttransactionnumber = models.CharField(db_column='debitTransactionAmountTransactionNumber', max_length=191, blank=True, null=True)  # Field name made lowercase.
    debittransactionamounttype = models.CharField(db_column='debitTransactionAmountType', max_length=191, blank=True, null=True)  # Field name made lowercase.
    debittransactionamountvaluedate = models.CharField(db_column='debitTransactionAmountValueDate', max_length=191, blank=True, null=True)  # Field name made lowercase.
    missingsalaryinmonths = models.CharField(db_column='missingSalaryInMonths', max_length=191, blank=True, null=True)  # Field name made lowercase.
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'fraud_report_bank_transactions'


class FraudReportCategoryStatus(models.Model):
    fraud_report_id = models.CharField(max_length=191, blank=True, null=True)
    category = models.CharField(max_length=191, blank=True, null=True)
    rule = models.CharField(max_length=191, blank=True, null=True)
    ruleid = models.CharField(db_column='ruleId', max_length=191, blank=True, null=True)  # Field name made lowercase.
    rulename = models.CharField(db_column='ruleName', max_length=191, blank=True, null=True)  # Field name made lowercase.
    status = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'fraud_report_category_status'


class GcmRegistraions(models.Model):
    user_id = models.IntegerField()
    device_id = models.CharField(max_length=191, blank=True, null=True)
    fcm_id = models.CharField(max_length=191)
    device_type = models.CharField(max_length=191)
    status = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'gcm_registraions'


class GpsLogs(models.Model):
    user_id = models.IntegerField()
    gps_status = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    latitude = models.CharField(max_length=191, blank=True, null=True)
    longitude = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'gps_logs'


class GradeLocks(models.Model):
    grade_id = models.IntegerField()
    grade_alice = models.CharField(max_length=191)
    loan_amount = models.IntegerField()
    tenure = models.IntegerField()
    score = models.IntegerField()
    foir = models.IntegerField()
    cf_foir = models.IntegerField()
    monthly_income = models.IntegerField()
    thin_file_loan_amount = models.IntegerField(blank=True, null=True)
    thin_file_tenure = models.IntegerField(blank=True, null=True)
    thin_file_foir = models.IntegerField(blank=True, null=True)
    thin_file_cf_foir = models.IntegerField(blank=True, null=True)
    thin_file_monthly_income = models.IntegerField(blank=True, null=True)
    thin_file_age = models.CharField(max_length=191, blank=True, null=True)
    update_by = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    age = models.CharField(max_length=100, blank=True, null=True)
    amount_paid = models.IntegerField()
    amount_paid_cr = models.IntegerField()
    employee_status = models.CharField(max_length=191, blank=True, null=True)
    rejected = models.IntegerField()
    checkduplicates = models.IntegerField(db_column='checkDuplicates')  # Field name made lowercase.
    negative_area = models.IntegerField()
    guarantor = models.IntegerField()
    accounttype = models.IntegerField(db_column='accountType')  # Field name made lowercase.
    no_owned_house = models.IntegerField()
    zero_downpayment = models.IntegerField()
    casetype = models.IntegerField(db_column='caseType')  # Field name made lowercase.
    ageatlastemi = models.IntegerField(db_column='ageAtLastEMI')  # Field name made lowercase.
    dpdcountrejection = models.IntegerField(db_column='dpdCountRejection')  # Field name made lowercase.
    pastdues = models.IntegerField(db_column='pastDues')  # Field name made lowercase.
    threeyear = models.IntegerField(db_column='threeYear')  # Field name made lowercase.
    abovethreeyear = models.IntegerField(db_column='aboveThreeYear')  # Field name made lowercase.
    case_type_value = models.CharField(max_length=191, blank=True, null=True)
    ageatlastemi_age = models.IntegerField(db_column='ageAtLastEMI_age', blank=True, null=True)  # Field name made lowercase.
    dpdcountrejection_years = models.IntegerField(db_column='dpdCountRejection_years', blank=True, null=True)  # Field name made lowercase.
    dpdcountrejection_dpds = models.IntegerField(db_column='dpdCountRejection_dpds', blank=True, null=True)  # Field name made lowercase.
    pastdues_value = models.CharField(db_column='pastDues_value', max_length=191, blank=True, null=True)  # Field name made lowercase.
    dpd_keywords = models.CharField(max_length=400, blank=True, null=True)
    threeyear_years = models.IntegerField(db_column='threeYear_years', blank=True, null=True)  # Field name made lowercase.
    threeyear_dpds = models.IntegerField(db_column='threeYear_dpds', blank=True, null=True)  # Field name made lowercase.
    above_dpd_keywords = models.CharField(max_length=400, blank=True, null=True)
    abovethreeyear_years = models.IntegerField(db_column='aboveThreeYear_years', blank=True, null=True)  # Field name made lowercase.
    abovethreeyear_dpds = models.IntegerField(db_column='aboveThreeYear_dpds', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'grade_locks'


class Grades(models.Model):
    grade_alice = models.CharField(max_length=191)
    loan_amount = models.IntegerField()
    min_loan_amount = models.IntegerField()
    tenure = models.IntegerField()
    score = models.IntegerField(blank=True, null=True)
    foir = models.IntegerField()
    cf_foir = models.IntegerField()
    monthly_income = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    age = models.CharField(max_length=191, blank=True, null=True)
    thin_file_loan_amount = models.IntegerField(blank=True, null=True)
    thin_file_min_loan_amount = models.IntegerField()
    thin_file_tenure = models.IntegerField(blank=True, null=True)
    thin_file_foir = models.IntegerField(blank=True, null=True)
    thin_file_cf_foir = models.IntegerField(blank=True, null=True)
    thin_file_monthly_income = models.IntegerField(blank=True, null=True)
    thin_file_age = models.CharField(max_length=191, blank=True, null=True)
    is_pincode_approved = models.IntegerField(blank=True, null=True)
    last_payment_date_number = models.IntegerField(blank=True, null=True)
    amount_paid = models.IntegerField()
    amount_paid_cr = models.IntegerField(blank=True, null=True)
    employee_status = models.CharField(max_length=191, blank=True, null=True)
    bank_validation = models.IntegerField()
    thin_file_employee_status = models.CharField(max_length=191, blank=True, null=True)
    thin_file_bank_validation = models.IntegerField()
    epf_verification = models.IntegerField()
    fetch_gst = models.IntegerField()
    thin_file_epf_verification = models.IntegerField()
    thin_file_fetch_gst = models.IntegerField()
    indebtedness = models.CharField(max_length=191, blank=True, null=True)
    experience = models.CharField(max_length=191, blank=True, null=True)
    thin_file_indebtedness = models.CharField(max_length=191, blank=True, null=True)
    thin_file_experience = models.CharField(max_length=191, blank=True, null=True)
    track_record = models.IntegerField(blank=True, null=True)
    rejected = models.IntegerField()
    checkduplicates = models.IntegerField(db_column='checkDuplicates')  # Field name made lowercase.
    negative_area = models.IntegerField()
    guarantor = models.IntegerField()
    accounttype = models.IntegerField(db_column='accountType')  # Field name made lowercase.
    no_owned_house = models.IntegerField()
    zero_downpayment = models.IntegerField()
    casetype = models.IntegerField(db_column='caseType')  # Field name made lowercase.
    ageatlastemi = models.IntegerField(db_column='ageAtLastEMI')  # Field name made lowercase.
    dpdcountrejection = models.IntegerField(db_column='dpdCountRejection')  # Field name made lowercase.
    pastdues = models.IntegerField(db_column='pastDues')  # Field name made lowercase.
    threeyear = models.IntegerField(db_column='threeYear')  # Field name made lowercase.
    abovethreeyear = models.IntegerField(db_column='aboveThreeYear')  # Field name made lowercase.
    case_type_value = models.CharField(max_length=191, blank=True, null=True)
    ageatlastemi_age = models.IntegerField(db_column='ageAtLastEMI_age', blank=True, null=True)  # Field name made lowercase.
    dpdcountrejection_years = models.IntegerField(db_column='dpdCountRejection_years', blank=True, null=True)  # Field name made lowercase.
    dpdcountrejection_dpds = models.IntegerField(db_column='dpdCountRejection_dpds', blank=True, null=True)  # Field name made lowercase.
    pastdues_value = models.CharField(db_column='pastDues_value', max_length=191, blank=True, null=True)  # Field name made lowercase.
    dpd_keywords = models.CharField(max_length=400, blank=True, null=True)
    threeyear_years = models.IntegerField(db_column='threeYear_years', blank=True, null=True)  # Field name made lowercase.
    threeyear_dpds = models.IntegerField(db_column='threeYear_dpds', blank=True, null=True)  # Field name made lowercase.
    above_dpd_keywords = models.CharField(max_length=400, blank=True, null=True)
    abovethreeyear_years = models.IntegerField(db_column='aboveThreeYear_years', blank=True, null=True)  # Field name made lowercase.
    abovethreeyear_dpds = models.IntegerField(db_column='aboveThreeYear_dpds', blank=True, null=True)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'grades'


class GstAuthentication(models.Model):
    data = models.TextField()
    gstin = models.CharField(max_length=191)
    merchant_id = models.IntegerField()
    user_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    type = models.CharField(max_length=191)

    class Meta:
        managed = False
        db_table = 'gst_authentication'


class GstFilingLog(models.Model):
    month = models.CharField(max_length=191)
    year = models.IntegerField()
    date_of_filing = models.DateField()
    filed_by = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'gst_filing_log'


class GstPanData(models.Model):
    data = models.TextField(blank=True, null=True)
    application_id = models.CharField(max_length=191)
    user_id = models.CharField(max_length=191)
    pan = models.CharField(max_length=191)
    type = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'gst_pan_data'


class HolidayLists(models.Model):
    date = models.DateField()
    reason = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'holiday_lists'


class HypervergeVideoAttribute(models.Model):
    application_id = models.IntegerField()
    url_data = models.TextField()
    agent_url_data = models.TextField(blank=True, null=True)
    webhook = models.TextField(blank=True, null=True)
    applicant_type = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'hyperverge_video_attribute'


class HypervergeVideoWebhook(models.Model):
    hyper_id = models.IntegerField()
    data = models.TextField()
    applicant_type = models.IntegerField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    event_type = models.CharField(max_length=255, blank=True, null=True)
    timestamp = models.PositiveBigIntegerField(blank=True, null=True)
    application_id = models.PositiveBigIntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'hyperverge_video_webhook'


class Hypothecation(models.Model):
    application_id = models.IntegerField()
    lender = models.CharField(max_length=191)
    start_date = models.DateTimeField()
    end_date = models.DateTimeField()
    user_id = models.IntegerField()
    file = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'hypothecation'


class InvoiceRevisionLog(models.Model):
    application_id = models.IntegerField()
    changes = models.TextField(blank=True, null=True)
    field_id = models.IntegerField(db_column='_id')  # Field renamed because it started with '_'.
    type = models.CharField(max_length=191)
    revised_by = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'invoice_revision_log'


class Invoices(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    invoice_id = models.CharField(max_length=191, blank=True, null=True)
    amount = models.CharField(max_length=191, blank=True, null=True)
    net_amount = models.CharField(max_length=191, blank=True, null=True)
    igst = models.CharField(max_length=191, blank=True, null=True)
    cgst = models.CharField(max_length=191, blank=True, null=True)
    sgst = models.CharField(max_length=191, blank=True, null=True)
    status = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    lender_id = models.IntegerField(blank=True, null=True)
    type = models.CharField(max_length=255, blank=True, null=True)
    phase_id = models.IntegerField(blank=True, null=True)
    state = models.CharField(max_length=191, blank=True, null=True)
    gst_number = models.CharField(max_length=191, blank=True, null=True)
    receiver_name = models.CharField(max_length=191, blank=True, null=True)
    invoice_date = models.CharField(max_length=191, blank=True, null=True)
    merchant_id = models.IntegerField()
    center_id = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'invoices'


class InvoicesTest(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    invoice_id = models.CharField(max_length=191, blank=True, null=True)
    amount = models.CharField(max_length=191, blank=True, null=True)
    net_amount = models.CharField(max_length=191, blank=True, null=True)
    igst = models.CharField(max_length=191, blank=True, null=True)
    cgst = models.CharField(max_length=191, blank=True, null=True)
    sgst = models.CharField(max_length=191, blank=True, null=True)
    status = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    lender_id = models.IntegerField(blank=True, null=True)
    type = models.CharField(max_length=255, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'invoices_test'


class Irr(models.Model):
    application_id = models.IntegerField()
    flat_rate = models.IntegerField(blank=True, null=True)
    reducing_balance_rate = models.IntegerField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'irr'


class Jobs(models.Model):
    from_field = models.CharField(db_column='from', max_length=191)  # Field renamed because it was a Python reserved word.
    payload = models.TextField()
    application_id = models.IntegerField()
    available_at = models.DateTimeField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    is_available = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'jobs'


class JobsArchive(models.Model):
    from_field = models.CharField(db_column='from', max_length=191)  # Field renamed because it was a Python reserved word.
    payload = models.TextField()
    application_id = models.IntegerField()
    available_at = models.DateTimeField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    is_available = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'jobs_archive'


class KarzaVideoAttributes(models.Model):
    application_id = models.IntegerField()
    url_data = models.TextField()
    applicant_type = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'karza_video_attributes'


class KarzaVideoWebhooks(models.Model):
    karza_id = models.IntegerField()
    application_id = models.IntegerField(blank=True, null=True)
    applicant_type = models.IntegerField()
    data = models.TextField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'karza_video_webhooks'


class KarzaVkycApiLogs(models.Model):
    application_id = models.IntegerField()
    applicant_type = models.IntegerField()
    api_link = models.CharField(max_length=255, blank=True, null=True)
    request = models.TextField()
    response = models.TextField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'karza_vkyc_api_logs'


class KycDetails(models.Model):
    application_id = models.IntegerField()
    request_id = models.CharField(max_length=191)
    response = models.TextField(blank=True, null=True)
    applicant_type = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'kyc_details'


class LeadActions(models.Model):
    lead_id = models.IntegerField()
    lead_status = models.IntegerField()
    user_id = models.IntegerField()
    action_date = models.CharField(max_length=191)
    comment = models.TextField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'lead_actions'


class LeadFiles(models.Model):
    lead_id = models.IntegerField()
    bank_name = models.CharField(max_length=191, blank=True, null=True)
    password = models.CharField(max_length=191, blank=True, null=True)
    file_type = models.CharField(max_length=191)
    file_path = models.CharField(max_length=191)
    created_by = models.IntegerField()
    accountuid = models.CharField(db_column='accountUID', max_length=191, blank=True, null=True)  # Field name made lowercase.
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'lead_files'


class LeadLogs(models.Model):
    lead_id = models.IntegerField()
    lead_status = models.IntegerField()
    user_id = models.IntegerField()
    comment = models.TextField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'lead_logs'


class LeadStatus(models.Model):
    status = models.CharField(max_length=191)
    user_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'lead_status'


class Leads(models.Model):
    firm = models.CharField(max_length=191, blank=True, null=True)
    sector_id = models.IntegerField()
    business = models.CharField(max_length=191, blank=True, null=True)
    address = models.TextField(blank=True, null=True)
    state_id = models.IntegerField(blank=True, null=True)
    city = models.CharField(max_length=191, blank=True, null=True)
    pincode = models.CharField(max_length=191, blank=True, null=True)
    monthly_sales_value = models.CharField(max_length=191, blank=True, null=True)
    monthly_sales_volume = models.CharField(max_length=191, blank=True, null=True)
    description = models.TextField(blank=True, null=True)
    source = models.CharField(max_length=191, blank=True, null=True)
    contacts = models.TextField(blank=True, null=True)
    status = models.CharField(max_length=191)
    lead_generated_by = models.IntegerField()
    user_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    next_action_date = models.DateField(blank=True, null=True)
    action_date = models.CharField(max_length=191, blank=True, null=True)
    merchant_id = models.IntegerField(blank=True, null=True)
    deleted_by = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'leads'


class LeadsEmails(models.Model):
    lead_id = models.IntegerField()
    user_id = models.IntegerField()
    subject = models.CharField(max_length=191)
    message = models.TextField()
    hash_id = models.CharField(max_length=191, blank=True, null=True)
    attachment_url = models.CharField(max_length=191, blank=True, null=True)
    is_attachment = models.IntegerField()
    replied_message = models.TextField(blank=True, null=True)
    replied = models.IntegerField(blank=True, null=True)
    replied_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'leads_emails'


class LendboxBorrowerReg(models.Model):
    application_id = models.IntegerField()
    result = models.CharField(max_length=191, blank=True, null=True)
    lbuserid = models.IntegerField(db_column='lbUserId', blank=True, null=True)  # Field name made lowercase.
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    user_id = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'lendbox_borrower_reg'


class LendboxCreateLoan(models.Model):
    application_id = models.IntegerField()
    lbuserid = models.IntegerField(db_column='lbUserId')  # Field name made lowercase.
    lbloanid = models.IntegerField(db_column='lbLoanId')  # Field name made lowercase.
    result = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    user_id = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'lendbox_create_loan'


class LendboxDocuments(models.Model):
    application_id = models.IntegerField()
    consumer_application_file_id = models.IntegerField()
    response = models.CharField(max_length=191)
    status = models.CharField(max_length=191)
    user_id = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'lendbox_documents'


class LenderCategoryValidation(models.Model):
    lender_id = models.IntegerField()
    category_id = models.IntegerField()
    max_approved_amount = models.IntegerField()
    max_net_tenure = models.IntegerField()
    created_by = models.IntegerField()
    updated_by = models.IntegerField(blank=True, null=True)
    deleted_by = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'lender_category_validation'


class LenderLanguageConsents(models.Model):
    lender_id = models.IntegerField()
    language = models.CharField(max_length=191)
    consent = models.TextField()
    status = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'lender_language_consents'


class LendersBankDetails(models.Model):
    account_holder = models.CharField(max_length=191)
    lender_id = models.IntegerField()
    bank_name = models.CharField(max_length=191)
    branch_name = models.CharField(max_length=191)
    account_number = models.CharField(max_length=191)
    account_type = models.CharField(max_length=191)
    ifsc_code = models.CharField(max_length=191)
    utility_code = models.CharField(max_length=191)
    created_by = models.IntegerField()
    updated_by = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    email = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'lenders_bank_details'


class LiabilityLog(models.Model):
    application_id = models.CharField(max_length=191)
    liability_percent = models.CharField(max_length=5)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'liability_log'


class LoanAgreementVendor(models.Model):
    id = models.BigAutoField(primary_key=True)
    application_id = models.IntegerField()
    esign_vendor = models.CharField(max_length=25)
    esign_type = models.CharField(max_length=3)
    vendor_doc_id = models.CharField(max_length=255, blank=True, null=True)
    is_stamped = models.IntegerField()
    stamp_tag = models.CharField(max_length=25, blank=True, null=True)
    stamp_qty = models.PositiveIntegerField()
    status = models.CharField(max_length=3)
    expiry_days = models.PositiveSmallIntegerField()
    is_bor_signed = models.IntegerField()
    bor_signed_id = models.CharField(max_length=255, blank=True, null=True)
    is_cobor = models.IntegerField()
    is_cobor_signed = models.IntegerField()
    cobor_signed_id = models.CharField(max_length=255, blank=True, null=True)
    response = models.TextField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'loan_agreement_vendor'


class LoanDecisionTable(models.Model):
    application_id = models.IntegerField()
    offer_id = models.IntegerField()
    cf_foir = models.CharField(max_length=191)
    foir = models.CharField(max_length=191)
    tenure = models.IntegerField()
    status = models.IntegerField()
    reason = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    interest_rate = models.FloatField(blank=True, null=True)
    payable = models.IntegerField(blank=True, null=True)
    processing_fee = models.IntegerField(blank=True, null=True)
    up_front_from_customer = models.IntegerField(blank=True, null=True)
    emi = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'loan_decision_table'


class LoanDefault(models.Model):
    bucket = models.CharField(max_length=10)
    application_id = models.TextField()
    delay_days = models.IntegerField()
    over_due = models.IntegerField(blank=True, null=True)
    outstanding = models.IntegerField(blank=True, null=True)
    data_type = models.IntegerField(blank=True, null=True)
    fldg_hold_count = models.IntegerField()
    total_fldg_hold_amount = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'loan_default'


class Locations(models.Model):
    state = models.CharField(max_length=255, blank=True, null=True)
    city = models.CharField(max_length=255, blank=True, null=True)
    area = models.CharField(max_length=255, blank=True, null=True)
    location = models.CharField(max_length=255, blank=True, null=True)
    pincode = models.CharField(max_length=255, blank=True, null=True)
    comment = models.CharField(max_length=255, blank=True, null=True)
    level = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'locations'


class Mandate(models.Model):
    consumer_application_id = models.IntegerField()
    mandate_id = models.CharField(max_length=191, blank=True, null=True)
    umrn = models.CharField(max_length=191, blank=True, null=True)
    action = models.CharField(max_length=1, blank=True, null=True)
    collection = models.CharField(max_length=1, blank=True, null=True)
    frequency = models.CharField(max_length=1, blank=True, null=True)
    monthly_frequency = models.IntegerField(blank=True, null=True)
    mandate_amount = models.IntegerField(blank=True, null=True)
    status = models.CharField(max_length=11, blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    mode = models.CharField(max_length=100, blank=True, null=True)
    mandate_url = models.TextField(blank=True, null=True)
    rejection_message = models.TextField(blank=True, null=True)
    mandate_cancel_response = models.TextField(blank=True, null=True)
    applicant_id = models.IntegerField(blank=True, null=True)
    expiry_date = models.CharField(max_length=191, blank=True, null=True)
    until_cancelled = models.IntegerField(blank=True, null=True)
    date_first_collection = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'mandate'


class MandateLogs(models.Model):
    consumer_application_id = models.IntegerField()
    mandate_id = models.CharField(max_length=191, blank=True, null=True)
    umrn = models.CharField(max_length=191, blank=True, null=True)
    mode = models.CharField(max_length=191, blank=True, null=True)
    action = models.CharField(max_length=191, blank=True, null=True)
    collection = models.CharField(max_length=191, blank=True, null=True)
    frequency = models.CharField(max_length=191, blank=True, null=True)
    monthly_frequency = models.IntegerField(blank=True, null=True)
    mandate_amount = models.IntegerField(blank=True, null=True)
    rejection_message = models.TextField(blank=True, null=True)
    mandate_cancel_response = models.TextField(blank=True, null=True)
    status = models.CharField(max_length=191)
    created_by = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    applicant_id = models.IntegerField(blank=True, null=True)
    until_cancelled = models.IntegerField()
    expiry_date = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'mandate_logs'


class MandateRequestLogs(models.Model):
    application_id = models.IntegerField()
    request = models.TextField()
    response = models.TextField()
    is_retry = models.IntegerField()
    created_by = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    error_type = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'mandate_request_logs'


class MandateStatusLogs(models.Model):
    mandate_id = models.IntegerField(blank=True, null=True)
    user_id = models.IntegerField(blank=True, null=True)
    status = models.CharField(max_length=191, blank=True, null=True)
    reason = models.TextField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'mandate_status_logs'


class MandatoryDocumentListLogs(models.Model):
    application_id = models.IntegerField()
    user_id = models.IntegerField()
    mandatory_document_list = models.TextField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'mandatory_document_list_logs'


class MarketingLeads(models.Model):
    mobile_number = models.CharField(max_length=255)
    pan_card = models.CharField(max_length=255)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'marketing_leads'


class Merchant(models.Model):
    category_id = models.CharField(max_length=191, blank=True, null=True)
    merchant_name = models.CharField(max_length=191, blank=True, null=True)
    slug = models.CharField(unique=True, max_length=191, blank=True, null=True)
    merchant_logo = models.CharField(max_length=191, blank=True, null=True)
    financial_partner = models.CharField(max_length=191, blank=True, null=True)
    contact_number = models.CharField(max_length=191, blank=True, null=True)
    email = models.TextField(blank=True, null=True)
    address = models.CharField(max_length=191, blank=True, null=True)
    grade_id = models.CharField(max_length=191, blank=True, null=True)
    status = models.CharField(max_length=8)
    max_no_cases = models.IntegerField()
    max_approval_value = models.IntegerField()
    status_changed_by = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    created_by = models.IntegerField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    type_of_firm = models.CharField(max_length=191, blank=True, null=True)
    nature_of_business = models.CharField(max_length=191, blank=True, null=True)
    owner_name = models.CharField(max_length=191, blank=True, null=True)
    title = models.CharField(max_length=191, blank=True, null=True)
    gst_number = models.CharField(max_length=191, blank=True, null=True)
    is_processing_fees = models.IntegerField(blank=True, null=True)
    is_collected = models.IntegerField(blank=True, null=True)
    code = models.CharField(max_length=191, blank=True, null=True)
    referred_by = models.CharField(max_length=10, blank=True, null=True)
    rcp = models.CharField(max_length=191, blank=True, null=True)
    sales_head = models.CharField(max_length=191, blank=True, null=True)
    finance_head = models.CharField(max_length=191, blank=True, null=True)
    avg_ticket_size = models.IntegerField(blank=True, null=True)
    rcp_email = models.CharField(max_length=191, blank=True, null=True)
    rcp_mobile = models.CharField(max_length=191, blank=True, null=True)
    sales_head_email = models.CharField(max_length=191, blank=True, null=True)
    sales_head_mobile = models.CharField(max_length=191, blank=True, null=True)
    finance_head_email = models.CharField(max_length=191, blank=True, null=True)
    finance_head_mobile = models.CharField(max_length=191, blank=True, null=True)
    is_guest_active = models.IntegerField(blank=True, null=True)
    is_gst = models.IntegerField(blank=True, null=True)
    state = models.CharField(max_length=191, blank=True, null=True)
    anchor_merchant_id = models.IntegerField(blank=True, null=True)
    pincode = models.CharField(max_length=12, blank=True, null=True)
    source = models.CharField(max_length=191, blank=True, null=True)
    gender = models.IntegerField(blank=True, null=True)
    # dob = models.DateTimeField(blank=True, null=True)
    dob = models.IntegerField(blank=True, null=True)
    pan_card = models.CharField(max_length=191, blank=True, null=True)
    is_auto_abort = models.IntegerField(blank=True, null=True)
    city = models.CharField(max_length=191, blank=True, null=True)
    # co_applicant = models.IntegerField(db_column='co-applicant', blank=True, null=True)  # Field renamed to remove unsuitable characters.
    co_applicant_0 = models.IntegerField(db_column='co_applicant', blank=True, null=True)  # Field renamed because of name conflict.
    gst_is_defaulter = models.IntegerField(blank=True, null=True)
    gst_is_any_delay = models.IntegerField(blank=True, null=True)
    months_gst_filled = models.IntegerField(blank=True, null=True)
    gst_data = models.TextField(blank=True, null=True)
    is_physical_verification = models.IntegerField(blank=True, null=True)
    is_auto_abort_approved = models.IntegerField(blank=True, null=True)
    rm_id = models.IntegerField(blank=True, null=True)
    is_auto_doc = models.IntegerField(blank=True, null=True)
    is_auto_approve = models.IntegerField(blank=True, null=True)
    high_risk = models.IntegerField(blank=True, null=True)
    vulnerable_merchant = models.IntegerField(blank=True, null=True)
    vulnerable_merchant_date = models.DateTimeField(blank=True, null=True)
    pre_approval = models.IntegerField(blank=True, null=True)
    send_collection_report = models.IntegerField()
    pending_adjustable_amount = models.CharField(max_length=191, blank=True, null=True)
    pending_collection_report = models.IntegerField()
    special_notes = models.TextField(blank=True, null=True)
    longitude = models.CharField(max_length=191, blank=True, null=True)
    latitude = models.CharField(max_length=191, blank=True, null=True)
    year_in_business = models.CharField(max_length=191, blank=True, null=True)
    location_audit = models.CharField(max_length=191, blank=True, null=True)
    liability_percent = models.CharField(max_length=191, blank=True, null=True)
    insurance_premium = models.IntegerField()
    location_serviceable = models.CharField(max_length=191, blank=True, null=True)
    user_banking_reason = models.CharField(max_length=191, blank=True, null=True)
    pre_status = models.IntegerField()
    charge_subvention_remaining_amount = models.IntegerField()
    welcome_letter_sent = models.IntegerField()
    send_da_on_checklist = models.IntegerField()
    target_number_application = models.CharField(max_length=191)
    target_value_application = models.CharField(max_length=191)
    custom_grade_id = models.IntegerField(blank=True, null=True)
    remove_esign_otp = models.IntegerField()
    pay_data_sharing = models.IntegerField()
    # official_merchant_name = models.CharField(max_length=191, blank=True, null=True)
    collect_advance_amount = models.IntegerField()
    is_fldg_active = models.IntegerField()
    is_trade_advance = models.IntegerField()
    trade_advance_amount = models.CharField(max_length=191)
    trade_advance_balance = models.CharField(max_length=191)
    agreement_signed_with = models.CharField(max_length=191, blank=True, null=True)
    agreement_signed_by = models.CharField(max_length=191, blank=True, null=True)
    merchant_reg_type = models.CharField(max_length=191, blank=True, null=True)
    designation_of_sign_auth = models.CharField(max_length=191, blank=True, null=True)
    available_exposure = models.CharField(max_length=191)
    skip_appl_otp = models.IntegerField()
    auto_approve_category = models.IntegerField(blank=True, null=True)
    combined_sl_la = models.IntegerField()
    ips = models.TextField(blank=True, null=True)
    mis_frequency = models.IntegerField()
    create_app_lead_on_map = models.IntegerField(blank=True, null=True)
    subv_inv_on_center = models.IntegerField()
    processing_fee_on_advance_amount = models.IntegerField()
    hold_liability = models.IntegerField()
    total_revenue_per_month = models.IntegerField(blank=True, null=True)
    percentage_of_sales_in_emi = models.IntegerField(blank=True, null=True)
    number_of_lenders = models.IntegerField(blank=True, null=True)
    number_of_visits = models.IntegerField(blank=True, null=True)
    landmark = models.CharField(max_length=191, blank=True, null=True)
    table_of_offers = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'merchant'


class MerchantApiCredentials(models.Model):
    merchant_id = models.IntegerField()
    key = models.TextField()
    ips = models.TextField(blank=True, null=True)
    status = models.IntegerField()
    created_by = models.IntegerField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    secret = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'merchant_api_credentials'


class MerchantApiRequest(models.Model):
    request_id = models.CharField(max_length=191, blank=True, null=True)
    request = models.TextField(blank=True, null=True)
    response = models.TextField(blank=True, null=True)
    merchant_id = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'merchant_api_request'


class MerchantBank(models.Model):
    merchant_id = models.IntegerField()
    bank_name = models.CharField(max_length=191)
    account_holder = models.CharField(max_length=191, blank=True, null=True)
    account_number = models.CharField(max_length=191)
    branch_name = models.CharField(max_length=191)
    ifsc_code = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    karza_response = models.CharField(max_length=500, blank=True, null=True)
    beneficiary_id = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'merchant_bank'


class MerchantBankLogs(models.Model):
    merchant_id = models.IntegerField()
    bank_name = models.CharField(max_length=191, blank=True, null=True)
    account_holder = models.CharField(max_length=191, blank=True, null=True)
    account_number = models.CharField(max_length=191, blank=True, null=True)
    branch_name = models.CharField(max_length=191, blank=True, null=True)
    ifsc_code = models.CharField(max_length=191, blank=True, null=True)
    karza_response = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    user_id = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'merchant_bank_logs'


class MerchantCategory(models.Model):
    name = models.CharField(max_length=191)
    status = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'merchant_category'


class MerchantCategoryScripts(models.Model):
    category_id = models.IntegerField()
    script_content = models.TextField()
    user_id = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'merchant_category_scripts'


class MerchantCategoryScriptsLogs(models.Model):
    script_id = models.IntegerField()
    script_content = models.TextField()
    user_id = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'merchant_category_scripts_logs'


class MerchantCategoryTat(models.Model):
    category_id = models.IntegerField()
    status = models.IntegerField()
    created_by = models.IntegerField()
    updated_by = models.IntegerField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'merchant_category_tat'


class MerchantCustomerJourney(models.Model):
    user_id = models.IntegerField(blank=True, null=True)
    merchant_id = models.IntegerField()
    payload = models.TextField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'merchant_customer_journey'


class MerchantFiles(models.Model):
    merchant_id = models.IntegerField(blank=True, null=True)
    bank_name = models.CharField(max_length=191, blank=True, null=True)
    password = models.CharField(max_length=191, blank=True, null=True)
    file_type = models.CharField(max_length=191, blank=True, null=True)
    file_path = models.CharField(max_length=191, blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    location_id = models.IntegerField(blank=True, null=True)
    created_by = models.IntegerField(blank=True, null=True)
    accountuid = models.TextField(db_column='accountUID', blank=True, null=True)  # Field name made lowercase.
    type = models.CharField(max_length=191, blank=True, null=True)
    statemenfilettype = models.CharField(max_length=191, blank=True, null=True)
    statementtype = models.CharField(max_length=191, blank=True, null=True)
    accounttype = models.CharField(max_length=191, blank=True, null=True)
    finbit_analysis_date = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'merchant_files'


class MerchantFldgAutoApproveLogs(models.Model):
    merchant_id = models.IntegerField()
    auto_approve_category_id = models.IntegerField()
    created_by = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'merchant_fldg_auto_approve_logs'


class MerchantGstFillingDatas(models.Model):
    merchant_id = models.IntegerField(blank=True, null=True)
    filing_frequency = models.CharField(max_length=191, blank=True, null=True)
    financial_year = models.CharField(max_length=191, blank=True, null=True)
    status = models.CharField(max_length=191, blank=True, null=True)
    dof = models.CharField(max_length=191, blank=True, null=True)
    ret_prd = models.CharField(max_length=191, blank=True, null=True)
    is_delay = models.IntegerField(blank=True, null=True)
    valid = models.CharField(max_length=191, blank=True, null=True)
    rtntype = models.CharField(max_length=191, blank=True, null=True)
    mof = models.CharField(max_length=191, blank=True, null=True)
    arn = models.CharField(max_length=191, blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    type = models.CharField(max_length=191)

    class Meta:
        managed = False
        db_table = 'merchant_gst_filling_datas'


class MerchantLocation(models.Model):
    merchant_id = models.IntegerField()
    name = models.CharField(max_length=191, blank=True, null=True)
    email = models.CharField(max_length=191, blank=True, null=True)
    phone = models.CharField(max_length=191, blank=True, null=True)
    slug = models.CharField(max_length=191, blank=True, null=True)
    location = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    gst_number = models.CharField(max_length=191, blank=True, null=True)
    # is_processing_fees = models.IntegerField(blank=True, null=True)
    is_physical_verification = models.IntegerField(blank=True, null=True)
    state = models.CharField(max_length=191, blank=True, null=True)
    gst_data = models.TextField(blank=True, null=True)
    gst_is_any_delay = models.IntegerField(blank=True, null=True)
    gst_is_defaulter = models.IntegerField(blank=True, null=True)
    months_gst_filled = models.IntegerField(blank=True, null=True)
    total_revenue_per_month = models.IntegerField(blank=True, null=True)
    percentage_of_sales_in_emi = models.IntegerField(blank=True, null=True)
    number_of_lenders = models.IntegerField(blank=True, null=True)
    number_of_visits = models.IntegerField(blank=True, null=True)
    landmark = models.CharField(max_length=191, blank=True, null=True)
    target_number_application = models.CharField(max_length=191)
    target_value_application = models.CharField(max_length=191)
    avg_ticket_size = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'merchant_location'


class MerchantLocationBank(models.Model):
    location_id = models.IntegerField()
    bank_name = models.CharField(max_length=191)
    account_number = models.CharField(max_length=191)
    branch_name = models.CharField(max_length=191)
    ifsc_code = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    account_holder = models.CharField(max_length=191, blank=True, null=True)
    karza_response = models.CharField(max_length=500, blank=True, null=True)
    beneficiary_id = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'merchant_location_bank'


class MerchantLog(models.Model):
    merchant_id = models.IntegerField()
    user_id = models.IntegerField(blank=True, null=True)
    grade_id = models.IntegerField(blank=True, null=True)
    offer_id = models.IntegerField(blank=True, null=True)
    merchant_module_id = models.IntegerField(blank=True, null=True)
    data = models.CharField(max_length=191, blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'merchant_log'


class MerchantModule(models.Model):
    merchant_id = models.IntegerField()
    tenure = models.IntegerField()
    subvention = models.FloatField()
    status = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    created_by = models.IntegerField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    module_set_by = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'merchant_module'


class MerchantOffers(models.Model):
    merchant_id = models.IntegerField()
    category_id = models.IntegerField(blank=True, null=True)
    slug = models.CharField(max_length=191, blank=True, null=True)
    processing_fee = models.IntegerField(blank=True, null=True)
    interest_type_id = models.IntegerField(blank=True, null=True)
    subvention_type_id = models.IntegerField(blank=True, null=True)
    advance_type = models.CharField(max_length=191, blank=True, null=True)
    processing_fee_type = models.CharField(max_length=191, blank=True, null=True)
    tenure = models.IntegerField()
    advance_emi = models.IntegerField()
    interest_rate = models.FloatField()
    subvention = models.FloatField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    is_deleted = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_by = models.IntegerField(blank=True, null=True)
    checked_by = models.IntegerField(blank=True, null=True)
    status = models.IntegerField(blank=True, null=True)
    monthly_irr = models.FloatField(blank=True, null=True)
    annualised_irr = models.FloatField(blank=True, null=True)
    payment_frequency = models.IntegerField(blank=True, null=True)
    disbursement_method = models.IntegerField(blank=True, null=True)
    processing_fee_first_emi = models.IntegerField()
    reason = models.TextField(blank=True, null=True)
    bnpl_repayment = models.CharField(max_length=191, blank=True, null=True)
    disable_offer_status = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'merchant_offers'


class MerchantOffersLock(models.Model):
    merchant_id = models.IntegerField()
    category_id = models.IntegerField(blank=True, null=True)
    slug = models.CharField(max_length=191, blank=True, null=True)
    processing_fee = models.IntegerField(blank=True, null=True)
    interest_type_id = models.IntegerField(blank=True, null=True)
    subvention_type_id = models.IntegerField(blank=True, null=True)
    advance_type = models.CharField(max_length=191, blank=True, null=True)
    processing_fee_type = models.CharField(max_length=191, blank=True, null=True)
    tenure = models.IntegerField()
    advance_emi = models.IntegerField()
    interest_rate = models.FloatField()
    subvention = models.FloatField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    is_deleted = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_by = models.IntegerField(blank=True, null=True)
    checked_by = models.IntegerField(blank=True, null=True)
    status = models.IntegerField(blank=True, null=True)
    monthly_irr = models.FloatField(blank=True, null=True)
    annualised_irr = models.FloatField(blank=True, null=True)
    archived_by = models.IntegerField(blank=True, null=True)
    is_already_active = models.IntegerField(blank=True, null=True)
    reason = models.TextField(blank=True, null=True)
    offer_id = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'merchant_offers_lock'


class MerchantRelationshipAnalytics(models.Model):
    merchant_id = models.IntegerField()
    application_received = models.IntegerField(blank=True, null=True)
    case_approved = models.IntegerField(blank=True, null=True)
    case_disbursed = models.IntegerField(blank=True, null=True)
    value_disbursed = models.IntegerField(blank=True, null=True)
    case_cancelled = models.IntegerField(blank=True, null=True)
    nach_registered = models.IntegerField(blank=True, null=True)
    processing_fee_collected = models.IntegerField(blank=True, null=True)
    principal_outstanding = models.IntegerField(blank=True, null=True)
    cash_collected = models.IntegerField(blank=True, null=True)
    percentage_due = models.IntegerField(blank=True, null=True)
    over_due_amount = models.IntegerField(blank=True, null=True)
    case_with_dpd = models.IntegerField(blank=True, null=True)
    percentage_dpd = models.IntegerField(blank=True, null=True)
    average_credit_score = models.IntegerField(blank=True, null=True)
    percentage_new_to_credit = models.IntegerField(blank=True, null=True)
    percentage_npa = models.IntegerField(blank=True, null=True)
    percentage_lgd = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'merchant_relationship_analytics'


class MerchantUserRequest(models.Model):
    name = models.CharField(max_length=191)
    mobile_number = models.CharField(max_length=191)
    email_id = models.CharField(max_length=191)
    designation = models.CharField(max_length=191)
    location = models.CharField(max_length=191)
    merchant_name = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'merchant_user_request'


class MerchantWhitelistLender(models.Model):
    merchant_id = models.IntegerField()
    lender_id = models.IntegerField()
    user_id = models.IntegerField()
    deleted_by = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'merchant_whitelist_lender'


class Migrations(models.Model):
    migration = models.CharField(max_length=191)
    batch = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'migrations'


class ModificationRequests(models.Model):
    uri = models.CharField(max_length=191)
    param = models.TextField()
    user_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'modification_requests'


class Moratorium(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    emi_date = models.CharField(max_length=191)
    interest_rate = models.CharField(max_length=191, blank=True, null=True)
    user_id = models.IntegerField()
    status = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    stopped_date = models.DateTimeField(blank=True, null=True)
    started_date = models.DateTimeField(blank=True, null=True)
    stopped_by = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'moratorium'


class NachSupportedBank(models.Model):
    bank = models.CharField(max_length=191)
    bank_code = models.CharField(max_length=191)
    type_of_bank = models.CharField(max_length=191)
    ifsc = models.CharField(max_length=191)
    micr = models.CharField(max_length=191)
    iin = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'nach_supported_bank'


class NegativeProfile(models.Model):
    name = models.CharField(max_length=255)
    is_hard_reject = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'negative_profile'


class Onfido(models.Model):
    application_id = models.IntegerField()
    data = models.TextField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    applicant_token_id = models.CharField(max_length=191, blank=True, null=True)
    check_response = models.TextField(blank=True, null=True)
    webhook_response = models.TextField(blank=True, null=True)
    check_id = models.TextField(blank=True, null=True)
    list_document = models.TextField(blank=True, null=True)
    list_live_photo = models.TextField(blank=True, null=True)
    list_live_video = models.TextField(blank=True, null=True)
    list_checks = models.TextField(blank=True, null=True)
    applicant_type = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'onfido'


class OnlinePayments(models.Model):
    application_id = models.IntegerField()
    payment_id = models.CharField(max_length=191, blank=True, null=True)
    payment_link = models.TextField(blank=True, null=True)
    amount = models.CharField(max_length=191)
    name = models.CharField(max_length=191, blank=True, null=True)
    email = models.CharField(max_length=191, blank=True, null=True)
    contact = models.CharField(max_length=191, blank=True, null=True)
    status = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    purpose = models.CharField(max_length=100, blank=True, null=True)
    emi_date = models.CharField(max_length=255, blank=True, null=True)
    response = models.TextField(blank=True, null=True)
    foreclosure_date = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'online_payments'


class OtpManager(models.Model):
    mobile_number = models.CharField(max_length=191, blank=True, null=True)
    otp = models.IntegerField(blank=True, null=True)
    status = models.CharField(max_length=10)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'otp_manager'


class Partners(models.Model):
    name = models.CharField(max_length=191)
    contact = models.CharField(max_length=191)
    email = models.CharField(max_length=191)
    company_name = models.CharField(max_length=191)
    turnover = models.CharField(max_length=191)
    website = models.CharField(max_length=191)
    existing_partner = models.IntegerField()
    merchant = models.CharField(max_length=191)
    industry = models.CharField(max_length=191)
    reference = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    refer_code = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'partners'


class PasswordResets(models.Model):
    email = models.CharField(max_length=191)
    token = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'password_resets'


class PaymentStatusLogs(models.Model):
    application_id = models.IntegerField()
    emi_payment_id = models.IntegerField()
    payment_date = models.DateTimeField()
    payment_reconciliation_date = models.DateTimeField(blank=True, null=True)
    status = models.CharField(max_length=191)
    reason = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    mode = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'payment_status_logs'


class PaymentTransactionDifferLogs(models.Model):
    user_id = models.IntegerField()
    transaction_id = models.IntegerField()
    emi_payment_id_old = models.IntegerField()
    emi_payment_id_new = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'payment_transaction_differ_logs'


class PaymentTransactions(models.Model):
    emi_payment_id = models.IntegerField()
    amount = models.IntegerField()
    mode = models.CharField(max_length=191)
    trasanction_id = models.CharField(max_length=191, blank=True, null=True)
    trasanction_acknowledgement = models.TextField(blank=True, null=True)
    payment_date = models.DateTimeField()
    status = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    paid_by = models.CharField(max_length=255, blank=True, null=True)
    collected_by = models.CharField(max_length=255, blank=True, null=True)
    wallet_name = models.CharField(max_length=255, blank=True, null=True)
    reason = models.TextField(blank=True, null=True)
    umrn = models.CharField(max_length=255, blank=True, null=True)
    application_id = models.IntegerField(blank=True, null=True)
    payment_for = models.CharField(max_length=255, blank=True, null=True)
    payment_reconciliation_date = models.DateTimeField(blank=True, null=True)
    cf_transaction_id = models.CharField(max_length=191, blank=True, null=True)
    bank_id = models.IntegerField(blank=True, null=True)
    bank_name = models.CharField(max_length=191, blank=True, null=True)
    is_deleted_at = models.DateTimeField(blank=True, null=True)
    deleted_by = models.IntegerField(blank=True, null=True)
    refunded_at = models.DateTimeField(blank=True, null=True)
    refunded_by = models.IntegerField(blank=True, null=True)
    collected_by_type = models.IntegerField(blank=True, null=True)
    adjust_with_disbursement = models.CharField(max_length=12, blank=True, null=True)
    adjusted_to = models.IntegerField(blank=True, null=True)
    adjusted_by = models.IntegerField(blank=True, null=True)
    differ_id = models.IntegerField(blank=True, null=True)
    is_advance_payment = models.CharField(max_length=191, blank=True, null=True)
    refund_maker_id = models.IntegerField(blank=True, null=True)
    refund_maker_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'payment_transactions'


class PaymentsMakerChecker(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    data = models.TextField(blank=True, null=True)
    maker_id = models.IntegerField(blank=True, null=True)
    checker_id = models.IntegerField(blank=True, null=True)
    status = models.IntegerField(blank=True, null=True)
    type = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    verify_date = models.DateTimeField(blank=True, null=True)
    emi_payment_id = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'payments_maker_checker'


class PayoutPreserve(models.Model):
    payout_status_id = models.IntegerField()
    request = models.TextField(blank=True, null=True)
    response = models.TextField(blank=True, null=True)
    user_id = models.IntegerField(blank=True, null=True)
    status = models.CharField(max_length=191, blank=True, null=True)
    api = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'payout_preserve'


class PayoutStatus(models.Model):
    application_id = models.IntegerField()
    user_id = models.IntegerField()
    status = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    retry = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'payout_status'


class PendingBalance(models.Model):
    application_id = models.IntegerField()
    pending = models.CharField(max_length=191)
    amount = models.CharField(max_length=191)
    status = models.CharField(max_length=191)
    adjusted_to = models.IntegerField(blank=True, null=True)
    type = models.CharField(max_length=191)
    transaction_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    merchant_id = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'pending_balance'


class PincodeApprovers(models.Model):
    user_id = models.IntegerField()
    application_id = models.IntegerField()
    reason = models.TextField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_by = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'pincode_approvers'


class PincodeMapping(models.Model):
    pincode = models.CharField(max_length=191)
    city = models.CharField(max_length=191)
    state = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'pincode_mapping'


class Pincodes(models.Model):
    pincode = models.CharField(max_length=191)
    taluk = models.CharField(max_length=191, blank=True, null=True)
    districtname = models.CharField(max_length=191, blank=True, null=True)
    state = models.CharField(max_length=191, blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'pincodes'


class Positions(models.Model):
    department = models.CharField(max_length=191)
    user_id = models.IntegerField()
    deleted_by = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'positions'


class PreApproval(models.Model):
    grade_id = models.IntegerField()
    thin_file = models.IntegerField()
    employment_type = models.CharField(max_length=191)
    loan_amount = models.IntegerField()
    min_loan_amount = models.IntegerField()
    net_tenure = models.IntegerField()
    score = models.IntegerField()
    past_dues = models.IntegerField()
    foir = models.IntegerField()
    cf_foir = models.IntegerField()
    monthly_income = models.IntegerField()
    min_age = models.IntegerField()
    max_age = models.IntegerField()
    residence_status = models.CharField(max_length=191)
    status = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'pre_approval'


class PreApprovalLock(models.Model):
    grade_id = models.IntegerField()
    thin_file = models.IntegerField()
    employment_type = models.CharField(max_length=191)
    loan_amount = models.IntegerField()
    min_loan_amount = models.IntegerField()
    net_tenure = models.IntegerField()
    score = models.IntegerField()
    past_dues = models.IntegerField()
    foir = models.IntegerField()
    cf_foir = models.IntegerField()
    monthly_income = models.IntegerField()
    min_age = models.IntegerField()
    max_age = models.IntegerField()
    residence_status = models.CharField(max_length=191)
    status = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    update_by = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'pre_approval_lock'


class PreApprovalLog(models.Model):
    grade_id = models.IntegerField()
    application_id = models.IntegerField(blank=True, null=True)
    employee_status = models.CharField(max_length=191, blank=True, null=True)
    past_dues = models.IntegerField(blank=True, null=True)
    foir = models.IntegerField(blank=True, null=True)
    cf_foir = models.IntegerField(blank=True, null=True)
    score = models.CharField(max_length=101, blank=True, null=True)
    loan_amount = models.IntegerField(blank=True, null=True)
    tenure = models.IntegerField(blank=True, null=True)
    gold = models.IntegerField(blank=True, null=True)
    monthly_income = models.IntegerField(blank=True, null=True)
    age = models.IntegerField(blank=True, null=True)
    residence_status = models.CharField(max_length=191, blank=True, null=True)
    age_at_last_emi = models.IntegerField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    pre_approval_id = models.IntegerField(blank=True, null=True)
    term_loan = models.IntegerField(blank=True, null=True)
    case_type = models.IntegerField(blank=True, null=True)
    three_year = models.IntegerField(blank=True, null=True)
    above_three = models.IntegerField(blank=True, null=True)
    account_type = models.CharField(max_length=191, blank=True, null=True)
    dpd = models.IntegerField(blank=True, null=True)
    black_list = models.IntegerField()
    request_id = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'pre_approval_log'


class Predictions(models.Model):
    pif = models.BigAutoField(primary_key=True)
    lid = models.PositiveBigIntegerField(blank=True, null=True)
    api_call = models.CharField(max_length=50, blank=True, null=True)
    decision = models.IntegerField()
    reason = models.CharField(max_length=255, blank=True, null=True)
    error = models.CharField(max_length=255, blank=True, null=True)
    payload = models.TextField(blank=True, null=True)
    response = models.TextField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'predictions'


class PrincipalOutstanding(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    principal_outstanding = models.CharField(max_length=191)
    date = models.DateTimeField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'principal_outstanding'


class ProFormaInvoice(models.Model):
    application_id = models.IntegerField()
    gst_number = models.CharField(max_length=191, blank=True, null=True)
    center_name = models.CharField(max_length=191, blank=True, null=True)
    customer_name = models.CharField(max_length=191, blank=True, null=True)
    treatment_name = models.CharField(max_length=191, blank=True, null=True)
    customer_registration_date = models.CharField(max_length=191, blank=True, null=True)
    customer_registration_number = models.CharField(max_length=191, blank=True, null=True)
    loan_application_no = models.CharField(max_length=191, blank=True, null=True)
    processing_fee_by_merchant = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    insurance_premium_by_merchant = models.IntegerField()
    insurance_premium_applicable = models.IntegerField(blank=True, null=True)
    insurance_premium_amount = models.CharField(max_length=191, blank=True, null=True)
    merchant_collected_advance_amount = models.IntegerField()
    fldg_applied = models.IntegerField()
    liability_hold = models.IntegerField()
    fldg_applied_category = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'pro_forma_invoice'


class ProductOffers(models.Model):
    product_id = models.IntegerField()
    offer_id = models.IntegerField()
    user_id = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'product_offers'


class Products(models.Model):
    merchant_id = models.IntegerField()
    name = models.CharField(max_length=191)
    code = models.CharField(max_length=191)
    warranty = models.CharField(max_length=191)
    description = models.TextField()
    amount = models.CharField(max_length=191)
    updated_by = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    center_id = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'products'


class ProjectLeadActions(models.Model):
    lead_id = models.IntegerField()
    lead_status = models.IntegerField()
    user_id = models.IntegerField()
    action_date = models.CharField(max_length=191)
    comment = models.TextField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'project_lead_actions'


class ProjectLeadFiles(models.Model):
    lead_id = models.IntegerField()
    bank_name = models.CharField(max_length=191, blank=True, null=True)
    password = models.CharField(max_length=191, blank=True, null=True)
    file_type = models.CharField(max_length=191)
    file_path = models.CharField(max_length=191)
    accounttype = models.CharField(max_length=191, blank=True, null=True)
    statementtype = models.CharField(max_length=191, blank=True, null=True)
    statemenfilettype = models.CharField(max_length=191, blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'project_lead_files'


class ProjectLeadLogs(models.Model):
    lead_id = models.IntegerField()
    lead_status = models.IntegerField()
    user_id = models.IntegerField()
    comment = models.TextField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'project_lead_logs'


class ProjectLeadStatus(models.Model):
    status = models.CharField(max_length=191)
    user_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'project_lead_status'


class ProjectLeads(models.Model):
    firm = models.CharField(max_length=191, blank=True, null=True)
    sector_id = models.IntegerField()
    address = models.TextField(blank=True, null=True)
    state_id = models.IntegerField(blank=True, null=True)
    city = models.CharField(max_length=191, blank=True, null=True)
    pincode = models.CharField(max_length=191, blank=True, null=True)
    description = models.TextField(blank=True, null=True)
    source = models.CharField(max_length=191, blank=True, null=True)
    contacts = models.TextField(blank=True, null=True)
    status = models.CharField(max_length=191)
    lead_generated_by = models.IntegerField()
    application_id = models.IntegerField(blank=True, null=True)
    user_id = models.IntegerField()
    deleted_by = models.CharField(max_length=191, blank=True, null=True)
    action_date = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'project_leads'


class ProjectLeadsEmails(models.Model):
    lead_id = models.IntegerField()
    user_id = models.IntegerField()
    subject = models.CharField(max_length=191)
    message = models.TextField()
    hash_id = models.CharField(max_length=191, blank=True, null=True)
    attachment_url = models.CharField(max_length=191, blank=True, null=True)
    is_attachment = models.IntegerField()
    replied = models.IntegerField()
    replied_at = models.DateTimeField(blank=True, null=True)
    replied_message = models.TextField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'project_leads_emails'


class PromiseToPay(models.Model):
    application_id = models.IntegerField()
    date = models.CharField(max_length=191)
    payment_received = models.IntegerField()
    payment_received_date = models.CharField(max_length=191, blank=True, null=True)
    user_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'promise_to_pay'


class QueueLog(models.Model):
    job_id = models.BigAutoField(primary_key=True)
    uid = models.PositiveBigIntegerField(blank=True, null=True)
    status = models.CharField(max_length=191)
    exchange = models.CharField(max_length=255, blank=True, null=True)
    route_key = models.CharField(max_length=255, blank=True, null=True)
    job_handler = models.CharField(max_length=255, blank=True, null=True)
    input = models.TextField(blank=True, null=True)
    output = models.TextField(blank=True, null=True)
    attempt_count = models.SmallIntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    job_status = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'queue_log'


class RefundPayment(models.Model):
    application_id = models.CharField(max_length=191)
    payment_id = models.CharField(max_length=191)
    referenceid = models.CharField(db_column='referenceId', max_length=191, blank=True, null=True)  # Field name made lowercase.
    transferid = models.CharField(db_column='transferId', max_length=191, blank=True, null=True)  # Field name made lowercase.
    status = models.CharField(max_length=191)
    message = models.CharField(max_length=191)
    acknowledged = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    utr = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'refund_payment'


class ReportedClosedApplications(models.Model):
    application_id = models.IntegerField()
    user_id = models.IntegerField()
    comment = models.TextField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'reported_closed_applications'


class ReviseDocumentLogs(models.Model):
    application_id = models.IntegerField()
    doc_list = models.TextField()
    user_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'revise_document_logs'


class RiskyAttributions(models.Model):
    risky_app_keywords = models.TextField()
    risky_sms_keywords = models.TextField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'risky_attributions'


class SanctionAmountLogs(models.Model):
    application_id = models.IntegerField()
    approved_amount = models.CharField(max_length=191)
    user_id = models.IntegerField()
    is_esing_done = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'sanction_amount_logs'


class SeoData(models.Model):
    link = models.TextField()
    title = models.TextField()
    description = models.TextField()
    user_id = models.TextField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'seo_data'


class Services(models.Model):
    name = models.CharField(max_length=191)
    status = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    start_time = models.CharField(max_length=191, blank=True, null=True)
    service_count = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'services'


class Sessions(models.Model):
    user_id = models.PositiveIntegerField(blank=True, null=True)
    ip_address = models.CharField(max_length=45, blank=True, null=True)
    user_agent = models.TextField(blank=True, null=True)
    payload = models.TextField()
    last_activity = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'sessions'


class Settlements(models.Model):
    data = models.TextField()
    type = models.CharField(max_length=191)
    payment_date = models.DateTimeField()
    reconciliation_date = models.DateTimeField()
    available_at = models.DateTimeField()
    is_available = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    status = models.CharField(max_length=191, blank=True, null=True)
    user_id = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'settlements'


class SettlementsJobs(models.Model):
    data = models.TextField()
    settlement_id = models.DateTimeField()
    available_at = models.DateTimeField()
    is_available = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'settlements_jobs'


class SmsLogs(models.Model):
    mobile_number = models.CharField(max_length=191)
    message = models.TextField()
    request_url = models.TextField()
    response = models.TextField()
    provider = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    field_id = models.IntegerField(db_column='_id', blank=True, null=True)  # Field renamed because it started with '_'.
    id_type = models.CharField(max_length=191, blank=True, null=True)
    created_by = models.IntegerField(blank=True, null=True)
    iswhatsapp = models.IntegerField(db_column='isWhatsapp')  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'sms_logs'


class State(models.Model):
    name = models.CharField(max_length=191)
    code = models.CharField(max_length=2, blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    code_number = models.CharField(max_length=2, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'state'


class StaticPage(models.Model):
    title = models.CharField(max_length=191)
    url = models.CharField(max_length=191)
    html = models.TextField()
    user_id = models.IntegerField()
    is_published = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    meta = models.TextField(blank=True, null=True)
    web_notice = models.IntegerField()
    cover_image = models.TextField(blank=True, null=True)
    cover_image_text = models.TextField(blank=True, null=True)
    breadcrumbs = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'static_page'


class StatusLogs(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    user_id = models.IntegerField(blank=True, null=True)
    status = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    reason = models.TextField(blank=True, null=True)
    is_reversed = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'status_logs'


class TallyJobsNew(models.Model):
    from_field = models.CharField(db_column='from', max_length=191)  # Field renamed because it was a Python reserved word.
    payload = models.CharField(max_length=255, blank=True, null=True)
    application_id = models.IntegerField()
    available_at = models.DateTimeField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    is_available = models.IntegerField(blank=True, null=True)
    emi_date = models.DateField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'tally_jobs_new'


class TatLogs(models.Model):
    field_id = models.IntegerField(db_column='_id')  # Field renamed because it started with '_'.
    id_type = models.CharField(max_length=191)
    action = models.CharField(max_length=191)
    user_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'tat_logs'


class TaxRates(models.Model):
    tax = models.CharField(max_length=191)
    tax_rate = models.FloatField()
    applicable_from = models.DateTimeField()
    created_by = models.IntegerField(blank=True, null=True)
    updated_by = models.IntegerField(blank=True, null=True)
    status = models.IntegerField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'tax_rates'


class TelecomDatas(models.Model):
    mobile_number = models.CharField(max_length=191, blank=True, null=True)
    telecom_response = models.TextField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'telecom_datas'


class TradeAdvanceDisbursement(models.Model):
    application_id = models.CharField(max_length=191)
    merchant_id = models.CharField(max_length=191)
    net_amount = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'trade_advance_disbursement'


class TradeAdvanceLogs(models.Model):
    merchant_id = models.IntegerField(blank=True, null=True)
    trade_advance_amount = models.CharField(max_length=191)
    user_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'trade_advance_logs'


class UserAttribution(models.Model):
    user_id = models.IntegerField()
    application_id = models.IntegerField(blank=True, null=True)
    utm_source = models.CharField(max_length=191, blank=True, null=True)
    utm_medium = models.CharField(max_length=191, blank=True, null=True)
    utm_campaign = models.CharField(max_length=191, blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'user_attribution'


class UserEmails(models.Model):
    email = models.CharField(max_length=191)
    status = models.IntegerField()
    email_karza_response = models.TextField()
    type = models.CharField(max_length=191)
    field_id = models.IntegerField(db_column='_id')  # Field renamed because it started with '_'.
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'user_emails'


class UserGeolocation(models.Model):
    applicant_id = models.IntegerField()
    applicant_type = models.IntegerField(blank=True, null=True)
    field_id = models.IntegerField(db_column='_id')  # Field renamed because it started with '_'.
    id_type = models.CharField(max_length=191)
    service = models.CharField(max_length=191)
    latitude = models.DecimalField(max_digits=10, decimal_places=8)
    longitude = models.DecimalField(max_digits=11, decimal_places=8)
    pincode = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'user_geolocation'


class UserLocations(models.Model):
    user_id = models.IntegerField()
    latitude = models.CharField(max_length=191)
    longitude = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'user_locations'


class UserNearestStations(models.Model):
    field_id = models.IntegerField(db_column='_id')  # Field renamed because it started with '_'.
    id_type = models.CharField(max_length=191)
    applicant_id = models.IntegerField()
    applicant_type = models.IntegerField()
    latitude = models.DecimalField(max_digits=10, decimal_places=8)
    longitude = models.DecimalField(max_digits=11, decimal_places=8)
    response = models.TextField()
    nearest_station = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'user_nearest_stations'


class UserPermissions(models.Model):
    user_type_id = models.IntegerField()
    permissions = models.TextField()
    created_by = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'user_permissions'


class UserTypes(models.Model):
    name = models.CharField(max_length=191)
    created_by = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'user_types'


class Users(models.Model):
    name = models.CharField(max_length=191, blank=True, null=True)
    username = models.CharField(max_length=191, blank=True, null=True)
    email = models.CharField(max_length=191, blank=True, null=True)
    mobile_number = models.TextField(blank=True, null=True)
    dob = models.DateField(blank=True, null=True)
    gender = models.CharField(max_length=6, blank=True, null=True)
    password = models.CharField(max_length=191, blank=True, null=True)
    user_type = models.CharField(max_length=191, blank=True, null=True)
    is_otp_verified = models.IntegerField(blank=True, null=True)
    remember_token = models.CharField(max_length=100, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    merchant_id = models.CharField(max_length=100, blank=True, null=True)
    center_id = models.IntegerField(blank=True, null=True)
    code = models.CharField(max_length=191, blank=True, null=True)
    referred_by = models.CharField(max_length=191, blank=True, null=True)
    is_gps = models.IntegerField(blank=True, null=True)
    is_gps_on = models.IntegerField(blank=True, null=True)
    monthly_application = models.CharField(max_length=191, blank=True, null=True)
    monthly_disbursement_value = models.CharField(max_length=191, blank=True, null=True)
    # is_email_valid = models.IntegerField(blank=True, null=True)
    # karza_email_response = models.TextField(blank=True, null=True)
    app_create_access = models.IntegerField(blank=True, null=True)
    google_token = models.TextField(blank=True, null=True)
    user_availability = models.IntegerField(blank=True, null=True)
    zones = models.TextField(blank=True, null=True)
    otp_counter = models.IntegerField(blank=True, null=True)
    last_counter_at = models.CharField(max_length=30, blank=True, null=True)
    battery_saver_mode = models.IntegerField()
    is_manager = models.IntegerField()
    source = models.CharField(max_length=191, blank=True, null=True)
    user_verified = models.IntegerField()
    whatsapp_api = models.IntegerField(blank=True, null=True)
    admin_login_counter = models.IntegerField()
    slack_id = models.CharField(max_length=191, blank=True, null=True)
    lender_id = models.IntegerField(blank=True, null=True)
    slack_url = models.TextField(blank=True, null=True)
    credit_approval_limit = models.IntegerField(blank=True, null=True)
    disbursement_checker_limit = models.IntegerField(blank=True, null=True)
    high_risk = models.IntegerField(blank=True, null=True)
    category = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'users'


class UtilityValidation(models.Model):
    data = models.TextField()
    consumer_application_file_id = models.IntegerField()
    user_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'utility_validation'


class Vendor(models.Model):
    name = models.CharField(max_length=191)
    status = models.IntegerField()
    ips = models.CharField(max_length=191, blank=True, null=True)
    created_by = models.IntegerField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    merchant_id = models.CharField(max_length=191, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'vendor'


class VendorApiCredentials(models.Model):
    vendor_id = models.IntegerField()
    key = models.CharField(max_length=191)
    secret = models.CharField(max_length=191)
    ips = models.CharField(max_length=191, blank=True, null=True)
    status = models.IntegerField()
    created_by = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'vendor_api_credentials'


class VendorWebhook(models.Model):
    name = models.CharField(max_length=191)
    endpoint = models.CharField(max_length=191)
    vendor_id = models.IntegerField()
    user_id = models.IntegerField()
    events = models.TextField()
    status = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'vendor_webhook'


class VerificationChecklists(models.Model):
    consumer_application_id = models.IntegerField()
    tele_verified = models.IntegerField()
    dob_match_bureau = models.IntegerField()
    address_match_bureau = models.IntegerField()
    pan_match_bureau = models.IntegerField()
    aadhar_match_bureau = models.IntegerField()
    dpd_6_months = models.IntegerField()
    negative_status_2_years = models.IntegerField()
    enquires_more_5_12months = models.IntegerField()
    salary_bank_statement = models.IntegerField()
    cheque_bounce = models.IntegerField()
    high_value_transaction = models.IntegerField()
    average_balance = models.CharField(max_length=191)
    mca = models.IntegerField()
    probe42 = models.IntegerField()
    advance_payment_confirmation = models.IntegerField()
    status = models.IntegerField()
    negative_area = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'verification_checklists'


class WaiveOffLogs(models.Model):
    emi_payment_id = models.IntegerField()
    waived_by = models.IntegerField()
    status = models.CharField(max_length=191)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    amount = models.IntegerField(blank=True, null=True)
    application_id = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'waive_off_logs'


class WalletConfiguration(models.Model):
    subwalletguid = models.CharField(db_column='subWalletGuid', max_length=191)  # Field name made lowercase.
    user_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'wallet_configuration'


class WalletLogs(models.Model):
    subwalletguid = models.CharField(db_column='subWalletGuid', max_length=191)  # Field name made lowercase.
    user_id = models.IntegerField()
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'wallet_logs'


class WebHookLogs(models.Model):
    vendor = models.CharField(max_length=191)
    data = models.TextField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'web_hook_logs'


class WebSeo(models.Model):
    url = models.TextField()
    title = models.TextField()
    meta = models.TextField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    created_by = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'web_seo'


class Webhook(models.Model):
    name = models.CharField(max_length=191)
    endpoint = models.CharField(max_length=191)
    merchant_id = models.IntegerField(blank=True, null=True)
    user_id = models.IntegerField()
    events = models.TextField(blank=True, null=True)
    status = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'webhook'


class WebhookRequestLogs(models.Model):
    request_id = models.CharField(max_length=191, blank=True, null=True)
    webhook_id = models.IntegerField()
    request = models.TextField()
    response = models.TextField()
    application_id = models.IntegerField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'webhook_request_logs'


class WhatsappCustomerService(models.Model):
    application_id = models.IntegerField()
    request_id = models.CharField(max_length=191)
    type = models.CharField(max_length=191)
    payload = models.CharField(max_length=191)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    user_type = models.CharField(max_length=191)

    class Meta:
        managed = False
        db_table = 'whatsapp_customer_service'


class WhatsappMessages(models.Model):
    request_id = models.CharField(max_length=191, blank=True, null=True)
    platformsenderid = models.CharField(db_column='PlatformSenderId', max_length=191)  # Field name made lowercase.
    message = models.TextField()
    payload = models.TextField()
    type = models.CharField(max_length=191)
    output_message = models.CharField(max_length=191, blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    response = models.TextField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'whatsapp_messages'


class Zones(models.Model):
    name = models.CharField(max_length=191)
    pincodes = models.TextField()
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    status = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'zones'


class AccountAggregator(models.Model):
    application_id = models.IntegerField(blank=True, null=True)
    redirectionurl = models.CharField(db_column='redirectionUrl', max_length=191, blank=True, null=True)  # Field name made lowercase.
    vuaid = models.CharField(db_column='vuaId', max_length=191, blank=True, null=True)  # Field name made lowercase.
    accountaggregatorid = models.CharField(db_column='accountAggregatorId', max_length=191, blank=True, null=True)  # Field name made lowercase.
    response = models.TextField(blank=True, null=True)
    deleted_at = models.DateTimeField(blank=True, null=True)
    created_at = models.DateTimeField(blank=True, null=True)
    updated_at = models.DateTimeField(blank=True, null=True)
    user_id = models.IntegerField(blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'account_aggregator'