Skip to main content

Database structure

Overview​

Each terrestrial BR IFIC contains a complete TerRaBase, which replaces (rather than updates) the complete TerRaBase in the previous terrestrial BR IFIC.

The complete TerRaBase is provided on each terrestrial BR IFIC (along with associated software) to provide the possibility to review the situation at an earlier time (e.g., six months ago, one year ago). Doing so requires nothing more than installing the appropriate BR IFIC; each terrestrial BR IFIC is self-contained so it will work properly even if the database structure has changed in the meantime.

TerRaBase contains only currently applicable data. It does not contain historical data which is no longer applicable.

TerRaBase is divided into four main parts:

Each of these parts contains numerous database tables, with different database structures.

Current TerRaBase files​

Starting with BR IFIC [nnnn], TerRaBase consists of a single file containing the complete database. This file is named BRIFIC_nnnn.db3, where nnnn is the BR IFIC number. This implies that, starting with BR IFIC [nnnn], it is possible to maintain several versions of TerRaBase in the same directory.

In addition, the BR IFIC contains another file, named GLAD.db, which contains GLAD data.

Both the TerRaBase file and the GLAD file are actually SQLite databases. See www.sqlite.org for further details.

Commonality among LF/MF, FM/TV, and FXM tables​

Within each domain, there is at least one primary database table.

  • In the FM/TV domain, the table is fmtv_terra for assignments and GE06 allotments.
  • In the FXM domain, the table is fxm_terra.
  • In the LF/MF domain, the table is lfmf_terra.

Reference tables​

There are two sets of reference tables on the terrestrial BR IFIC:

  • GLobal Administration Data (GLAD), which contains reference tables used throughout ITU, not only in TerRaSys.
  • Other reference tables used only in TerRaSys.

Although the choice of reference tables has been driven by the need for these reference tables in the various programs distributed on the terrestrial BR IFIC, these may be helpful in other situations.

Global Administrative Data (GLAD)​

GLobal Administration Data (GLAD) contains reference tables used throughout ITU, in many automated systems, not only in TerRaSys. Consequently, on the BR IFIC (Terrestrial Services), the GLAD data is maintained in a separate database; it is not part of TerRaBase.