groups

335 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('groups_id_seq'::regclass)
group_campaigns.group_id fk_rails_476b4c6bd2 R
groups_members.group_id fk_rails_49c564f8bd R
name text 2147483647 √ null
notes text 2147483647 √ null
area_id int4 10 √ null
areas.id fk_rails_cd2c7032e2 R
created_at timestamp 29,6 √ null
updated_at timestamp 29,6 √ null
controlshift_group_id int4 10 √ null
group_type text 2147483647 √ null
member_count int4 10 √ null
activity_rating int4 10 √ null
key_issues text 2147483647 √ null
latitude float8 17,17 √ null
longitude float8 17,17 √ null
location text 2147483647 √ null
internal_notes text 2147483647 √ null
event_count int4 10 √ null
image_url text 2147483647 √ null
controlshift_group_slug text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
groups_pkey Primary key Asc id
index_groups_on_area_id Performance Asc area_id

Relationships

Close relationships within degrees of separation