Database
Purpose
This page documents the actual database inventory extracted from the production MySQL schema metadata. It is based on INFORMATION_SCHEMA exports only and does not include customer data.
Extraction Summary
| Metric | Count |
|---|---|
| Tables | 189 |
| Columns | 2112 |
| Foreign key links | 197 |
| Index entries | 633 |
| Migration files | 57 |
| Route definitions | 744 |
| Controller/Request/Resource files | 299 |
| Model/Entity files | 199 |
Database Inventory by Domain
| Domain | Table Count | Representative Tables |
|---|---|---|
| Credentials & NFC | 4 | card_import, copy_nfc_codes, importing_nfc_codes_operations, nfc_codes |
| Notification & Communication | 7 | automated_calls, contacts, notification_logs, notifications, notifications_new, nova_notifications, onesignal_devices |
| Order & Cart | 25 | carts, company_package_order_items, company_package_orders, deposit_orders, export_deposit_orders, export_orders, export_withdraw_orders, free_subscription_orders, free_subscription_orders_details, free_subscriptions |
| Other | 31 | cities, companies, discount_reasons, excuses, features, group_notes, groups, guide_manuals, importing_stock_operations, login_loggers |
| Product & Catalog | 20 | block_products, commission_packages, company_free_package_statistics, company_packages, favourites, free_packages, general_commission_packages, importing_products_operations, maqsafy_product_commission_packages, maqsafy_products |
| School & Education | 33 | classrooms, educational_administrations, educational_levels, educational_offices, export_schools, group_school, import_school, maqsafy_school_products, school_commission_packages, school_fee_classroom |
| Supplier & Company | 12 | automated_drivers, company_insights_statistecs, company_page_visibility, service_provider_company_page_visibility, supplier_categories, supplier_classifications, supplier_landings, supplier_store_classification, supplier_store_supplier_employee, supplier_stores |
| System & Operations | 9 | action_events, export_data, failed_jobs, jobs, media, migrations, nova_field_attachments, nova_pending_field_attachments, websockets_statistics_entries |
| User & Identity | 32 | company_packages_staffs, fcm_tokens, guardians, importing_students_operations, mobile_password_resets, model_has_permissions, model_has_roles, nfc_users, password_resets, permissions |
| Wallet & Finance | 16 | bank_accounts, banks, export_transactions, export_wallets, girls_balances, mastercard_payments, money_transfers, payment, payouts, system_wallets |
Largest Tables by Estimated Row Count
TABLE_ROWS is an estimate reported by MySQL/InnoDB metadata and should be used for operational prioritization, not exact financial reporting.
| TABLE_NAME | ENGINE | TABLE_ROWS |
|---|---|---|
| free_subscription_orders_details | InnoDB | 16184449 |
| transactions | InnoDB | 5819051 |
| rates | InnoDB | 3350733 |
| order_items | InnoDB | 3254404 |
| free_subscription_orders | InnoDB | 3248952 |
| products | InnoDB | 3015811 |
| store_statistics | InnoDB | 2008535 |
| orders | InnoDB | 1500880 |
| action_events | InnoDB | 441890 |
| wallets | InnoDB | 419549 |
| notifications | InnoDB | 385500 |
| userables | InnoDB | 359064 |
| money_transfers | InnoDB | 301617 |
| users | InnoDB | 301200 |
| export_transactions | InnoDB | 294805 |
| export_data | InnoDB | 284831 |
| invoices | InnoDB | 284636 |
| deposit_orders | InnoDB | 179505 |
| notifications_new | InnoDB | 94248 |
| nfc_users | InnoDB | 89607 |
Tables with Most Index Entries
| TABLE_NAME | Index Entries |
|---|---|
| users | 26 |
| transactions | 15 |
| orders | 13 |
| nfc_users | 11 |
| schools | 11 |
| stores | 11 |
| schools_package | 10 |
| return_orders | 10 |
| supplier_orders | 9 |
| company_package_orders | 8 |
| userables | 8 |
| stock_logs | 8 |
| company_package_order_items | 8 |
| school_fee_orders | 7 |
| return_carts | 7 |
| return_order_items | 7 |
| model_has_roles | 7 |
| products | 7 |
| action_events | 7 |
| automated_calls | 6 |
Tables with Most Foreign Key Links
| TABLE_NAME | FK Count |
|---|---|
| users | 9 |
| stores | 7 |
| orders | 6 |
| return_carts | 6 |
| free_subscription_orders | 5 |
| carts | 5 |
| return_orders | 5 |
| schools | 5 |
| student_school_fees | 4 |
| return_order_items | 4 |
| return_invoices | 4 |
| nfc_users | 4 |
| free_subscription_orders_details | 3 |
| block_products | 3 |
| order_items | 3 |
| invoices | 3 |
| free_subscriptions | 3 |
| products | 3 |
| school_notification_classrooms | 3 |
| stock_logs | 3 |
Confirmed Core Tables
| Table Name |
|---|
| action_events |
| automated_calls |
| automated_drivers |
| bank_accounts |
| banks |
| block_products |
| card_import |
| carts |
| cities |
| classrooms |
| commission_packages |
| companies |
| company_free_package_statistics |
| company_insights_statistecs |
| company_package_order_items |
| company_package_orders |
| company_packages |
| company_packages_staffs |
| company_page_visibility |
| contacts |
| copy_nfc_codes |
| deposit_orders |
| discount_reasons |
| educational_administrations |
| educational_levels |
| educational_offices |
| excuses |
| export_data |
| export_deposit_orders |
| export_orders |
| export_schools |
| export_transactions |
| export_wallets |
| export_withdraw_orders |
| failed_jobs |
| favourites |
| fcm_tokens |
| features |
| free_packages |
| free_subscription_orders |
| free_subscription_orders_details |
| free_subscriptions |
| general_commission_packages |
| girls_balances |
| group_notes |
| group_school |
| groups |
| guardians |
| guide_manuals |
| import_school |
| importing_nfc_codes_operations |
| importing_products_operations |
| importing_stock_operations |
| importing_students_operations |
| invoices |
| jobs |
| login_loggers |
| maqsafy_product_commission_packages |
| maqsafy_product_order_items |
| maqsafy_product_orders |
| maqsafy_products |
| maqsafy_school_products |
| mastercard_payments |
| media |
| migrations |
| mobile_password_resets |
| mobile_verifications |
| model_has_permissions |
| model_has_roles |
| money_transfers |
| nfc_codes |
| nfc_users |
| notification_logs |
| notifications |
| notifications_new |
| nova_field_attachments |
| nova_notifications |
| nova_pending_field_attachments |
| onesignal_devices |
| order_items |
| order_vending_details |
| orders |
| package_landings |
| pages |
| password_resets |
| payment |
| payouts |
| permissions |
| personal_access_tokens |
| product_categories |
| product_packages |
| product_packages_products |
| products |
| products_info |
| push_notification_packages |
| questions |
| rates |
| regions |
| register_requests |
| return_carts |
| return_invoices |
| return_order_items |
| return_orders |
| role_has_permissions |
| roles |
| school_commission_packages |
| school_fee_classroom |
| school_fee_educational_level |
| school_fee_full_installment_payments |
| school_fee_installment_upfront_payments |
| school_fee_logs |
| school_fee_order_type_program_dates |
| school_fee_order_type_program_educational_levels |
| school_fee_order_type_programs |
| school_fee_order_types |
| school_fee_order_types_staff |
| school_fee_orders |
| school_fee_student |
| school_fee_upfront_payments |
| school_fees |
| school_fees_discount_reasons |
| school_landings |
| school_managers |
| school_mobile_messages |
| school_notification_classrooms |
| school_notification_settings |
| school_notification_users |
| school_number_users_log |
| school_page_visibility |
| school_push_notification_packages |
| school_report_titles |
| school_reports |
| schools |
| schools_package |
| service_provider_commission_packages |
| service_provider_companies |
| service_provider_company_page_visibility |
| settings |
| soft_pos |
| staff_automated_calls |
| status_logs |
| stock_logs |
| store_landings |
| store_statistics |
| store_stocks |
| stores |
| student_guardian |
| student_school_fee_logs |
| student_school_fees |
| students_king_abdallah_balances |
| supervisory_agencies |
| supervisory_agencies_stores |
| supervisory_agency_page_visibility |
| supplier_carts |
| supplier_categories |
| supplier_classifications |
| supplier_landings |
| supplier_order_items |
| supplier_orders |
| supplier_products |
| supplier_store_classification |
| supplier_store_supplier_employee |
| supplier_stores |
| supplier_stores_cities |
| supplier_stores_page_visibility |
| system_wallets |
| table_105 |
| tax_inovices |
| tax_invoice_requests |
| test |
| top_sale |
| transaction_issues |
| transactions |
| trips |
| tv_link_codes |
| update_student_school_operations |
| user_bank_accounts |
| user_landings |
| user_notification_targets |
| user_notifications |
| userables |
| users |
| value_added_taxes |
| vending_machines |
| wallets |
| wallets_reports |
| websockets_statistics_entries |
| withdraw_commission_packages |
| withdraw_orders |
Database Review Notes
- The schema contains 189 tables, 2112 columns, 197 foreign key relationships, and 633 index entries.
- The largest operational tables by estimated row count include
free_subscription_orders_details,transactions,rates,order_items,free_subscription_orders,products,store_statistics, andorders. - Tables related to orders, wallet/finance, users, schools, products, credentials/NFC, and notifications are present.
- This page confirms table existence only. It does not confirm business correctness, data quality, or security enforcement.
Remaining Open Items
| Item | Status | Notes |
|---|---|---|
| Exact ERD diagram | Open | Can be generated from foreign-keys.csv. |
| Data retention policy | Open | Requires business/security decision. |
| RPO/RTO | Open | Requires operations decision. |
| Backup restore test evidence | Open | Requires actual restore test. |
| Table ownership by module | Partial | Can be refined from code ownership. |