campaigns

100746 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('campaigns_id_seq'::regclass)
actions.campaign_id fk_rails_f2ec642546 R
events.campaign_id fk_rails_e78ca55c91 R
group_campaigns.campaign_id fk_rails_0dcd6ac2f5 R
name text 2147483647 √ null
created_at timestamp 29,6 √ null
updated_at timestamp 29,6 √ null
issue_id int4 10 √ null
issues.id fk_rails_3457f6a6ac R
description text 2147483647 √ null
author_id int4 10 √ null
members.id fk_rails_2715f9086d R
controlshift_campaign_id int4 10 √ null
campaign_type text 2147483647 √ null
latitude float8 17,17 √ null
longitude float8 17,17 √ null
location text 2147483647 √ null
image text 2147483647 √ null
slug text 2147483647 √ null
moderation_status text 2147483647 √ null
finished_at timestamp 29,6 √ null
target_type varchar 255 √ null
outcome varchar 2147483647 √ null
languages _varchar 2147483647 √ '{}'::character varying[]

Indexes

Constraint Name Type Sort Column(s)
campaigns_pkey Primary key Asc id
idx_campaigns_ctrlshift_id Performance Asc controlshift_campaign_id
index_campaigns_on_author_id Performance Asc author_id
index_campaigns_on_issue_id Performance Asc issue_id

Relationships

Close relationships within degrees of separation