| <!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> |
|
