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.
A category_type is composed of a set of category elements. It can used on a question_element instead of adding yourself all elements.
Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
:——— | :——— | :————- | :—————- | :—————- | :———— |
id_category_type | integer | X | X | This is the primary key of the table. | |
icon_name | character varying(8192) | X | It corresponds to the geometric type of the icon. It is represented by an enumeration in Java and can have one of these values : CIRCLE, CROSS, DIAMOND, SQUARE, STAR or TRIANGLE. | ||
label | character varying(8192) | X | This is an human readable name for the category type. | ||
id_organization | integer | organization(id_organization) | This is a foreign key to the table organization. |