Datenbase Schema

  1. 1. Datenbase schema
  2. 3. Tables
    1. 2.1 Apiuser
    2. 2.2 Offer
    3. 2.3 Status
    4. 2.4 Job
    5. 2.5 Userright
    6. 2.6 Message

Schema

Overview of used tables.

Tables

Apiuser

An user in iro.

Offer

All possible Offers over a Message can be sended. provider, typ and route are used to get the data form configuration file.

Status

Status updates from external

Job

A complete Job.

  • status show the status of the job (init, started, sending, sended or error).
  • info is used to make it possible to create different billing groups for user.

Userright

Allowed offers for one user. Default routes are sorted by default value.

Message

A message that has created costs.

isBilled is False since the bill is paid.