category


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
base_activity_category.id_category category_fkR
category.id_parent category_fk7R
goal_category.id_category category_fkR
template_event_category.id_category category_fkR
user_activity_category.id_category category_fkC
user_preference_category.id_category user_preference_category_fkR
enabled bool 1 false
name text 2147483647 null
slug text 2147483647 null
button_image int4 10 √ null
file.id category_fk2R
button_image_selected int4 10 √ null
file.id category_fk3R
cover_image int4 10 √ null
file.id category_fk4R
icon int4 10 √ null
file.id category_fk5R
icon_sticker int4 10 √ null
file.id category_fk6R
id_group int4 10 √ null
category_group.id group_fkN
id_community int4 10 null
community.id community_fkR
created_at timestamptz 35,6 √ null
updated_at timestamptz 35,6 √ null
id_parent int4 10 √ null
category.id category_fk7R

Indexes

Constraint Name Type Sort Column(s)
category_pk Primary key Asc id
category_slug_unique Must be unique Asc/Asc slug + id_community

Relationships

Close relationships within degrees of separation