User Tools

Site Tools


Sidebar

Table listing

Here is the list of all tables created in the database.

Clic on a table name for more informations.

model:indicator_labels

Table indicator\_labels

Remarks

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.

Schema

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”.

Diagram

model/indicator_labels.txt · Last modified: 2016/01/11 21:38 (external edit)