| <!DOCTYPE html> |
| <html> |
| <head> |
| <meta charset="utf-8"> |
| <meta http-equiv="X-UA-Compatible" content="IE=edge"> |
| <title>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>Constraints</h1> |
| </section> |
| <!-- Main content --> |
| <section class="content"> |
| <div class="box box-primary"> |
| <div class="box-header with-border"> |
| <i class="ion ion-key"></i> |
| <h3 class="box-title">368 Foreign Key Constraints</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="fk_table" class="table table-bordered table-striped dataTable" role="grid"> |
| <thead align='left'> |
| <tr> |
| <th>Constraint Name</th> |
| <th>Child Column</th> |
| <th>Parent Column</th> |
| <th>Delete Rule</th> |
| </tr> |
| </thead> |
| <tbody> |
| <tr> |
| <td>m_provisioning_criteria_definition_ibfk_3</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_provisioning_criteria_definition.html'>m_provisioning_criteria_definition</a><span>.liability_account</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_account.html'>acc_gl_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_provisioning_criteria_definition_ibfk_4</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_provisioning_criteria_definition.html'>m_provisioning_criteria_definition</a><span>.expense_account</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_account.html'>acc_gl_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_provisioning_criteria_definition_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_provisioning_criteria_definition.html'>m_provisioning_criteria_definition</a><span>.criteria_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_provisioning_criteria.html'>m_provisioning_criteria</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_provisioning_criteria_definition_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_provisioning_criteria_definition.html'>m_provisioning_criteria_definition</a><span>.category_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_provision_category.html'>m_provision_category</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_report_mailing_job_run_history_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_report_mailing_job_run_history.html'>m_report_mailing_job_run_history</a><span>.job_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_report_mailing_job.html'>m_report_mailing_job</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_accounting_rule_acc_gl_account_debit</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_accounting_rule.html'>acc_accounting_rule</a><span>.debit_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_account.html'>acc_gl_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_accounting_rule_acc_gl_account_credit</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_accounting_rule.html'>acc_accounting_rule</a><span>.credit_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_account.html'>acc_gl_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_accounting_rule_m_office</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_accounting_rule.html'>acc_accounting_rule</a><span>.office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_access_type_code_m_code_value</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_entity_to_entity_access.html'>m_entity_to_entity_access</a><span>.access_type_code_value_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_product_mix_product_id_to_m_product_loan</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_mix.html'>m_product_mix</a><span>.product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan.html'>m_product_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_product_mix_restricted_product_id_to_m_product_loan</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_mix.html'>m_product_mix</a><span>.restricted_product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan.html'>m_product_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_gl_journal_entry_acc_gl_account</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_journal_entry.html'>acc_gl_journal_entry</a><span>.account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_account.html'>acc_gl_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_gl_journal_entry_m_appuser_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_journal_entry.html'>acc_gl_journal_entry</a><span>.lastmodifiedby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_gl_journal_entry_m_loan_transaction</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_journal_entry.html'>acc_gl_journal_entry</a><span>.loan_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_transaction.html'>m_loan_transaction</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_gl_journal_entry_m_savings_account_transaction</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_journal_entry.html'>acc_gl_journal_entry</a><span>.savings_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_transaction.html'>m_savings_account_transaction</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_gl_journal_entry_m_office</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_journal_entry.html'>acc_gl_journal_entry</a><span>.office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_gl_journal_entry_m_payment_detail</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_journal_entry.html'>acc_gl_journal_entry</a><span>.payment_details_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_payment_detail.html'>m_payment_detail</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_gl_journal_entry_m_client_transaction</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_journal_entry.html'>acc_gl_journal_entry</a><span>.client_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_transaction.html'>m_client_transaction</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_gl_journal_entry_m_appuser</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_journal_entry.html'>acc_gl_journal_entry</a><span>.createdby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_gl_journal_entry_acc_gl_journal_entry</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_journal_entry.html'>acc_gl_journal_entry</a><span>.reversal_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_journal_entry.html'>acc_gl_journal_entry</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_gl_journal_entry_m_share_account_transaction</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_journal_entry.html'>acc_gl_journal_entry</a><span>.share_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account_transactions.html'>m_share_account_transactions</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK__m_loan_transaction</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_charge_paid_by.html'>m_loan_charge_paid_by</a><span>.loan_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_transaction.html'>m_loan_transaction</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK__m_loan_charge</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_charge_paid_by.html'>m_loan_charge_paid_by</a><span>.loan_charge_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_charge.html'>m_loan_charge</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_loan_m_loan_recalculation_details</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_recalculation_details.html'>m_loan_recalculation_details</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_product_market_price_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_product_market_price.html'>m_share_product_market_price</a><span>.product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_product.html'>m_share_product</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_accounting_rule_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_rule_tags.html'>acc_rule_tags</a><span>.acc_rule_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_accounting_rule.html'>acc_accounting_rule</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_code_value_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_rule_tags.html'>acc_rule_tags</a><span>.tag_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK2291C477E2551DCC</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.parent_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>Parent_levelId_reference</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group_level.html'>m_group_level</a><span>.parent_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group_level.html'>m_group_level</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK1_request_audit_table_m_client</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/request_audit_table.html'>request_audit_table</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKMSS0000000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_mandatory_savings_schedule.html'>m_mandatory_savings_schedule</a><span>.savings_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_entity_datatable_check_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_entity_datatable_check.html'>m_entity_datatable_check</a><span>.x_registered_table_name</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/x_registered_table.html'>x_registered_table</a><span>.registered_table_name</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK488B92AA40BE0710</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_repayment_schedule.html'>m_loan_repayment_schedule</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_calendar_m_calendar_history</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_calendar_history.html'>m_calendar_history</a><span>.calendar_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_calendar.html'>m_calendar</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_standing_instructions_account_transfer_details</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_standing_instructions.html'>m_account_transfer_standing_instructions</a><span>.account_transfer_details_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_details.html'>m_account_transfer_details</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_document_m_client</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_identifier.html'>m_client_identifier</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_document_m_code_value</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_identifier.html'>m_client_identifier</a><span>.document_type_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_guarantee_details_loan_product</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan_guarantee_details.html'>m_product_loan_guarantee_details</a><span>.loan_product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan.html'>m_product_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK1_client_device_registration_m_client</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/client_device_registration.html'>client_device_registration</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_survey_responses_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_survey_responses.html'>m_survey_responses</a><span>.question_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_survey_questions.html'>m_survey_questions</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>notification_mapper_ibfk_3</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/notification_mapper.html'>notification_mapper</a><span>.notification_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/notification_generator.html'>notification_generator</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>notification_mapper_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/notification_mapper.html'>notification_mapper</a><span>.user_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_savings_account_transaction_m_payment_detail</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_transaction.html'>m_savings_account_transaction</a><span>.payment_detail_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_payment_detail.html'>m_payment_detail</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKSAT0000000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_transaction.html'>m_savings_account_transaction</a><span>.savings_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_savings_account_transaction_m_office</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_transaction.html'>m_savings_account_transaction</a><span>.office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_calendar_instance_m_meeting</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_meeting.html'>m_meeting</a><span>.calendar_instance_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_calendar_instance.html'>m_calendar_instance</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKDPTP00000000000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_deposit_product_term_and_preclosure.html'>m_deposit_product_term_and_preclosure</a><span>.savings_product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_product.html'>m_savings_product</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_topic_has_m_appuser_m_appuser1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/topic_subscriber.html'>topic_subscriber</a><span>.user_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_topic_has_m_appuser_topic</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/topic_subscriber.html'>topic_subscriber</a><span>.topic_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/topic.html'>topic</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>scheduled_email_campaign_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/scheduled_email_campaign.html'>scheduled_email_campaign</a><span>.stretchy_report_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/stretchy_report.html'>stretchy_report</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_survey_lookup_tables_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_survey_lookup_tables.html'>m_survey_lookup_tables</a><span>.survey_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_surveys.html'>m_surveys</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_savings_account_charge_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_charge.html'>m_savings_account_charge</a><span>.charge_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_charge.html'>m_charge</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_savings_account_charge_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_charge.html'>m_savings_account_charge</a><span>.savings_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>borrower_cycle_loan_product_FK</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan_variations_borrower_cycle.html'>m_product_loan_variations_borrower_cycle</a><span>.loan_product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan.html'>m_product_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_mappings_m_variable_product_loan_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan_variable_installment_config.html'>m_product_loan_variable_installment_config</a><span>.loan_product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan.html'>m_product_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>scheduledjobsFK</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/job_run_history.html'>job_run_history</a><span>.job_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/job.html'>job</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>cbConfigfk1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_creditbureau_configuration.html'>m_creditbureau_configuration</a><span>.organisation_creditbureau_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_creditbureau.html'>m_creditbureau</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKDPIRC00000000000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_deposit_product_interest_rate_chart.html'>m_deposit_product_interest_rate_chart</a><span>.deposit_product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_product.html'>m_savings_product</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKDPIRC00000000000002</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_deposit_product_interest_rate_chart.html'>m_deposit_product_interest_rate_chart</a><span>.interest_rate_chart_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_interest_rate_chart.html'>m_interest_rate_chart</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_cashiers_m_staff</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_cashiers.html'>m_cashiers</a><span>.staff_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_staff.html'>m_staff</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_cashiers_m_teller</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_cashiers.html'>m_cashiers</a><span>.teller_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tellers.html'>m_tellers</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_staff_m_image</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_staff.html'>m_staff</a><span>.image_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_image.html'>m_image</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_staff_m_office</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_staff.html'>m_staff</a><span>.office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK7C9708924D26803</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_note.html'>m_note</a><span>.loan_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_transaction.html'>m_loan_transaction</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK7C970898F889C3F</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_note.html'>m_note</a><span>.lastmodifiedby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_note_m_group</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_note.html'>m_note</a><span>.group_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group.html'>m_group</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK7C9708940BE0710</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_note.html'>m_note</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK7C97089541F0A56</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_note.html'>m_note</a><span>.createdby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_savings_account_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_note.html'>m_note</a><span>.savings_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK7C970897179A0CB</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_note.html'>m_note</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fkClientCollateral</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_collateral_management.html'>m_loan_collateral_management</a><span>.client_collateral_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_collateral_management.html'>m_client_collateral_management</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Cascade on delete: Deletion of parent deletes child'>Cascade on delete</span></td> |
| </tr> |
| <tr> |
| <td>fkLoan</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_collateral_management.html'>m_loan_collateral_management</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Cascade on delete: Deletion of parent deletes child'>Cascade on delete</span></td> |
| </tr> |
| <tr> |
| <td>fkTransaction</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_collateral_management.html'>m_loan_collateral_management</a><span>.transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_transaction.html'>m_loan_transaction</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Cascade on delete: Deletion of parent deletes child'>Cascade on delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_mappings_m_floating_rates</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_floating_rates_periods.html'>m_floating_rates_periods</a><span>.floating_rates_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_floating_rates.html'>m_floating_rates</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>address_fields_codefk2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_address.html'>m_address</a><span>.country_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>address_fields_codefk1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_address.html'>m_address</a><span>.state_province_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loanproduct_provisioning_entry_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loanproduct_provisioning_entry.html'>m_loanproduct_provisioning_entry</a><span>.history_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_provisioning_history.html'>m_provisioning_history</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loanproduct_provisioning_entry_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loanproduct_provisioning_entry.html'>m_loanproduct_provisioning_entry</a><span>.criteria_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_provisioning_criteria.html'>m_provisioning_criteria</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loanproduct_provisioning_entry_ibfk_3</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loanproduct_provisioning_entry.html'>m_loanproduct_provisioning_entry</a><span>.office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loanproduct_provisioning_entry_ibfk_4</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loanproduct_provisioning_entry.html'>m_loanproduct_provisioning_entry</a><span>.product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan.html'>m_product_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loanproduct_provisioning_entry_ibfk_5</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loanproduct_provisioning_entry.html'>m_loanproduct_provisioning_entry</a><span>.category_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_provision_category.html'>m_provision_category</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loanproduct_provisioning_entry_ibfk_6</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loanproduct_provisioning_entry.html'>m_loanproduct_provisioning_entry</a><span>.liability_account</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_account.html'>acc_gl_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loanproduct_provisioning_entry_ibfk_7</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loanproduct_provisioning_entry.html'>m_loanproduct_provisioning_entry</a><span>.expense_account</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_account.html'>acc_gl_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_product_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_product.html'>m_share_product</a><span>.createdby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_product_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_product.html'>m_share_product</a><span>.lastmodifiedby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKDPRD00000000000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_deposit_product_recurring_detail.html'>m_deposit_product_recurring_detail</a><span>.savings_product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_product.html'>m_savings_product</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_charge_m_tax_group</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_charge.html'>m_charge</a><span>.tax_group_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_group.html'>m_tax_group</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_payment_detail_m_payment_types</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_charge.html'>m_charge</a><span>.payment_type_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_payment_type.html'>m_payment_type</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_charge_acc_gl_account</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_charge.html'>m_charge</a><span>.income_or_liability_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_account.html'>acc_gl_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_additional_details_repayment_schedule_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_interest_recalculation_additional_details.html'>m_loan_interest_recalculation_additional_details</a><span>.loan_repayment_schedule_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_repayment_schedule.html'>m_loan_repayment_schedule</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKSTAFF000000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/sms_messages_outbound.html'>sms_messages_outbound</a><span>.staff_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_staff.html'>m_staff</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKGROUP000000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/sms_messages_outbound.html'>sms_messages_outbound</a><span>.group_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group.html'>m_group</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKCLIENT00000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/sms_messages_outbound.html'>sms_messages_outbound</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKCAMPAIGN00000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/sms_messages_outbound.html'>sms_messages_outbound</a><span>.campaign_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/sms_campaign.html'>sms_campaign</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loan_paid_in_advance_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_paid_in_advance.html'>m_loan_paid_in_advance</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKGLACC000000002</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_account.html'>acc_gl_account</a><span>.tag_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_ACC_0000000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_account.html'>acc_gl_account</a><span>.parent_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_account.html'>acc_gl_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_survey_scorecards_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_survey_scorecards.html'>m_survey_scorecards</a><span>.question_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_survey_questions.html'>m_survey_questions</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_survey_scorecards_ibfk_3</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_survey_scorecards.html'>m_survey_scorecards</a><span>.response_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_survey_responses.html'>m_survey_responses</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_survey_scorecards_ibfk_4</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_survey_scorecards.html'>m_survey_scorecards</a><span>.user_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_survey_scorecards_ibfk_5</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_survey_scorecards.html'>m_survey_scorecards</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_survey_scorecards_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_survey_scorecards.html'>m_survey_scorecards</a><span>.survey_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_surveys.html'>m_surveys</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_c_external_service_properties_c_external_service</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/c_external_service_properties.html'>c_external_service_properties</a><span>.external_service_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/c_external_service.html'>c_external_service</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>Parent_Id_reference</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group.html'>m_group</a><span>.parent_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group.html'>m_group</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_group_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group.html'>m_group</a><span>.office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_group_m_staff</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group.html'>m_group</a><span>.staff_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_staff.html'>m_staff</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_group_level</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group.html'>m_group</a><span>.level_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group_level.html'>m_group_level</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_group_m_code</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group.html'>m_group</a><span>.closure_reason_cv_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_teller_transactions_m_cashiers</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_cashier_transactions.html'>m_cashier_transactions</a><span>.cashier_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_cashiers.html'>m_cashiers</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Cascade on delete: Deletion of parent deletes child'>Cascade on delete</span></td> |
| </tr> |
| <tr> |
| <td>FKSAIRS00000000000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_interest_rate_slab.html'>m_savings_account_interest_rate_slab</a><span>.savings_account_interest_rate_chart_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_interest_rate_chart.html'>m_savings_account_interest_rate_chart</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_M_LOAN_RATE_RATE</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_rate.html'>m_loan_rate</a><span>.rate_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_rate.html'>m_rate</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_M_LOAN_RATE_LOAN</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_rate.html'>m_loan_rate</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_transfer_details_m_appuser</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_transfer_details.html'>m_client_transfer_details</a><span>.submitted_by</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_transfer_details_m_office</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_transfer_details.html'>m_client_transfer_details</a><span>.from_office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_transfer_details_m_client</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_transfer_details.html'>m_client_transfer_details</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_transfer_details_m_office_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_transfer_details.html'>m_client_transfer_details</a><span>.to_office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_mappings_m_loan_repayment_schedule</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_transaction_repayment_schedule_mapping.html'>m_loan_transaction_repayment_schedule_mapping</a><span>.loan_repayment_schedule_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_repayment_schedule.html'>m_loan_repayment_schedule</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_mappings_m_loan_transaction</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_transaction_repayment_schedule_mapping.html'>m_loan_transaction_repayment_schedule_mapping</a><span>.loan_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_transaction.html'>m_loan_transaction</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>linked_loan_fk</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_portfolio_account_associations.html'>m_portfolio_account_associations</a><span>.linked_loan_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>account_association_loan_fk</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_portfolio_account_associations.html'>m_portfolio_account_associations</a><span>.loan_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>account_association_savings_fk</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_portfolio_account_associations.html'>m_portfolio_account_associations</a><span>.savings_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>linked_savings_fk</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_portfolio_account_associations.html'>m_portfolio_account_associations</a><span>.linked_savings_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_holiday_id_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_holiday_office.html'>m_holiday_office</a><span>.holiday_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_holiday.html'>m_holiday</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_office_id_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_holiday_office.html'>m_holiday_office</a><span>.office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_deposit_account_term_and_preclosure_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_deposit_account_term_and_preclosure.html'>m_deposit_account_term_and_preclosure</a><span>.transfer_to_savings_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKDATP00000000000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_deposit_account_term_and_preclosure.html'>m_deposit_account_term_and_preclosure</a><span>.savings_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_m_savings_officer_assignment_history_0001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_officer_assignment_history.html'>m_savings_officer_assignment_history</a><span>.account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_m_savings_officer_assignment_history_0002</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_officer_assignment_history.html'>m_savings_officer_assignment_history</a><span>.savings_officer_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_staff.html'>m_staff</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKCFCEA42640BE0710</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_transaction.html'>m_loan_transaction</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_loan_transaction_m_payment_detail</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_transaction.html'>m_loan_transaction</a><span>.payment_detail_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_payment_detail.html'>m_payment_detail</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_loan_transaction_m_office</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_transaction.html'>m_loan_transaction</a><span>.office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_account_transfer_details_to_client</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_details.html'>m_account_transfer_details</a><span>.to_client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_account_transfer_details_from_client</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_details.html'>m_account_transfer_details</a><span>.from_client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_account_transfer_details_to_savings_account</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_details.html'>m_account_transfer_details</a><span>.to_savings_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_account_transfer_details_to_loan_account</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_details.html'>m_account_transfer_details</a><span>.to_loan_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_account_transfer_details_from_office</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_details.html'>m_account_transfer_details</a><span>.from_office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_account_transfer_details_from_loan_account</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_details.html'>m_account_transfer_details</a><span>.from_loan_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_account_transfer_details_to_office</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_details.html'>m_account_transfer_details</a><span>.to_office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_account_transfer_details_from_savings_account</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_details.html'>m_account_transfer_details</a><span>.from_savings_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKSA00000000000002</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.group_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group.html'>m_group</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKSA00000000000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_gsim_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.gsim_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/gsim_accounts.html'>gsim_accounts</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_savings_account_tax_group</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.tax_group_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_group.html'>m_tax_group</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKSA00000000000003</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_product.html'>m_savings_product</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_collateral_code_value</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_collateral.html'>m_loan_collateral</a><span>.type_cv_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_collateral_m_loan</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_collateral.html'>m_loan_collateral</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_product_loan_m_product_loan_recalculation_details</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan_recalculation_details.html'>m_product_loan_recalculation_details</a><span>.product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan.html'>m_product_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_job_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/job_parameters.html'>job_parameters</a><span>.job_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/job.html'>job</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK__rel_id_m_entity_relation_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_entity_to_entity_mapping.html'>m_entity_to_entity_mapping</a><span>.rel_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_entity_relation.html'>m_entity_relation</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_share_account_dividend_details_account_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account_dividend_details.html'>m_share_account_dividend_details</a><span>.account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account.html'>m_share_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_share_account_dividend_details_dividend_pay_out_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account_dividend_details.html'>m_share_account_dividend_details</a><span>.dividend_pay_out_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_product_dividend_pay_out.html'>m_share_product_dividend_pay_out</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>SEFKGROUP000000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/scheduled_email_messages_outbound.html'>scheduled_email_messages_outbound</a><span>.group_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group.html'>m_group</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>SEFKSTAFF000000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/scheduled_email_messages_outbound.html'>scheduled_email_messages_outbound</a><span>.staff_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_staff.html'>m_staff</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_schedule_email_campign1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/scheduled_email_messages_outbound.html'>scheduled_email_messages_outbound</a><span>.email_campaign_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/scheduled_email_campaign.html'>scheduled_email_campaign</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>SEFKCLIENT00000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/scheduled_email_messages_outbound.html'>scheduled_email_messages_outbound</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_report_parameter_002</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/stretchy_report_parameter.html'>stretchy_report_parameter</a><span>.parameter_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/stretchy_parameter.html'>stretchy_parameter</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_report_parameter_001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/stretchy_report_parameter.html'>stretchy_report_parameter</a><span>.report_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/stretchy_report.html'>stretchy_report</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Cascade on delete: Deletion of parent deletes child'>Cascade on delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_tax_group_createdby</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_group.html'>m_tax_group</a><span>.createdby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_tax_group_lastmodifiedby</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_group.html'>m_tax_group</a><span>.lastmodifiedby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_tellers_gl_account_credit_account_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tellers.html'>m_tellers</a><span>.credit_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_account.html'>acc_gl_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_tellers_gl_account_debit_account_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tellers.html'>m_tellers</a><span>.debit_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_account.html'>acc_gl_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_tellers_m_office</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tellers.html'>m_tellers</a><span>.office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK7662CE59B4100309</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser_role.html'>m_appuser_role</a><span>.appuser_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK7662CE5915CEC7AB</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser_role.html'>m_appuser_role</a><span>.role_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_role.html'>m_role</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_2fa_access_token_user_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/twofactor_access_token.html'>twofactor_access_token</a><span>.appuser_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fkCurrencyCode</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_collateral_management.html'>m_collateral_management</a><span>.currency</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_currency.html'>m_currency</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Cascade on delete: Deletion of parent deletes child'>Cascade on delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_gsim_group_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/gsim_accounts.html'>gsim_accounts</a><span>.group_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group.html'>m_group</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_interest_incentives_m_interest_rate_slab</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_interest_incentives.html'>m_interest_incentives</a><span>.interest_rate_slab_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_interest_rate_slab.html'>m_interest_rate_slab</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loan_reschedule_request_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_reschedule_request.html'>m_loan_reschedule_request</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loan_reschedule_request_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_reschedule_request.html'>m_loan_reschedule_request</a><span>.reschedule_reason_cv_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loan_reschedule_request_ibfk_3</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_reschedule_request.html'>m_loan_reschedule_request</a><span>.submitted_by_user_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loan_reschedule_request_ibfk_4</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_reschedule_request.html'>m_loan_reschedule_request</a><span>.approved_by_user_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loan_reschedule_request_ibfk_5</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_reschedule_request.html'>m_loan_reschedule_request</a><span>.rejected_by_user_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_guarantor_m_code_value</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_guarantor.html'>m_guarantor</a><span>.client_reln_cv_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_guarantor_m_loan</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_guarantor.html'>m_guarantor</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_account_transfer_standing_instructions_m_history</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_standing_instructions_history.html'>m_account_transfer_standing_instructions_history</a><span>.standing_instruction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_standing_instructions.html'>m_account_transfer_standing_instructions</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loan_topup_FK_closure_loan_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_topup.html'>m_loan_topup</a><span>.closure_loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loan_topup_FK_loan_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_topup.html'>m_loan_topup</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loan_topup_FK_account_transfer_details_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_topup.html'>m_loan_topup</a><span>.account_transfer_details_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_details.html'>m_account_transfer_details</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_account_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account.html'>m_share_account</a><span>.savings_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_account_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account.html'>m_share_account</a><span>.product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_product.html'>m_share_product</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_account_ibfk_4</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account.html'>m_share_account</a><span>.approved_userid</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_account_ibfk_3</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account.html'>m_share_account</a><span>.submitted_userid</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_account_ibfk_6</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account.html'>m_share_account</a><span>.activated_userid</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_account_ibfk_5</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account.html'>m_share_account</a><span>.rejected_userid</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_account_ibfk_8</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account.html'>m_share_account</a><span>.lastmodifiedby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_account_ibfk_7</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account.html'>m_share_account</a><span>.closed_userid</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_account_ibfk_9</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account.html'>m_share_account</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_x_code_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/x_table_column_code_mappings.html'>x_table_column_code_mappings</a><span>.code_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code.html'>m_code</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK__m_appuser__pocket</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_pocket.html'>m_pocket</a><span>.app_user_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_loan_overdue_installment_charge_m_loan_repayment_schedule</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_overdue_installment_charge.html'>m_loan_overdue_installment_charge</a><span>.loan_schedule_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_repayment_schedule.html'>m_loan_repayment_schedule</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_loan_overdue_installment_charge_m_loan_charge</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_overdue_installment_charge.html'>m_loan_overdue_installment_charge</a><span>.loan_charge_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_charge.html'>m_loan_charge</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_gl_closure_m_appuser_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_closure.html'>acc_gl_closure</a><span>.lastmodifiedby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_gl_closure_m_office</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_closure.html'>acc_gl_closure</a><span>.office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_gl_closure_m_appuser</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_closure.html'>acc_gl_closure</a><span>.createdby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_loan_tranche_disbursement_charge_m_loan_charge</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_tranche_disbursement_charge.html'>m_loan_tranche_disbursement_charge</a><span>.loan_charge_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_charge.html'>m_loan_charge</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_loan_tranche_disbursement_charge_m_loan_disbursement_detail</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_tranche_disbursement_charge.html'>m_loan_tranche_disbursement_charge</a><span>.disbursement_detail_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_disbursement_detail.html'>m_loan_disbursement_detail</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_report_mailing_job_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_report_mailing_job.html'>m_report_mailing_job</a><span>.createdby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_report_mailing_job_ibfk_4</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_report_mailing_job.html'>m_report_mailing_job</a><span>.run_as_userid</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_report_mailing_job_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_report_mailing_job.html'>m_report_mailing_job</a><span>.lastmodifiedby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_report_mailing_job_ibfk_3</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_report_mailing_job.html'>m_report_mailing_job</a><span>.stretchy_report_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/stretchy_report.html'>stretchy_report</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK1E37728B783C5C25</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office_transaction.html'>m_office_transaction</a><span>.from_office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK1E37728B93C6C1B6</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office_transaction.html'>m_office_transaction</a><span>.to_office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_deposit_on_hold_transaction_m_savings_account</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_deposit_account_on_hold_transaction.html'>m_deposit_account_on_hold_transaction</a><span>.savings_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_hook_template_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_hook_schema.html'>m_hook_schema</a><span>.hook_template_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_hook_templates.html'>m_hook_templates</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_savings_interest_incentives_m_savings_interest_rate_slab</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_interest_incentives.html'>m_savings_interest_incentives</a><span>.deposit_account_interest_rate_slab_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_interest_rate_slab.html'>m_savings_account_interest_rate_slab</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_hook_id_cfg</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_hook_configuration.html'>m_hook_configuration</a><span>.hook_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_hook.html'>m_hook</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_family_members_client_id_m_client</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_family_members.html'>m_family_members</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_family_members_marital_status_m_code_value</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_family_members.html'>m_family_members</a><span>.marital_status_cv_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_family_members_relationship_m_code_value</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_family_members.html'>m_family_members</a><span>.relationship_cv_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_family_members_gender_m_code_value</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_family_members.html'>m_family_members</a><span>.gender_cv_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_family_members_profession_m_code_value</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_family_members.html'>m_family_members</a><span>.profession_cv_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_template_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_hook.html'>m_hook</a><span>.template_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_hook_templates.html'>m_hook_templates</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_ugd_template_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_hook.html'>m_hook</a><span>.ugd_template_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_template.html'>m_template</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_tax_component_history_lastmodifiedby</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_component_history.html'>m_tax_component_history</a><span>.lastmodifiedby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_tax_component_history_createdby</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_component_history.html'>m_tax_component_history</a><span>.createdby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_tax_component_history_tax_component_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_component_history.html'>m_tax_component_history</a><span>.tax_component_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_component.html'>m_tax_component</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loan_arrears_aging_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_arrears_aging.html'>m_loan_arrears_aging</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKDARD00000000000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_deposit_account_recurring_detail.html'>m_deposit_account_recurring_detail</a><span>.savings_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_interop_identifier_account</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/interop_identifier.html'>interop_identifier</a><span>.account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_product_charge_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_product_charge.html'>m_share_product_charge</a><span>.charge_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_charge.html'>m_charge</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_product_charge_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_product_charge.html'>m_share_product_charge</a><span>.product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_product.html'>m_share_product</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_loan_disbursement_detail_loan_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_disbursement_detail.html'>m_loan_disbursement_detail</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_grouprole_m_codevalue</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group_roles.html'>m_group_roles</a><span>.role_cv_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKGroupRoleGroupId</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group_roles.html'>m_group_roles</a><span>.group_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group.html'>m_group</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKGroupRoleClientId</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group_roles.html'>m_group_roles</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_loan_schedule_id_charge_schedule</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_installment_charge.html'>m_loan_installment_charge</a><span>.loan_schedule_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_repayment_schedule.html'>m_loan_repayment_schedule</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_loan_charge_id_charge_schedule</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_installment_charge.html'>m_loan_installment_charge</a><span>.loan_charge_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_charge.html'>m_loan_charge</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_m_savings_product</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.default_savings_product</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_product.html'>m_savings_product</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_substatus_m_code_value</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.sub_status</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_m_staff</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.staff_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_staff.html'>m_staff</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK1_m_client_gender_m_code_value</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.gender_cv_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_m_code</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.closure_reason_cv_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_m_image</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.image_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_image.html'>m_image</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_type_mcode_value_reject</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.reject_reason_cv_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKCE00CAB3E0DD567A</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_type_m_code_value_withdraw</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.withdraw_reason_cv_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_m_office</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.transfer_to_office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_classification_m_code_value</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.client_classification_cv_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_type_m_code_value</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.client_type_cv_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_m_savings_account</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.default_savings_account</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_hook_idc</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_hook_registered_events.html'>m_hook_registered_events</a><span>.hook_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_hook.html'>m_hook</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_M_PRODUCT_LOAN_RATE_LOAN</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan_rate.html'>m_product_loan_rate</a><span>.product_loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan.html'>m_product_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_M_PRODUCT_LOAN_RATE_RATE</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan_rate.html'>m_product_loan_rate</a><span>.rate_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_rate.html'>m_rate</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_guarantor_transaction_guarantor_fund_detail</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_guarantor_transaction.html'>m_guarantor_transaction</a><span>.guarantor_fund_detail_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_guarantor_funding_details.html'>m_guarantor_funding_details</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_guarantor_transaction_m_deposit_account_on_hold_transaction</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_guarantor_transaction.html'>m_guarantor_transaction</a><span>.deposit_on_hold_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_deposit_account_on_hold_transaction.html'>m_deposit_account_on_hold_transaction</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_guarantor_transaction_m_loan_transaction</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_guarantor_transaction.html'>m_guarantor_transaction</a><span>.loan_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_transaction.html'>m_loan_transaction</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK__m_savings_account_transaction</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_charge_paid_by.html'>m_savings_account_charge_paid_by</a><span>.savings_account_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_transaction.html'>m_savings_account_transaction</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK__m_savings_account_charge</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_charge_paid_by.html'>m_savings_account_charge_paid_by</a><span>.savings_account_charge_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_charge.html'>m_savings_account_charge</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_provisioning_history_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_provisioning_history.html'>m_provisioning_history</a><span>.createdby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_provisioning_history_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_provisioning_history.html'>m_provisioning_history</a><span>.lastmodifiedby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_client_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_non_person.html'>m_client_non_person</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_guarantor_fund_details_account_associations_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_guarantor_funding_details.html'>m_guarantor_funding_details</a><span>.account_associations_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_portfolio_account_associations.html'>m_portfolio_account_associations</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_guarantor_fund_details_m_guarantor</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_guarantor_funding_details.html'>m_guarantor_funding_details</a><span>.guarantor_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_guarantor.html'>m_guarantor</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fkrepaymentwithpostdated</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_repayment_with_post_dated_checks.html'>m_repayment_with_post_dated_checks</a><span>.repayment_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_repayment_schedule.html'>m_loan_repayment_schedule</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Cascade on delete: Deletion of parent deletes child'>Cascade on delete</span></td> |
| </tr> |
| <tr> |
| <td>fkloanrepayment</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_repayment_with_post_dated_checks.html'>m_repayment_with_post_dated_checks</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Cascade on delete: Deletion of parent deletes child'>Cascade on delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_office_mapping_acc_gl_account</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_financial_activity_account.html'>acc_gl_financial_activity_account</a><span>.gl_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_account.html'>acc_gl_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_product_mapping_m_payment_type</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_product_mapping.html'>acc_product_mapping</a><span>.payment_type</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_payment_type.html'>m_payment_type</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_acc_product_mapping_m_charge</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_product_mapping.html'>acc_product_mapping</a><span>.charge_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_charge.html'>m_charge</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_savings_product_tax_group</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_product.html'>m_savings_product</a><span>.tax_group_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_group.html'>m_tax_group</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loan_charge_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_charge.html'>m_loan_charge</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loan_charge_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_charge.html'>m_loan_charge</a><span>.charge_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_charge.html'>m_charge</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_M_RATE_APPROVE_USER</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_rate.html'>m_rate</a><span>.approve_user</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_M_RATE_CREATE_USER</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_rate.html'>m_rate</a><span>.createdby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_stretchy_parameter_001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/stretchy_parameter.html'>stretchy_parameter</a><span>.parent_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/stretchy_parameter.html'>stretchy_parameter</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_tax_component_credit_gl_account</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_component.html'>m_tax_component</a><span>.credit_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_account.html'>acc_gl_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_tax_component_debit_gl_account</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_component.html'>m_tax_component</a><span>.debit_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/acc_gl_account.html'>acc_gl_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_tax_component_createdby</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_component.html'>m_tax_component</a><span>.createdby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_tax_component_lastmodifiedby</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_component.html'>m_tax_component</a><span>.lastmodifiedby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_account_purchased_shares_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account_transactions.html'>m_share_account_transactions</a><span>.account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account.html'>m_share_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_account_transfer_transaction_from_m_loan_transaction</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_transaction.html'>m_account_transfer_transaction</a><span>.from_loan_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_transaction.html'>m_loan_transaction</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_account_transfer_transaction_account_detail</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_transaction.html'>m_account_transfer_transaction</a><span>.account_transfer_details_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_details.html'>m_account_transfer_details</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_account_transfer_transaction_to_m_savings_transaction</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_transaction.html'>m_account_transfer_transaction</a><span>.to_savings_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_transaction.html'>m_savings_account_transaction</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_account_transfer_transaction_to_m_loan_transaction</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_transaction.html'>m_account_transfer_transaction</a><span>.to_loan_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_transaction.html'>m_loan_transaction</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_account_transfer_transaction_from_m_savings_transaction</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_account_transfer_transaction.html'>m_account_transfer_transaction</a><span>.from_savings_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_transaction.html'>m_savings_account_transaction</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_loan_ltp_strategy</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.loan_transaction_strategy_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/ref_loan_transaction_processing_strategy.html'>ref_loan_transaction_processing_strategy</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_closedon_userid</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.closedon_userid</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loan_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.group_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group.html'>m_group</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKB6F935D87179A0CB</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_loan_m_staff</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.loan_officer_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_staff.html'>m_staff</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK7C885877240145</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.fund_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_fund.html'>m_fund</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_rejectedon_userid</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.rejectedon_userid</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_glim_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.glim_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/glim_accounts.html'>glim_accounts</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_withdrawnon_userid</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.withdrawnon_userid</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_loanpurpose_codevalue</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.loanpurpose_cv_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_writeoffreason_m_loan_m_code_value</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.writeoff_reason_cv_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_disbursedon_userid</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.disbursedon_userid</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_submittedon_userid</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.submittedon_userid</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_approvedon_userid</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.approvedon_userid</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKB6F935D8C8D4B434</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan.html'>m_product_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKSAIRC00000000000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_interest_rate_chart.html'>m_savings_account_interest_rate_chart</a><span>.savings_account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account.html'>m_savings_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_account_charge_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account_charge.html'>m_share_account_charge</a><span>.account_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account.html'>m_share_account</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_account_charge_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account_charge.html'>m_share_account_charge</a><span>.charge_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_charge.html'>m_charge</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_account_transactions_charge_mapping_ibfk1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account_charge_paid_by.html'>m_share_account_charge_paid_by</a><span>.share_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account_transactions.html'>m_share_account_transactions</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_share_account_transactions_charge_mapping_ibfk2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account_charge_paid_by.html'>m_share_account_charge_paid_by</a><span>.charge_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_account_charge.html'>m_share_account_charge</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_survey_components_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_survey_components.html'>m_survey_components</a><span>.survey_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_surveys.html'>m_surveys</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_provisioning_criteria_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_provisioning_criteria.html'>m_provisioning_criteria</a><span>.lastmodifiedby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_provisioning_criteria_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_provisioning_criteria.html'>m_provisioning_criteria</a><span>.createdby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_import_m_document</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_import_document.html'>m_import_document</a><span>.document_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_document.html'>m_document</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_import_m_appuser</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_import_document.html'>m_import_document</a><span>.createdby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loanproduct_provisioning_mapping_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loanproduct_provisioning_mapping.html'>m_loanproduct_provisioning_mapping</a><span>.criteria_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_provisioning_criteria.html'>m_provisioning_criteria</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loanproduct_provisioning_mapping_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loanproduct_provisioning_mapping.html'>m_loanproduct_provisioning_mapping</a><span>.product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan.html'>m_product_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_savings_product_charge_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_product_charge.html'>m_savings_product_charge</a><span>.charge_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_charge.html'>m_charge</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_savings_product_charge_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_product_charge.html'>m_savings_product_charge</a><span>.savings_product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_product.html'>m_savings_product</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_group_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/glim_accounts.html'>glim_accounts</a><span>.group_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group.html'>m_group</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_charge_paid_by_m_client_charge</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_charge_paid_by.html'>m_client_charge_paid_by</a><span>.client_charge_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_charge.html'>m_client_charge</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_charge_paid_by_m_client_transaction</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_charge_paid_by.html'>m_client_charge_paid_by</a><span>.client_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_transaction.html'>m_client_transaction</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_survey_questions_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_survey_questions.html'>m_survey_questions</a><span>.survey_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_surveys.html'>m_surveys</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_payment_detail_m_payment_type</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_payment_detail.html'>m_payment_detail</a><span>.payment_type_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_payment_type.html'>m_payment_type</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_calendar_m_calendar_instance</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_calendar_instance.html'>m_calendar_instance</a><span>.calendar_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_calendar.html'>m_calendar</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_mappings_m_product_loan_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan_floating_rates.html'>m_product_loan_floating_rates</a><span>.loan_product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan.html'>m_product_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_mappings_m_floating_rates_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan_floating_rates.html'>m_product_loan_floating_rates</a><span>.floating_rates_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_floating_rates.html'>m_floating_rates</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_appuser_previous_password_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser_previous_password.html'>m_appuser_previous_password</a><span>.user_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>sms_campaign_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/sms_campaign.html'>sms_campaign</a><span>.report_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/stretchy_report.html'>stretchy_report</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>cbId</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_creditreport.html'>m_creditreport</a><span>.credit_bureau_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_creditbureau.html'>m_creditbureau</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loan_repayment_schedule_history_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_repayment_schedule_history.html'>m_loan_repayment_schedule_history</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_loan_repayment_schedule_history_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_repayment_schedule_history.html'>m_loan_repayment_schedule_history</a><span>.loan_reschedule_request_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_reschedule_request.html'>m_loan_reschedule_request</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_savings_account_transaction_tax_details_tax_component</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_transaction_tax_details.html'>m_savings_account_transaction_tax_details</a><span>.tax_component_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_component.html'>m_tax_component</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_savings_account_transaction_tax_details_savings_transaction</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_transaction_tax_details.html'>m_savings_account_transaction_tax_details</a><span>.savings_transaction_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_savings_account_transaction.html'>m_savings_account_transaction</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>lastmodifiedby_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_adhoc.html'>m_adhoc</a><span>.lastmodifiedby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>createdby_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_adhoc.html'>m_adhoc</a><span>.createdby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_share_product_dividend_pay_out_lastmodifiedby_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_product_dividend_pay_out.html'>m_share_product_dividend_pay_out</a><span>.lastmodifiedby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_share_product_dividend_pay_out_product_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_product_dividend_pay_out.html'>m_share_product_dividend_pay_out</a><span>.product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_product.html'>m_share_product</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_share_product_dividend_pay_out_createdby_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_share_product_dividend_pay_out.html'>m_share_product_dividend_pay_out</a><span>.createdby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK__m_pocket</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_pocket_accounts_mapping.html'>m_pocket_accounts_mapping</a><span>.pocket_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_pocket.html'>m_pocket</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKA6A8A7D77240145</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan.html'>m_product_loan</a><span>.fund_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_fund.html'>m_fund</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_ltp_strategy</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan.html'>m_product_loan</a><span>.loan_transaction_strategy_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/ref_loan_transaction_processing_strategy.html'>ref_loan_transaction_processing_strategy</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_cb_lp2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_creditbureau_loanproduct_mapping.html'>m_creditbureau_loanproduct_mapping</a><span>.loan_product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan.html'>m_product_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>cblpfk2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_creditbureau_loanproduct_mapping.html'>m_creditbureau_loanproduct_mapping</a><span>.organisation_creditbureau_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_organisation_creditbureau.html'>m_organisation_creditbureau</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_loan_id_m_loan_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_term_variations.html'>m_loan_term_variations</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_m_loan_officer_assignment_history_0001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_officer_assignment_history.html'>m_loan_officer_assignment_history</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_m_loan_officer_assignment_history_0002</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_officer_assignment_history.html'>m_loan_officer_assignment_history</a><span>.loan_officer_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_staff.html'>m_staff</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>address_codefk</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_address.html'>m_client_address</a><span>.address_type_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>clientaddressfk</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_address.html'>m_client_address</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKCFCEA42640BE071Z</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code_value.html'>m_code_value</a><span>.code_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_code.html'>m_code</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fkCollateral</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_collateral_management.html'>m_client_collateral_management</a><span>.collateral_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_collateral_management.html'>m_collateral_management</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Cascade on delete: Deletion of parent deletes child'>Cascade on delete</span></td> |
| </tr> |
| <tr> |
| <td>fkClient</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_collateral_management.html'>m_client_collateral_management</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Cascade on delete: Deletion of parent deletes child'>Cascade on delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_transaction_m_appuser</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_transaction.html'>m_client_transaction</a><span>.appuser_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_transaction_m_client</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_transaction.html'>m_client_transaction</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKIRS00000000000001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_interest_rate_slab.html'>m_interest_rate_slab</a><span>.interest_rate_chart_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_interest_rate_chart.html'>m_interest_rate_chart</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_staff_assignment_history_centre_id_m_group</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_staff_assignment_history.html'>m_staff_assignment_history</a><span>.centre_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group.html'>m_group</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_staff_assignment_history_m_staff</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_staff_assignment_history.html'>m_staff_assignment_history</a><span>.staff_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_staff.html'>m_staff</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_selfservice_appuser_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_selfservice_user_client_mapping.html'>m_selfservice_user_client_mapping</a><span>.appuser_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_selfservice_client_id</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_selfservice_user_client_mapping.html'>m_selfservice_user_client_mapping</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_charge_m_charge</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_charge.html'>m_client_charge</a><span>.charge_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_charge.html'>m_charge</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_charge_m_client</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_charge.html'>m_client_charge</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>orgcb_cbfk</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_organisation_creditbureau.html'>m_organisation_creditbureau</a><span>.creditbureau_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_creditbureau.html'>m_creditbureau</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK8DEDB048103B544B</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_role_permission.html'>m_role_permission</a><span>.permission_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_permission.html'>m_permission</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK8DEDB04815CEC7AB</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_role_permission.html'>m_role_permission</a><span>.role_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_role.html'>m_role</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_tax_group_mappings_tax_group</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_group_mappings.html'>m_tax_group_mappings</a><span>.tax_group_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_group.html'>m_tax_group</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_tax_group_mappings_lastmodifiedby</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_group_mappings.html'>m_tax_group_mappings</a><span>.lastmodifiedby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_tax_group_mappings_createdby</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_group_mappings.html'>m_tax_group_mappings</a><span>.createdby_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_tax_group_mappings_tax_component</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_group_mappings.html'>m_tax_group_mappings</a><span>.tax_component_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_tax_component.html'>m_tax_component</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_product_loan_charge_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan_charge.html'>m_product_loan_charge</a><span>.charge_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_charge.html'>m_charge</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_product_loan_charge_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan_charge.html'>m_product_loan_charge</a><span>.product_loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan.html'>m_product_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_loan_tranche_charges_m_charge</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_tranche_charges.html'>m_loan_tranche_charges</a><span>.charge_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_charge.html'>m_charge</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_loan_tranche_charges_m_loan</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_tranche_charges.html'>m_loan_tranche_charges</a><span>.loan_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan.html'>m_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_group_client_ibfk_1</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group_client.html'>m_group_client</a><span>.group_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group.html'>m_group</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>m_group_client_ibfk_2</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_group_client.html'>m_group_client</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_m_product_loan_configurable_attributes_0001</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan_configurable_attributes.html'>m_product_loan_configurable_attributes</a><span>.loan_product_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_product_loan.html'>m_product_loan</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_checker_m_appuser</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_portfolio_command_source.html'>m_portfolio_command_source</a><span>.checker_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_maker_m_appuser</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_portfolio_command_source.html'>m_portfolio_command_source</a><span>.maker_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK__m_loan_reschedule_request</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_reschedule_request_term_variations_mapping.html'>m_loan_reschedule_request_term_variations_mapping</a><span>.loan_reschedule_request_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_reschedule_request.html'>m_loan_reschedule_request</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK__m_loan_term_variations</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_reschedule_request_term_variations_mapping.html'>m_loan_reschedule_request_term_variations_mapping</a><span>.loan_term_variations_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_loan_term_variations.html'>m_loan_term_variations</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FKB3D587CE0DD567A</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.office_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_office.html'>m_office</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>fk_m_appuser_002</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_appuser.html'>m_appuser</a><span>.staff_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_staff.html'>m_staff</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_client_m_client_attendance</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_attendance.html'>m_client_attendance</a><span>.client_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client.html'>m_client</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| <tr> |
| <td>FK_m_meeting_m_client_attendance</td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_client_attendance.html'>m_client_attendance</a><span>.meeting_id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td> |
| <table border='0' cellspacing='0' cellpadding='0'> |
| <tr> |
| <td><a href='tables/m_meeting.html'>m_meeting</a><span>.id</span></td> |
| </tr> |
| </table> |
| </td> |
| <td><span title='Restrict delete: Parent cannot be deleted if children exist'>Restrict delete</span></td> |
| </tr> |
| </tbody> |
| </table> |
| </div> |
| </div> |
| <div class="box box-primary"> |
| <div class="box-header with-border"> |
| <i class="fa fa-sitemap"></i> |
| <h3 class="box-title">Check Constraints</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="check_table" class="table table-bordered table-striped dataTable" role="grid"> |
| <thead align='left'> |
| <tr> |
| <th>Table</th> |
| <th>Constraint Name</th> |
| <th>Constraint</th> |
| </tr> |
| </thead> |
| <tbody> |
| </tbody> |
| </table> |
| </div> |
| </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="constraint.js"></script> |
| <script src="schemaSpy.js"></script> |
| </body> |
| </html> |
