Database – Deletion Audit Table (deletion_audit)
Description
For some tables, the database marks records as deleted in the 'deleted' field. For others, records are completely removed. This table keeps a record of what was completely removed from the database.
Common Uses
To audit what was deleted from the database.
Table Fields
Column | Data Type | Column Info | Value Notes | Other |
table_name | varchar(50) | The name of the table the record was deleted from. | ||
deleted_id | int(11) | The ID of the record that was deleted. | ||
deletedAt | timestamp | The date and time when the item was deleted. | ||
compound_index | varchar(150) | This column is used when doing hard deletes on tables that have a compound index. For instance, 'loan__portfolio' contains both 'loan_id' and 'portfolio_id' foreign keys, so when doing a hard delete on this table it tracks those keys as a JSON string. | { loan_id: 2154, portfolio_id: 182 } |
A record of deletions from the following tables is shown in the deletion_audit table:
- Loan-Related:
- loan_tx
- loan__customer
- loan__recurrent_charge
- loan__rule_applied_settings
- loan_active_time_tx
- loan__portfolio
- Tenant-Related:
- custom_field__entity
Not all tables that use a hard delete are included in the deletion_audit table. This is either because the history for those tables is already tracked in the loan_status_archive table, or because the deletion of records is so inconsequential that tracking it doesn't make sense. This is the list of tables that use a hard delete:
- Untracked Loan-Related:
- billing_tool__loan
- collector_queue__loan
- custom_form_tool__loan
- email_tool__loan
- linked_loan__entity
- loan__customer
- loan__recurrent_charge
- loan__rule_applied_apd_reset
- loan__rule_applied_charge_off
- loan__rule_applied_settings
- loan__rule_applied_stop_interest
- loan__sub_portfolio
- loan_active_time_tx
- loan_chargeoff__transactions
- loan_reverse_status_archive -> when a modification is canceled
- loan_tx
- mail_house_loan
- loan__rule_applied_account_tools
- loan__rule_applied_autopay
- loan__rule_applied_checklist
- loan__rule_applied_customer_tools
- loan__rule_applied_duedate
- loan__rule_applied_loan_setup
- loan_late_fee__buckets
- Untracked Tenant-Related:
- admin_tool__loan
- advance_category_entity
- cash_drawer__payment_method
- checklist_item__entity
- custom_boarding_process_step_entity
- custom_field__entity
- customer_social_profile_entity
- customer_status_entity
- defaults_late_fee__buckets
- doc_section_entity
- email_queue
- escrow__transactions
- holding_account__investor
- investment__portfolio
- investment__sub_portfolio
- investor_status_entity
- note_category_entity
- notification_category__delivery
- payment__portfolio
- report_cache
- restriction_group__user
- restriction_group__user
- rule__category
- rule_applied_settings__portfolio
- rule_applied_settings__portfolio_to_delete
- rule_applied_settings__sub_portfolio
- rule_applied_settings__sub_portfolio_to_delete
- view_template__view_module
- work_item__questions
- actions__notes
- action__result
- payment__sub_portfolio
- preconfigured_loan__portfolio
- preconfigured_loan__sub_portfolio
- result__notes
- support_transaction__topic
- wizard_group_wizard