Checking Database Table Structures
==================================

Bank Accounts Table Structure:
------------------------------
id - bigint(20) unsigned
user_id - bigint(20) unsigned
account_type_id - bigint(20) unsigned
account_number - varchar(255)
routing_number - varchar(255)
account_name - varchar(255)
balance - decimal(15,2)
available_balance - decimal(15,2)
pending_balance - decimal(15,2)
status - varchar(255)
opened_at - timestamp
closed_at - timestamp
created_at - timestamp
updated_at - timestamp

Cards Table Structure:
----------------------
id - bigint(20) unsigned
user_id - bigint(20) unsigned
bank_account_id - bigint(20) unsigned
card_number - text
masked_number - varchar(19)
card_type - varchar(255)
card_network - varchar(255)
card_name - varchar(255)
holder_name - varchar(255)
expiry_month - varchar(2)
expiry_year - varchar(4)
cvv - text
pin_hash - varchar(255)
status - enum('active','inactive','suspended','locked','expired','lost','stolen')
activation_code - varchar(6)
activated_at - timestamp
last_used_at - timestamp
daily_atm_limit - decimal(10,2)
daily_purchase_limit - decimal(10,2)
monthly_limit - decimal(12,2)
international_transactions - tinyint(1)
contactless_enabled - tinyint(1)
online_transactions - tinyint(1)
atm_withdrawals - tinyint(1)
pos_transactions - tinyint(1)
transaction_alerts - tinyint(1)
low_balance_alerts - tinyint(1)
security_alerts - tinyint(1)
design_theme - varchar(255)
plastic_type - varchar(255)
delivery_address - varchar(255)
delivery_status - enum('not_shipped','shipped','delivered','returned')
tracking_number - varchar(255)
shipped_at - timestamp
delivered_at - timestamp
fraud_patterns - longtext
failed_pin_attempts - int(11)
locked_until - timestamp
metadata - longtext
created_at - timestamp
updated_at - timestamp

Card Transactions Table Structure:
----------------------------------
id - bigint(20) unsigned
card_id - bigint(20) unsigned
user_id - bigint(20) unsigned
bank_account_id - bigint(20) unsigned
transaction_id - varchar(50)
type - enum('purchase','withdrawal','refund','fee','reversal','cashback')
method - enum('chip','swipe','contactless','online','atm','manual')
amount - decimal(15,2)
fee - decimal(10,2)
currency - varchar(3)
status - enum('pending','completed','failed','cancelled','disputed')
merchant_name - varchar(255)
merchant_category - varchar(255)
merchant_id - varchar(255)
merchant_address - varchar(255)
transaction_location - varchar(255)
latitude - decimal(10,8)
longitude - decimal(11,8)
country_code - varchar(3)
security_data - longtext
fraud_score - decimal(5,2)
is_international - tinyint(1)
is_suspicious - tinyint(1)
decline_reason - varchar(255)
authorization_code - varchar(255)
reference_number - varchar(255)
processor_response - varchar(255)
authorized_at - timestamp
settled_at - timestamp
raw_data - longtext
metadata - longtext
description - text
created_at - timestamp
updated_at - timestamp


Existing Data:
==============
Bank Accounts: 119
Cards: 0
Card Transactions: 0