| <!DOCTYPE html> |
| <html> |
| <head> |
| <meta charset="utf-8"> |
| <meta http-equiv="X-UA-Compatible" content="IE=edge"> |
| <title>m_loan - fineract_default Database</title> |
| <!-- Tell the browser to be responsive to screen width --> |
| <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport"> |
| <link rel="icon" type="image/png" sizes="16x16" href="../favicon.png"> |
| <!-- Bootstrap 3.3.5 --> |
| <link rel="stylesheet" href="../bower/admin-lte/bootstrap/css/bootstrap.min.css"> |
| <!-- Font Awesome --> |
| <link rel="stylesheet" href="../bower/font-awesome/css/font-awesome.min.css"> |
| <!-- Ionicons --> |
| <link rel="stylesheet" href="../bower/ionicons/css/ionicons.min.css"> |
| <!-- DataTables --> |
| <link rel="stylesheet" href="../bower/datatables.net-bs/css/dataTables.bootstrap.min.css"> |
| <link rel="stylesheet" href="../bower/datatables.net-buttons-bs/css/buttons.bootstrap.min.css"> |
| <!-- Code Mirror --> |
| <link rel="stylesheet" href="../bower/codemirror/codemirror.css"> |
| <!-- Fonts --> |
| <link href='../fonts/indieflower/indie-flower.css' rel='stylesheet' type='text/css'> |
| <link href='../fonts/source-sans-pro/source-sans-pro.css' rel='stylesheet' type='text/css'> |
| |
| <!-- Theme style --> |
| <link rel="stylesheet" href="../bower/admin-lte/dist/css/AdminLTE.min.css"> |
| <!-- Salvattore --> |
| <link rel="stylesheet" href="../bower/salvattore/salvattore.css"> |
| <!-- AdminLTE Skins. Choose a skin from the css/skins |
| folder instead of downloading all of them to reduce the load. --> |
| <link rel="stylesheet" href="../bower/admin-lte/dist/css/skins/_all-skins.min.css"> |
| <!-- SchemaSpy --> |
| <link rel="stylesheet" href="../schemaSpy.css"> |
| |
| <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries --> |
| <!-- WARNING: Respond.js doesn't work if you view the page via file:// --> |
| <!--[if lt IE 9]> |
| <script src="../bower/html5shiv/html5shiv.min.js"></script> |
| <script src="../bower/respond/respond.min.js"></script> |
| <![endif]--> |
| </head> |
| <!-- ADD THE CLASS layout-top-nav TO REMOVE THE SIDEBAR. --> |
| <body class="hold-transition skin-blue layout-top-nav"> |
| <div class="wrapper"> |
| <header class="main-header"> |
| <nav class="navbar navbar-static-top"> |
| <div class="container"> |
| <div class="navbar-header"> |
| <a href="../index.html" class="navbar-brand"><b>fineract_default</b> Database</a> |
| <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar-collapse"><i class="fa fa-bars"></i></button> |
| </div> |
| |
| <!-- Collect the nav links, forms, and other content for toggling --> |
| <div class="collapse navbar-collapse pull-left" id="navbar-collapse"> |
| <ul class="nav navbar-nav"> |
| <li><a href="../index.html">Tables <span class="sr-only">(current)</span></a></li> |
| <li><a href="../columns.html" title="All of the columns in the schema">Columns</a></li> |
| <li><a href="../constraints.html" title="Useful for diagnosing error messages that just give constraint name or number">Constraints</a></li> |
| <li><a href="../relationships.html" title="Diagram of table relationships">Relationships</a></li> |
| <li><a href="../orphans.html" title="View of tables with neither parents nor children">Orphan Tables</a></li> |
| <li><a href="../anomalies.html" title="Things that might not be quite right">Anomalies</a></li> |
| <li><a href="../routines.html" title="Procedures and functions">Routines</a></li> |
| </ul> |
| </div> |
| <!-- /.navbar-collapse --> |
| <!-- Navbar Right Menu --> |
| </div> |
| <!-- /.container-fluid --> |
| </nav> |
| </header> |
| <!-- Main content --> |
| <!-- Full Width Column --> |
| <div class="content-wrapper"> |
| <!-- Content Header (Page header) --> |
| <section class="content-header"> |
| <h1>m_loan</h1><p><span id="recordNumber">0</span> rows</p><br /> |
| </section> |
| <!-- Main content --> |
| <section class="content"> |
| <div class="box box-primary"> |
| <div class="box-header with-border"> |
| <span class="glyphicon glyphicon-list-alt" aria-hidden="true"></span> |
| <h3 id="Columns" class="box-title">Columns</h3> |
| <div class="box-tools pull-right"> |
| <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> |
| <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> |
| </div> |
| </div> |
| <div class="box-body"> |
| <table id="standard_table" class="table table-bordered table-striped dataTable" role="grid"> |
| <thead align='left'> |
| <tr> |
| <th>Column</th> |
| <th>Type</th> |
| <th>Size</th> |
| <th title='Are nulls allowed?'>Nulls</th> |
| <th title='Is column automatically updated?'>Auto</th> |
| <th title='Default value'>Default</th> |
| <th title='Columns in tables that reference this column'>Children</th> |
| <th title='Columns in tables that are referenced by this column'>Parents</th> |
| <th title='Comments' class="toggle"><span>Comments</span></th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="id">id</span></td> |
| <td>BIGINT</td> |
| <td>19</td> |
| <td title=''></td> |
| <td title='Automatically updated by the database'>√</td> |
| <td>null</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td title="m_account_transfer_details.from_loan_account_id references m_loan.id via FK_m_account_transfer_details_from_loan_account"><a href='m_account_transfer_details.html'>m_account_transfer_details</a><span class='relatedKey'>.from_loan_account_id</span></td> |
| <td class="constraint detail">FK_m_account_transfer_details_from_loan_account<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_account_transfer_details.to_loan_account_id references m_loan.id via FK_m_account_transfer_details_to_loan_account"><a href='m_account_transfer_details.html'>m_account_transfer_details</a><span class='relatedKey'>.to_loan_account_id</span></td> |
| <td class="constraint detail">FK_m_account_transfer_details_to_loan_account<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_guarantor.loan_id references m_loan.id via FK_m_guarantor_m_loan"><a href='m_guarantor.html'>m_guarantor</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">FK_m_guarantor_m_loan<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_arrears_aging.loan_id references m_loan.id via m_loan_arrears_aging_ibfk_1"><a href='m_loan_arrears_aging.html'>m_loan_arrears_aging</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">m_loan_arrears_aging_ibfk_1<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_charge.loan_id references m_loan.id via m_loan_charge_ibfk_2"><a href='m_loan_charge.html'>m_loan_charge</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">m_loan_charge_ibfk_2<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_collateral.loan_id references m_loan.id via FK_collateral_m_loan"><a href='m_loan_collateral.html'>m_loan_collateral</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">FK_collateral_m_loan<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_collateral_management.loan_id references m_loan.id via fkLoan"><a href='m_loan_collateral_management.html'>m_loan_collateral_management</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">fkLoan<span title='Cascade on delete: Deletion of parent deletes child'>C</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_disbursement_detail.loan_id references m_loan.id via FK_loan_disbursement_detail_loan_id"><a href='m_loan_disbursement_detail.html'>m_loan_disbursement_detail</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">FK_loan_disbursement_detail_loan_id<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_officer_assignment_history.loan_id references m_loan.id via fk_m_loan_officer_assignment_history_0001"><a href='m_loan_officer_assignment_history.html'>m_loan_officer_assignment_history</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">fk_m_loan_officer_assignment_history_0001<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_paid_in_advance.loan_id references m_loan.id via m_loan_paid_in_advance_ibfk_1"><a href='m_loan_paid_in_advance.html'>m_loan_paid_in_advance</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">m_loan_paid_in_advance_ibfk_1<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_rate.loan_id references m_loan.id via FK_M_LOAN_RATE_LOAN"><a href='m_loan_rate.html'>m_loan_rate</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">FK_M_LOAN_RATE_LOAN<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_recalculation_details.loan_id references m_loan.id via FK_m_loan_m_loan_recalculation_details"><a href='m_loan_recalculation_details.html'>m_loan_recalculation_details</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">FK_m_loan_m_loan_recalculation_details<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_repayment_schedule.loan_id references m_loan.id via FK488B92AA40BE0710"><a href='m_loan_repayment_schedule.html'>m_loan_repayment_schedule</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">FK488B92AA40BE0710<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_repayment_schedule_history.loan_id references m_loan.id via m_loan_repayment_schedule_history_ibfk_1"><a href='m_loan_repayment_schedule_history.html'>m_loan_repayment_schedule_history</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">m_loan_repayment_schedule_history_ibfk_1<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_reschedule_request.loan_id references m_loan.id via m_loan_reschedule_request_ibfk_1"><a href='m_loan_reschedule_request.html'>m_loan_reschedule_request</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">m_loan_reschedule_request_ibfk_1<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_term_variations.loan_id references m_loan.id via FK_loan_id_m_loan_id"><a href='m_loan_term_variations.html'>m_loan_term_variations</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">FK_loan_id_m_loan_id<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_topup.closure_loan_id references m_loan.id via m_loan_topup_FK_closure_loan_id"><a href='m_loan_topup.html'>m_loan_topup</a><span class='relatedKey'>.closure_loan_id</span></td> |
| <td class="constraint detail">m_loan_topup_FK_closure_loan_id<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_topup.loan_id references m_loan.id via m_loan_topup_FK_loan_id"><a href='m_loan_topup.html'>m_loan_topup</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">m_loan_topup_FK_loan_id<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_tranche_charges.loan_id references m_loan.id via FK_m_loan_tranche_charges_m_loan"><a href='m_loan_tranche_charges.html'>m_loan_tranche_charges</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">FK_m_loan_tranche_charges_m_loan<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_transaction.loan_id references m_loan.id via FKCFCEA42640BE0710"><a href='m_loan_transaction.html'>m_loan_transaction</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">FKCFCEA42640BE0710<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_note.loan_id references m_loan.id via FK7C9708940BE0710"><a href='m_note.html'>m_note</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">FK7C9708940BE0710<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_portfolio_account_associations.linked_loan_account_id references m_loan.id via linked_loan_fk"><a href='m_portfolio_account_associations.html'>m_portfolio_account_associations</a><span class='relatedKey'>.linked_loan_account_id</span></td> |
| <td class="constraint detail">linked_loan_fk<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_portfolio_account_associations.loan_account_id references m_loan.id via account_association_loan_fk"><a href='m_portfolio_account_associations.html'>m_portfolio_account_associations</a><span class='relatedKey'>.loan_account_id</span></td> |
| <td class="constraint detail">account_association_loan_fk<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_repayment_with_post_dated_checks.loan_id references m_loan.id via fkloanrepayment"><a href='m_repayment_with_post_dated_checks.html'>m_repayment_with_post_dated_checks</a><span class='relatedKey'>.loan_id</span></td> |
| <td class="constraint detail">fkloanrepayment<span title='Cascade on delete: Deletion of parent deletes child'>C</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td class='indexedColumn' title='Indexed'><i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'></i><span id="account_no">account_no</span></td> |
| <td>VARCHAR</td> |
| <td>20</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>null</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td class='indexedColumn' title='Indexed'><i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'></i><span id="external_id">external_id</span></td> |
| <td>VARCHAR</td> |
| <td>100</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="client_id">client_id</span></td> |
| <td>BIGINT</td> |
| <td>19</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td title="m_loan.client_id references m_client.id via FKB6F935D87179A0CB"><a href='m_client.html'>m_client</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FKB6F935D87179A0CB<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="group_id">group_id</span></td> |
| <td>BIGINT</td> |
| <td>19</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td title="m_loan.group_id references m_group.id via m_loan_ibfk_1"><a href='m_group.html'>m_group</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">m_loan_ibfk_1<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="glim_id">glim_id</span></td> |
| <td>BIGINT</td> |
| <td>19</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td title="m_loan.glim_id references glim_accounts.id via FK_glim_id"><a href='glim_accounts.html'>glim_accounts</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FK_glim_id<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="product_id">product_id</span></td> |
| <td>BIGINT</td> |
| <td>19</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td title="m_loan.product_id references m_product_loan.id via FKB6F935D8C8D4B434"><a href='m_product_loan.html'>m_product_loan</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FKB6F935D8C8D4B434<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="fund_id">fund_id</span></td> |
| <td>BIGINT</td> |
| <td>19</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td title="m_loan.fund_id references m_fund.id via FK7C885877240145"><a href='m_fund.html'>m_fund</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FK7C885877240145<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="loan_officer_id">loan_officer_id</span></td> |
| <td>BIGINT</td> |
| <td>19</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td title="m_loan.loan_officer_id references m_staff.id via FK_m_loan_m_staff"><a href='m_staff.html'>m_staff</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FK_m_loan_m_staff<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="loanpurpose_cv_id">loanpurpose_cv_id</span></td> |
| <td>INT</td> |
| <td>10</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td title="m_loan.loanpurpose_cv_id references m_code_value.id via FK_m_loanpurpose_codevalue"><a href='m_code_value.html'>m_code_value</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FK_m_loanpurpose_codevalue<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="loan_status_id">loan_status_id</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>null</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="loan_type_enum">loan_type_enum</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>null</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="currency_code">currency_code</span></td> |
| <td>VARCHAR</td> |
| <td>3</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>null</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="currency_digits">currency_digits</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>null</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="currency_multiplesof">currency_multiplesof</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="principal_amount_proposed">principal_amount_proposed</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>null</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="principal_amount">principal_amount</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>null</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="approved_principal">approved_principal</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>null</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="net_disbursal_amount">net_disbursal_amount</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>null</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="arrearstolerance_amount">arrearstolerance_amount</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="is_floating_interest_rate">is_floating_interest_rate</span></td> |
| <td>BIT</td> |
| <td>1</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>b'0'</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="interest_rate_differential">interest_rate_differential</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="nominal_interest_rate_per_period">nominal_interest_rate_per_period</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="interest_period_frequency_enum">interest_period_frequency_enum</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="annual_nominal_interest_rate">annual_nominal_interest_rate</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="interest_method_enum">interest_method_enum</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>null</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="interest_calculated_in_period_enum">interest_calculated_in_period_enum</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="allow_partial_period_interest_calcualtion">allow_partial_period_interest_calcualtion</span></td> |
| <td>BIT</td> |
| <td>1</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>b'0'</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="term_frequency">term_frequency</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="term_period_frequency_enum">term_period_frequency_enum</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="repay_every">repay_every</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>null</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="repayment_period_frequency_enum">repayment_period_frequency_enum</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>null</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="number_of_repayments">number_of_repayments</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>null</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="grace_on_principal_periods">grace_on_principal_periods</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="recurring_moratorium_principal_periods">recurring_moratorium_principal_periods</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="grace_on_interest_periods">grace_on_interest_periods</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="grace_interest_free_periods">grace_interest_free_periods</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="amortization_method_enum">amortization_method_enum</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>null</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="submittedon_date">submittedon_date</span></td> |
| <td>DATE</td> |
| <td>10</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="submittedon_userid">submittedon_userid</span></td> |
| <td>BIGINT</td> |
| <td>19</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td title="m_loan.submittedon_userid references m_appuser.id via FK_submittedon_userid"><a href='m_appuser.html'>m_appuser</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FK_submittedon_userid<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="approvedon_date">approvedon_date</span></td> |
| <td>DATE</td> |
| <td>10</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="approvedon_userid">approvedon_userid</span></td> |
| <td>BIGINT</td> |
| <td>19</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td title="m_loan.approvedon_userid references m_appuser.id via FK_approvedon_userid"><a href='m_appuser.html'>m_appuser</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FK_approvedon_userid<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="expected_disbursedon_date">expected_disbursedon_date</span></td> |
| <td>DATE</td> |
| <td>10</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="expected_firstrepaymenton_date">expected_firstrepaymenton_date</span></td> |
| <td>DATE</td> |
| <td>10</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="interest_calculated_from_date">interest_calculated_from_date</span></td> |
| <td>DATE</td> |
| <td>10</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="disbursedon_date">disbursedon_date</span></td> |
| <td>DATE</td> |
| <td>10</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="disbursedon_userid">disbursedon_userid</span></td> |
| <td>BIGINT</td> |
| <td>19</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td title="m_loan.disbursedon_userid references m_appuser.id via FK_disbursedon_userid"><a href='m_appuser.html'>m_appuser</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FK_disbursedon_userid<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="expected_maturedon_date">expected_maturedon_date</span></td> |
| <td>DATE</td> |
| <td>10</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="maturedon_date">maturedon_date</span></td> |
| <td>DATE</td> |
| <td>10</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="closedon_date">closedon_date</span></td> |
| <td>DATE</td> |
| <td>10</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="closedon_userid">closedon_userid</span></td> |
| <td>BIGINT</td> |
| <td>19</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td title="m_loan.closedon_userid references m_appuser.id via FK_closedon_userid"><a href='m_appuser.html'>m_appuser</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FK_closedon_userid<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="total_charges_due_at_disbursement_derived">total_charges_due_at_disbursement_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="principal_disbursed_derived">principal_disbursed_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="principal_repaid_derived">principal_repaid_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="principal_writtenoff_derived">principal_writtenoff_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="principal_outstanding_derived">principal_outstanding_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="interest_charged_derived">interest_charged_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="interest_repaid_derived">interest_repaid_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="interest_waived_derived">interest_waived_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="interest_writtenoff_derived">interest_writtenoff_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="interest_outstanding_derived">interest_outstanding_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="fee_charges_charged_derived">fee_charges_charged_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="fee_charges_repaid_derived">fee_charges_repaid_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="fee_charges_waived_derived">fee_charges_waived_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="fee_charges_writtenoff_derived">fee_charges_writtenoff_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="fee_charges_outstanding_derived">fee_charges_outstanding_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="penalty_charges_charged_derived">penalty_charges_charged_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="penalty_charges_repaid_derived">penalty_charges_repaid_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="penalty_charges_waived_derived">penalty_charges_waived_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="penalty_charges_writtenoff_derived">penalty_charges_writtenoff_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="penalty_charges_outstanding_derived">penalty_charges_outstanding_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="total_expected_repayment_derived">total_expected_repayment_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="total_repayment_derived">total_repayment_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="total_expected_costofloan_derived">total_expected_costofloan_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="total_costofloan_derived">total_costofloan_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="total_waived_derived">total_waived_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="total_writtenoff_derived">total_writtenoff_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="total_outstanding_derived">total_outstanding_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>0.000000</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="total_overpaid_derived">total_overpaid_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="rejectedon_date">rejectedon_date</span></td> |
| <td>DATE</td> |
| <td>10</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="rejectedon_userid">rejectedon_userid</span></td> |
| <td>BIGINT</td> |
| <td>19</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td title="m_loan.rejectedon_userid references m_appuser.id via FK_rejectedon_userid"><a href='m_appuser.html'>m_appuser</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FK_rejectedon_userid<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="rescheduledon_date">rescheduledon_date</span></td> |
| <td>DATE</td> |
| <td>10</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="rescheduledon_userid">rescheduledon_userid</span></td> |
| <td>BIGINT</td> |
| <td>19</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="withdrawnon_date">withdrawnon_date</span></td> |
| <td>DATE</td> |
| <td>10</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="withdrawnon_userid">withdrawnon_userid</span></td> |
| <td>BIGINT</td> |
| <td>19</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td title="m_loan.withdrawnon_userid references m_appuser.id via FK_withdrawnon_userid"><a href='m_appuser.html'>m_appuser</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FK_withdrawnon_userid<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="writtenoffon_date">writtenoffon_date</span></td> |
| <td>DATE</td> |
| <td>10</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="loan_transaction_strategy_id">loan_transaction_strategy_id</span></td> |
| <td>BIGINT</td> |
| <td>19</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td title="m_loan.loan_transaction_strategy_id references ref_loan_transaction_processing_strategy.id via FK_loan_ltp_strategy"><a href='ref_loan_transaction_processing_strategy.html'>ref_loan_transaction_processing_strategy</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FK_loan_ltp_strategy<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="sync_disbursement_with_meeting">sync_disbursement_with_meeting</span></td> |
| <td>BIT</td> |
| <td>1</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="loan_counter">loan_counter</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="loan_product_counter">loan_product_counter</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="fixed_emi_amount">fixed_emi_amount</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="max_outstanding_loan_balance">max_outstanding_loan_balance</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="grace_on_arrears_ageing">grace_on_arrears_ageing</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="is_npa">is_npa</span></td> |
| <td>BIT</td> |
| <td>1</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>b'0'</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="total_recovered_derived">total_recovered_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="accrued_till">accrued_till</span></td> |
| <td>DATE</td> |
| <td>10</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="interest_recalcualated_on">interest_recalcualated_on</span></td> |
| <td>DATE</td> |
| <td>10</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="days_in_month_enum">days_in_month_enum</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="days_in_year_enum">days_in_year_enum</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="interest_recalculation_enabled">interest_recalculation_enabled</span></td> |
| <td>BIT</td> |
| <td>1</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>b'0'</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="guarantee_amount_derived">guarantee_amount_derived</span></td> |
| <td>DECIMAL</td> |
| <td>19,6</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="create_standing_instruction_at_disbursement">create_standing_instruction_at_disbursement</span></td> |
| <td>BIT</td> |
| <td>1</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="version">version</span></td> |
| <td>INT</td> |
| <td>10</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="writeoff_reason_cv_id">writeoff_reason_cv_id</span></td> |
| <td>INT</td> |
| <td>10</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td title="m_loan.writeoff_reason_cv_id references m_code_value.id via FK_writeoffreason_m_loan_m_code_value"><a href='m_code_value.html'>m_code_value</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FK_writeoffreason_m_loan_m_code_value<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="loan_sub_status_id">loan_sub_status_id</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="is_topup">is_topup</span></td> |
| <td>BIT</td> |
| <td>1</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>b'0'</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="is_equal_amortization">is_equal_amortization</span></td> |
| <td>BIT</td> |
| <td>1</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>b'0'</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="fixed_principal_percentage_per_installment">fixed_principal_percentage_per_installment</span></td> |
| <td>DECIMAL</td> |
| <td>5,2</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| </tbody> |
| </table> |
| </div> |
| </div> |
| <div class="box box-primary"> |
| <div class="box-header with-border"> |
| <i class="fa fa-sitemap"></i> |
| <h3 id="Indexes" class="box-title">Indexes</h3> |
| <div class="box-tools pull-right"> |
| <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> |
| <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> |
| </div> |
| </div> |
| <div class="box-body"> |
| <table id="indexes_table" class="table table-bordered table-striped dataTable" role="grid"> |
| <thead> |
| <tr> |
| <th>Constraint Name</th> |
| <th>Type</th> |
| <th>Sort</th> |
| <th>Column(s)</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td class='primaryKey' title='Primary Key'><i class='icon ion-key iconkey'></i> PRIMARY</td> |
| <td>Primary key</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>id</td> |
| </tr> |
| <tr> |
| <td class='uniqueKey' title='Unique Key'><i class='icon ion-key iconkey'></i> account_no</td> |
| <td>Must be unique</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>account_no</td> |
| </tr> |
| <tr> |
| <td class='uniqueKey' title='Unique Key'><i class='icon ion-key iconkey'></i> external_id</td> |
| <td>Must be unique</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>external_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FK7C885877240145</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>fund_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FK_approvedon_userid</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>approvedon_userid</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FK_closedon_userid</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>closedon_userid</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FK_disbursedon_userid</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>disbursedon_userid</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FK_glim_id</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>glim_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FK_loan_ltp_strategy</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>loan_transaction_strategy_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>fk_m_group_client_001_idx</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span>/<span title='Ascending'>Asc</span></td> |
| <td>group_id + client_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FK_m_loan_m_staff</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>loan_officer_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FK_m_loanpurpose_codevalue</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>loanpurpose_cv_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FK_rejectedon_userid</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>rejectedon_userid</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FK_submittedon_userid</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>submittedon_userid</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FK_withdrawnon_userid</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>withdrawnon_userid</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FK_writeoffreason_m_loan_m_code_value</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>writeoff_reason_cv_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FKB6F935D87179A0CB</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>client_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FKB6F935D8C8D4B434</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>product_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>group_id</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>group_id</td> |
| </tr> |
| </tbody> |
| </table> |
| </div><!-- /.box-body --> |
| </div> |
| <div class="box box-primary"> |
| <div class="box-header with-border"> |
| <i class="fa fa-code-fork"></i> |
| <h3 id="Relationships" class="box-title">Relationships</h3> |
| <div class="box-tools pull-right"> |
| <button type="button" class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-minus"></i></button> |
| <button type="button" class="btn btn-box-tool" data-widget="remove"><i class="fa fa-times"></i></button> |
| </div> |
| </div> |
| <div class="box-body"> |
| <div class="nav-tabs-custom"><!-- Tabs within a box --> |
| <h5>Close relationships within degrees of separation</h5> |
| <ul class="nav nav-tabs pull-left ui-sortable-handle"> |
| <li class="active"><a href="#oneDegreeImg-chart" data-toggle="tab" aria-expanded="true">One</a></li> |
| <li class=""><a href="#twodegreesDegreeImg-chart" data-toggle="tab" aria-expanded="true">Two degrees</a></li> |
| </ul> |
| <div class="tab-content no-padding"> |
| <div class="chart tab-pane active" id="oneDegreeImg-chart" style="position: relative; overflow-x:auto;"> |
| <map id="oneDegreeRelationshipsDiagram" name="oneDegreeRelationshipsDiagram"> |
| <area shape="rect" id="node1" href="../../tables/glim_accounts.html" target="_top" title="glim_accounts" alt="" coords="1037,1715,1277,1891"> |
| <area shape="rect" id="node2" href="../../tables/m_group.html" target="_top" title="m_group" alt="" coords="508,1729,744,2052"> |
| <area shape="rect" id="node7" href="../../tables/m_staff.html" target="_top" title="m_staff" alt="" coords="5,2029,371,2293"> |
| <area shape="rect" id="node8" href="../../tables/m_code_value.html" target="_top" title="m_code_value" alt="" coords="87,1152,289,1328"> |
| <area shape="rect" id="node3" href="../../tables/m_account_transfer_details.html" target="_top" title="m_account_transfer_details" alt="" coords="2160,392,2455,744"> |
| <area shape="rect" id="node4" href="../../tables/m_client.html" target="_top" title="m_client" alt="" coords="487,741,765,1328"> |
| <area shape="rect" id="node5" href="../../tables/m_loan.html" target="_top" title="m_loan" alt="" coords="1476,1093,2033,4331"> |
| <area shape="rect" id="node6" href="../../tables/m_appuser.html" target="_top" title="m_appuser" alt="" coords="1003,3501,1311,3736"> |
| <area shape="rect" id="node10" href="../../tables/m_fund.html" target="_top" title="m_fund" alt="" coords="551,1345,701,1497"> |
| <area shape="rect" id="node11" href="../../tables/ref_loan_transaction_processing_strategy.html" target="_top" title="ref_loan_transaction_processing_strategy" alt="" coords="415,1515,837,1661"> |
| <area shape="rect" id="node12" href="../../tables/m_product_loan.html" target="_top" title="m_product_loan" alt="" coords="881,1325,1432,1589"> |
| <area shape="rect" id="node9" href="../../tables/m_guarantor.html" target="_top" title="m_guarantor" alt="" coords="2185,5,2429,181"> |
| <area shape="rect" id="node13" href="../../tables/m_loan_arrears_aging.html" target="_top" title="m_loan_arrears_aging" alt="" coords="2130,2381,2485,2499"> |
| <area shape="rect" id="node14" href="../../tables/m_loan_charge.html" target="_top" title="m_loan_charge" alt="" coords="2145,2516,2470,2721"> |
| <area shape="rect" id="node15" href="../../tables/m_loan_collateral.html" target="_top" title="m_loan_collateral" alt="" coords="2205,199,2410,375"> |
| <area shape="rect" id="node16" href="../../tables/m_loan_collateral_management.html" target="_top" title="m_loan_collateral_management" alt="" coords="2613,1420,2945,1625"> |
| <area shape="rect" id="node17" href="../../tables/m_loan_transaction.html" target="_top" title="m_loan_transaction" alt="" coords="2128,1508,2487,1743"> |
| <area shape="rect" id="node18" href="../../tables/m_loan_disbursement_detail.html" target="_top" title="m_loan_disbursement_detail" alt="" coords="2155,2739,2459,2885"> |
| <area shape="rect" id="node19" href="../../tables/m_loan_officer_assignment_history.html" target="_top" title="m_loan_officer_assignment_history" alt="" coords="2126,4335,2489,4511"> |
| <area shape="rect" id="node20" href="../../tables/m_loan_paid_in_advance.html" target="_top" title="m_loan_paid_in_advance" alt="" coords="2117,961,2497,1079"> |
| <area shape="rect" id="node21" href="../../tables/m_loan_rate.html" target="_top" title="m_loan_rate" alt="" coords="2224,1096,2391,1219"> |
| <area shape="rect" id="node22" href="../../tables/m_loan_recalculation_details.html" target="_top" title="m_loan_recalculation_details" alt="" coords="2077,1236,2537,1383"> |
| <area shape="rect" id="node23" href="../../tables/m_loan_repayment_schedule.html" target="_top" title="m_loan_repayment_schedule" alt="" coords="2119,797,2495,944"> |
| <area shape="rect" id="node24" href="../../tables/m_loan_repayment_schedule_history.html" target="_top" title="m_loan_repayment_schedule_history" alt="" coords="2591,2825,2968,3001"> |
| <area shape="rect" id="node25" href="../../tables/m_loan_reschedule_request.html" target="_top" title="m_loan_reschedule_request" alt="" coords="2153,4017,2462,4281"> |
| <area shape="rect" id="node26" href="../../tables/m_loan_term_variations.html" target="_top" title="m_loan_term_variations" alt="" coords="2169,1796,2446,1943"> |
| <area shape="rect" id="node27" href="../../tables/m_loan_topup.html" target="_top" title="m_loan_topup" alt="" coords="2632,1197,2927,1403"> |
| <area shape="rect" id="node28" href="../../tables/m_loan_tranche_charges.html" target="_top" title="m_loan_tranche_charges" alt="" coords="2173,1960,2442,2112"> |
| <area shape="rect" id="node29" href="../../tables/m_note.html" target="_top" title="m_note" alt="" coords="2613,4239,2945,4591"> |
| <area shape="rect" id="node30" href="../../tables/m_portfolio_account_associations.html" target="_top" title="m_portfolio_account_associations" alt="" coords="2132,2129,2483,2364"> |
| <area shape="rect" id="node31" href="../../tables/m_repayment_with_post_dated_checks.html" target="_top" title="m_repayment_with_post_dated_checks" alt="" coords="2581,687,2977,892"> |
| </map> |
| <a name='diagram'><object type="image/svg+xml" id="oneDegreeImg" data="../diagrams/tables/m_loan.1degree.svg" class="diagram" border="0" align="left"></object></a> |
| </div> |
| <div class="chart tab-pane " id="twodegreesDegreeImg-chart" style="position: relative; overflow-x:auto;"> |
| <map id="twoDegreesRelationshipsDiagram" name="twoDegreesRelationshipsDiagram"> |
| <area shape="rect" id="node1" href="../../tables/acc_gl_account.html" target="_top" title="acc_gl_account" alt="" coords="1250,519,1439,607"> |
| <area shape="rect" id="node2" href="../../tables/m_code_value.html" target="_top" title="m_code_value" alt="" coords="713,5195,915,5371"> |
| <area shape="rect" id="node38" href="../../tables/m_code.html" target="_top" title="m_code" alt="" coords="308,4807,444,4895"> |
| <area shape="rect" id="node3" href="../../tables/acc_gl_closure.html" target="_top" title="acc_gl_closure" alt="" coords="1252,104,1437,192"> |
| <area shape="rect" id="node4" href="../../tables/m_appuser.html" target="_top" title="m_appuser" alt="" coords="660,1360,968,1595"> |
| <area shape="rect" id="node5" href="../../tables/m_office.html" target="_top" title="m_office" alt="" coords="7,1392,148,1480"> |
| <area shape="rect" id="node23" href="../../tables/m_staff.html" target="_top" title="m_staff" alt="" coords="193,4912,559,5176"> |
| <area shape="rect" id="node6" href="../../tables/acc_gl_journal_entry.html" target="_top" title="acc_gl_journal_entry" alt="" coords="4036,60,4263,148"> |
| <area shape="rect" id="node7" href="../../tables/m_client_transaction.html" target="_top" title="m_client_transaction" alt="" coords="2977,133,3204,221"> |
| <area shape="rect" id="node8" href="../../tables/m_loan_transaction.html" target="_top" title="m_loan_transaction" alt="" coords="3464,901,3823,1136"> |
| <area shape="rect" id="node9" href="../../tables/m_payment_detail.html" target="_top" title="m_payment_detail" alt="" coords="2987,239,3195,327"> |
| <area shape="rect" id="node12" href="../../tables/m_client.html" target="_top" title="m_client" alt="" coords="2451,4801,2730,5388"> |
| <area shape="rect" id="node17" href="../../tables/m_loan.html" target="_top" title="m_loan" alt="" coords="2812,1264,3369,4501"> |
| <area shape="rect" id="node10" href="../../tables/acc_rule_tags.html" target="_top" title="acc_rule_tags" alt="" coords="1256,4951,1433,5039"> |
| <area shape="rect" id="node11" href="../../tables/client_device_registration.html" target="_top" title="client_device_registration" alt="" coords="2960,5053,3221,5141"> |
| <area shape="rect" id="node18" href="../../tables/m_savings_account.html" target="_top" title="m_savings_account" alt="" coords="2126,5480,2346,5568"> |
| <area shape="rect" id="node29" href="../../tables/m_savings_product.html" target="_top" title="m_savings_product" alt="" coords="1752,5127,1971,5215"> |
| <area shape="rect" id="node30" href="../../tables/m_image.html" target="_top" title="m_image" alt="" coords="5,4897,149,4985"> |
| <area shape="rect" id="node13" href="../../tables/glim_accounts.html" target="_top" title="glim_accounts" alt="" coords="2116,2125,2356,2301"> |
| <area shape="rect" id="node14" href="../../tables/m_group.html" target="_top" title="m_group" alt="" coords="1227,5644,1463,5967"> |
| <area shape="rect" id="node43" href="../../tables/m_group_level.html" target="_top" title="m_group_level" alt="" coords="722,5793,906,5881"> |
| <area shape="rect" id="node15" href="../../tables/gsim_accounts.html" target="_top" title="gsim_accounts" alt="" coords="1768,5705,1955,5793"> |
| <area shape="rect" id="node16" href="../../tables/m_account_transfer_details.html" target="_top" title="m_account_transfer_details" alt="" coords="3496,4593,3791,4945"> |
| <area shape="rect" id="node40" href="../../tables/m_product_loan.html" target="_top" title="m_product_loan" alt="" coords="1069,2721,1620,2985"> |
| <area shape="rect" id="node51" href="../../tables/m_fund.html" target="_top" title="m_fund" alt="" coords="739,2659,889,2811"> |
| <area shape="rect" id="node52" href="../../tables/ref_loan_transaction_processing_strategy.html" target="_top" title="ref_loan_transaction_processing_strategy" alt="" coords="603,3596,1025,3743"> |
| <area shape="rect" id="node28" href="../../tables/m_tax_group.html" target="_top" title="m_tax_group" alt="" coords="1258,3377,1431,3465"> |
| <area shape="rect" id="node19" href="../../tables/m_account_transfer_standing_instructions.html" target="_top" title="m_account_transfer_standing_instructions" alt="" coords="3959,4649,4340,4737"> |
| <area shape="rect" id="node20" href="../../tables/m_account_transfer_transaction.html" target="_top" title="m_account_transfer_transaction" alt="" coords="3995,1244,4303,1332"> |
| <area shape="rect" id="node21" href="../../tables/m_address.html" target="_top" title="m_address" alt="" coords="1266,5056,1423,5144"> |
| <area shape="rect" id="node22" href="../../tables/m_adhoc.html" target="_top" title="m_adhoc" alt="" coords="1272,1735,1417,1823"> |
| <area shape="rect" id="node24" href="../../tables/m_appuser_previous_password.html" target="_top" title="m_appuser_previous_password" alt="" coords="1193,1840,1497,1928"> |
| <area shape="rect" id="node25" href="../../tables/m_appuser_role.html" target="_top" title="m_appuser_role" alt="" coords="1248,1945,1441,2033"> |
| <area shape="rect" id="node26" href="../../tables/m_cashiers.html" target="_top" title="m_cashiers" alt="" coords="733,4807,895,4895"> |
| <area shape="rect" id="node27" href="../../tables/m_charge.html" target="_top" title="m_charge" alt="" coords="2516,557,2665,645"> |
| <area shape="rect" id="node31" href="../../tables/m_client_address.html" target="_top" title="m_client_address" alt="" coords="2989,5727,3193,5815"> |
| <area shape="rect" id="node32" href="../../tables/m_client_attendance.html" target="_top" title="m_client_attendance" alt="" coords="2978,5159,3203,5247"> |
| <area shape="rect" id="node33" href="../../tables/m_client_charge.html" target="_top" title="m_client_charge" alt="" coords="2993,735,3189,823"> |
| <area shape="rect" id="node34" href="../../tables/m_client_collateral_management.html" target="_top" title="m_client_collateral_management" alt="" coords="3489,4315,3798,4403"> |
| <area shape="rect" id="node35" href="../../tables/m_client_identifier.html" target="_top" title="m_client_identifier" alt="" coords="2986,5336,3195,5424"> |
| <area shape="rect" id="node36" href="../../tables/m_client_non_person.html" target="_top" title="m_client_non_person" alt="" coords="2975,4843,3207,4931"> |
| <area shape="rect" id="node37" href="../../tables/m_client_transfer_details.html" target="_top" title="m_client_transfer_details" alt="" coords="2962,840,3219,928"> |
| <area shape="rect" id="node39" href="../../tables/m_creditbureau_loanproduct_mapping.html" target="_top" title="m_creditbureau_loanproduct_mapping" alt="" coords="1685,2881,2038,2969"> |
| <area shape="rect" id="node41" href="../../tables/m_entity_to_entity_access.html" target="_top" title="m_entity_to_entity_access" alt="" coords="1212,5233,1477,5321"> |
| <area shape="rect" id="node42" href="../../tables/m_family_members.html" target="_top" title="m_family_members" alt="" coords="2982,5621,3199,5709"> |
| <area shape="rect" id="node44" href="../../tables/m_group_client.html" target="_top" title="m_group_client" alt="" coords="2996,5832,3185,5920"> |
| <area shape="rect" id="node45" href="../../tables/m_group_roles.html" target="_top" title="m_group_roles" alt="" coords="2997,5937,3184,6025"> |
| <area shape="rect" id="node46" href="../../tables/m_guarantor.html" target="_top" title="m_guarantor" alt="" coords="3521,5692,3765,5868"> |
| <area shape="rect" id="node47" href="../../tables/m_guarantor_funding_details.html" target="_top" title="m_guarantor_funding_details" alt="" coords="4006,5443,4293,5531"> |
| <area shape="rect" id="node48" href="../../tables/m_portfolio_account_associations.html" target="_top" title="m_portfolio_account_associations" alt="" coords="3468,5440,3819,5675"> |
| <area shape="rect" id="node49" href="../../tables/m_guarantor_transaction.html" target="_top" title="m_guarantor_transaction" alt="" coords="4425,3315,4683,3403"> |
| <area shape="rect" id="node50" href="../../tables/m_import_document.html" target="_top" title="m_import_document" alt="" coords="1232,2051,1457,2139"> |
| <area shape="rect" id="node53" href="../../tables/m_loan_arrears_aging.html" target="_top" title="m_loan_arrears_aging" alt="" coords="3466,2035,3821,2152"> |
| <area shape="rect" id="node54" href="../../tables/m_loan_charge.html" target="_top" title="m_loan_charge" alt="" coords="3481,345,3806,551"> |
| <area shape="rect" id="node55" href="../../tables/m_loan_charge_paid_by.html" target="_top" title="m_loan_charge_paid_by" alt="" coords="4024,669,4275,757"> |
| <area shape="rect" id="node56" href="../../tables/m_loan_collateral.html" target="_top" title="m_loan_collateral" alt="" coords="3541,4020,3746,4196"> |
| <area shape="rect" id="node57" href="../../tables/m_loan_collateral_management.html" target="_top" title="m_loan_collateral_management" alt="" coords="3983,1929,4315,2135"> |
| <area shape="rect" id="node58" href="../../tables/m_loan_disbursement_detail.html" target="_top" title="m_loan_disbursement_detail" alt="" coords="3491,1635,3795,1781"> |
| <area shape="rect" id="node59" href="../../tables/m_loan_installment_charge.html" target="_top" title="m_loan_installment_charge" alt="" coords="4013,457,4286,545"> |
| <area shape="rect" id="node60" href="../../tables/m_loan_repayment_schedule.html" target="_top" title="m_loan_repayment_schedule" alt="" coords="3455,737,3831,884"> |
| <area shape="rect" id="node61" href="../../tables/m_loan_interest_recalculation_additional_details.html" target="_top" title="m_loan_interest_recalculation_additional_details" alt="" coords="3939,564,4360,652"> |
| <area shape="rect" id="node62" href="../../tables/m_loan_officer_assignment_history.html" target="_top" title="m_loan_officer_assignment_history" alt="" coords="3462,3624,3825,3800"> |
| <area shape="rect" id="node63" href="../../tables/m_loan_overdue_installment_charge.html" target="_top" title="m_loan_overdue_installment_charge" alt="" coords="3981,351,4318,439"> |
| <area shape="rect" id="node64" href="../../tables/m_loan_paid_in_advance.html" target="_top" title="m_loan_paid_in_advance" alt="" coords="3453,2169,3833,2287"> |
| <area shape="rect" id="node65" href="../../tables/m_loan_rate.html" target="_top" title="m_loan_rate" alt="" coords="3560,205,3727,328"> |
| <area shape="rect" id="node66" href="../../tables/m_rate.html" target="_top" title="m_rate" alt="" coords="1279,1521,1411,1609"> |
| <area shape="rect" id="node67" href="../../tables/m_loan_recalculation_details.html" target="_top" title="m_loan_recalculation_details" alt="" coords="3413,1471,3873,1617"> |
| <area shape="rect" id="node68" href="../../tables/m_loan_repayment_schedule_history.html" target="_top" title="m_loan_repayment_schedule_history" alt="" coords="3961,1355,4338,1531"> |
| <area shape="rect" id="node69" href="../../tables/m_loan_reschedule_request.html" target="_top" title="m_loan_reschedule_request" alt="" coords="3489,1153,3798,1417"> |
| <area shape="rect" id="node70" href="../../tables/m_loan_reschedule_request_term_variations_mapping.html" target="_top" title="m_loan_reschedule_request_term_variations_mapping" alt="" coords="3917,1680,4381,1768"> |
| <area shape="rect" id="node71" href="../../tables/m_loan_term_variations.html" target="_top" title="m_loan_term_variations" alt="" coords="3505,1835,3782,1981"> |
| <area shape="rect" id="node72" href="../../tables/m_loan_topup.html" target="_top" title="m_loan_topup" alt="" coords="4002,2241,4297,2447"> |
| <area shape="rect" id="node73" href="../../tables/m_loan_tranche_charges.html" target="_top" title="m_loan_tranche_charges" alt="" coords="3509,568,3778,720"> |
| <area shape="rect" id="node74" href="../../tables/m_loan_tranche_disbursement_charge.html" target="_top" title="m_loan_tranche_disbursement_charge" alt="" coords="3973,775,4326,863"> |
| <area shape="rect" id="node75" href="../../tables/m_loan_transaction_repayment_schedule_mapping.html" target="_top" title="m_loan_transaction_repayment_schedule_mapping" alt="" coords="3929,880,4370,968"> |
| <area shape="rect" id="node76" href="../../tables/m_loanproduct_provisioning_entry.html" target="_top" title="m_loanproduct_provisioning_entry" alt="" coords="1698,521,2025,609"> |
| <area shape="rect" id="node77" href="../../tables/m_provisioning_criteria.html" target="_top" title="m_provisioning_criteria" alt="" coords="1221,887,1468,975"> |
| <area shape="rect" id="node78" href="../../tables/m_provisioning_history.html" target="_top" title="m_provisioning_history" alt="" coords="1221,413,1468,501"> |
| <area shape="rect" id="node79" href="../../tables/m_loanproduct_provisioning_mapping.html" target="_top" title="m_loanproduct_provisioning_mapping" alt="" coords="1685,1771,2037,1859"> |
| <area shape="rect" id="node80" href="../../tables/m_note.html" target="_top" title="m_note" alt="" coords="3983,4280,4315,4632"> |
| <area shape="rect" id="node81" href="../../tables/m_pocket.html" target="_top" title="m_pocket" alt="" coords="1270,2156,1419,2244"> |
| <area shape="rect" id="node82" href="../../tables/m_portfolio_command_source.html" target="_top" title="m_portfolio_command_source" alt="" coords="1197,2261,1492,2349"> |
| <area shape="rect" id="node83" href="../../tables/m_product_loan_charge.html" target="_top" title="m_product_loan_charge" alt="" coords="2965,629,3216,717"> |
| <area shape="rect" id="node84" href="../../tables/m_product_loan_configurable_attributes.html" target="_top" title="m_product_loan_configurable_attributes" alt="" coords="1679,2671,2044,2759"> |
| <area shape="rect" id="node85" href="../../tables/m_product_loan_floating_rates.html" target="_top" title="m_product_loan_floating_rates" alt="" coords="1712,2776,2011,2864"> |
| <area shape="rect" id="node86" href="../../tables/m_product_loan_guarantee_details.html" target="_top" title="m_product_loan_guarantee_details" alt="" coords="1698,2987,2025,3075"> |
| <area shape="rect" id="node87" href="../../tables/m_product_loan_rate.html" target="_top" title="m_product_loan_rate" alt="" coords="1747,1876,1976,1964"> |
| <area shape="rect" id="node88" href="../../tables/m_product_loan_recalculation_details.html" target="_top" title="m_product_loan_recalculation_details" alt="" coords="1688,3092,2035,3180"> |
| <area shape="rect" id="node89" href="../../tables/m_product_loan_variable_installment_config.html" target="_top" title="m_product_loan_variable_installment_config" alt="" coords="1664,2460,2059,2548"> |
| <area shape="rect" id="node90" href="../../tables/m_product_loan_variations_borrower_cycle.html" target="_top" title="m_product_loan_variations_borrower_cycle" alt="" coords="1667,2565,2055,2653"> |
| <area shape="rect" id="node91" href="../../tables/m_product_mix.html" target="_top" title="m_product_mix" alt="" coords="1767,2355,1956,2443"> |
| <area shape="rect" id="node92" href="../../tables/m_repayment_with_post_dated_checks.html" target="_top" title="m_repayment_with_post_dated_checks" alt="" coords="3951,985,4347,1191"> |
| <area shape="rect" id="node93" href="../../tables/m_report_mailing_job.html" target="_top" title="m_report_mailing_job" alt="" coords="1228,2367,1461,2455"> |
| <area shape="rect" id="node94" href="../../tables/m_savings_officer_assignment_history.html" target="_top" title="m_savings_officer_assignment_history" alt="" coords="2413,5621,2768,5709"> |
| <area shape="rect" id="node95" href="../../tables/m_selfservice_user_client_mapping.html" target="_top" title="m_selfservice_user_client_mapping" alt="" coords="2925,1053,3256,1141"> |
| <area shape="rect" id="node96" href="../../tables/m_share_account.html" target="_top" title="m_share_account" alt="" coords="2988,344,3193,432"> |
| <area shape="rect" id="node97" href="../../tables/m_share_product.html" target="_top" title="m_share_product" alt="" coords="1243,1260,1447,1348"> |
| <area shape="rect" id="node98" href="../../tables/m_share_product_dividend_pay_out.html" target="_top" title="m_share_product_dividend_pay_out" alt="" coords="1693,1365,2029,1453"> |
| <area shape="rect" id="node99" href="../../tables/m_staff_assignment_history.html" target="_top" title="m_staff_assignment_history" alt="" coords="1722,6027,2001,6115"> |
| <area shape="rect" id="node100" href="../../tables/m_survey_scorecards.html" target="_top" title="m_survey_scorecards" alt="" coords="2973,1159,3208,1247"> |
| <area shape="rect" id="node101" href="../../tables/m_tax_component.html" target="_top" title="m_tax_component" alt="" coords="1757,1260,1966,1348"> |
| <area shape="rect" id="node102" href="../../tables/m_tax_component_history.html" target="_top" title="m_tax_component_history" alt="" coords="2103,1417,2369,1505"> |
| <area shape="rect" id="node103" href="../../tables/m_tax_group_mappings.html" target="_top" title="m_tax_group_mappings" alt="" coords="2111,1233,2361,1321"> |
| <area shape="rect" id="node104" href="../../tables/notification_mapper.html" target="_top" title="notification_mapper" alt="" coords="1234,676,1455,764"> |
| <area shape="rect" id="node105" href="../../tables/request_audit_table.html" target="_top" title="request_audit_table" alt="" coords="2981,4948,3200,5036"> |
| <area shape="rect" id="node106" href="../../tables/scheduled_email_messages_outbound.html" target="_top" title="scheduled_email_messages_outbound" alt="" coords="2915,6148,3267,6236"> |
| <area shape="rect" id="node107" href="../../tables/sms_messages_outbound.html" target="_top" title="sms_messages_outbound" alt="" coords="2959,6043,3223,6131"> |
| <area shape="rect" id="node108" href="../../tables/topic_subscriber.html" target="_top" title="topic_subscriber" alt="" coords="1245,781,1444,869"> |
| <area shape="rect" id="node109" href="../../tables/twofactor_access_token.html" target="_top" title="twofactor_access_token" alt="" coords="1220,2472,1469,2560"> |
| </map> |
| <a name='diagram'><object type="image/svg+xml" id="twodegreesDegreeImg" data="../diagrams/tables/m_loan.2degrees.svg" class="diagram" border="0" align="left"></object></a> |
| </div> |
| </div> |
| </div> |
| </div><!-- /.box-body --> |
| </div> |
| </section> |
| <script> |
| var config = { |
| pagination: true |
| } |
| </script> |
| </div> |
| <!-- /.content-wrapper --> |
| <footer class="main-footer"> |
| <div> |
| <div class="pull-right hidden-xs"> |
| <a href="https://github.com/schemaspy/schemaspy" title="GitHub for SchemaSpy"><i class="fa fa-github-square fa-2x"></i></a> |
| <a href="http://stackoverflow.com/questions/tagged/schemaspy" title="StackOverflow for SchemaSpy"><i class="fa fa-stack-overflow fa-2x"></i></a> |
| </div> |
| <strong>Generated by <a href="http://schemaspy.org/" class="logo-text"><i class="fa fa-database"></i> SchemaSpy 6.1.0</a></strong> |
| </div> |
| <!-- /.container --> |
| </footer> |
| </div> |
| <!-- ./wrapper --> |
| |
| <!-- jQuery 2.2.3 --> |
| <script src="../bower/admin-lte/plugins/jQuery/jquery-2.2.3.min.js"></script> |
| <script src="../bower/admin-lte/plugins/jQueryUI/jquery-ui.min.js"></script> |
| <!-- Bootstrap 3.3.5 --> |
| <script src="../bower/admin-lte/bootstrap/js/bootstrap.min.js"></script> |
| <!-- DataTables --> |
| <script src="../bower/datatables.net/jquery.dataTables.min.js"></script> |
| <script src="../bower/datatables.net-bs/js/dataTables.bootstrap.min.js"></script> |
| <script src="../bower/datatables.net-buttons/dataTables.buttons.min.js"></script> |
| <script src="../bower/datatables.net-buttons-bs/js/buttons.bootstrap.min.js"></script> |
| <script src="../bower/datatables.net-buttons/buttons.html5.min.js"></script> |
| <script src="../bower/datatables.net-buttons/buttons.print.min.js"></script> |
| <script src="../bower/datatables.net-buttons/buttons.colVis.min.js"></script> |
| <!-- SheetJS --> |
| <script src="../bower/js-xlsx/xlsx.full.min.js"></script> |
| <!-- pdfmake --> |
| <script src="../bower/pdfmake/pdfmake.min.js"></script> |
| <script src="../bower/pdfmake/vfs_fonts.js"></script> |
| <!-- SlimScroll --> |
| <script src="../bower/admin-lte/plugins/slimScroll/jquery.slimscroll.min.js"></script> |
| <!-- FastClick --> |
| <script src="../bower/admin-lte/plugins/fastclick/fastclick.js"></script> |
| <!-- Salvattore --> |
| <script src="../bower/salvattore/salvattore.min.js"></script> |
| <!-- AnchorJS --> |
| <script src="../bower/anchor-js/anchor.min.js"></script> |
| <!-- CodeMirror --> |
| <script src="../bower/codemirror/codemirror.js"></script> |
| <script src="../bower/codemirror/sql.js"></script> |
| <!-- AdminLTE App --> |
| <script src="../bower/admin-lte/dist/js/app.min.js"></script> |
| <script src="table.js"></script> |
| <script src="../schemaSpy.js"></script> |
| </body> |
| </html> |
