user_activity


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
user_activity_category.id_activity activity_fkC
user_activity_event.id_user_activity user_activity_fkC
user_activity_group.id_activity activity_group_activity_fkC
summary text 2147483647 √ null
hours float8 17,17 √ 0.00
points int2 5 √ null
geoverified bool 1 √ null
id_dd_activity_type int4 10 null
dd_activity_type.id dd_activity_type_fkR
created_at timestamptz 35,6 √ null
updated_at timestamptz 35,6 √ null
geoloc geography 2147483647 √ null
id_user int8 19 null
users.id_node activity_user_fkR
id_node_base_activity int8 19 null
node.id base_activity_fkC
id_dd_node_type_base_activity int2 5 null
id_community int4 10 null
community.id community_fkR

Indexes

Constraint Name Type Sort Column(s)
activity_pk Primary key Asc id

Relationships

Close relationships within degrees of separation