base_activity


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id_node int8 19 null
base_activity_category.id_node base_activity_fkC
base_activity_media.id_node_base_activity base_activity_fkC
base_activity_survey_activity.id_node_base_activity base_activity_fkC
base_activity_user.id_node_base_activity base_activity_fkR
base_activity_visibility.id_node_base_activity base_activity_fkC
base_activity_visibility_group.id_node_base_activity base_activity_fkC
challenge.id_node_base_activity base_activity_fkR
instance_rating.id_node base_activity_fkR
pinned.id_node pinned_node_fkR
pinned_board_user.id_node pinned_board_user___fk_base_activityR
node.id node_fkC
name text 2147483647 √ null
description text 2147483647 √ null
notes text 2147483647 √ null
enabled bool 1 √ null
points int2 5 null
hours int2 5 null
created_at timestamptz 35,6 √ null
updated_at timestamptz 35,6 √ null
id_address int4 10 √ null
address.id address_fkN
id_community int4 10 null
community.id community_fkR
id_dd_node_type int2 5 null
base_activity_category.id_dd_node_type base_activity_fkC
base_activity_media.id_dd_node_type_base_activity base_activity_fkC
base_activity_survey_activity.id_dd_node_type_base_activity base_activity_fkC
base_activity_user.id_dd_node_type_base_activity base_activity_fkR
base_activity_visibility.id_dd_node_type_base_activity base_activity_fkC
base_activity_visibility_group.id_dd_node_type_base_activity base_activity_fkC
challenge.id_dd_node_type base_activity_fkR
instance_rating.id_dd_node_type base_activity_fkR
dd_node_type.id dd_node_type_fkR
id_cover_image_file int4 10 √ null
file.id file_fkN
users_limit int2 5 √ null

This field defines the maximum of users that can be added to base_activity_table
auto_join bool 1 √ false

Let’s an users to add himself to the table base_acitivity_user
short_description text 2147483647 √ null
id_dd_repeatable_unit int2 5 √ null
dd_repeatable_unit.id dd_repeatable_unit_fkR

Indexes

Constraint Name Type Sort Column(s)
base_activity_pk Primary key Asc/Asc id_node + id_dd_node_type
base_activity_uq Must be unique Asc id_address
base_activity_uq2 Must be unique Asc id_node

Relationships

Close relationships within degrees of separation