| <!DOCTYPE html> |
| <html> |
| <head> |
| <meta charset="utf-8"> |
| <meta http-equiv="X-UA-Compatible" content="IE=edge"> |
| <title>m_savings_account - 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_savings_account</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="interop_identifier.account_id references m_savings_account.id via fk_interop_identifier_account"><a href='interop_identifier.html'>interop_identifier</a><span class='relatedKey'>.account_id</span></td> |
| <td class="constraint detail">fk_interop_identifier_account<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_account_transfer_details.from_savings_account_id references m_savings_account.id via FK_m_account_transfer_details_from_savings_account"><a href='m_account_transfer_details.html'>m_account_transfer_details</a><span class='relatedKey'>.from_savings_account_id</span></td> |
| <td class="constraint detail">FK_m_account_transfer_details_from_savings_account<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_account_transfer_details.to_savings_account_id references m_savings_account.id via FK_m_account_transfer_details_to_savings_account"><a href='m_account_transfer_details.html'>m_account_transfer_details</a><span class='relatedKey'>.to_savings_account_id</span></td> |
| <td class="constraint detail">FK_m_account_transfer_details_to_savings_account<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_client.default_savings_account references m_savings_account.id via FK_m_client_m_savings_account"><a href='m_client.html'>m_client</a><span class='relatedKey'>.default_savings_account</span></td> |
| <td class="constraint detail">FK_m_client_m_savings_account<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_deposit_account_on_hold_transaction.savings_account_id references m_savings_account.id via FK_deposit_on_hold_transaction_m_savings_account"><a href='m_deposit_account_on_hold_transaction.html'>m_deposit_account_on_hold_transaction</a><span class='relatedKey'>.savings_account_id</span></td> |
| <td class="constraint detail">FK_deposit_on_hold_transaction_m_savings_account<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_deposit_account_recurring_detail.savings_account_id references m_savings_account.id via FKDARD00000000000001"><a href='m_deposit_account_recurring_detail.html'>m_deposit_account_recurring_detail</a><span class='relatedKey'>.savings_account_id</span></td> |
| <td class="constraint detail">FKDARD00000000000001<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_deposit_account_term_and_preclosure.savings_account_id references m_savings_account.id via FKDATP00000000000001"><a href='m_deposit_account_term_and_preclosure.html'>m_deposit_account_term_and_preclosure</a><span class='relatedKey'>.savings_account_id</span></td> |
| <td class="constraint detail">FKDATP00000000000001<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_deposit_account_term_and_preclosure.transfer_to_savings_account_id references m_savings_account.id via m_deposit_account_term_and_preclosure_ibfk_1"><a href='m_deposit_account_term_and_preclosure.html'>m_deposit_account_term_and_preclosure</a><span class='relatedKey'>.transfer_to_savings_account_id</span></td> |
| <td class="constraint detail">m_deposit_account_term_and_preclosure_ibfk_1<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_mandatory_savings_schedule.savings_account_id references m_savings_account.id via FKMSS0000000001"><a href='m_mandatory_savings_schedule.html'>m_mandatory_savings_schedule</a><span class='relatedKey'>.savings_account_id</span></td> |
| <td class="constraint detail">FKMSS0000000001<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_note.savings_account_id references m_savings_account.id via FK_savings_account_id"><a href='m_note.html'>m_note</a><span class='relatedKey'>.savings_account_id</span></td> |
| <td class="constraint detail">FK_savings_account_id<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_portfolio_account_associations.linked_savings_account_id references m_savings_account.id via linked_savings_fk"><a href='m_portfolio_account_associations.html'>m_portfolio_account_associations</a><span class='relatedKey'>.linked_savings_account_id</span></td> |
| <td class="constraint detail">linked_savings_fk<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_portfolio_account_associations.savings_account_id references m_savings_account.id via account_association_savings_fk"><a href='m_portfolio_account_associations.html'>m_portfolio_account_associations</a><span class='relatedKey'>.savings_account_id</span></td> |
| <td class="constraint detail">account_association_savings_fk<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_savings_account_charge.savings_account_id references m_savings_account.id via m_savings_account_charge_ibfk_2"><a href='m_savings_account_charge.html'>m_savings_account_charge</a><span class='relatedKey'>.savings_account_id</span></td> |
| <td class="constraint detail">m_savings_account_charge_ibfk_2<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_savings_account_interest_rate_chart.savings_account_id references m_savings_account.id via FKSAIRC00000000000001"><a href='m_savings_account_interest_rate_chart.html'>m_savings_account_interest_rate_chart</a><span class='relatedKey'>.savings_account_id</span></td> |
| <td class="constraint detail">FKSAIRC00000000000001<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_savings_account_transaction.savings_account_id references m_savings_account.id via FKSAT0000000001"><a href='m_savings_account_transaction.html'>m_savings_account_transaction</a><span class='relatedKey'>.savings_account_id</span></td> |
| <td class="constraint detail">FKSAT0000000001<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_savings_officer_assignment_history.account_id references m_savings_account.id via fk_m_savings_officer_assignment_history_0001"><a href='m_savings_officer_assignment_history.html'>m_savings_officer_assignment_history</a><span class='relatedKey'>.account_id</span></td> |
| <td class="constraint detail">fk_m_savings_officer_assignment_history_0001<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_share_account.savings_account_id references m_savings_account.id via m_share_account_ibfk_2"><a href='m_share_account.html'>m_share_account</a><span class='relatedKey'>.savings_account_id</span></td> |
| <td class="constraint detail">m_share_account_ibfk_2<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="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_savings_account.client_id references m_client.id via FKSA00000000000001"><a href='m_client.html'>m_client</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FKSA00000000000001<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_savings_account.group_id references m_group.id via FKSA00000000000002"><a href='m_group.html'>m_group</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FKSA00000000000002<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="gsim_id">gsim_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_savings_account.gsim_id references gsim_accounts.id via FK_gsim_id"><a href='gsim_accounts.html'>gsim_accounts</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FK_gsim_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_savings_account.product_id references m_savings_product.id via FKSA00000000000003"><a href='m_savings_product.html'>m_savings_product</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FKSA00000000000003<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="field_officer_id">field_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'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="status_enum">status_enum</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>300</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="sub_status_enum">sub_status_enum</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="account_type_enum">account_type_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="deposit_type_enum">deposit_type_enum</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>100</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=''></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_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'> |
| </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><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'> |
| </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><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'> |
| </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><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'> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="activatedon_date">activatedon_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="activatedon_userid">activatedon_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="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><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'> |
| </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="nominal_annual_interest_rate">nominal_annual_interest_rate</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="interest_compounding_period_enum">interest_compounding_period_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_posting_period_enum">interest_posting_period_enum</span></td> |
| <td>SMALLINT</td> |
| <td>5</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>4</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_calculation_type_enum">interest_calculation_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="interest_calculation_days_in_year_type_enum">interest_calculation_days_in_year_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="min_required_opening_balance">min_required_opening_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="lockin_period_frequency">lockin_period_frequency</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="lockin_period_frequency_enum">lockin_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="withdrawal_fee_for_transfer">withdrawal_fee_for_transfer</span></td> |
| <td>BIT</td> |
| <td>1</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>b'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_overdraft">allow_overdraft</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="overdraft_limit">overdraft_limit</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="nominal_annual_interest_rate_overdraft">nominal_annual_interest_rate_overdraft</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="min_overdraft_for_interest_calculation">min_overdraft_for_interest_calculation</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="lockedin_until_date_derived">lockedin_until_date_derived</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="total_deposits_derived">total_deposits_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="total_withdrawals_derived">total_withdrawals_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="total_withdrawal_fees_derived">total_withdrawal_fees_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="total_fees_charge_derived">total_fees_charge_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="total_penalty_charge_derived">total_penalty_charge_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="total_annual_fees_derived">total_annual_fees_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="total_interest_earned_derived">total_interest_earned_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="total_interest_posted_derived">total_interest_posted_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="total_overdraft_interest_derived">total_overdraft_interest_derived</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="total_withhold_tax_derived">total_withhold_tax_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="account_balance_derived">account_balance_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="min_required_balance">min_required_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="enforce_min_required_balance">enforce_min_required_balance</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_balance_for_interest_calculation">min_balance_for_interest_calculation</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="start_interest_calculation_date">start_interest_calculation_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="on_hold_funds_derived">on_hold_funds_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="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><span id="withhold_tax">withhold_tax</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 class='foreignKey' title='Foreign Key'><i class='icon ion-key iconkey' style='padding-left: 5px;'></i><span id="tax_group_id">tax_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_savings_account.tax_group_id references m_tax_group.id via FK_savings_account_tax_group"><a href='m_tax_group.html'>m_tax_group</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FK_savings_account_tax_group<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| </table> |
| </td> |
| <td></td> |
| </tr> |
| <tr> |
| <td><span id="last_interest_calculation_date">last_interest_calculation_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="total_savings_amount_on_hold">total_savings_amount_on_hold</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_posted_till_date">interest_posted_till_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="reason_for_block">reason_for_block</span></td> |
| <td>VARCHAR</td> |
| <td>256</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_allowed_lien_limit">max_allowed_lien_limit</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_lien_allowed">is_lien_allowed</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> |
| </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'>FK_gsim_id</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>gsim_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FK_savings_account_tax_group</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>tax_group_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FKSA00000000000001</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>client_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FKSA00000000000002</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>group_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FKSA00000000000003</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>product_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/gsim_accounts.html" target="_top" title="gsim_accounts" alt="" coords="779,1553,1019,1729"> |
| <area shape="rect" id="node2" href="../../tables/m_group.html" target="_top" title="m_group" alt="" coords="370,1408,606,1731"> |
| <area shape="rect" id="node3" href="../../tables/interop_identifier.html" target="_top" title="interop_identifier" alt="" coords="1793,1752,2006,1987"> |
| <area shape="rect" id="node4" href="../../tables/m_savings_account.html" target="_top" title="m_savings_account" alt="" coords="1083,1459,1637,3464"> |
| <area shape="rect" id="node6" href="../../tables/m_client.html" target="_top" title="m_client" alt="" coords="760,803,1039,1389"> |
| <area shape="rect" id="node7" href="../../tables/m_savings_product.html" target="_top" title="m_savings_product" alt="" coords="260,1748,716,1953"> |
| <area shape="rect" id="node14" href="../../tables/m_tax_group.html" target="_top" title="m_tax_group" alt="" coords="5,2188,216,2364"> |
| <area shape="rect" id="node5" href="../../tables/m_account_transfer_details.html" target="_top" title="m_account_transfer_details" alt="" coords="1752,375,2047,727"> |
| <area shape="rect" id="node8" href="../../tables/m_deposit_account_on_hold_transaction.html" target="_top" title="m_deposit_account_on_hold_transaction" alt="" coords="1695,2004,2104,2151"> |
| <area shape="rect" id="node9" href="../../tables/m_deposit_account_recurring_detail.html" target="_top" title="m_deposit_account_recurring_detail" alt="" coords="1681,2168,2117,2315"> |
| <area shape="rect" id="node10" href="../../tables/m_deposit_account_term_and_preclosure.html" target="_top" title="m_deposit_account_term_and_preclosure" alt="" coords="1691,2332,2107,2508"> |
| <area shape="rect" id="node11" href="../../tables/m_mandatory_savings_schedule.html" target="_top" title="m_mandatory_savings_schedule" alt="" coords="1713,2525,2085,2672"> |
| <area shape="rect" id="node12" href="../../tables/m_note.html" target="_top" title="m_note" alt="" coords="1733,5,2065,357"> |
| <area shape="rect" id="node13" href="../../tables/m_portfolio_account_associations.html" target="_top" title="m_portfolio_account_associations" alt="" coords="1724,2689,2075,2924"> |
| <area shape="rect" id="node15" href="../../tables/m_savings_account_charge.html" target="_top" title="m_savings_account_charge" alt="" coords="1744,2941,2055,3117"> |
| <area shape="rect" id="node16" href="../../tables/m_savings_account_interest_rate_chart.html" target="_top" title="m_savings_account_interest_rate_chart" alt="" coords="1699,1143,2100,1289"> |
| <area shape="rect" id="node17" href="../../tables/m_savings_account_transaction.html" target="_top" title="m_savings_account_transaction" alt="" coords="1725,1307,2074,1541"> |
| <area shape="rect" id="node18" href="../../tables/m_savings_officer_assignment_history.html" target="_top" title="m_savings_officer_assignment_history" alt="" coords="1703,1559,2095,1735"> |
| <area shape="rect" id="node19" href="../../tables/m_share_account.html" target="_top" title="m_share_account" alt="" coords="1690,744,2109,1125"> |
| </map> |
| <a name='diagram'><object type="image/svg+xml" id="oneDegreeImg" data="../diagrams/tables/m_savings_account.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_journal_entry.html" target="_top" title="acc_gl_journal_entry" alt="" coords="3461,139,3688,227"> |
| <area shape="rect" id="node2" href="../../tables/m_client_transaction.html" target="_top" title="m_client_transaction" alt="" coords="2560,120,2787,208"> |
| <area shape="rect" id="node3" href="../../tables/m_appuser.html" target="_top" title="m_appuser" alt="" coords="390,2956,549,3044"> |
| <area shape="rect" id="node4" href="../../tables/m_loan_transaction.html" target="_top" title="m_loan_transaction" alt="" coords="3022,335,3241,423"> |
| <area shape="rect" id="node5" href="../../tables/m_office.html" target="_top" title="m_office" alt="" coords="7,3047,148,3135"> |
| <area shape="rect" id="node6" href="../../tables/m_payment_detail.html" target="_top" title="m_payment_detail" alt="" coords="2569,225,2777,313"> |
| <area shape="rect" id="node7" href="../../tables/m_savings_account_transaction.html" target="_top" title="m_savings_account_transaction" alt="" coords="2957,440,3306,675"> |
| <area shape="rect" id="node8" href="../../tables/m_share_account_transactions.html" target="_top" title="m_share_account_transactions" alt="" coords="2981,229,3281,317"> |
| <area shape="rect" id="node10" href="../../tables/m_client.html" target="_top" title="m_client" alt="" coords="2063,3764,2341,4351"> |
| <area shape="rect" id="node20" href="../../tables/m_staff.html" target="_top" title="m_staff" alt="" coords="193,4071,333,4159"> |
| <area shape="rect" id="node17" href="../../tables/m_loan.html" target="_top" title="m_loan" alt="" coords="2599,3300,2747,3388"> |
| <area shape="rect" id="node15" href="../../tables/m_savings_account.html" target="_top" title="m_savings_account" alt="" coords="1385,1151,1940,3156"> |
| <area shape="rect" id="node57" href="../../tables/m_share_account.html" target="_top" title="m_share_account" alt="" coords="2464,367,2883,748"> |
| <area shape="rect" id="node9" href="../../tables/client_device_registration.html" target="_top" title="client_device_registration" alt="" coords="2543,3796,2804,3884"> |
| <area shape="rect" id="node23" href="../../tables/m_code_value.html" target="_top" title="m_code_value" alt="" coords="379,4373,560,4461"> |
| <area shape="rect" id="node24" href="../../tables/m_savings_product.html" target="_top" title="m_savings_product" alt="" coords="885,1043,1341,1248"> |
| <area shape="rect" id="node25" href="../../tables/m_image.html" target="_top" title="m_image" alt="" coords="5,4115,149,4203"> |
| <area shape="rect" id="node11" href="../../tables/glim_accounts.html" target="_top" title="glim_accounts" alt="" coords="1571,3485,1754,3573"> |
| <area shape="rect" id="node12" href="../../tables/m_group.html" target="_top" title="m_group" alt="" coords="605,3623,841,3945"> |
| <area shape="rect" id="node40" href="../../tables/m_group_level.html" target="_top" title="m_group_level" alt="" coords="377,3787,561,3875"> |
| <area shape="rect" id="node13" href="../../tables/gsim_accounts.html" target="_top" title="gsim_accounts" alt="" coords="993,3397,1233,3573"> |
| <area shape="rect" id="node14" href="../../tables/interop_identifier.html" target="_top" title="interop_identifier" alt="" coords="2095,1520,2309,1755"> |
| <area shape="rect" id="node22" href="../../tables/m_tax_group.html" target="_top" title="m_tax_group" alt="" coords="618,2792,829,2968"> |
| <area shape="rect" id="node16" href="../../tables/m_account_transfer_details.html" target="_top" title="m_account_transfer_details" alt="" coords="2984,1676,3279,2028"> |
| <area shape="rect" id="node18" href="../../tables/m_account_transfer_standing_instructions.html" target="_top" title="m_account_transfer_standing_instructions" alt="" coords="3384,1679,3765,1767"> |
| <area shape="rect" id="node19" href="../../tables/m_account_transfer_transaction.html" target="_top" title="m_account_transfer_transaction" alt="" coords="3421,433,3729,521"> |
| <area shape="rect" id="node21" href="../../tables/m_charge.html" target="_top" title="m_charge" alt="" coords="2127,907,2277,995"> |
| <area shape="rect" id="node26" href="../../tables/m_client_address.html" target="_top" title="m_client_address" alt="" coords="2571,4323,2775,4411"> |
| <area shape="rect" id="node27" href="../../tables/m_client_attendance.html" target="_top" title="m_client_attendance" alt="" coords="2561,3901,2786,3989"> |
| <area shape="rect" id="node28" href="../../tables/m_client_charge.html" target="_top" title="m_client_charge" alt="" coords="2575,1244,2771,1332"> |
| <area shape="rect" id="node29" href="../../tables/m_client_collateral_management.html" target="_top" title="m_client_collateral_management" alt="" coords="2519,4007,2828,4095"> |
| <area shape="rect" id="node30" href="../../tables/m_client_identifier.html" target="_top" title="m_client_identifier" alt="" coords="2569,4428,2778,4516"> |
| <area shape="rect" id="node31" href="../../tables/m_client_non_person.html" target="_top" title="m_client_non_person" alt="" coords="2557,4112,2789,4200"> |
| <area shape="rect" id="node32" href="../../tables/m_client_transfer_details.html" target="_top" title="m_client_transfer_details" alt="" coords="2545,3089,2802,3177"> |
| <area shape="rect" id="node33" href="../../tables/m_deposit_account_on_hold_transaction.html" target="_top" title="m_deposit_account_on_hold_transaction" alt="" coords="2927,1067,3336,1213"> |
| <area shape="rect" id="node34" href="../../tables/m_deposit_account_recurring_detail.html" target="_top" title="m_deposit_account_recurring_detail" alt="" coords="1984,1808,2420,1955"> |
| <area shape="rect" id="node35" href="../../tables/m_deposit_account_term_and_preclosure.html" target="_top" title="m_deposit_account_term_and_preclosure" alt="" coords="1994,1972,2410,2148"> |
| <area shape="rect" id="node36" href="../../tables/m_deposit_product_interest_rate_chart.html" target="_top" title="m_deposit_product_interest_rate_chart" alt="" coords="1484,835,1841,923"> |
| <area shape="rect" id="node37" href="../../tables/m_deposit_product_recurring_detail.html" target="_top" title="m_deposit_product_recurring_detail" alt="" coords="1495,940,1831,1028"> |
| <area shape="rect" id="node38" href="../../tables/m_deposit_product_term_and_preclosure.html" target="_top" title="m_deposit_product_term_and_preclosure" alt="" coords="1476,1045,1849,1133"> |
| <area shape="rect" id="node39" href="../../tables/m_family_members.html" target="_top" title="m_family_members" alt="" coords="2565,4885,2782,4973"> |
| <area shape="rect" id="node41" href="../../tables/m_group_client.html" target="_top" title="m_group_client" alt="" coords="2579,3583,2768,3671"> |
| <area shape="rect" id="node42" href="../../tables/m_group_roles.html" target="_top" title="m_group_roles" alt="" coords="2580,4744,2767,4832"> |
| <area shape="rect" id="node43" href="../../tables/m_guarantor_funding_details.html" target="_top" title="m_guarantor_funding_details" alt="" coords="3431,1993,3718,2081"> |
| <area shape="rect" id="node44" href="../../tables/m_portfolio_account_associations.html" target="_top" title="m_portfolio_account_associations" alt="" coords="2956,2201,3307,2436"> |
| <area shape="rect" id="node45" href="../../tables/m_guarantor_transaction.html" target="_top" title="m_guarantor_transaction" alt="" coords="3813,1069,4071,1157"> |
| <area shape="rect" id="node46" href="../../tables/m_loan_topup.html" target="_top" title="m_loan_topup" alt="" coords="3484,3185,3665,3273"> |
| <area shape="rect" id="node47" href="../../tables/m_mandatory_savings_schedule.html" target="_top" title="m_mandatory_savings_schedule" alt="" coords="2016,1156,2388,1303"> |
| <area shape="rect" id="node48" href="../../tables/m_note.html" target="_top" title="m_note" alt="" coords="3409,3291,3741,3643"> |
| <area shape="rect" id="node49" href="../../tables/m_savings_account_charge.html" target="_top" title="m_savings_account_charge" alt="" coords="2518,943,2829,1119"> |
| <area shape="rect" id="node50" href="../../tables/m_savings_account_charge_paid_by.html" target="_top" title="m_savings_account_charge_paid_by" alt="" coords="3405,763,3744,851"> |
| <area shape="rect" id="node51" href="../../tables/m_savings_account_interest_rate_chart.html" target="_top" title="m_savings_account_interest_rate_chart" alt="" coords="2001,1320,2403,1467"> |
| <area shape="rect" id="node52" href="../../tables/m_savings_account_interest_rate_slab.html" target="_top" title="m_savings_account_interest_rate_slab" alt="" coords="2497,1349,2850,1437"> |
| <area shape="rect" id="node53" href="../../tables/m_savings_account_transaction_tax_details.html" target="_top" title="m_savings_account_transaction_tax_details" alt="" coords="3380,539,3769,627"> |
| <area shape="rect" id="node54" href="../../tables/m_savings_officer_assignment_history.html" target="_top" title="m_savings_officer_assignment_history" alt="" coords="2006,4404,2398,4580"> |
| <area shape="rect" id="node55" href="../../tables/m_savings_product_charge.html" target="_top" title="m_savings_product_charge" alt="" coords="2536,765,2811,853"> |
| <area shape="rect" id="node56" href="../../tables/m_selfservice_user_client_mapping.html" target="_top" title="m_selfservice_user_client_mapping" alt="" coords="2508,3195,2839,3283"> |
| <area shape="rect" id="node58" href="../../tables/m_share_product.html" target="_top" title="m_share_product" alt="" coords="621,405,825,493"> |
| <area shape="rect" id="node59" href="../../tables/m_share_account_charge.html" target="_top" title="m_share_account_charge" alt="" coords="3001,833,3262,921"> |
| <area shape="rect" id="node60" href="../../tables/m_share_account_dividend_details.html" target="_top" title="m_share_account_dividend_details" alt="" coords="2968,692,3295,780"> |
| <area shape="rect" id="node61" href="../../tables/m_staff_assignment_history.html" target="_top" title="m_staff_assignment_history" alt="" coords="974,3929,1253,4017"> |
| <area shape="rect" id="node62" href="../../tables/m_survey_scorecards.html" target="_top" title="m_survey_scorecards" alt="" coords="2556,3477,2791,3565"> |
| <area shape="rect" id="node63" href="../../tables/m_tax_group_mappings.html" target="_top" title="m_tax_group_mappings" alt="" coords="989,2944,1238,3032"> |
| <area shape="rect" id="node64" href="../../tables/request_audit_table.html" target="_top" title="request_audit_table" alt="" coords="2564,4217,2783,4305"> |
| <area shape="rect" id="node65" href="../../tables/scheduled_email_messages_outbound.html" target="_top" title="scheduled_email_messages_outbound" alt="" coords="2497,4533,2849,4621"> |
| <area shape="rect" id="node66" href="../../tables/sms_messages_outbound.html" target="_top" title="sms_messages_outbound" alt="" coords="2541,4639,2805,4727"> |
| </map> |
| <a name='diagram'><object type="image/svg+xml" id="twodegreesDegreeImg" data="../diagrams/tables/m_savings_account.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> |
