=== CHECKING TABLE SCHEMA ===

Checking schema for table 'account_settings':

Columns:
------------------------
id - bigint(20) unsigned - NO - PRI - 
branch_id - bigint(20) unsigned - NO - MUL - 
transaction_type - enum('penjualan_tunai','pembelian','pengeluaran','penjualan_qris','penjualan_bank','hpp','opname','stock_opname_surplus','stock_opname_deficit','pembayaran_pembelian','stockist','penjualan') - YES -  - 
debit_account_id - bigint(20) unsigned - YES -  - 
credit_account_id - bigint(20) unsigned - YES -  - 
account_id - bigint(20) unsigned - NO - MUL - 
sub_account_id - bigint(20) unsigned - NO - MUL - 
debit_sub_account_id - bigint(20) unsigned - YES - MUL - 
credit_sub_account_id - bigint(20) unsigned - YES - MUL - 
credit_list_sub_account_id - bigint(20) unsigned - YES - MUL - 
created_at - timestamp - YES -  - 
updated_at - timestamp - YES -  - 
primary_list_sub_account_id - bigint(11) - YES -  - 
debit_list_sub_account_id - bigint(11) - YES -  - 

Indexes:
------------------------
PRIMARY - Column: id - Non_unique: 0
unique_branch_transaction_type - Column: branch_id - Non_unique: 0
unique_branch_transaction_type - Column: transaction_type - Non_unique: 0
account_settings_account_id_foreign - Column: account_id - Non_unique: 1
account_settings_sub_account_id_foreign - Column: sub_account_id - Non_unique: 1
account_settings_debit_sub_account_id_foreign - Column: debit_sub_account_id - Non_unique: 1
account_settings_credit_sub_account_id_foreign - Column: credit_sub_account_id - Non_unique: 1
account_settings_credit_list_sub_account_id_foreign - Column: credit_list_sub_account_id - Non_unique: 1

Checking for data issues:
------------------------
No duplicate branch_id/transaction_type combinations found.
WARNING: Found 1 records with empty transaction_type:
ID: 19, Branch ID: 2

=== CHECKING TABLE SCHEMA COMPLETE ===