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