Necessary Tables + Short description
| table | description |
| call | Stores the information about all calls (starttime/endtime/device/…) |
| cid | Caller identification numbers get stored here for use with card |
| cardtype | for the different card types |
| card | Information about calling cards which are in use at the moment |
| country | Full countryname for a countrycode |
| countryprefix | Prefix for all countries + subcodes (FIX/MOB) |
| provider | The provider which can be used for outgoing calls (+ dialstr) |
| providerdestination | Tells the system which provider can route calls to which destination |
| providerrate | The provider / destinations rates |
| tariff | You can have more than one defined tariff for your customers |
| tariffrate | The rates for each tariff per destination |
The table schema with demo data is included with the application.
Phone System 