group

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id text 2147483647 null
dcpr_error_report_notification.group_id dcpr_error_report_notification_group_id_fkeyR
dcpr_geospatial_request_notification.group_id dcpr_geospatial_request_notification_group_id_fkeyR
dcpr_request.organization_id dcpr_request_organization_id_fkeyR
dcpr_request_notification.group_id dcpr_request_notification_group_id_fkeyR
error_report_notification.group_id error_report_notification_group_id_fkeyR
group_extra.group_id group_extra_group_id_fkeyR
group_extra_revision.group_id group_extra_revision_group_id_fkeyR
member.group_id member_group_id_fkeyR
user_following_group.object_id user_following_group_group_id_fkeyC
name text 2147483647 null
title text 2147483647 √ null
description text 2147483647 √ null
created timestamp 29,6 √ null
state text 2147483647 √ null
type text 2147483647 null
approval_status text 2147483647 √ null
image_url text 2147483647 √ null
is_organization bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
group_pkey Primary key Asc id
group_name_key Must be unique Asc name
idx_group_id Performance Asc id
idx_group_name Performance Asc name

Relationships

Close relationships within degrees of separation