| <!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>Columns</h1> |
| </section> |
| <!-- Main content --> |
| <section class="content"> |
| <div class="box box-primary"> |
| <div class="box-header with-border"> |
| <span class="glyphicon glyphicon-list-alt" aria-hidden="true"></span> |
| <h3 class="box-title">Columns</h3> |
| </div> |
| <div class="box-body"> |
| <table id="column_table" class="table table-bordered table-striped dataTable" role="grid"> |
| <thead align='left'> |
| <tr> |
| <th>Table</th> |
| <th>Type</th> |
| <th>Column</th> |
| <th>Type</th> |
| <th>Size</th> |
| <th title='Are nulls allowed?'>Nullable</th> |
| <th title='Is column automatically updated?'>Auto</th> |
| <th title='Default value'>Default</th> |
| <th title='Comments' class="toggle"><span>Comments</span></th> |
| </tr> |
| </thead> |
| <tbody></tbody> |
| </table> |
| </div> |
| </div> |
| </section> |
| <script> |
| var tableData = [ |
| { |
| "tableName": "m_deposit_account_on_hold_transaction", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>savings_account_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_transaction", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "appuser_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "sms_campaign", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "recurrence_start_date", |
| "type": "DATETIME", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_calendar_history", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "duration", |
| "type": "SMALLINT", |
| "length": 5, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_address", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "address_line_1", |
| "type": "VARCHAR", |
| "length": 100, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "notification_mapper", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_template", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "entity", |
| "type": "INT", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loanproduct_provisioning_entry", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>office_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_staff", |
| "tableType": "Table", |
| "keyClass": "indexedColumn", |
| "keyTitle": "Indexed", |
| "name": "<i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'><\/i>external_id", |
| "type": "VARCHAR", |
| "length": 100, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_share_account_transactions", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "amount", |
| "type": "DECIMAL", |
| "length": 20, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_guarantor", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "comment", |
| "type": "VARCHAR", |
| "length": 500, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_mandatory_savings_schedule", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "deposit_amount_completed_derived", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_product_loan", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>fund_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_deposit_product_interest_rate_chart", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>interest_rate_chart_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "principal_disbursed_derived", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "0.000000", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_organisation_creditbureau", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "is_active", |
| "type": "BIT", |
| "length": 1, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "glim_accounts", |
| "tableType": "Table", |
| "keyClass": "indexedColumn", |
| "keyTitle": "Indexed", |
| "name": "<i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'><\/i>account_number", |
| "type": "VARCHAR", |
| "length": 50, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client_charge", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "charge_time_enum", |
| "type": "SMALLINT", |
| "length": 5, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_staff", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "lastname", |
| "type": "VARCHAR", |
| "length": 50, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "r_enum_value", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>enum_name", |
| "type": "VARCHAR", |
| "length": 100, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client_identifier", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "created_date", |
| "type": "DATETIME", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_product_loan_variable_installment_config", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "minimum_gap", |
| "type": "INT", |
| "length": 10, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_product_loan", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "principal_amount", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_tax_group_mappings", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>tax_component_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_entity_to_entity_access", |
| "tableType": "Table", |
| "keyClass": "indexedColumn", |
| "keyTitle": "Indexed", |
| "name": "<i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'><\/i>entity_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_pocket_accounts_mapping", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>pocket_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_portfolio_command_source", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "loan_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "acc_product_mapping", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "product_type", |
| "type": "SMALLINT", |
| "length": 5, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_creditbureau_configuration", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>organisation_creditbureau_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_share_product_dividend_pay_out", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "status", |
| "type": "SMALLINT", |
| "length": 5, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_account_transaction_tax_details", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>savings_transaction_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_share_product_dividend_pay_out", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "lastmodified_date", |
| "type": "DATETIME", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_recalculation_details", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "compounding_frequency_on_day", |
| "type": "INT", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_adhoc", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_share_account_charge_paid_by", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "amount", |
| "type": "DECIMAL", |
| "length": 20, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client_identifier", |
| "tableType": "Table", |
| "keyClass": "indexedColumn", |
| "keyTitle": "Indexed", |
| "name": "<i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'><\/i>active", |
| "type": "INT", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_share_account", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>approved_userid", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "closedon_date", |
| "type": "DATE", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_repayment_schedule", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "recalculated_interest_component", |
| "type": "BIT", |
| "length": 1, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "b'0'", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_working_days", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_provisioning_criteria", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "created_date", |
| "type": "DATETIME", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_officer_assignment_history", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>loan_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_recalculation_details", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "rest_frequency_weekday_enum", |
| "type": "INT", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "request_audit_table", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "account_number", |
| "type": "VARCHAR", |
| "length": 100, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_staff_assignment_history", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "lastmodifiedby_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_guarantor_funding_details", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>guarantor_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_rate", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "created_date", |
| "type": "DATETIME", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_product", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "days_to_escheat", |
| "type": "INT", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_account_interest_rate_slab", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "to_period", |
| "type": "INT", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_hook_configuration", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>hook_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_trial_balance", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "entry_date", |
| "type": "DATE", |
| "length": 10, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_selfservice_beneficiaries_tpt", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "office_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_family_members", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "is_dependent", |
| "type": "BIT", |
| "length": 1, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_calendar", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "remind_by_enum", |
| "type": "SMALLINT", |
| "length": 5, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client_charge", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "amount_outstanding_derived", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_account", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "submittedon_date", |
| "type": "DATE", |
| "length": 10, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_share_account", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "lastmodified_date", |
| "type": "DATETIME", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client_transaction", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>client_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "updated_by", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "sms_campaign", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "closedon_date", |
| "type": "DATE", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_code_value", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "code_description", |
| "type": "VARCHAR", |
| "length": 500, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_group", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>closure_reason_cv_id", |
| "type": "INT", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client_identifier", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "lastmodifiedby_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_deposit_account_term_and_preclosure", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "deposit_period", |
| "type": "INT", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "middlename", |
| "type": "VARCHAR", |
| "length": 50, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "stretchy_parameter", |
| "tableType": "Table", |
| "keyClass": "indexedColumn", |
| "keyTitle": "Indexed", |
| "name": "<i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'><\/i>parameter_name", |
| "type": "VARCHAR", |
| "length": 45, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_password_validation_policy", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "key", |
| "type": "VARCHAR", |
| "length": 255, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "stretchy_parameter", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "selectOne", |
| "type": "VARCHAR", |
| "length": 1, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "DATABASECHANGELOGLOCK", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>ID", |
| "type": "INT", |
| "length": 10, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "interest_writtenoff_derived", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "0.000000", |
| "comments": "" |
| }, |
| { |
| "tableName": "stretchy_report", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "report_subtype", |
| "type": "VARCHAR", |
| "length": 20, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_interest_rate_chart", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_note", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>lastmodifiedby_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_code", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "is_system_defined", |
| "type": "BIT", |
| "length": 1, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "b'0'", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_deposit_product_term_and_preclosure", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "max_deposit_term", |
| "type": "INT", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_share_product", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "created_date", |
| "type": "DATETIME", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_transaction_repayment_schedule_mapping", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>loan_transaction_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "acc_gl_journal_entry", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>office_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_survey_responses", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>question_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "fixed_principal_percentage_per_installment", |
| "type": "DECIMAL", |
| "length": 5, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_surveys", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "description", |
| "type": "VARCHAR", |
| "length": 4000, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_tax_component", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>debit_account_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_charge", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "min_cap", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_account", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "sub_status_enum", |
| "type": "SMALLINT", |
| "length": 5, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "0", |
| "comments": "" |
| }, |
| { |
| "tableName": "stretchy_report_parameter", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "INT", |
| "length": 10, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_share_account_transactions", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "charge_amount", |
| "type": "DECIMAL", |
| "length": 20, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_share_account_charge", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_arrears_aging", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "penalty_charges_overdue_derived", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "0.000000", |
| "comments": "" |
| }, |
| { |
| "tableName": "oauth_access_token", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "refresh_token", |
| "type": "VARCHAR", |
| "length": 256, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_paid_in_advance", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "penalty_charges_in_advance_derived", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "0.000000", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "repay_every", |
| "type": "SMALLINT", |
| "length": 5, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_staff", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "email_address", |
| "type": "VARCHAR", |
| "length": 150, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_share_product_dividend_pay_out", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>createdby_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_share_account", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "submitted_date", |
| "type": "DATE", |
| "length": 10, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>default_savings_product", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_guarantor", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "lastname", |
| "type": "VARCHAR", |
| "length": 50, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "job_parameters", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "parameter_value", |
| "type": "INT", |
| "length": 10, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_product_loan_recalculation_details", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "is_compounding_to_be_posted_as_transaction", |
| "type": "BIT", |
| "length": 1, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "b'0'", |
| "comments": "" |
| }, |
| { |
| "tableName": "topic", |
| "tableType": "Table", |
| "keyClass": "indexedColumn", |
| "keyTitle": "Indexed", |
| "name": "<i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'><\/i>title", |
| "type": "VARCHAR", |
| "length": 100, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_report_mailing_job_run_history", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "error_log", |
| "type": "TEXT", |
| "length": 65535, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_tax_group", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>lastmodifiedby_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_account_transaction", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>office_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_meeting", |
| "tableType": "Table", |
| "keyClass": "indexedColumn", |
| "keyTitle": "Indexed", |
| "name": "<i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'><\/i>meeting_date", |
| "type": "DATE", |
| "length": 10, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client_charge_paid_by", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>client_charge_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_product_loan", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "max_nominal_interest_rate_per_period", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_portfolio_account_associations", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_product", |
| "tableType": "Table", |
| "keyClass": "indexedColumn", |
| "keyTitle": "Indexed", |
| "name": "<i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'><\/i>short_name", |
| "type": "VARCHAR", |
| "length": 4, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_charge", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "is_penalty", |
| "type": "BIT", |
| "length": 1, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "b'0'", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "penalty_charges_repaid_derived", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "0.000000", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_tax_group", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "name", |
| "type": "VARCHAR", |
| "length": 50, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_product", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "lockin_period_frequency", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_rate", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>rate_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_share_account_transactions", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_interest_rate_slab", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client_identifier", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "job_run_history", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>job_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_interest_incentives", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_holiday", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "rescheduling_type", |
| "type": "INT", |
| "length": 10, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "2", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "penalty_charges_waived_derived", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "0.000000", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_creditbureau_configuration", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "description", |
| "type": "VARCHAR", |
| "length": 50, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "mix_taxonomy", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "need_mapping", |
| "type": "BIT", |
| "length": 1, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "acc_gl_account", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>parent_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_product_loan_recalculation_details", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "rest_frequency_nth_day_enum", |
| "type": "INT", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "interest_waived_derived", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "0.000000", |
| "comments": "" |
| }, |
| { |
| "tableName": "acc_gl_journal_entry", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "entry_date", |
| "type": "DATE", |
| "length": 10, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_product_loan_recalculation_details", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "compounding_frequency_weekday_enum", |
| "type": "INT", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>transfer_to_office_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "date_of_birth", |
| "type": "DATE", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "fullname", |
| "type": "VARCHAR", |
| "length": 100, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "scheduled_email_messages_outbound", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "status_enum", |
| "type": "INT", |
| "length": 10, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "100", |
| "comments": "" |
| }, |
| { |
| "tableName": "acc_rule_tags", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_officer_assignment_history", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "created_date", |
| "type": "DATETIME", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_share_account_transactions", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "total_shares", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_tax_component", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "credit_account_type_enum", |
| "type": "SMALLINT", |
| "length": 5, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_provisioning_criteria", |
| "tableType": "Table", |
| "keyClass": "indexedColumn", |
| "keyTitle": "Indexed", |
| "name": "<i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'><\/i>criteria_name", |
| "type": "VARCHAR", |
| "length": 200, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_mandatory_savings_schedule", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>savings_account_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_note", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "created_date", |
| "type": "DATETIME", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client_collateral_management", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_permission", |
| "tableType": "Table", |
| "keyClass": "indexedColumn", |
| "keyTitle": "Indexed", |
| "name": "<i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'><\/i>code", |
| "type": "VARCHAR", |
| "length": 100, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_portfolio_command_source", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "product_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "is_staff", |
| "type": "BIT", |
| "length": 1, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "b'0'", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_account", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "lockin_period_frequency_enum", |
| "type": "SMALLINT", |
| "length": 5, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_share_account_charge", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "charge_payment_mode_enum", |
| "type": "SMALLINT", |
| "length": 5, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "0", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_floating_rates_periods", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "is_differential_to_base_lending_rate", |
| "type": "BIT", |
| "length": 1, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "b'0'", |
| "comments": "" |
| }, |
| { |
| "tableName": "ppi_scores", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "score_from", |
| "type": "INT", |
| "length": 10, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>sub_status", |
| "type": "INT", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_interest_incentives", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "entiry_type", |
| "type": "SMALLINT", |
| "length": 5, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_overdue_installment_charge", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "frequency_number", |
| "type": "INT", |
| "length": 10, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_guarantor_funding_details", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_repayment_schedule", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "createdby_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_repayment_with_post_dated_checks", |
| "tableType": "Table", |
| "keyClass": "indexedColumn", |
| "keyTitle": "Indexed", |
| "name": "<i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'><\/i>check_no", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "notification_generator", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "object_identifier", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_share_product", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "allow_dividends_inactive_clients", |
| "type": "BIT", |
| "length": 1, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "b'0'", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_arrears_aging", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "interest_overdue_derived", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "0.000000", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_report_mailing_job", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "previous_run_error_message", |
| "type": "TEXT", |
| "length": 65535, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_guarantor_transaction", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_hook_templates", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "SMALLINT", |
| "length": 5, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_interest_rate_slab", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "description", |
| "type": "VARCHAR", |
| "length": 200, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_tax_group_mappings", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>tax_group_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_account_interest_rate_slab", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "oauth_access_token", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "token", |
| "type": "BLOB", |
| "length": 65535, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_portfolio_command_source", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>maker_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_charge_paid_by", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "installment_number", |
| "type": "SMALLINT", |
| "length": 5, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_account_transfer_transaction", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>from_loan_transaction_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_product_loan", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "over_applied_number", |
| "type": "INT", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_appuser", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>office_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_repayment_schedule", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "principal_writtenoff_derived", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_account_interest_rate_slab", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>savings_account_interest_rate_chart_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_account_transfer_details", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>to_loan_account_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_tax_component", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "debit_account_type_enum", |
| "type": "SMALLINT", |
| "length": 5, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_account_transfer_standing_instructions_history", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>standing_instruction_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_family_members", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "qualification", |
| "type": "VARCHAR", |
| "length": 50, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_group_client", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>group_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_account", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "status_enum", |
| "type": "SMALLINT", |
| "length": 5, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "300", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_account_charge", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "amount_writtenoff_derived", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "notification_generator", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "actor", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_share_account_charge", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "amount", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client_transaction", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "scheduled_email_campaign", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "is_visible", |
| "type": "BIT", |
| "length": 1, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "b'1'", |
| "comments": "" |
| }, |
| { |
| "tableName": "twofactor_access_token", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "valid_to", |
| "type": "DATETIME", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_holiday", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "to_date", |
| "type": "DATETIME", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "DATABASECHANGELOG", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "EXECTYPE", |
| "type": "VARCHAR", |
| "length": 10, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_topup", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "topup_amount", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>approvedon_userid", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_account", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "interest_compounding_period_enum", |
| "type": "SMALLINT", |
| "length": 5, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "acc_gl_journal_entry", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "organization_running_balance", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "0.000000", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_account_charge", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "stretchy_report_parameter", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>parameter_id", |
| "type": "INT", |
| "length": 10, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_tranche_disbursement_charge", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>loan_charge_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "stretchy_report", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "report_type", |
| "type": "VARCHAR", |
| "length": 20, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_topup", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>loan_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_account", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "activatedon_date", |
| "type": "DATE", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_account_transaction", |
| "tableType": "Table", |
| "keyClass": "indexedColumn", |
| "keyTitle": "Indexed", |
| "name": "<i class='fa fa-sitemap fa-rotate-120' style='padding-right: 5px;'><\/i>ref_no", |
| "type": "VARCHAR", |
| "length": 128, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "scheduled_email_messages_outbound", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "message", |
| "type": "TEXT", |
| "length": 65535, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_group_roles", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "√", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "notification_mapper", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "is_read", |
| "type": "BIT", |
| "length": 1, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "b'0'", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "closedon_userid", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "oauth_refresh_token", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "token_id", |
| "type": "VARCHAR", |
| "length": 256, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_import_document", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "end_time", |
| "type": "DATETIME", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_savings_account_interest_rate_slab", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "annual_interest_rate", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_account_transfer_standing_instructions", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "amount", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_client", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>default_savings_account", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "total_overpaid_derived", |
| "type": "DECIMAL", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_tellers", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>office_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_collateral_management", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "is_released", |
| "type": "BIT", |
| "length": 1, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "b'0'", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_adhoc", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>createdby_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_loan_overdue_installment_charge", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>loan_schedule_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_password_validation_policy", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "active", |
| "type": "BIT", |
| "length": 1, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "b'0'", |
| "comments": "" |
| }, |
| { |
| "tableName": "notification_mapper", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>user_id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "acc_rule_tags", |
| "tableType": "Table", |
| "keyClass": "foreignKey", |
| "keyTitle": "Foreign Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>tag_id", |
| "type": "INT", |
| "length": 10, |
| "nullable": "", |
| "autoUpdated": "", |
| "defaultValue": "null", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_interest_rate_chart", |
| "tableType": "Table", |
| "keyClass": "", |
| "keyTitle": "", |
| "name": "end_date", |
| "type": "DATE", |
| "length": 10, |
| "nullable": "√", |
| "autoUpdated": "", |
| "defaultValue": "NULL", |
| "comments": "" |
| }, |
| { |
| "tableName": "m_account_transfer_standing_instructions_history", |
| "tableType": "Table", |
| "keyClass": "primaryKey", |
| "keyTitle": "Primary Key", |
| "name": "<i class='icon ion-key iconkey' style='padding-left: 5px;'><\/i>id", |
| "type": "BIGINT", |
| "length": 19, |
| "nullable": |
