Contact_Methods

Field

Type

Description

Joins

id

primary key (int)

id of contact method

ㅤ

content

text

phone number or email of alternate contact information

unique to table

created_at

timestamp

date&time contact method was created

unique to table

updated_at

timestamp

date&time contact method was last updated

unique to table

contact_type

text

cell_phone_number/ work_phone_number/ home_phone_number/ other_phone_number/ work_email_address/ home_email_address

unique to table

person_id

foreign key (int)

id of person record the contact method is associated with

id in people table

invalid

text

t/f if the contact method was marked invalid in phone banking

unique to table

extension

integer

phone extension

unique to table