# Generated by Django 6.0.5 on 2026-05-08 01:15 from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ] operations = [ migrations.CreateModel( name='Aboutus', fields=[ ('abid', models.AutoField(primary_key=True, serialize=False)), ('about', models.TextField()), ], options={ 'verbose_name': 'Aboutus', 'verbose_name_plural': 'Aboutuss', 'db_table': 'aboutus', }, ), migrations.CreateModel( name='AdditionalFees', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('get_id', models.CharField(max_length=200)), ('tid', models.CharField(max_length=200)), ('fee', models.CharField(max_length=200)), ('amount', models.CharField(db_column='Amount', max_length=200)), ], options={ 'verbose_name': 'AdditionalFees', 'verbose_name_plural': 'AdditionalFeess', 'db_table': 'additional_fees', }, ), migrations.CreateModel( name='AffordabilityCheck', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('provider', models.CharField(blank=True, max_length=100, null=True)), ('endpoint', models.CharField(blank=True, max_length=100, null=True)), ('username', models.CharField(blank=True, max_length=50, null=True)), ('password', models.CharField(blank=True, max_length=50, null=True)), ('status', models.CharField(blank=True, max_length=50, null=True)), ], options={ 'verbose_name': 'AffordabilityCheck', 'verbose_name_plural': 'AffordabilityChecks', 'db_table': 'affordability_check', }, ), migrations.CreateModel( name='Attachment', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('get_id', models.CharField(max_length=200)), ('tid', models.CharField(max_length=200)), ('attached_file', models.TextField()), ('date_time', models.DateTimeField(auto_now_add=True)), ], options={ 'verbose_name': 'Attachment', 'verbose_name_plural': 'Attachments', 'db_table': 'attachment', }, ), migrations.CreateModel( name='B2cpaymentsresults', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('merchant_loan_ref', models.CharField(blank=True, db_column='MerchantLoanRef', default=0, max_length=50, null=True)), ('sasa_pay_ref', models.CharField(blank=True, db_column='SasaPayRef', default=0, max_length=50, null=True)), ('m_pesa_ref', models.CharField(blank=True, db_column='MPesaRef', default=0, max_length=50, null=True)), ('result_code', models.IntegerField(blank=True, db_column='ResultCode', default=0, null=True)), ('result_desc', models.TextField(blank=True, db_column='ResultDesc', null=True)), ('trans_amount', models.DecimalField(blank=True, db_column='TransAmount', decimal_places=2, default=0.0, max_digits=12, null=True)), ('sasa_pay_acc_balance', models.DecimalField(blank=True, db_column='SasaPayAccBalance', decimal_places=2, default=0.0, max_digits=12, null=True)), ('transaction_date', models.DateField(blank=True, db_column='TransactionDate', null=True)), ], options={ 'verbose_name': 'B2cpaymentsresults', 'verbose_name_plural': 'B2cpaymentsresultss', 'db_table': 'b2cpaymentsresults', }, ), migrations.CreateModel( name='Backup', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('tracking_id', models.CharField(max_length=200)), ('amount', models.CharField(max_length=200)), ('address', models.TextField()), ('date_time', models.DateTimeField(auto_now_add=True)), ], options={ 'verbose_name': 'Backup', 'verbose_name_plural': 'Backups', 'db_table': 'backup', }, ), migrations.CreateModel( name='BankAccounts', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('bank_name', models.CharField(blank=True, db_column='bankName', max_length=50, null=True)), ('account_number', models.BigIntegerField(blank=True, db_column='accountNumber', null=True)), ('balance', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('transaction_type', models.CharField(db_column='transactionType', max_length=20)), ('gl_code', models.CharField(max_length=10)), ('source_gl_code', models.CharField(max_length=50)), ], options={ 'verbose_name': 'BankAccounts', 'verbose_name_plural': 'BankAccountss', 'db_table': 'bank_accounts', }, ), migrations.CreateModel( name='Banner', fields=[ ('banaid', models.AutoField(primary_key=True, serialize=False)), ('bannar', models.TextField()), ], options={ 'verbose_name': 'Banner', 'verbose_name_plural': 'Banners', 'db_table': 'banner', }, ), migrations.CreateModel( name='Basic', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('borrower', models.IntegerField(blank=True, null=True)), ('basic_pay', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('additional_fixed_allowance', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('gross_pay', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('statutory_deductions', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('loan_instalments', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('net_pay', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('other_bank_loans', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('monthly_living_expenses', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('max_available', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ], options={ 'verbose_name': 'Basic', 'verbose_name_plural': 'Basics', 'db_table': 'basic', }, ), migrations.CreateModel( name='Battachment', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('get_id', models.CharField(max_length=200)), ('tid', models.CharField(max_length=200)), ('attached_file', models.TextField()), ('date_time', models.DateTimeField(auto_now_add=True)), ('document_type', models.CharField(blank=True, max_length=50, null=True)), ('file_size', models.CharField(blank=True, max_length=50, null=True)), ('file_ext', models.CharField(blank=True, max_length=50, null=True)), ], options={ 'verbose_name': 'Battachment', 'verbose_name_plural': 'Battachments', 'db_table': 'battachment', }, ), migrations.CreateModel( name='Borrowers', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('fname', models.CharField(max_length=200)), ('middlename', models.CharField(max_length=50)), ('lname', models.CharField(max_length=200)), ('email', models.CharField(blank=True, max_length=200, null=True)), ('phone', models.CharField(blank=True, max_length=200, null=True)), ('telephone', models.CharField(default='', max_length=50)), ('addrs1', models.TextField()), ('addrs2', models.TextField()), ('district', models.CharField(max_length=200)), ('country', models.CharField(max_length=200)), ('comment', models.TextField(blank=True, null=True)), ('account', models.CharField(max_length=200)), ('image', models.CharField(blank=True, max_length=200, null=True)), ('date_time', models.DateTimeField(auto_now_add=True)), ('status', models.CharField(max_length=200)), ('date_of_birth', models.DateField(blank=True, null=True)), ('gender', models.CharField(blank=True, max_length=10, null=True)), ('id_number', models.CharField(blank=True, max_length=25, null=True)), ('passport', models.CharField(blank=True, max_length=50, null=True)), ('credit_score', models.CharField(blank=True, max_length=25, null=True)), ('employment_status', models.CharField(blank=True, max_length=25, null=True)), ('employer', models.CharField(blank=True, max_length=50, null=True)), ('title', models.CharField(blank=True, max_length=50, null=True)), ('created_by', models.CharField(blank=True, max_length=50, null=True)), ('modified_by', models.CharField(blank=True, max_length=50, null=True)), ('balance', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('emp_code', models.CharField(blank=True, max_length=50, null=True)), ('salary', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('disposable_income', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('occupation', models.CharField(blank=True, max_length=50, null=True)), ('modified_on', models.DateTimeField(blank=True, null=True)), ('postal', models.IntegerField(blank=True, null=True)), ('ownership_type', models.CharField(blank=True, db_column='ownershipType', max_length=10, null=True)), ('member', models.BooleanField(default=False)), ('marital', models.CharField(max_length=30)), ('marriage_type', models.CharField(db_column='marriageType', max_length=30)), ], options={ 'verbose_name': 'Borrowers', 'verbose_name_plural': 'Borrowerss', 'db_table': 'borrowers', }, ), migrations.CreateModel( name='BorrowersSalaries', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('borrower', models.IntegerField(blank=True, null=True)), ('basic_pay', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('additional_fixed_allowance', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('gross_pay', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('statutory_deductions', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('loan_instalments', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('net_pay', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('other_bank_loans', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('monthly_living_expenses', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('max_available', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ], options={ 'verbose_name': 'BorrowersSalaries', 'verbose_name_plural': 'BorrowersSalariess', 'db_table': 'borrowers_salaries', }, ), migrations.CreateModel( name='Branches', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(blank=True, max_length=50, null=True)), ('location', models.CharField(blank=True, max_length=50, null=True)), ('code', models.CharField(blank=True, max_length=10, null=True)), ('status', models.CharField(blank=True, max_length=50, null=True)), ('sub_account', models.IntegerField(blank=True, null=True)), ], options={ 'verbose_name': 'Branches', 'verbose_name_plural': 'Branchess', 'db_table': 'branches', }, ), migrations.CreateModel( name='BureauRecords', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('batch', models.IntegerField(default=0)), ('borrower', models.IntegerField(default=0)), ('id_number', models.CharField(blank=True, max_length=25, null=True)), ('passport', models.CharField(blank=True, max_length=50, null=True)), ('baccount', models.CharField(max_length=200)), ('district', models.CharField(max_length=200)), ('country', models.CharField(max_length=200)), ('reason', models.TextField()), ('bureau_account_type', models.CharField(db_column='bureauAccountType', max_length=10)), ('modified_date', models.DateTimeField(blank=True, null=True)), ('lname', models.CharField(max_length=200)), ('fname', models.CharField(max_length=200)), ('gender', models.CharField(blank=True, max_length=10, null=True)), ('phone', models.CharField(blank=True, max_length=200, null=True)), ('employer', models.CharField(max_length=50)), ('application_date', models.DateTimeField(blank=True, null=True)), ('balance', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('loan_repayment_method', models.CharField(blank=True, max_length=10, null=True)), ('loan_payment_scheme', models.CharField(max_length=200)), ('postal', models.IntegerField(blank=True, null=True)), ('ownership_type', models.CharField(blank=True, max_length=10, null=True)), ('amount_topay', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('loan_duration', models.CharField(default=0, max_length=50)), ('loan_duration_period', models.CharField(max_length=200)), ('status', models.CharField(max_length=200)), ('date_of_birth', models.DateField(blank=True, null=True)), ('branch', models.CharField(blank=True, max_length=50, null=True)), ('title', models.CharField(blank=True, max_length=50, null=True)), ('addrs2', models.TextField()), ('addrs1', models.TextField()), ], options={ 'verbose_name': 'BureauRecords', 'verbose_name_plural': 'BureauRecordss', 'db_table': 'bureau_records', }, ), migrations.CreateModel( name='BureauSubmissions', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('batch', models.IntegerField(blank=True, null=True)), ('loan_records', models.IntegerField(blank=True, null=True)), ('status', models.CharField(blank=True, default='Scheduled', max_length=50, null=True)), ('action_date', models.DateTimeField(blank=True, null=True)), ('action_by', models.CharField(blank=True, max_length=50, null=True)), ], options={ 'verbose_name': 'BureauSubmissions', 'verbose_name_plural': 'BureauSubmissionss', 'db_table': 'bureau_submissions', }, ), migrations.CreateModel( name='Collateral', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('idm', models.CharField(max_length=200)), ('tid', models.CharField(max_length=200)), ('name', models.CharField(max_length=200)), ('type_of_collateral', models.CharField(max_length=200)), ('model', models.CharField(max_length=200)), ('make', models.CharField(max_length=200)), ('serial_number', models.CharField(max_length=200)), ('estimated_price', models.CharField(max_length=200)), ('proof_of_ownership', models.TextField()), ('cimage', models.TextField()), ('observation', models.TextField()), ('loan', models.IntegerField(blank=True, null=True)), ], options={ 'verbose_name': 'Collateral', 'verbose_name_plural': 'Collaterals', 'db_table': 'collateral', }, ), migrations.CreateModel( name='Comments', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('tid', models.CharField(max_length=55)), ('comment', models.TextField()), ('date', models.DateTimeField(auto_now_add=True)), ('account', models.CharField(max_length=100)), ('customer', models.CharField(max_length=100)), ], options={ 'verbose_name': 'Comments', 'verbose_name_plural': 'Commentss', 'db_table': 'comments', }, ), migrations.CreateModel( name='Countries', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(default='', max_length=50)), ('alpha_2', models.CharField(default='', max_length=200)), ('alpha_3', models.CharField(default='', max_length=200)), ], options={ 'verbose_name': 'Countries', 'verbose_name_plural': 'Countriess', 'db_table': 'countries', }, ), migrations.CreateModel( name='DocumentsRequired', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(blank=True, max_length=50, null=True)), ('status', models.CharField(blank=True, max_length=10, null=True)), ], options={ 'verbose_name': 'DocumentsRequired', 'verbose_name_plural': 'DocumentsRequireds', 'db_table': 'documents_required', }, ), migrations.CreateModel( name='EmployerDetails', fields=[ ('id', models.IntegerField()), ('employee_no', models.BigIntegerField(blank=True, null=True)), ('employer_name', models.CharField(max_length=30)), ('department', models.CharField(max_length=50)), ('employer_code', models.CharField(blank=True, max_length=12, null=True)), ('designation', models.CharField(max_length=30)), ('engagement_date', models.DateField(blank=True, null=True)), ('employment_status', models.CharField(max_length=30)), ('retirement', models.DateField(blank=True, null=True)), ('employer_contact', models.BigIntegerField(blank=True, null=True)), ('telephone', models.IntegerField(blank=True, null=True)), ('employer_designation', models.CharField(blank=True, max_length=50, null=True)), ], options={ 'verbose_name': 'EmployerDetails', 'verbose_name_plural': 'EmployerDetailss', 'db_table': 'employer_details', }, ), migrations.CreateModel( name='EmpPermission', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('tid', models.CharField(max_length=200)), ('module_name', models.CharField(max_length=350)), ('pcreate', models.CharField(max_length=20)), ('pread', models.CharField(max_length=20)), ('pupdate', models.CharField(max_length=20)), ('pdelete', models.CharField(max_length=20)), ], options={ 'verbose_name': 'EmpPermission', 'verbose_name_plural': 'EmpPermissions', 'db_table': 'emp_permission', }, ), migrations.CreateModel( name='EmpRole', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('role', models.CharField(max_length=200)), ], options={ 'verbose_name': 'EmpRole', 'verbose_name_plural': 'EmpRoles', 'db_table': 'emp_role', }, ), migrations.CreateModel( name='ETemplates', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('sender', models.CharField(max_length=200)), ('receiver_email', models.CharField(max_length=350)), ('subject', models.CharField(max_length=350)), ('msg', models.TextField()), ('time_date', models.DateTimeField(auto_now_add=True)), ], options={ 'verbose_name': 'ETemplates', 'verbose_name_plural': 'ETemplatess', 'db_table': 'etemplates', }, ), migrations.CreateModel( name='FAQs', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('topic', models.TextField()), ('content', models.TextField()), ], options={ 'verbose_name': 'FAQs', 'verbose_name_plural': 'FAQss', 'db_table': 'faqs', }, ), migrations.CreateModel( name='FinInfo', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('get_id', models.CharField(max_length=200)), ('tid', models.CharField(max_length=200)), ('occupation', models.CharField(max_length=25)), ('mincome', models.CharField(max_length=200)), ('frequency', models.CharField(blank=True, max_length=10, null=True)), ], options={ 'verbose_name': 'FinInfo', 'verbose_name_plural': 'FinInfos', 'db_table': 'fin_info', }, ), migrations.CreateModel( name='Footer', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('email', models.CharField(max_length=200)), ('pho', models.CharField(max_length=200)), ('face', models.CharField(max_length=200)), ('webs', models.CharField(max_length=200)), ('conh', models.CharField(max_length=200)), ('twi', models.CharField(max_length=200)), ('gplus', models.CharField(max_length=200)), ('ins', models.CharField(max_length=200)), ('yous', models.CharField(max_length=200)), ('about', models.TextField()), ('apply', models.TextField()), ('mission', models.TextField()), ('objective', models.TextField()), ('map', models.TextField()), ], options={ 'verbose_name': 'Footer', 'verbose_name_plural': 'Footers', 'db_table': 'footer', }, ), migrations.CreateModel( name='GlCodes', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('code', models.CharField(max_length=50)), ('name', models.CharField(blank=True, max_length=100, null=True)), ('type_field', models.CharField(blank=True, db_column='type', max_length=50, null=True)), ('portfolio', models.CharField(blank=True, max_length=50, null=True)), ('balance', models.DecimalField(decimal_places=2, max_digits=16)), ], options={ 'verbose_name': 'GlCodes', 'verbose_name_plural': 'GlCodess', 'db_table': 'gl_codes', }, ), migrations.CreateModel( name='GrazuriUser', fields=[ ('userid', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(max_length=200)), ('email', models.CharField(max_length=200)), ('gender', models.CharField(max_length=20)), ('id_number', models.IntegerField()), ('phone', models.CharField(max_length=200)), ('addr1', models.TextField()), ('addr2', models.TextField()), ('district', models.CharField(max_length=200)), ('country', models.CharField(max_length=200)), ('comment', models.CharField(max_length=200)), ('username', models.CharField(max_length=200)), ('password', models.CharField(max_length=200)), ('id', models.CharField(max_length=200)), ('image', models.TextField(blank=True, null=True)), ('role', models.CharField(max_length=200)), ('date_of_birth', models.DateField(blank=True, null=True)), ('passport', models.CharField(blank=True, max_length=50, null=True)), ('branch', models.CharField(blank=True, max_length=50, null=True)), ], options={ 'verbose_name': 'GrazuriUser', 'verbose_name_plural': 'GrazuriUsers', 'db_table': 'user', }, ), migrations.CreateModel( name='HIW', fields=[ ('hid', models.AutoField(primary_key=True, serialize=False)), ('hiw', models.TextField()), ], options={ 'verbose_name': 'HIW', 'verbose_name_plural': 'HIWs', 'db_table': 'hiw', }, ), migrations.CreateModel( name='JournalTransactions', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('date', models.DateTimeField(blank=True, null=True)), ('account', models.BigIntegerField(blank=True, null=True)), ('transaction', models.CharField(blank=True, max_length=50, null=True)), ('opening_balance', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('debit', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('credit', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('balance', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('agent', models.CharField(blank=True, max_length=50, null=True)), ('tx_id', models.CharField(blank=True, max_length=50, null=True)), ('notes', models.CharField(blank=True, max_length=50, null=True)), ('filename', models.CharField(blank=True, max_length=50, null=True)), ], options={ 'verbose_name': 'JournalTransactions', 'verbose_name_plural': 'JournalTransactionss', 'db_table': 'journal_transactions', }, ), migrations.CreateModel( name='LoanAdditionalSettings', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('fee_description', models.CharField(blank=True, max_length=50, null=True)), ('percentage', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('fixed_amount', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('is_penalty', models.IntegerField(blank=True, null=True)), ('is_initial_deduction', models.IntegerField(blank=True, null=True)), ], options={ 'verbose_name': 'LoanAdditionalSettings', 'verbose_name_plural': 'LoanAdditionalSettingss', 'db_table': 'loan_additional_settings', }, ), migrations.CreateModel( name='LoanDisbursements', fields=[ ('pay_id', models.AutoField(primary_key=True, serialize=False)), ('loan', models.IntegerField(blank=True, null=True)), ('date', models.DateTimeField(auto_now_add=True)), ('transaction', models.CharField(max_length=200)), ('disbursement_method', models.CharField(max_length=50)), ], options={ 'verbose_name': 'LoanDisbursements', 'verbose_name_plural': 'LoanDisbursementss', 'db_table': 'loan_disbursements', }, ), migrations.CreateModel( name='LoanFees', fields=[ ('loan_fees_id', models.AutoField(primary_key=True, serialize=False)), ('fee_name', models.CharField(blank=True, max_length=50, null=True)), ('fee_amount', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('loan', models.IntegerField(blank=True, null=True)), ('date_added', models.DateTimeField(blank=True, null=True)), ('added_by', models.CharField(blank=True, max_length=50, null=True)), ('gl_code', models.CharField(max_length=20)), ('status', models.CharField(max_length=20)), ], options={ 'verbose_name': 'LoanFees', 'verbose_name_plural': 'LoanFeess', 'db_table': 'loan_fees', }, ), migrations.CreateModel( name='LoanFeespayments', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('loan_fees_id', models.IntegerField()), ('loan_id', models.IntegerField()), ('loanaccount', models.CharField(default='', max_length=50)), ('trxno', models.CharField(default='', max_length=50)), ('paymentref', models.CharField(default='', max_length=50)), ('amount', models.DecimalField(decimal_places=2, max_digits=16)), ('date_added', models.DateTimeField()), ('added_by', models.CharField(default='', max_length=50)), ('gl_code', models.CharField(default='', max_length=50)), ], options={ 'verbose_name': 'LoanFeespayments', 'verbose_name_plural': 'LoanFeespaymentss', 'db_table': 'loan_feespayments', }, ), migrations.CreateModel( name='LoanFeesSettings', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('fee_name', models.CharField(max_length=50)), ('fee_amount', models.DecimalField(decimal_places=2, max_digits=16)), ('min_loan', models.DecimalField(decimal_places=2, max_digits=16)), ('max_loan', models.DecimalField(decimal_places=2, max_digits=16)), ('deductible', models.CharField()), ('active_status', models.BooleanField(default=False)), ], options={ 'verbose_name': 'LoanFeesSettings', 'verbose_name_plural': 'LoanFeesSettingss', 'db_table': 'loan_fees_settings', }, ), migrations.CreateModel( name='LoanfeesTable', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('loan_fees', models.CharField(blank=True, null=True)), ('insurance_on_total_loan', models.IntegerField(blank=True, null=True)), ], options={ 'verbose_name': 'Loanfees', 'verbose_name_plural': 'Loanfeess', 'db_table': 'loanfees', }, ), migrations.CreateModel( name='LoanGuarantors', fields=[ ('guarantor_id', models.AutoField(primary_key=True, serialize=False)), ('borrower', models.IntegerField(default=0)), ('loan_id', models.IntegerField(default=0)), ('name', models.CharField(default='', max_length=100)), ('relationship', models.CharField(default='', max_length=100)), ('phone', models.CharField(default='', max_length=50)), ('status', models.CharField(default='', max_length=50)), ('remarks', models.CharField(default='', max_length=50)), ('image', models.CharField()), ('address', models.CharField(blank=True, max_length=100, null=True)), ], options={ 'verbose_name': 'LoanGuarantors', 'verbose_name_plural': 'LoanGuarantorss', 'db_table': 'loan_guarantors', }, ), migrations.CreateModel( name='LoanInfo', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('borrower', models.IntegerField(default=0)), ('baccount', models.CharField(max_length=200)), ('reason', models.TextField()), ('amount', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('application_date', models.DateTimeField(blank=True, null=True)), ('agent', models.CharField(max_length=200)), ('loan_product', models.TextField()), ('repayment_remark', models.CharField(max_length=200)), ('amount_todisburse', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('amount_intrestatuodeducted', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('amount_topay', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('pay_date', models.DateField(blank=True, null=True)), ('balance', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('teller', models.CharField(max_length=200)), ('status', models.CharField(max_length=200)), ('disbursement_status', models.CharField(max_length=200)), ('loan_num_of_repayments', models.CharField(max_length=200)), ('loan_payment_scheme', models.CharField(max_length=200)), ('loan_duration_period', models.CharField(max_length=200)), ('loan_duration', models.CharField(default=0, max_length=50)), ('loan_interest_period', models.CharField(max_length=200)), ('loan_interest', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('loan_interest_type', models.CharField(max_length=200)), ('loan_interest_method', models.CharField(max_length=200)), ('date_release', models.DateField(blank=True, null=True)), ('loan_disbursed_by_id', models.CharField(max_length=200)), ('upstatus', models.CharField(blank=True, max_length=50, null=True)), ('loan_maturity', models.DateField(blank=True, null=True)), ('modified_date', models.DateTimeField(blank=True, null=True)), ('modified_by', models.CharField(blank=True, max_length=50, null=True)), ('fees', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('branch', models.CharField(blank=True, max_length=50, null=True)), ('loan_repayment_method', models.CharField(blank=True, max_length=10, null=True)), ('ownership_type', models.CharField(blank=True, max_length=10, null=True)), ('payment_reference', models.CharField(blank=True, max_length=50, null=True)), ('status_reason', models.CharField(blank=True, max_length=100, null=True)), ('disbursed_amount', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('interest_value', models.DecimalField(decimal_places=2, max_digits=16)), ('bureau_account_type', models.CharField(db_column='bureauAccountType', max_length=10)), ('gl_code', models.CharField(max_length=20)), ('resch', models.IntegerField(db_column='Resch', default=0)), ], options={ 'verbose_name': 'LoanInfo', 'verbose_name_plural': 'LoanInfos', 'db_table': 'loan_info', }, ), migrations.CreateModel( name='Loanprocessingfeesx', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('custacc', models.CharField(default='', max_length=50)), ('trx_no', models.CharField(db_column='TrxNo', default='', max_length=50)), ('payment_ref', models.CharField(db_column='paymentRef', default='', max_length=50)), ('loan_no', models.CharField(blank=True, db_column='loanNo', default='', max_length=50, null=True)), ], options={ 'verbose_name': 'Loanprocessingfeesx', 'verbose_name_plural': 'Loanprocessingfeesxs', 'db_table': 'loanprocessingfeesx', }, ), migrations.CreateModel( name='LoanRescheduleTable', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('original_loan_no', models.CharField(max_length=65)), ('new_loan_no', models.CharField(max_length=65)), ('borrower_id', models.IntegerField()), ('original_loan_balance', models.DecimalField(decimal_places=2, max_digits=12)), ('fine_charged', models.DecimalField(decimal_places=2, max_digits=12)), ('payable_intrest', models.IntegerField()), ('new_loan_balance', models.DecimalField(decimal_places=2, max_digits=12)), ('Payable_instalments', models.DecimalField(decimal_places=2, max_digits=12)), ('repayment_cycle', models.TextField()), ('loan_officer', models.TextField()), ('approving_officer_1', models.TextField()), ('approving_officer_1_idno', models.CharField(max_length=100)), ('approving_officer_2', models.TextField()), ('approving_officer_2_idno', models.CharField(max_length=100)), ('Resch_date', models.DateField()), ], options={ 'verbose_name': 'LoanRescheduleTable', 'verbose_name_plural': 'LoanRescheduleTables', 'db_table': 'loan_reschedule_table', }, ), migrations.CreateModel( name='LoanSettings', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('interest_rate', models.DecimalField(blank=True, null=True)), ('minimum_loan', models.IntegerField(blank=True, null=True)), ('maximum_loan', models.IntegerField(blank=True, null=True)), ('default_duration', models.IntegerField(blank=True, null=True)), ('payment_cycle', models.CharField(blank=True, max_length=50, null=True)), ('interest_method', models.CharField(blank=True, max_length=50, null=True)), ('loan_insurance', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('collateral', models.CharField(blank=True, max_length=10, null=True)), ('minimum_loan_collateral', models.IntegerField(blank=True, null=True)), ('penalty_fees', models.IntegerField(blank=True, null=True)), ], options={ 'verbose_name': 'LoanSettings', 'verbose_name_plural': 'LoanSettingss', 'db_table': 'loan_settings', }, ), migrations.CreateModel( name='LoanStatuses', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('status', models.CharField(blank=True, max_length=50, null=True)), ('added_by', models.CharField(blank=True, max_length=50, null=True)), ('added_date', models.DateTimeField(auto_now_add=True, null=True)), ('loan', models.IntegerField(blank=True, null=True)), ('reason', models.CharField(blank=True, max_length=100, null=True)), ], options={ 'verbose_name': 'LoanStatuses', 'verbose_name_plural': 'LoanStatusess', 'db_table': 'loan_statuses', }, ), migrations.CreateModel( name='Message', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('sender_id', models.CharField(max_length=200)), ('sender_name', models.CharField(max_length=200)), ('msg_to', models.CharField(max_length=200)), ('subject', models.CharField(max_length=300)), ('message', models.TextField()), ('date_time', models.DateTimeField(auto_now_add=True)), ('status', models.CharField(blank=True, default=0, null=True)), ], options={ 'verbose_name': 'Message', 'verbose_name_plural': 'Messages', 'db_table': 'message', }, ), migrations.CreateModel( name='Mywallet', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('tid', models.CharField(max_length=200)), ('t_to', models.CharField(max_length=200)), ('amount', models.CharField(db_column='Amount', max_length=200)), ('desc', models.CharField(db_column='Desc', max_length=200)), ('wtype', models.CharField(max_length=200)), ('tdate', models.DateTimeField(auto_now_add=True)), ], options={ 'verbose_name': 'Mywallet', 'verbose_name_plural': 'Mywallets', 'db_table': 'mywallet', }, ), migrations.CreateModel( name='NextOfKinDetails', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('borrower', models.IntegerField(blank=True, null=True)), ('names', models.CharField(blank=True, max_length=50, null=True)), ('address', models.CharField(blank=True, max_length=50, null=True)), ('contact', models.CharField(blank=True, max_length=50, null=True)), ('email', models.CharField(blank=True, max_length=50, null=True)), ('employer', models.CharField(blank=True, max_length=50, null=True)), ], options={ 'verbose_name': 'NextOfKinDetails', 'verbose_name_plural': 'NextOfKinDetailss', 'db_table': 'next_of_kin_details', }, ), migrations.CreateModel( name='Paymenterrors', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('paymenterror', models.TextField()), ], options={ 'verbose_name': 'Paymenterrors', 'verbose_name_plural': 'Paymenterrorss', 'db_table': 'paymenterrors', }, ), migrations.CreateModel( name='Payments', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('tid', models.CharField(max_length=200)), ('account', models.CharField(max_length=200)), ('balance', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('customer', models.CharField(max_length=200)), ('loan', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('pay_date', models.DateTimeField(auto_now_add=True)), ('amount_to_pay', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('remarks', models.TextField()), ('payment_method', models.CharField(blank=True, max_length=50, null=True)), ('reference', models.CharField(blank=True, max_length=50, null=True)), ('tr_id', models.CharField(max_length=20)), ('gl_code', models.CharField(max_length=20)), ('status', models.CharField(default='C', max_length=10)), ], options={ 'verbose_name': 'Payments', 'verbose_name_plural': 'Paymentss', 'db_table': 'payments', }, ), migrations.CreateModel( name='PaymentSchedule', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('idm', models.CharField(max_length=200)), ('tid', models.CharField(max_length=200)), ('term', models.CharField(max_length=200)), ('day', models.CharField(max_length=200)), ('schedule', models.CharField(max_length=200)), ('interest', models.CharField(max_length=200)), ('penalty', models.CharField(max_length=200)), ], options={ 'verbose_name': 'PaymentSchedule', 'verbose_name_plural': 'PaymentSchedules', 'db_table': 'payment_schedule', }, ), migrations.CreateModel( name='PaySchedule', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('get_id', models.CharField(max_length=200)), ('tid', models.CharField(max_length=200)), ('schedule', models.CharField(max_length=200)), ('balance', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('interest', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('payment', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('principal_due', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('pay_type', models.CharField(blank=True, max_length=50, null=True)), ('fees', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('total_due', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('principal_payment', models.DecimalField(decimal_places=2, max_digits=16)), ('interest_payment', models.DecimalField(decimal_places=2, max_digits=16)), ('fees_payment', models.DecimalField(decimal_places=2, max_digits=16)), ('open_indicator', models.CharField(max_length=1)), ('penalty', models.DecimalField(decimal_places=2, max_digits=16)), ('penalty_payment', models.DecimalField(decimal_places=2, max_digits=16)), ('payment_tx_id', models.CharField(max_length=20)), ], options={ 'verbose_name': 'PaySchedule', 'verbose_name_plural': 'PaySchedules', 'db_table': 'pay_schedule', }, ), migrations.CreateModel( name='Products', fields=[ ('product_id', models.AutoField(primary_key=True, serialize=False)), ('product_name', models.CharField(max_length=50)), ('product_type', models.CharField(max_length=50)), ('account_type', models.CharField(db_column='accountType', max_length=10)), ('product_configuration', models.TextField()), ], options={ 'verbose_name': 'Products', 'verbose_name_plural': 'Productss', 'db_table': 'products', }, ), migrations.CreateModel( name='ReversedPayments', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('tid', models.CharField(max_length=200)), ('account', models.CharField(max_length=200)), ('balance', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('customer', models.CharField(max_length=200)), ('loan', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('pay_date', models.DateTimeField(auto_now_add=True)), ('amount_to_pay', models.DecimalField(decimal_places=2, default=0.0, max_digits=16)), ('remarks', models.TextField()), ('payment_method', models.CharField(blank=True, max_length=50, null=True)), ('reference', models.CharField(blank=True, max_length=50, null=True)), ('tx_id', models.CharField(blank=True, max_length=50, null=True)), ('gl_code', models.CharField(blank=True, max_length=50, null=True)), ('status', models.CharField(blank=True, default='C', max_length=50, null=True)), ], options={ 'verbose_name': 'ReversedPayments', 'verbose_name_plural': 'ReversedPaymentss', 'db_table': 'reversed_payments', }, ), migrations.CreateModel( name='SaccosMembers', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('firstname', models.CharField(blank=True, max_length=50, null=True)), ('middlename', models.CharField(blank=True, max_length=50, null=True)), ('surname', models.CharField(blank=True, max_length=50, null=True)), ('othername1', models.CharField(blank=True, max_length=50, null=True)), ('othername2', models.CharField(blank=True, max_length=50, null=True)), ('member_status', models.CharField(blank=True, max_length=50, null=True)), ('lastmodified', models.CharField(blank=True, max_length=50, null=True)), ('address', models.CharField(blank=True, max_length=200, null=True)), ('dateofbirt', models.CharField(blank=True, max_length=50, null=True)), ('email', models.CharField(blank=True, max_length=50, null=True)), ('gender', models.CharField(blank=True, max_length=50, null=True)), ('home_phone', models.CharField(blank=True, max_length=50, null=True)), ('id_number', models.CharField(blank=True, db_column='idNumber', max_length=50, null=True)), ('postal_address', models.CharField(blank=True, db_column='postalAddress', max_length=50, null=True)), ('physical_address', models.CharField(blank=True, db_column='physicalAddress', max_length=50, null=True)), ('mobilenumber', models.IntegerField(blank=True, null=True)), ], options={ 'verbose_name': 'SaccosMembers', 'verbose_name_plural': 'SaccosMemberss', 'db_table': 'saccos_members', }, ), migrations.CreateModel( name='SasaPayIPN', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('mpesaref', models.CharField(max_length=100)), ('paidby', models.CharField(max_length=200)), ('amountpaid', models.DecimalField(decimal_places=6, default=0.0, max_digits=20)), ('paidon', models.DateField()), ('billref', models.CharField(default=0, max_length=50)), ], options={ 'verbose_name': 'SasaPayIPN', 'verbose_name_plural': 'SasaPayIPNs', 'db_table': 'sasapayipn', }, ), migrations.CreateModel( name='SMS', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('sms_gateway', models.TextField()), ('username', models.TextField()), ('password', models.TextField()), ('api', models.TextField()), ('status', models.TextField()), ], options={ 'verbose_name': 'SMS', 'verbose_name_plural': 'SMSs', 'db_table': 'sms', }, ), migrations.CreateModel( name='SMSMessages', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('phone', models.IntegerField(blank=True, null=True)), ('message', models.CharField(blank=True, null=True)), ('datetime', models.DateTimeField(blank=True, null=True)), ('response', models.CharField(blank=True, max_length=50, null=True)), ('url', models.CharField(blank=True, null=True)), ('loan', models.IntegerField()), ], options={ 'verbose_name': 'SMSMessages', 'verbose_name_plural': 'SMSMessagess', 'db_table': 'sms_messages', }, ), migrations.CreateModel( name='STKPushResults', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('merchant_loan_ref', models.CharField(db_column='MerchantLoanRef', default=0, max_length=50)), ('sasa_pay_ref', models.CharField(db_column='SasaPayRef', max_length=20)), ('result_code', models.IntegerField(db_column='ResultCode', default=0)), ('result_desc', models.TextField(blank=True, db_column='ResultDesc', null=True)), ('trans_amount', models.DecimalField(db_column='TransAmount', decimal_places=2, max_digits=12)), ('transaction_date', models.DateField(blank=True, db_column='TransactionDate', null=True)), ], options={ 'verbose_name': 'STKPushResults', 'verbose_name_plural': 'STKPushResultss', 'db_table': 'stkpushresults', }, ), migrations.CreateModel( name='Systemset', fields=[ ('sysid', models.AutoField(primary_key=True, serialize=False)), ('title', models.CharField(max_length=200)), ('name', models.CharField(max_length=200)), ('footer', models.TextField()), ('abb', models.CharField(max_length=200)), ('fax', models.TextField()), ('currency', models.TextField()), ('website', models.TextField()), ('mobile', models.TextField()), ('image', models.CharField(max_length=200)), ('modal_image', models.CharField(max_length=200)), ('address', models.TextField()), ('email', models.TextField()), ('map', models.TextField()), ('stamp', models.CharField(max_length=350)), ('timezone', models.TextField()), ('sms_charges', models.CharField(max_length=200)), ('trading_name', models.CharField(blank=True, max_length=50, null=True)), ('srn', models.CharField(blank=True, max_length=50, null=True)), ('recipient', models.CharField(blank=True, max_length=50, null=True)), ('submission_cycle', models.CharField(blank=True, max_length=50, null=True)), ('day_of_submission', models.IntegerField(blank=True, null=True)), ('sftp_url', models.CharField(blank=True, max_length=100, null=True)), ('sftp_port', models.IntegerField(blank=True, null=True)), ('bureau_email', models.CharField(blank=True, max_length=50, null=True)), ('submission_method', models.CharField(blank=True, max_length=50, null=True)), ('bureau_submission', models.IntegerField(blank=True, null=True)), ('scoring', models.IntegerField(blank=True, null=True)), ('file_type', models.CharField(blank=True, max_length=50, null=True)), ('sftp_password', models.CharField(blank=True, max_length=100, null=True)), ('sftp_username', models.CharField(blank=True, max_length=50, null=True)), ('registration', models.CharField(max_length=20)), ], options={ 'verbose_name': 'Systemset', 'verbose_name_plural': 'Systemsets', 'db_table': 'systemset', }, ), migrations.CreateModel( name='SystemTransactions', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('date', models.DateTimeField(blank=True, null=True)), ('account', models.BigIntegerField(blank=True, null=True)), ('transaction', models.CharField(blank=True, max_length=50, null=True)), ('opening_balance', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('debit', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('credit', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('balance', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('agent', models.CharField(blank=True, max_length=50, null=True)), ('loan', models.IntegerField()), ('tx_id', models.CharField(max_length=20)), ], options={ 'verbose_name': 'SystemTransactions', 'verbose_name_plural': 'SystemTransactionss', 'db_table': 'system_transactions', }, ), migrations.CreateModel( name='TempBorrowers', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('fname', models.CharField(blank=True, max_length=50, null=True)), ('lname', models.CharField(blank=True, max_length=50, null=True)), ('employer', models.CharField(blank=True, max_length=50, null=True)), ('salary', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('disposable', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('requestedloan', models.DecimalField(blank=True, decimal_places=2, max_digits=16, null=True)), ('session', models.CharField(blank=True, max_length=50, null=True)), ('agent', models.CharField(blank=True, max_length=50, null=True)), ('emp_code', models.CharField(blank=True, max_length=50, null=True)), ], options={ 'verbose_name': 'TempBorrowers', 'verbose_name_plural': 'TempBorrowerss', 'db_table': 'temp_borrowers', }, ), migrations.CreateModel( name='Transaction', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('txid', models.CharField(max_length=200)), ('t_type', models.CharField(max_length=200)), ('acctno', models.CharField(max_length=200)), ('fn', models.CharField(max_length=200)), ('ln', models.CharField(max_length=200)), ('email', models.CharField(max_length=300)), ('phone', models.CharField(max_length=200)), ('amount', models.CharField(max_length=200)), ('date_time', models.DateTimeField(auto_now_add=True)), ], options={ 'verbose_name': 'Transaction', 'verbose_name_plural': 'Transactions', 'db_table': 'transaction', }, ), migrations.CreateModel( name='Twallet', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('tid', models.CharField(max_length=200)), ('total', models.CharField(db_column='Total', max_length=200)), ], options={ 'verbose_name': 'Twallet', 'verbose_name_plural': 'Twallets', 'db_table': 'twallet', }, ), migrations.CreateModel( name='UnknownPayments', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('paidamt', models.DecimalField(decimal_places=2, default=0.0, max_digits=14)), ('paidby', models.CharField(max_length=230)), ('paidon', models.DateField()), ('msisdn', models.CharField(max_length=100)), ('reference', models.CharField(default='', max_length=50)), ('notes', models.CharField(default='', max_length=1020)), ('posted', models.IntegerField(default=0)), ], options={ 'verbose_name': 'UnknownPayments', 'verbose_name_plural': 'UnknownPaymentss', 'db_table': 'unknown_payments', }, ), ]