Database Overview¶
Linked Tables¶
The application uses 15 linked back-end tables.
Examples:
| Table | Purpose |
|---|---|
| tblCadets | Cadet records |
| tblCompanies | Company organization |
| tblOrders | Orders management |
| tblRewards | Awards and rewards |
Local Tables¶
The front-end contains 4 local tables used for temporary data and processing.
Examples:
- tblDropdownFilters
- TempOML
- TempSortOrder
These tables are used for filtering, sorting, and temporary calculations.