PortaBilling data model concept

Link copied to clipboard

The illustration below shows some major elements and their interrelationships. For the sake of clarity, only the most important tables and columns are shown.

PortaBilling data model concept

  • Destinations define possible phone number prefixes which will be used in the system.
  • Rates table stores information about rating parameters for a specific destination with a specific tariff.
  • Tariffs serve as a price list to be assigned to a specific customer or vendor.
  • The relationship between vendors and tariffs is defined via the Connections table. A tariff assigned to a specific connection will be used to calculate termination costs for a given vendor.
  • Every account is assigned a certain product, which defines how the account will use the service and how it will be charged for this.
  • A product is related to tariffs via the rating table (Accessibility), which defines the mapping between the service consumption point (a combination of the node, access code, and originating line information) and the applicable rating (service and tariff). Thus a single product may be linked with multiple tariffs.
  • Accounts are linked to a customer so that a single customer can have multiple accounts.

On this page