| <!DOCTYPE html> |
| <html> |
| <head> |
| <meta charset="utf-8"> |
| <meta http-equiv="X-UA-Compatible" content="IE=edge"> |
| <title>m_appuser - 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_appuser</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="acc_gl_closure.createdby_id references m_appuser.id via FK_acc_gl_closure_m_appuser"><a href='acc_gl_closure.html'>acc_gl_closure</a><span class='relatedKey'>.createdby_id</span></td> |
| <td class="constraint detail">FK_acc_gl_closure_m_appuser<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="acc_gl_closure.lastmodifiedby_id references m_appuser.id via FK_acc_gl_closure_m_appuser_2"><a href='acc_gl_closure.html'>acc_gl_closure</a><span class='relatedKey'>.lastmodifiedby_id</span></td> |
| <td class="constraint detail">FK_acc_gl_closure_m_appuser_2<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="acc_gl_journal_entry.createdby_id references m_appuser.id via FK_acc_gl_journal_entry_m_appuser"><a href='acc_gl_journal_entry.html'>acc_gl_journal_entry</a><span class='relatedKey'>.createdby_id</span></td> |
| <td class="constraint detail">FK_acc_gl_journal_entry_m_appuser<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="acc_gl_journal_entry.lastmodifiedby_id references m_appuser.id via FK_acc_gl_journal_entry_m_appuser_2"><a href='acc_gl_journal_entry.html'>acc_gl_journal_entry</a><span class='relatedKey'>.lastmodifiedby_id</span></td> |
| <td class="constraint detail">FK_acc_gl_journal_entry_m_appuser_2<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_adhoc.createdby_id references m_appuser.id via createdby_id"><a href='m_adhoc.html'>m_adhoc</a><span class='relatedKey'>.createdby_id</span></td> |
| <td class="constraint detail">createdby_id<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_adhoc.lastmodifiedby_id references m_appuser.id via lastmodifiedby_id"><a href='m_adhoc.html'>m_adhoc</a><span class='relatedKey'>.lastmodifiedby_id</span></td> |
| <td class="constraint detail">lastmodifiedby_id<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_appuser_previous_password.user_id references m_appuser.id via m_appuser_previous_password_ibfk_1"><a href='m_appuser_previous_password.html'>m_appuser_previous_password</a><span class='relatedKey'>.user_id</span></td> |
| <td class="constraint detail">m_appuser_previous_password_ibfk_1<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_appuser_role.appuser_id references m_appuser.id via FK7662CE59B4100309"><a href='m_appuser_role.html'>m_appuser_role</a><span class='relatedKey'>.appuser_id</span></td> |
| <td class="constraint detail">FK7662CE59B4100309<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_client_transaction.appuser_id references m_appuser.id via FK_m_client_transaction_m_appuser"><a href='m_client_transaction.html'>m_client_transaction</a><span class='relatedKey'>.appuser_id</span></td> |
| <td class="constraint detail">FK_m_client_transaction_m_appuser<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_client_transfer_details.submitted_by references m_appuser.id via FK_m_client_transfer_details_m_appuser"><a href='m_client_transfer_details.html'>m_client_transfer_details</a><span class='relatedKey'>.submitted_by</span></td> |
| <td class="constraint detail">FK_m_client_transfer_details_m_appuser<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_import_document.createdby_id references m_appuser.id via FK_m_import_m_appuser"><a href='m_import_document.html'>m_import_document</a><span class='relatedKey'>.createdby_id</span></td> |
| <td class="constraint detail">FK_m_import_m_appuser<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan.approvedon_userid references m_appuser.id via FK_approvedon_userid"><a href='m_loan.html'>m_loan</a><span class='relatedKey'>.approvedon_userid</span></td> |
| <td class="constraint detail">FK_approvedon_userid<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan.closedon_userid references m_appuser.id via FK_closedon_userid"><a href='m_loan.html'>m_loan</a><span class='relatedKey'>.closedon_userid</span></td> |
| <td class="constraint detail">FK_closedon_userid<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan.disbursedon_userid references m_appuser.id via FK_disbursedon_userid"><a href='m_loan.html'>m_loan</a><span class='relatedKey'>.disbursedon_userid</span></td> |
| <td class="constraint detail">FK_disbursedon_userid<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan.rejectedon_userid references m_appuser.id via FK_rejectedon_userid"><a href='m_loan.html'>m_loan</a><span class='relatedKey'>.rejectedon_userid</span></td> |
| <td class="constraint detail">FK_rejectedon_userid<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan.submittedon_userid references m_appuser.id via FK_submittedon_userid"><a href='m_loan.html'>m_loan</a><span class='relatedKey'>.submittedon_userid</span></td> |
| <td class="constraint detail">FK_submittedon_userid<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan.withdrawnon_userid references m_appuser.id via FK_withdrawnon_userid"><a href='m_loan.html'>m_loan</a><span class='relatedKey'>.withdrawnon_userid</span></td> |
| <td class="constraint detail">FK_withdrawnon_userid<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_reschedule_request.approved_by_user_id references m_appuser.id via m_loan_reschedule_request_ibfk_4"><a href='m_loan_reschedule_request.html'>m_loan_reschedule_request</a><span class='relatedKey'>.approved_by_user_id</span></td> |
| <td class="constraint detail">m_loan_reschedule_request_ibfk_4<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_reschedule_request.rejected_by_user_id references m_appuser.id via m_loan_reschedule_request_ibfk_5"><a href='m_loan_reschedule_request.html'>m_loan_reschedule_request</a><span class='relatedKey'>.rejected_by_user_id</span></td> |
| <td class="constraint detail">m_loan_reschedule_request_ibfk_5<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_loan_reschedule_request.submitted_by_user_id references m_appuser.id via m_loan_reschedule_request_ibfk_3"><a href='m_loan_reschedule_request.html'>m_loan_reschedule_request</a><span class='relatedKey'>.submitted_by_user_id</span></td> |
| <td class="constraint detail">m_loan_reschedule_request_ibfk_3<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_note.createdby_id references m_appuser.id via FK7C97089541F0A56"><a href='m_note.html'>m_note</a><span class='relatedKey'>.createdby_id</span></td> |
| <td class="constraint detail">FK7C97089541F0A56<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_note.lastmodifiedby_id references m_appuser.id via FK7C970898F889C3F"><a href='m_note.html'>m_note</a><span class='relatedKey'>.lastmodifiedby_id</span></td> |
| <td class="constraint detail">FK7C970898F889C3F<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_pocket.app_user_id references m_appuser.id via FK__m_appuser__pocket"><a href='m_pocket.html'>m_pocket</a><span class='relatedKey'>.app_user_id</span></td> |
| <td class="constraint detail">FK__m_appuser__pocket<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_portfolio_command_source.checker_id references m_appuser.id via FK_m_checker_m_appuser"><a href='m_portfolio_command_source.html'>m_portfolio_command_source</a><span class='relatedKey'>.checker_id</span></td> |
| <td class="constraint detail">FK_m_checker_m_appuser<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_portfolio_command_source.maker_id references m_appuser.id via FK_m_maker_m_appuser"><a href='m_portfolio_command_source.html'>m_portfolio_command_source</a><span class='relatedKey'>.maker_id</span></td> |
| <td class="constraint detail">FK_m_maker_m_appuser<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_provisioning_criteria.createdby_id references m_appuser.id via m_provisioning_criteria_ibfk_1"><a href='m_provisioning_criteria.html'>m_provisioning_criteria</a><span class='relatedKey'>.createdby_id</span></td> |
| <td class="constraint detail">m_provisioning_criteria_ibfk_1<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_provisioning_criteria.lastmodifiedby_id references m_appuser.id via m_provisioning_criteria_ibfk_2"><a href='m_provisioning_criteria.html'>m_provisioning_criteria</a><span class='relatedKey'>.lastmodifiedby_id</span></td> |
| <td class="constraint detail">m_provisioning_criteria_ibfk_2<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_provisioning_history.createdby_id references m_appuser.id via m_provisioning_history_ibfk_1"><a href='m_provisioning_history.html'>m_provisioning_history</a><span class='relatedKey'>.createdby_id</span></td> |
| <td class="constraint detail">m_provisioning_history_ibfk_1<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_provisioning_history.lastmodifiedby_id references m_appuser.id via m_provisioning_history_ibfk_2"><a href='m_provisioning_history.html'>m_provisioning_history</a><span class='relatedKey'>.lastmodifiedby_id</span></td> |
| <td class="constraint detail">m_provisioning_history_ibfk_2<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_rate.approve_user references m_appuser.id via FK_M_RATE_APPROVE_USER"><a href='m_rate.html'>m_rate</a><span class='relatedKey'>.approve_user</span></td> |
| <td class="constraint detail">FK_M_RATE_APPROVE_USER<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_rate.createdby_id references m_appuser.id via FK_M_RATE_CREATE_USER"><a href='m_rate.html'>m_rate</a><span class='relatedKey'>.createdby_id</span></td> |
| <td class="constraint detail">FK_M_RATE_CREATE_USER<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_report_mailing_job.createdby_id references m_appuser.id via m_report_mailing_job_ibfk_1"><a href='m_report_mailing_job.html'>m_report_mailing_job</a><span class='relatedKey'>.createdby_id</span></td> |
| <td class="constraint detail">m_report_mailing_job_ibfk_1<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_report_mailing_job.lastmodifiedby_id references m_appuser.id via m_report_mailing_job_ibfk_2"><a href='m_report_mailing_job.html'>m_report_mailing_job</a><span class='relatedKey'>.lastmodifiedby_id</span></td> |
| <td class="constraint detail">m_report_mailing_job_ibfk_2<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_report_mailing_job.run_as_userid references m_appuser.id via m_report_mailing_job_ibfk_4"><a href='m_report_mailing_job.html'>m_report_mailing_job</a><span class='relatedKey'>.run_as_userid</span></td> |
| <td class="constraint detail">m_report_mailing_job_ibfk_4<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_selfservice_user_client_mapping.appuser_id references m_appuser.id via m_selfservice_appuser_id"><a href='m_selfservice_user_client_mapping.html'>m_selfservice_user_client_mapping</a><span class='relatedKey'>.appuser_id</span></td> |
| <td class="constraint detail">m_selfservice_appuser_id<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_share_account.activated_userid references m_appuser.id via m_share_account_ibfk_6"><a href='m_share_account.html'>m_share_account</a><span class='relatedKey'>.activated_userid</span></td> |
| <td class="constraint detail">m_share_account_ibfk_6<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_share_account.approved_userid references m_appuser.id via m_share_account_ibfk_4"><a href='m_share_account.html'>m_share_account</a><span class='relatedKey'>.approved_userid</span></td> |
| <td class="constraint detail">m_share_account_ibfk_4<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_share_account.closed_userid references m_appuser.id via m_share_account_ibfk_7"><a href='m_share_account.html'>m_share_account</a><span class='relatedKey'>.closed_userid</span></td> |
| <td class="constraint detail">m_share_account_ibfk_7<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_share_account.lastmodifiedby_id references m_appuser.id via m_share_account_ibfk_8"><a href='m_share_account.html'>m_share_account</a><span class='relatedKey'>.lastmodifiedby_id</span></td> |
| <td class="constraint detail">m_share_account_ibfk_8<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_share_account.rejected_userid references m_appuser.id via m_share_account_ibfk_5"><a href='m_share_account.html'>m_share_account</a><span class='relatedKey'>.rejected_userid</span></td> |
| <td class="constraint detail">m_share_account_ibfk_5<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_share_account.submitted_userid references m_appuser.id via m_share_account_ibfk_3"><a href='m_share_account.html'>m_share_account</a><span class='relatedKey'>.submitted_userid</span></td> |
| <td class="constraint detail">m_share_account_ibfk_3<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_share_product.createdby_id references m_appuser.id via m_share_product_ibfk_1"><a href='m_share_product.html'>m_share_product</a><span class='relatedKey'>.createdby_id</span></td> |
| <td class="constraint detail">m_share_product_ibfk_1<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_share_product.lastmodifiedby_id references m_appuser.id via m_share_product_ibfk_2"><a href='m_share_product.html'>m_share_product</a><span class='relatedKey'>.lastmodifiedby_id</span></td> |
| <td class="constraint detail">m_share_product_ibfk_2<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_share_product_dividend_pay_out.createdby_id references m_appuser.id via FK_m_share_product_dividend_pay_out_createdby_id"><a href='m_share_product_dividend_pay_out.html'>m_share_product_dividend_pay_out</a><span class='relatedKey'>.createdby_id</span></td> |
| <td class="constraint detail">FK_m_share_product_dividend_pay_out_createdby_id<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_share_product_dividend_pay_out.lastmodifiedby_id references m_appuser.id via FK_m_share_product_dividend_pay_out_lastmodifiedby_id"><a href='m_share_product_dividend_pay_out.html'>m_share_product_dividend_pay_out</a><span class='relatedKey'>.lastmodifiedby_id</span></td> |
| <td class="constraint detail">FK_m_share_product_dividend_pay_out_lastmodifiedby_id<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_survey_scorecards.user_id references m_appuser.id via m_survey_scorecards_ibfk_4"><a href='m_survey_scorecards.html'>m_survey_scorecards</a><span class='relatedKey'>.user_id</span></td> |
| <td class="constraint detail">m_survey_scorecards_ibfk_4<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_tax_component.createdby_id references m_appuser.id via FK_tax_component_createdby"><a href='m_tax_component.html'>m_tax_component</a><span class='relatedKey'>.createdby_id</span></td> |
| <td class="constraint detail">FK_tax_component_createdby<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_tax_component.lastmodifiedby_id references m_appuser.id via FK_tax_component_lastmodifiedby"><a href='m_tax_component.html'>m_tax_component</a><span class='relatedKey'>.lastmodifiedby_id</span></td> |
| <td class="constraint detail">FK_tax_component_lastmodifiedby<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_tax_component_history.createdby_id references m_appuser.id via FK_tax_component_history_createdby"><a href='m_tax_component_history.html'>m_tax_component_history</a><span class='relatedKey'>.createdby_id</span></td> |
| <td class="constraint detail">FK_tax_component_history_createdby<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_tax_component_history.lastmodifiedby_id references m_appuser.id via FK_tax_component_history_lastmodifiedby"><a href='m_tax_component_history.html'>m_tax_component_history</a><span class='relatedKey'>.lastmodifiedby_id</span></td> |
| <td class="constraint detail">FK_tax_component_history_lastmodifiedby<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_tax_group.createdby_id references m_appuser.id via FK_tax_group_createdby"><a href='m_tax_group.html'>m_tax_group</a><span class='relatedKey'>.createdby_id</span></td> |
| <td class="constraint detail">FK_tax_group_createdby<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_tax_group.lastmodifiedby_id references m_appuser.id via FK_tax_group_lastmodifiedby"><a href='m_tax_group.html'>m_tax_group</a><span class='relatedKey'>.lastmodifiedby_id</span></td> |
| <td class="constraint detail">FK_tax_group_lastmodifiedby<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_tax_group_mappings.createdby_id references m_appuser.id via FK_tax_group_mappings_createdby"><a href='m_tax_group_mappings.html'>m_tax_group_mappings</a><span class='relatedKey'>.createdby_id</span></td> |
| <td class="constraint detail">FK_tax_group_mappings_createdby<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="m_tax_group_mappings.lastmodifiedby_id references m_appuser.id via FK_tax_group_mappings_lastmodifiedby"><a href='m_tax_group_mappings.html'>m_tax_group_mappings</a><span class='relatedKey'>.lastmodifiedby_id</span></td> |
| <td class="constraint detail">FK_tax_group_mappings_lastmodifiedby<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="notification_mapper.user_id references m_appuser.id via notification_mapper_ibfk_2"><a href='notification_mapper.html'>notification_mapper</a><span class='relatedKey'>.user_id</span></td> |
| <td class="constraint detail">notification_mapper_ibfk_2<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="topic_subscriber.user_id references m_appuser.id via fk_topic_has_m_appuser_m_appuser1"><a href='topic_subscriber.html'>topic_subscriber</a><span class='relatedKey'>.user_id</span></td> |
| <td class="constraint detail">fk_topic_has_m_appuser_m_appuser1<span title='Restrict delete: Parent cannot be deleted if children exist'>R</span></td> |
| </tr> |
| <tr> |
| <td title="twofactor_access_token.appuser_id references m_appuser.id via fk_2fa_access_token_user_id"><a href='twofactor_access_token.html'>twofactor_access_token</a><span class='relatedKey'>.appuser_id</span></td> |
| <td class="constraint detail">fk_2fa_access_token_user_id<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><span id="is_deleted">is_deleted</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="office_id">office_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_appuser.office_id references m_office.id via FKB3D587CE0DD567A"><a href='m_office.html'>m_office</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">FKB3D587CE0DD567A<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="staff_id">staff_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_appuser.staff_id references m_staff.id via fk_m_appuser_002"><a href='m_staff.html'>m_staff</a><span class='relatedKey'>.id</span></td> |
| <td class="constraint detail">fk_m_appuser_002<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="username">username</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="firstname">firstname</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="lastname">lastname</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="password">password</span></td> |
| <td>VARCHAR</td> |
| <td>255</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="email">email</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="firsttime_login_remaining">firsttime_login_remaining</span></td> |
| <td>BIT</td> |
| <td>1</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="nonexpired">nonexpired</span></td> |
| <td>BIT</td> |
| <td>1</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="nonlocked">nonlocked</span></td> |
| <td>BIT</td> |
| <td>1</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="nonexpired_credentials">nonexpired_credentials</span></td> |
| <td>BIT</td> |
| <td>1</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="enabled">enabled</span></td> |
| <td>BIT</td> |
| <td>1</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="last_time_password_updated">last_time_password_updated</span></td> |
| <td>DATE</td> |
| <td>10</td> |
| <td title=''></td> |
| <td title=''></td> |
| <td>'1970-01-01'</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="password_never_expires">password_never_expires</span></td> |
| <td>BIT</td> |
| <td>1</td> |
| <td title='nullable'>√</td> |
| <td title=''></td> |
| <td>NULL</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| </table> |
| </td> |
| <td><p>define if the password, should be check for validity period or not</p></td> |
| </tr> |
| <tr> |
| <td><span id="is_self_service_user">is_self_service_user</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="cannot_change_password">cannot_change_password</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> |
| </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 title='Indexed'>fk_m_appuser_002x</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>staff_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>FKB3D587CE0DD567A</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>office_id</td> |
| </tr> |
| <tr> |
| <td title='Indexed'>last_time_password_updated</td> |
| <td>Performance</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>last_time_password_updated</td> |
| </tr> |
| <tr> |
| <td class='uniqueKey' title='Unique Key'><i class='icon ion-key iconkey'></i> username_org</td> |
| <td>Must be unique</td> |
| <td><span title='Ascending'>Asc</span></td> |
| <td>username</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/acc_gl_closure.html" target="_top" title="acc_gl_closure" alt="" coords="1200,330,1411,564"> |
| <area shape="rect" id="node2" href="../../tables/m_appuser.html" target="_top" title="m_appuser" alt="" coords="629,3168,1032,3766"> |
| <area shape="rect" id="node3" href="../../tables/m_office.html" target="_top" title="m_office" alt="" coords="5,303,176,508"> |
| <area shape="rect" id="node7" href="../../tables/m_staff.html" target="_top" title="m_staff" alt="" coords="220,1111,585,1375"> |
| <area shape="rect" id="node4" href="../../tables/acc_gl_journal_entry.html" target="_top" title="acc_gl_journal_entry" alt="" coords="1627,483,1949,923"> |
| <area shape="rect" id="node5" href="../../tables/m_client_transaction.html" target="_top" title="m_client_transaction" alt="" coords="1176,582,1435,787"> |
| <area shape="rect" id="node6" href="../../tables/m_adhoc.html" target="_top" title="m_adhoc" alt="" coords="1159,1690,1452,1866"> |
| <area shape="rect" id="node8" href="../../tables/m_appuser_previous_password.html" target="_top" title="m_appuser_previous_password" alt="" coords="1142,1883,1469,2030"> |
| <area shape="rect" id="node9" href="../../tables/m_appuser_role.html" target="_top" title="m_appuser_role" alt="" coords="1209,2047,1402,2170"> |
| <area shape="rect" id="node10" href="../../tables/m_client_transfer_details.html" target="_top" title="m_client_transfer_details" alt="" coords="1169,78,1442,312"> |
| <area shape="rect" id="node11" href="../../tables/m_import_document.html" target="_top" title="m_import_document" alt="" coords="1189,2187,1421,2363"> |
| <area shape="rect" id="node12" href="../../tables/m_loan.html" target="_top" title="m_loan" alt="" coords="1076,876,1535,1492"> |
| <area shape="rect" id="node13" href="../../tables/m_loan_reschedule_request.html" target="_top" title="m_loan_reschedule_request" alt="" coords="1633,1098,1943,1362"> |
| <area shape="rect" id="node14" href="../../tables/m_note.html" target="_top" title="m_note" alt="" coords="1622,1379,1954,1731"> |
| <area shape="rect" id="node15" href="../../tables/m_pocket.html" target="_top" title="m_pocket" alt="" coords="1228,2380,1383,2503"> |
| <area shape="rect" id="node16" href="../../tables/m_portfolio_command_source.html" target="_top" title="m_portfolio_command_source" alt="" coords="1148,2520,1463,2902"> |
| <area shape="rect" id="node17" href="../../tables/m_provisioning_criteria.html" target="_top" title="m_provisioning_criteria" alt="" coords="1176,2919,1435,3124"> |
| <area shape="rect" id="node18" href="../../tables/m_provisioning_history.html" target="_top" title="m_provisioning_history" alt="" coords="1177,3142,1434,3318"> |
| <area shape="rect" id="node19" href="../../tables/m_rate.html" target="_top" title="m_rate" alt="" coords="1200,3335,1411,3511"> |
| <area shape="rect" id="node20" href="../../tables/m_report_mailing_job.html" target="_top" title="m_report_mailing_job" alt="" coords="1147,3528,1463,3792"> |
| <area shape="rect" id="node21" href="../../tables/m_selfservice_user_client_mapping.html" target="_top" title="m_selfservice_user_client_mapping" alt="" coords="1123,3810,1487,3962"> |
| <area shape="rect" id="node22" href="../../tables/m_share_account.html" target="_top" title="m_share_account" alt="" coords="1579,3864,1997,4246"> |
| <area shape="rect" id="node23" href="../../tables/m_share_product.html" target="_top" title="m_share_product" alt="" coords="1096,4195,1515,4400"> |
| <area shape="rect" id="node24" href="../../tables/m_share_product_dividend_pay_out.html" target="_top" title="m_share_product_dividend_pay_out" alt="" coords="1605,4319,1971,4524"> |
| <area shape="rect" id="node25" href="../../tables/m_survey_scorecards.html" target="_top" title="m_survey_scorecards" alt="" coords="1185,4490,1425,4754"> |
| <area shape="rect" id="node26" href="../../tables/m_tax_component.html" target="_top" title="m_tax_component" alt="" coords="1161,4843,1449,5078"> |
| <area shape="rect" id="node27" href="../../tables/m_tax_component_history.html" target="_top" title="m_tax_component_history" alt="" coords="1647,4679,1929,4884"> |
| <area shape="rect" id="node28" href="../../tables/m_tax_group.html" target="_top" title="m_tax_group" alt="" coords="1200,5095,1411,5271"> |
| <area shape="rect" id="node29" href="../../tables/m_tax_group_mappings.html" target="_top" title="m_tax_group_mappings" alt="" coords="1658,5114,1918,5348"> |
| <area shape="rect" id="node30" href="../../tables/notification_mapper.html" target="_top" title="notification_mapper" alt="" coords="1191,5360,1420,5536"> |
| <area shape="rect" id="node31" href="../../tables/topic_subscriber.html" target="_top" title="topic_subscriber" alt="" coords="1201,5554,1410,5730"> |
| <area shape="rect" id="node32" href="../../tables/twofactor_access_token.html" target="_top" title="twofactor_access_token" alt="" coords="1174,5747,1437,5923"> |
| </map> |
| <a name='diagram'><object type="image/svg+xml" id="oneDegreeImg" data="../diagrams/tables/m_appuser.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_accounting_rule.html" target="_top" title="acc_accounting_rule" alt="" coords="2013,2055,2238,2143"> |
| <area shape="rect" id="node2" href="../../tables/acc_gl_account.html" target="_top" title="acc_gl_account" alt="" coords="1627,2232,1817,2320"> |
| <area shape="rect" id="node3" href="../../tables/m_office.html" target="_top" title="m_office" alt="" coords="5,283,176,488"> |
| <area shape="rect" id="node4" href="../../tables/m_code_value.html" target="_top" title="m_code_value" alt="" coords="1195,2008,1376,2096"> |
| <area shape="rect" id="node5" href="../../tables/acc_gl_closure.html" target="_top" title="acc_gl_closure" alt="" coords="1180,764,1391,999"> |
| <area shape="rect" id="node6" href="../../tables/m_appuser.html" target="_top" title="m_appuser" alt="" coords="629,2504,1032,3101"> |
| <area shape="rect" id="node20" href="../../tables/m_staff.html" target="_top" title="m_staff" alt="" coords="220,5048,585,5312"> |
| <area shape="rect" id="node7" href="../../tables/acc_gl_journal_entry.html" target="_top" title="acc_gl_journal_entry" alt="" coords="3693,1068,4014,1508"> |
| <area shape="rect" id="node8" href="../../tables/m_client_transaction.html" target="_top" title="m_client_transaction" alt="" coords="2844,1603,3103,1808"> |
| <area shape="rect" id="node9" href="../../tables/m_loan_transaction.html" target="_top" title="m_loan_transaction" alt="" coords="3303,1505,3521,1593"> |
| <area shape="rect" id="node10" href="../../tables/m_payment_detail.html" target="_top" title="m_payment_detail" alt="" coords="2869,831,3077,919"> |
| <area shape="rect" id="node11" href="../../tables/m_savings_account_transaction.html" target="_top" title="m_savings_account_transaction" alt="" coords="3259,1259,3565,1347"> |
| <area shape="rect" id="node12" href="../../tables/m_share_account_transactions.html" target="_top" title="m_share_account_transactions" alt="" coords="3262,1364,3562,1452"> |
| <area shape="rect" id="node16" href="../../tables/m_client.html" target="_top" title="m_client" alt="" coords="2449,2191,2597,2279"> |
| <area shape="rect" id="node17" href="../../tables/m_loan.html" target="_top" title="m_loan" alt="" coords="2744,2944,3203,3560"> |
| <area shape="rect" id="node18" href="../../tables/m_savings_account.html" target="_top" title="m_savings_account" alt="" coords="2015,2623,2235,2711"> |
| <area shape="rect" id="node76" href="../../tables/m_share_account.html" target="_top" title="m_share_account" alt="" coords="2764,1132,3183,1513"> |
| <area shape="rect" id="node13" href="../../tables/glim_accounts.html" target="_top" title="glim_accounts" alt="" coords="2431,2827,2614,2915"> |
| <area shape="rect" id="node14" href="../../tables/m_group.html" target="_top" title="m_group" alt="" coords="1650,2555,1794,2643"> |
| <area shape="rect" id="node15" href="../../tables/m_account_transfer_details.html" target="_top" title="m_account_transfer_details" alt="" coords="3275,2209,3549,2297"> |
| <area shape="rect" id="node28" href="../../tables/m_savings_product.html" target="_top" title="m_savings_product" alt="" coords="1613,2449,1831,2537"> |
| <area shape="rect" id="node29" href="../../tables/m_image.html" target="_top" title="m_image" alt="" coords="19,5299,163,5387"> |
| <area shape="rect" id="node36" href="../../tables/m_fund.html" target="_top" title="m_fund" alt="" coords="1219,2655,1352,2743"> |
| <area shape="rect" id="node37" href="../../tables/ref_loan_transaction_processing_strategy.html" target="_top" title="ref_loan_transaction_processing_strategy" alt="" coords="1097,3117,1473,3205"> |
| <area shape="rect" id="node38" href="../../tables/m_product_loan.html" target="_top" title="m_product_loan" alt="" coords="1625,3111,1819,3199"> |
| <area shape="rect" id="node27" href="../../tables/m_tax_group.html" target="_top" title="m_tax_group" alt="" coords="1180,2317,1391,2493"> |
| <area shape="rect" id="node19" href="../../tables/m_adhoc.html" target="_top" title="m_adhoc" alt="" coords="1139,2760,1432,2936"> |
| <area shape="rect" id="node21" href="../../tables/m_appuser_previous_password.html" target="_top" title="m_appuser_previous_password" alt="" coords="1122,2953,1449,3100"> |
| <area shape="rect" id="node22" href="../../tables/m_appuser_role.html" target="_top" title="m_appuser_role" alt="" coords="1189,431,1382,553"> |
| <area shape="rect" id="node23" href="../../tables/m_role.html" target="_top" title="m_role" alt="" coords="766,463,895,551"> |
| <area shape="rect" id="node24" href="../../tables/m_cashiers.html" target="_top" title="m_cashiers" alt="" coords="2442,3692,2603,3780"> |
| <area shape="rect" id="node25" href="../../tables/m_tellers.html" target="_top" title="m_tellers" alt="" coords="2053,3265,2198,3353"> |
| <area shape="rect" id="node26" href="../../tables/m_charge.html" target="_top" title="m_charge" alt="" coords="2899,1933,3048,2021"> |
| <area shape="rect" id="node30" href="../../tables/m_client_charge_paid_by.html" target="_top" title="m_client_charge_paid_by" alt="" coords="3283,1611,3541,1699"> |
| <area shape="rect" id="node31" href="../../tables/m_client_transfer_details.html" target="_top" title="m_client_transfer_details" alt="" coords="2837,5149,3110,5384"> |
| <area shape="rect" id="node32" href="../../tables/m_guarantor.html" target="_top" title="m_guarantor" alt="" coords="3327,2736,3497,2824"> |
| <area shape="rect" id="node33" href="../../tables/m_holiday_office.html" target="_top" title="m_holiday_office" alt="" coords="303,763,503,851"> |
| <area shape="rect" id="node34" href="../../tables/m_import_document.html" target="_top" title="m_import_document" alt="" coords="1169,571,1401,747"> |
| <area shape="rect" id="node35" href="../../tables/m_document.html" target="_top" title="m_document" alt="" coords="745,585,917,673"> |
| <area shape="rect" id="node39" href="../../tables/m_loan_arrears_aging.html" target="_top" title="m_loan_arrears_aging" alt="" coords="3293,3459,3531,3547"> |
| <area shape="rect" id="node40" href="../../tables/m_loan_charge.html" target="_top" title="m_loan_charge" alt="" coords="3318,2631,3506,2719"> |
| <area shape="rect" id="node41" href="../../tables/m_loan_collateral.html" target="_top" title="m_loan_collateral" alt="" coords="3310,2420,3514,2508"> |
| <area shape="rect" id="node42" href="../../tables/m_loan_collateral_management.html" target="_top" title="m_loan_collateral_management" alt="" coords="3703,2641,4004,2729"> |
| <area shape="rect" id="node43" href="../../tables/m_loan_disbursement_detail.html" target="_top" title="m_loan_disbursement_detail" alt="" coords="3271,3564,3553,3652"> |
| <area shape="rect" id="node44" href="../../tables/m_loan_officer_assignment_history.html" target="_top" title="m_loan_officer_assignment_history" alt="" coords="3247,4713,3577,4801"> |
| <area shape="rect" id="node45" href="../../tables/m_loan_paid_in_advance.html" target="_top" title="m_loan_paid_in_advance" alt="" coords="3283,3669,3541,3757"> |
| <area shape="rect" id="node46" href="../../tables/m_loan_rate.html" target="_top" title="m_loan_rate" alt="" coords="3329,2315,3495,2403"> |
| <area shape="rect" id="node47" href="../../tables/m_rate.html" target="_top" title="m_rate" alt="" coords="1617,1333,1827,1509"> |
| <area shape="rect" id="node48" href="../../tables/m_loan_recalculation_details.html" target="_top" title="m_loan_recalculation_details" alt="" coords="3270,2983,3554,3071"> |
| <area shape="rect" id="node49" href="../../tables/m_loan_repayment_schedule.html" target="_top" title="m_loan_repayment_schedule" alt="" coords="3269,3176,3555,3264"> |
| <area shape="rect" id="node50" href="../../tables/m_loan_repayment_schedule_history.html" target="_top" title="m_loan_repayment_schedule_history" alt="" coords="3683,3419,4024,3507"> |
| <area shape="rect" id="node51" href="../../tables/m_loan_reschedule_request.html" target="_top" title="m_loan_reschedule_request" alt="" coords="3257,3775,3567,4039"> |
| <area shape="rect" id="node52" href="../../tables/m_loan_reschedule_request_term_variations_mapping.html" target="_top" title="m_loan_reschedule_request_term_variations_mapping" alt="" coords="3621,3707,4085,3795"> |
| <area shape="rect" id="node53" href="../../tables/m_loan_term_variations.html" target="_top" title="m_loan_term_variations" alt="" coords="3287,3353,3537,3441"> |
| <area shape="rect" id="node54" href="../../tables/m_loan_topup.html" target="_top" title="m_loan_topup" alt="" coords="3763,3095,3944,3183"> |
| <area shape="rect" id="node55" href="../../tables/m_loan_tranche_charges.html" target="_top" title="m_loan_tranche_charges" alt="" coords="3283,2525,3541,2613"> |
| <area shape="rect" id="node56" href="../../tables/m_loanproduct_provisioning_entry.html" target="_top" title="m_loanproduct_provisioning_entry" alt="" coords="1962,2337,2289,2425"> |
| <area shape="rect" id="node57" href="../../tables/m_provisioning_criteria.html" target="_top" title="m_provisioning_criteria" alt="" coords="1593,2804,1851,3009"> |
| <area shape="rect" id="node58" href="../../tables/m_provisioning_history.html" target="_top" title="m_provisioning_history" alt="" coords="1157,2124,1414,2300"> |
| <area shape="rect" id="node59" href="../../tables/m_loanproduct_provisioning_mapping.html" target="_top" title="m_loanproduct_provisioning_mapping" alt="" coords="1949,3371,2301,3459"> |
| <area shape="rect" id="node60" href="../../tables/m_note.html" target="_top" title="m_note" alt="" coords="3687,1924,4019,2276"> |
| <area shape="rect" id="node61" href="../../tables/m_office_transaction.html" target="_top" title="m_office_transaction" alt="" coords="289,5,517,93"> |
| <area shape="rect" id="node62" href="../../tables/m_pocket.html" target="_top" title="m_pocket" alt="" coords="1208,3981,1363,4104"> |
| <area shape="rect" id="node63" href="../../tables/m_pocket_accounts_mapping.html" target="_top" title="m_pocket_accounts_mapping" alt="" coords="1577,3984,1867,4072"> |
| <area shape="rect" id="node64" href="../../tables/m_portfolio_account_associations.html" target="_top" title="m_portfolio_account_associations" alt="" coords="3251,2841,3573,2929"> |
| <area shape="rect" id="node65" href="../../tables/m_portfolio_command_source.html" target="_top" title="m_portfolio_command_source" alt="" coords="1128,3475,1443,3856"> |
| <area shape="rect" id="node66" href="../../tables/m_product_loan_rate.html" target="_top" title="m_product_loan_rate" alt="" coords="2011,2764,2240,2852"> |
| <area shape="rect" id="node67" href="../../tables/m_provisioning_criteria_definition.html" target="_top" title="m_provisioning_criteria_definition" alt="" coords="1965,2232,2286,2320"> |
| <area shape="rect" id="node68" href="../../tables/m_repayment_with_post_dated_checks.html" target="_top" title="m_repayment_with_post_dated_checks" alt="" coords="3675,3221,4031,3309"> |
| <area shape="rect" id="node69" href="../../tables/m_report_mailing_job.html" target="_top" title="m_report_mailing_job" alt="" coords="1127,4301,1443,4565"> |
| <area shape="rect" id="node70" href="../../tables/stretchy_report.html" target="_top" title="stretchy_report" alt="" coords="736,4421,925,4509"> |
| <area shape="rect" id="node71" href="../../tables/m_report_mailing_job_run_history.html" target="_top" title="m_report_mailing_job_run_history" alt="" coords="1561,4304,1883,4392"> |
| <area shape="rect" id="node72" href="../../tables/m_savings_account_transaction_tax_details.html" target="_top" title="m_savings_account_transaction_tax_details" alt="" coords="3659,1672,4048,1760"> |
| <area shape="rect" id="node73" href="../../tables/m_tax_component.html" target="_top" title="m_tax_component" alt="" coords="1981,2977,2269,3212"> |
| <area shape="rect" id="node74" href="../../tables/m_savings_officer_assignment_history.html" target="_top" title="m_savings_officer_assignment_history" alt="" coords="2345,3299,2700,3387"> |
| <area shape="rect" id="node75" href="../../tables/m_selfservice_user_client_mapping.html" target="_top" title="m_selfservice_user_client_mapping" alt="" coords="2791,2039,3155,2191"> |
| <area shape="rect" id="node77" href="../../tables/m_share_product.html" target="_top" title="m_share_product" alt="" coords="1076,1232,1495,1437"> |
| <area shape="rect" id="node78" href="../../tables/m_share_account_charge.html" target="_top" title="m_share_account_charge" alt="" coords="3281,1849,3543,1937"> |
| <area shape="rect" id="node79" href="../../tables/m_share_account_dividend_details.html" target="_top" title="m_share_account_dividend_details" alt="" coords="3249,868,3575,956"> |
| <area shape="rect" id="node80" href="../../tables/m_share_product_dividend_pay_out.html" target="_top" title="m_share_product_dividend_pay_out" alt="" coords="1539,933,1905,1139"> |
| <area shape="rect" id="node81" href="../../tables/m_share_product_charge.html" target="_top" title="m_share_product_charge" alt="" coords="3282,1725,3542,1813"> |
| <area shape="rect" id="node82" href="../../tables/m_share_product_market_price.html" target="_top" title="m_share_product_market_price" alt="" coords="1571,1228,1873,1316"> |
| <area shape="rect" id="node83" href="../../tables/m_staff_assignment_history.html" target="_top" title="m_staff_assignment_history" alt="" coords="1986,3764,2265,3852"> |
| <area shape="rect" id="node84" href="../../tables/m_survey_questions.html" target="_top" title="m_survey_questions" alt="" coords="2013,5473,2238,5561"> |
| <area shape="rect" id="node85" href="../../tables/m_surveys.html" target="_top" title="m_surveys" alt="" coords="1643,5455,1801,5543"> |
| <area shape="rect" id="node86" href="../../tables/m_survey_responses.html" target="_top" title="m_survey_responses" alt="" coords="2408,5545,2637,5633"> |
| <area shape="rect" id="node87" href="../../tables/m_survey_scorecards.html" target="_top" title="m_survey_scorecards" alt="" coords="2853,5437,3093,5701"> |
| <area shape="rect" id="node88" href="../../tables/m_tax_component_history.html" target="_top" title="m_tax_component_history" alt="" coords="2381,3076,2664,3281"> |
| <area shape="rect" id="node89" href="../../tables/m_tax_group_mappings.html" target="_top" title="m_tax_group_mappings" alt="" coords="2393,3404,2653,3639"> |
| <area shape="rect" id="node90" href="../../tables/notification_mapper.html" target="_top" title="notification_mapper" alt="" coords="1171,4583,1400,4759"> |
| <area shape="rect" id="node91" href="../../tables/notification_generator.html" target="_top" title="notification_generator" alt="" coords="713,4615,949,4703"> |
| <area shape="rect" id="node92" href="../../tables/scheduled_email_messages_outbound.html" target="_top" title="scheduled_email_messages_outbound" alt="" coords="2797,2368,3149,2456"> |
| <area shape="rect" id="node93" href="../../tables/sms_messages_outbound.html" target="_top" title="sms_messages_outbound" alt="" coords="2841,2473,3105,2561"> |
| <area shape="rect" id="node94" href="../../tables/topic_subscriber.html" target="_top" title="topic_subscriber" alt="" coords="1181,4776,1390,4952"> |
| <area shape="rect" id="node95" href="../../tables/topic.html" target="_top" title="topic" alt="" coords="771,4808,891,4896"> |
| <area shape="rect" id="node96" href="../../tables/twofactor_access_token.html" target="_top" title="twofactor_access_token" alt="" coords="1154,1743,1417,1919"> |
| </map> |
| <a name='diagram'><object type="image/svg+xml" id="twodegreesDegreeImg" data="../diagrams/tables/m_appuser.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> |