ConditionsDbSchema: Difference between revisions
Jump to navigation
Jump to search
(Created page with "==Introduction== A database '''schema''' is the design of the tables and functions, etc, and their interactions. Here we describe the conditions database in some detail. We...") |
|||
| Line 9: | Line 9: | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! scope="col"| | ! scope="col"| channel | ||
! scope="col"| | ! scope="col"| flag | ||
! scope="col"| | ! scope="col"| DtoE | ||
|- | |- | ||
| 0 | |||
| | | 12 | ||
| | | 1.11 | ||
|- | |- | ||
| 1 | |||
| | | 13 | ||
| | | 2.11 | ||
|- | |- | ||
| 2 | |||
| | | 11 | ||
| 3.11 | |||
|} | |} | ||
==Upper Level== | ==Upper Level== | ||
Revision as of 22:13, 24 October 2018
Introduction
A database schema is the design of the tables and functions, etc, and their interactions. Here we describe the conditions database in some detail.
We are using postgres databases. In postgres, the word "schema" is also used to refer to a what is essentially a folder, or a way to group database tables and assign permssions as a group. We have several of this type of schema, one for each detector subsystem (trk,cal,crv) plus one for the interval of validity structure (val) and one for test tables (tst). A table can be referred to as schema.name, for example, we have an example table in the tst schema, tst.calib1.
Lower Level
Starting with tst.calib1, we have a conceptual content like:
| channel | flag | DtoE |
|---|---|---|
| 0 | 12 | 1.11 |
| 1 | 13 | 2.11 |
| 2 | 11 | 3.11 |