| <!DOCTYPE html> |
| <html> |
| <head> |
| <meta charset="utf-8"> |
| <meta http-equiv="X-UA-Compatible" content="IE=edge"> |
| <title>m_product_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_product_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_creditbureau_loanproduct_mapping.loan_product_id references m_product_loan.id via fk_cb_lp2"><a href='m_creditbureau_loanproduct_mapping.html'>m_creditbureau_loanproduct_mapping</a><span class='relatedKey'>.loan_product_id</span></td> |
| <td class="constraint detail">fk_cb_lp2<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan.product_id references m_product_loan.id via FKB6F935D8C8D4B434"><a href='m_loan.html'>m_loan</a><span class='relatedKey'>.product_id</span></td> |
| <td class="constraint detail">FKB6F935D8C8D4B434<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loanproduct_provisioning_entry.product_id references m_product_loan.id via m_loanproduct_provisioning_entry_ibfk_4"><a href='m_loanproduct_provisioning_entry.html'>m_loanproduct_provisioning_entry</a><span class='relatedKey'>.product_id</span></td> |
| <td class="constraint detail">m_loanproduct_provisioning_entry_ibfk_4<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loanproduct_provisioning_mapping.product_id references m_product_loan.id via m_loanproduct_provisioning_mapping_ibfk_1"><a href='m_loanproduct_provisioning_mapping.html'>m_loanproduct_provisioning_mapping</a><span class='relatedKey'>.product_id</span></td> |
| <td class="constraint detail">m_loanproduct_provisioning_mapping_ibfk_1<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_product_loan_charge.product_loan_id references m_product_loan.id via m_product_loan_charge_ibfk_2"><a href='m_product_loan_charge.html'>m_product_loan_charge</a><span class='relatedKey'>.product_loan_id</span></td> |
| <td class="constraint detail">m_product_loan_charge_ibfk_2<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_product_loan_configurable_attributes.loan_product_id references m_product_loan.id via fk_m_product_loan_configurable_attributes_0001"><a href='m_product_loan_configurable_attributes.html'>m_product_loan_configurable_attributes</a><span class='relatedKey'>.loan_product_id</span></td> |
| <td class="constraint detail">fk_m_product_loan_configurable_attributes_0001<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_product_loan_floating_rates.loan_product_id references m_product_loan.id via FK_mappings_m_product_loan_id"><a href='m_product_loan_floating_rates.html'>m_product_loan_floating_rates</a><span class='relatedKey'>.loan_product_id</span></td> |
| <td class="constraint detail">FK_mappings_m_product_loan_id<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_product_loan_guarantee_details.loan_product_id references m_product_loan.id via FK_guarantee_details_loan_product"><a href='m_product_loan_guarantee_details.html'>m_product_loan_guarantee_details</a><span class='relatedKey'>.loan_product_id</span></td> |
| <td class="constraint detail">FK_guarantee_details_loan_product<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_product_loan_rate.product_loan_id references m_product_loan.id via FK_M_PRODUCT_LOAN_RATE_LOAN"><a href='m_product_loan_rate.html'>m_product_loan_rate</a><span class='relatedKey'>.product_loan_id</span></td> |
| <td class="constraint detail">FK_M_PRODUCT_LOAN_RATE_LOAN<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_product_loan_recalculation_details.product_id references m_product_loan.id via FK_m_product_loan_m_product_loan_recalculation_details"><a href='m_product_loan_recalculation_details.html'>m_product_loan_recalculation_details</a><span class='relatedKey'>.product_id</span></td> |
| <td class="constraint detail">FK_m_product_loan_m_product_loan_recalculation_details<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_product_loan_variable_installment_config.loan_product_id references m_product_loan.id via FK_mappings_m_variable_product_loan_id"><a href='m_product_loan_variable_installment_config.html'>m_product_loan_variable_installment_config</a><span class='relatedKey'>.loan_product_id</span></td> |
| <td class="constraint detail">FK_mappings_m_variable_product_loan_id<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_product_loan_variations_borrower_cycle.loan_product_id references m_product_loan.id via borrower_cycle_loan_product_FK"><a href='m_product_loan_variations_borrower_cycle.html'>m_product_loan_variations_borrower_cycle</a><span class='relatedKey'>.loan_product_id</span></td> |
| <td class="constraint detail">borrower_cycle_loan_product_FK<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_product_mix.product_id references m_product_loan.id via FK_m_product_mix_product_id_to_m_product_loan"><a href='m_product_mix.html'>m_product_mix</a><span class='relatedKey'>.product_id</span></td> |
| <td class="constraint detail">FK_m_product_mix_product_id_to_m_product_loan<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_product_mix.restricted_product_id references m_product_loan.id via FK_m_product_mix_restricted_product_id_to_m_product_loan"><a href='m_product_mix.html'>m_product_mix</a><span class='relatedKey'>.restricted_product_id</span></td> |
| <td class="constraint detail">FK_m_product_mix_restricted_product_id_to_m_product_loan<span title='Restrict delete: Parent cannot be deleted if children exist'>R</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="short_name">short_name</span></td> |
| <td>VARCHAR</td> |
| <td>4</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">principal_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="min_principal_amount">min_principal_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_principal_amount">max_principal_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="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 class='indexedColumn' title='Indexed'><i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'></i><span id="name">name</span></td> |
| <td>VARCHAR</td> |
| <td>100</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="description">description</span></td> |
| <td>VARCHAR</td> |
| <td>500</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="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_product_loan.fund_id references m_fund.id via FKA6A8A7D77240145"><a href='m_fund.html'>m_fund</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FKA6A8A7D77240145<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="is_linked_to_floating_interest_rates">is_linked_to_floating_interest_rates</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="allow_variabe_installments">allow_variabe_installments</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="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="min_nominal_interest_rate_per_period">min_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="max_nominal_interest_rate_per_period">max_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="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="min_number_of_repayments">min_number_of_repayments</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="max_number_of_repayments">max_number_of_repayments</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_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="accounting_type">accounting_type</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 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_product_loan.loan_transaction_strategy_id references ref_loan_transaction_processing_strategy.id via FK_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_ltp_strategy<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </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><span id="include_in_borrower_cycle">include_in_borrower_cycle</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="use_borrower_cycle">use_borrower_cycle</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="start_date">start_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="close_date">close_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="allow_multiple_disbursals">allow_multiple_disbursals</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="max_disbursals">max_disbursals</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'> |
| </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="overdue_days_for_npa">overdue_days_for_npa</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="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="min_days_between_disbursal_and_first_repayment">min_days_between_disbursal_and_first_repayment</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'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="hold_guarantee_funds">hold_guarantee_funds</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="principal_threshold_for_last_installment">principal_threshold_for_last_installment</span></td> |
| <td>DECIMAL</td> |
| <td>5,2</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>50.00</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="account_moves_out_of_npa_only_on_arrears_completion">account_moves_out_of_npa_only_on_arrears_completion</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="can_define_fixed_emi_amount">can_define_fixed_emi_amount</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="instalment_amount_in_multiples_of">instalment_amount_in_multiples_of</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="can_use_for_topup">can_use_for_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="sync_expected_with_disbursement_date">sync_expected_with_disbursement_date</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="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> |
| <tr> |
| <td><span id="disallow_expected_disbursements">disallow_expected_disbursements</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="allow_approved_disbursed_amounts_over_applied">allow_approved_disbursed_amounts_over_applied</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="over_applied_calculation_type">over_applied_calculation_type</span></td> |
| <td>VARCHAR</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="over_applied_number">over_applied_number</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'> |
| </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> external_id</td> |
| <td>Must be unique</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>external_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FK_ltp_strategy</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>loan_transaction_strategy_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FKA6A8A7D77240145</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>fund_id</td> |
| </tr> |
| <tr> |
| <td class='uniqueKey' title='Unique Key'><i class='icon ion-key iconkey'></i> name</td> |
| <td>Must be unique</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>name</td> |
| </tr> |
| <tr> |
| <td class='uniqueKey' title='Unique Key'><i class='icon ion-key iconkey'></i> short_name</td> |
| <td>Must be unique</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>short_name</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/m_creditbureau_loanproduct_mapping.html" target="_top" title="m_creditbureau_loanproduct_mapping" alt="" coords="1199,639,1592,815"> |
| <area shape="rect" id="node2" href="../../tables/m_product_loan.html" target="_top" title="m_product_loan" alt="" coords="472,1591,1121,3449"> |
| <area shape="rect" id="node4" href="../../tables/m_fund.html" target="_top" title="m_fund" alt="" coords="142,1251,291,1403"> |
| <area shape="rect" id="node5" href="../../tables/ref_loan_transaction_processing_strategy.html" target="_top" title="ref_loan_transaction_processing_strategy" alt="" coords="5,1991,428,2137"> |
| <area shape="rect" id="node3" href="../../tables/m_loan.html" target="_top" title="m_loan" alt="" coords="1166,5,1625,621"> |
| <area shape="rect" id="node6" href="../../tables/m_loanproduct_provisioning_entry.html" target="_top" title="m_loanproduct_provisioning_entry" alt="" coords="1216,832,1575,1155"> |
| <area shape="rect" id="node7" href="../../tables/m_loanproduct_provisioning_mapping.html" target="_top" title="m_loanproduct_provisioning_mapping" alt="" coords="1201,1172,1590,1324"> |
| <area shape="rect" id="node8" href="../../tables/m_product_loan_charge.html" target="_top" title="m_product_loan_charge" alt="" coords="1265,1341,1525,1464"> |
| <area shape="rect" id="node9" href="../../tables/m_product_loan_configurable_attributes.html" target="_top" title="m_product_loan_configurable_attributes" alt="" coords="1190,1481,1601,1628"> |
| <area shape="rect" id="node10" href="../../tables/m_product_loan_floating_rates.html" target="_top" title="m_product_loan_floating_rates" alt="" coords="1170,1645,1621,1821"> |
| <area shape="rect" id="node11" href="../../tables/m_product_loan_guarantee_details.html" target="_top" title="m_product_loan_guarantee_details" alt="" coords="1175,1839,1616,1985"> |
| <area shape="rect" id="node12" href="../../tables/m_product_loan_rate.html" target="_top" title="m_product_loan_rate" alt="" coords="1277,2003,1513,2125"> |
| <area shape="rect" id="node13" href="../../tables/m_product_loan_recalculation_details.html" target="_top" title="m_product_loan_recalculation_details" alt="" coords="1165,2143,1625,2289"> |
| <area shape="rect" id="node14" href="../../tables/m_product_loan_variable_installment_config.html" target="_top" title="m_product_loan_variable_installment_config" alt="" coords="1173,2307,1618,2453"> |
| <area shape="rect" id="node15" href="../../tables/m_product_loan_variations_borrower_cycle.html" target="_top" title="m_product_loan_variations_borrower_cycle" alt="" coords="1179,2471,1612,2617"> |
| <area shape="rect" id="node16" href="../../tables/m_product_mix.html" target="_top" title="m_product_mix" alt="" coords="1275,2635,1515,2787"> |
| </map> |
| <a name='diagram'><object type="image/svg+xml" id="oneDegreeImg" data="../diagrams/tables/m_product_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="1113,2452,1302,2540"> |
| <area shape="rect" id="node2" href="../../tables/m_code_value.html" target="_top" title="m_code_value" alt="" coords="191,2973,372,3061"> |
| <area shape="rect" id="node3" href="../../tables/glim_accounts.html" target="_top" title="glim_accounts" alt="" coords="1116,3024,1299,3112"> |
| <area shape="rect" id="node4" href="../../tables/m_group.html" target="_top" title="m_group" alt="" coords="555,3079,699,3167"> |
| <area shape="rect" id="node8" href="../../tables/m_office.html" target="_top" title="m_office" alt="" coords="5,3079,147,3167"> |
| <area shape="rect" id="node10" href="../../tables/m_staff.html" target="_top" title="m_staff" alt="" coords="211,3185,351,3273"> |
| <area shape="rect" id="node5" href="../../tables/m_account_transfer_details.html" target="_top" title="m_account_transfer_details" alt="" coords="2137,4032,2412,4120"> |
| <area shape="rect" id="node6" href="../../tables/m_client.html" target="_top" title="m_client" alt="" coords="553,2973,701,3061"> |
| <area shape="rect" id="node7" href="../../tables/m_loan.html" target="_top" title="m_loan" alt="" coords="1577,2888,2035,3504"> |
| <area shape="rect" id="node9" href="../../tables/m_appuser.html" target="_top" title="m_appuser" alt="" coords="1128,3237,1287,3325"> |
| <area shape="rect" id="node13" href="../../tables/m_product_loan.html" target="_top" title="m_product_loan" alt="" coords="883,576,1532,2435"> |
| <area shape="rect" id="node16" href="../../tables/m_fund.html" target="_top" title="m_fund" alt="" coords="553,2525,702,2677"> |
| <area shape="rect" id="node17" href="../../tables/ref_loan_transaction_processing_strategy.html" target="_top" title="ref_loan_transaction_processing_strategy" alt="" coords="416,2769,839,2916"> |
| <area shape="rect" id="node11" href="../../tables/m_charge.html" target="_top" title="m_charge" alt="" coords="1731,2433,1881,2521"> |
| <area shape="rect" id="node12" href="../../tables/m_creditbureau_loanproduct_mapping.html" target="_top" title="m_creditbureau_loanproduct_mapping" alt="" coords="1609,196,2003,372"> |
| <area shape="rect" id="node14" href="../../tables/m_organisation_creditbureau.html" target="_top" title="m_organisation_creditbureau" alt="" coords="1064,228,1351,316"> |
| <area shape="rect" id="node15" href="../../tables/m_guarantor.html" target="_top" title="m_guarantor" alt="" coords="2189,2309,2360,2397"> |
| <area shape="rect" id="node18" href="../../tables/m_loan_arrears_aging.html" target="_top" title="m_loan_arrears_aging" alt="" coords="2156,3276,2393,3364"> |
| <area shape="rect" id="node19" href="../../tables/m_loan_charge.html" target="_top" title="m_loan_charge" alt="" coords="2181,2415,2369,2503"> |
| <area shape="rect" id="node20" href="../../tables/m_loan_collateral.html" target="_top" title="m_loan_collateral" alt="" coords="2173,2625,2377,2713"> |
| <area shape="rect" id="node21" href="../../tables/m_loan_collateral_management.html" target="_top" title="m_loan_collateral_management" alt="" coords="2541,2144,2842,2232"> |
| <area shape="rect" id="node22" href="../../tables/m_loan_transaction.html" target="_top" title="m_loan_transaction" alt="" coords="2165,1992,2384,2080"> |
| <area shape="rect" id="node23" href="../../tables/m_loan_disbursement_detail.html" target="_top" title="m_loan_disbursement_detail" alt="" coords="2134,3381,2415,3469"> |
| <area shape="rect" id="node24" href="../../tables/m_loan_officer_assignment_history.html" target="_top" title="m_loan_officer_assignment_history" alt="" coords="2109,3927,2440,4015"> |
| <area shape="rect" id="node25" href="../../tables/m_loan_paid_in_advance.html" target="_top" title="m_loan_paid_in_advance" alt="" coords="2146,3575,2403,3663"> |
| <area shape="rect" id="node26" href="../../tables/m_loan_rate.html" target="_top" title="m_loan_rate" alt="" coords="2191,2783,2358,2871"> |
| <area shape="rect" id="node27" href="../../tables/m_rate.html" target="_top" title="m_rate" alt="" coords="1740,2783,1872,2871"> |
| <area shape="rect" id="node28" href="../../tables/m_loan_recalculation_details.html" target="_top" title="m_loan_recalculation_details" alt="" coords="2133,2960,2417,3048"> |
| <area shape="rect" id="node29" href="../../tables/m_loan_repayment_schedule.html" target="_top" title="m_loan_repayment_schedule" alt="" coords="2132,3680,2417,3768"> |
| <area shape="rect" id="node30" href="../../tables/m_loan_repayment_schedule_history.html" target="_top" title="m_loan_repayment_schedule_history" alt="" coords="2521,3583,2862,3671"> |
| <area shape="rect" id="node31" href="../../tables/m_loan_reschedule_request.html" target="_top" title="m_loan_reschedule_request" alt="" coords="2136,3821,2413,3909"> |
| <area shape="rect" id="node32" href="../../tables/m_loan_term_variations.html" target="_top" title="m_loan_term_variations" alt="" coords="2150,3065,2399,3153"> |
| <area shape="rect" id="node33" href="../../tables/m_loan_topup.html" target="_top" title="m_loan_topup" alt="" coords="2601,3457,2782,3545"> |
| <area shape="rect" id="node34" href="../../tables/m_loan_tranche_charges.html" target="_top" title="m_loan_tranche_charges" alt="" coords="2146,2520,2403,2608"> |
| <area shape="rect" id="node35" href="../../tables/m_loanproduct_provisioning_entry.html" target="_top" title="m_loanproduct_provisioning_entry" alt="" coords="2095,1343,2454,1665"> |
| <area shape="rect" id="node36" href="../../tables/m_provision_category.html" target="_top" title="m_provision_category" alt="" coords="1687,1785,1925,1873"> |
| <area shape="rect" id="node37" href="../../tables/m_provisioning_criteria.html" target="_top" title="m_provisioning_criteria" alt="" coords="1683,2279,1929,2367"> |
| <area shape="rect" id="node38" href="../../tables/m_provisioning_history.html" target="_top" title="m_provisioning_history" alt="" coords="1683,1680,1929,1768"> |
| <area shape="rect" id="node39" href="../../tables/m_loanproduct_provisioning_mapping.html" target="_top" title="m_loanproduct_provisioning_mapping" alt="" coords="2080,1683,2469,1835"> |
| <area shape="rect" id="node40" href="../../tables/m_note.html" target="_top" title="m_note" alt="" coords="2625,2400,2758,2488"> |
| <area shape="rect" id="node41" href="../../tables/m_portfolio_account_associations.html" target="_top" title="m_portfolio_account_associations" alt="" coords="2114,3171,2435,3259"> |
| <area shape="rect" id="node42" href="../../tables/m_product_loan_charge.html" target="_top" title="m_product_loan_charge" alt="" coords="2145,1852,2405,1975"> |
| <area shape="rect" id="node43" href="../../tables/m_product_loan_configurable_attributes.html" target="_top" title="m_product_loan_configurable_attributes" alt="" coords="1601,1152,2011,1299"> |
| <area shape="rect" id="node44" href="../../tables/m_product_loan_floating_rates.html" target="_top" title="m_product_loan_floating_rates" alt="" coords="1581,389,2031,565"> |
| <area shape="rect" id="node45" href="../../tables/m_floating_rates.html" target="_top" title="m_floating_rates" alt="" coords="1109,451,1306,539"> |
| <area shape="rect" id="node46" href="../../tables/m_product_loan_guarantee_details.html" target="_top" title="m_product_loan_guarantee_details" alt="" coords="1585,1316,2027,1463"> |
| <area shape="rect" id="node47" href="../../tables/m_product_loan_rate.html" target="_top" title="m_product_loan_rate" alt="" coords="2157,2169,2393,2292"> |
| <area shape="rect" id="node48" href="../../tables/m_product_loan_recalculation_details.html" target="_top" title="m_product_loan_recalculation_details" alt="" coords="1576,1480,2036,1627"> |
| <area shape="rect" id="node49" href="../../tables/m_product_loan_variable_installment_config.html" target="_top" title="m_product_loan_variable_installment_config" alt="" coords="1583,655,2029,801"> |
| <area shape="rect" id="node50" href="../../tables/m_product_loan_variations_borrower_cycle.html" target="_top" title="m_product_loan_variations_borrower_cycle" alt="" coords="1589,819,2023,965"> |
| <area shape="rect" id="node51" href="../../tables/m_product_mix.html" target="_top" title="m_product_mix" alt="" coords="1686,983,1926,1135"> |
| <area shape="rect" id="node52" href="../../tables/m_repayment_with_post_dated_checks.html" target="_top" title="m_repayment_with_post_dated_checks" alt="" coords="2513,3728,2869,3816"> |
| </map> |
| <a name='diagram'><object type="image/svg+xml" id="twodegreesDegreeImg" data="../diagrams/tables/m_product_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> |