Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Sidebar
model:category_element
Table of Contents
Table category\_element
Remarks
A category element is an element of a category type. Each category element is represented by an icon (icon determined by the column icon_name of the table category_type) and has its own color.
Schema
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| id_category_element | integer | X | X | This is the primary key of the table. | |
| color_hex | character varying(6) | X | This is the hexadecimal code of the color of the element. | ||
| label | text | X | This is an human readable name for the category element. | ||
| id_organization | integer | organization(id_organization) | This is a foreign key to the table organization. | ||
| id_category_type | integer | X | category\_type(id_category_type) | This is a foreign key to the table category_type. |
Diagram
model/category_element.txt · Last modified: 2016/01/11 21:38 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
