Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Here is the list of all tables created in the database.
Clic on a table name for more informations.
This table contains all possible values of an indicator which have is aggregation column with the value 3 (=AGGREGATE_MULTINOMIAL). The indicator related is like a listbox. This table can be compared to a list of choices : each element has its own index (with the column code). This table is created with the annotation @CollectionOfElements on the field labels of the class Indicator in Java.
Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
:——— | :——— | :————- | :—————- | :—————- | :———— |
indicator_indicatorid | integer | X | X | indicator(indicatorid) | This is a foreign key to the table indicator. |
code | integer | X | This is the number of the value in the listbox. | ||
element | character varying(255) | This is a value of the “listbox”. |