contacts

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('contacts_id_seq'::regclass)
contact_responses.contact_id fk_rails_1833f9e0dc R
contactee_id int4 10 null
members.id fk_rails_107de0f05c R
contactor_id int4 10 √ null
members.id fk_rails_4b3dad1b77 R
contact_campaign_id int4 10 √ null
contact_campaigns.id fk_rails_d435965eb4 R
external_id varchar 2147483647 √ null
contact_type varchar 2147483647 √ null
system varchar 2147483647 √ null
status varchar 2147483647 √ null
notes text 2147483647 √ null
duration int4 10 √ null
happened_at timestamp 29,6 √ null
created_at timestamp 29,6 √ null
updated_at timestamp 29,6 √ null
data json 2147483647 √ '"{}"'::json

Indexes

Constraint Name Type Sort Column(s)
contacts_pkey Primary key Asc id
index_contacts_on_contact_campaign_id Performance Asc contact_campaign_id
index_contacts_on_contact_type Performance Asc contact_type
index_contacts_on_contactee_id Performance Asc contactee_id
index_contacts_on_contactor_id Performance Asc contactor_id
index_contacts_on_external_id Performance Asc external_id

Relationships

Close relationships within degrees of separation