group

2860 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 8 null
campaign_group_association.group_id campaign_group_association_group_id_fkey R
group_membership.group_id group_membership_group_id_fkey R
pin_video.pinned_in_group pin_video_pinned_in_group_fkey R
temp_customer_campaign.group_id temp_customer_campaign_group_id_fkey R
name varchar 128 √ null
creator_id varchar 64 null
user.userid group_creator_id_fkey R
customer_id varchar 8 null
customer.id group_customer_id_fkey1 R
status varchar 32 √ null
is_public bool 1 null
created_at timestamptz 35,6 √ now()

Indexes

Constraint Name Type Sort Column(s)
group_pkey Primary key Asc id
group_name_customer_id_key Must be unique Asc/Asc name + customer_id
group_name_customer_id_key1 Must be unique Asc/Asc name + customer_id

Relationships

Close relationships within degrees of separation