mysql Database for the CallingCard Applications

Necessary Tables + Short description

tabledescription
callStores the information about all calls (starttime/endtime/device/...)
cidCaller identification numbers get stored here for use with card
cardtypefor the different card types
cardInformation about calling cards which are in use at the moment
countryFull countryname for a countrycode
countryprefixPrefix for all countries + subcodes (FIX/MOB)
providerThe provider which can be used for outgoing calls (+ dialstr)
providerdestinationTells the system which provider can route calls to which destination
providerrateThe provider / destinations rates
tariffYou can have more than one defined tariff for your customers
tariffrateThe rates for each tariff per destination


The table schema with demo data is included with the application.Image

Necessary Tables + Short description

tabledescription
callStores the information about all calls (starttime/endtime/device/...)
cidCaller identification numbers get stored here for use with card
cardtypefor the different card types
cardInformation about calling cards which are in use at the moment
countryFull countryname for a countrycode
countryprefixPrefix for all countries + subcodes (FIX/MOB)
providerThe provider which can be used for outgoing calls (+ dialstr)
providerdestinationTells the system which provider can route calls to which destination
providerrateThe provider / destinations rates
tariffYou can have more than one defined tariff for your customers
tariffrateThe rates for each tariff per destination


The table schema with demo data is included with the application.Image
Created by: wuwu, Last modification: Fri 25 of Mar, 2005 (08:29 UTC) by terchris
Please update this page with new information, just login and click on the "Edit" or "Discussion" tab. Get a free login here: Register Thanks! - Find us on Google+