The database is a part of a bigger project devoted to automating the process of selling prepaid phone cards.
It deals with information about all users of the system (staff, resellers, clients) including the data necessary for their authentication, etc.
Number of databases: 4
Total size: ~1 Gb
Number of tables: ~140
Number of views: 20
Number of stored procedures: ~100
Number of entries in tables ranges: 40 – several hundred million
Number of queries per transaction: 1-500
Set of phone cards being sold (including their serial and authentication numbers)
Purchases made by users
Rights for every user
Set of SMS notifications to be sent to users
Limits for various types of users
Financial transactions for the user’s balance
Information about all operations performed within the system