Shepherd Database Structure

1. touches

1.1. touch_id

1.2. account_company_id

1.3. touch_name

2. contacts_touches

2.1. touch_id

2.2. contact_id

2.3. account_user_id

2.4. touch_date

2.5. reminder_date

3. activities

3.1. activity_id

3.2. contact_id

3.3. touch_id

3.4. account_user_id

3.5. activity_type_id

3.6. date

4. schedules

4.1. schedule_id

4.2. stage_id

4.3. account_company_id

4.4. name

5. activity_types

5.1. activity_type_id

5.2. name

6. socials

6.1. social_id

6.2. name

7. contact_socials

7.1. social_id

7.2. contact_id

7.3. company_id

7.4. link

8. touch_schedules

8.1. schedule_id

8.2. account_user_id

8.3. touch_id

8.4. contact_id

8.5. interval

9. Notes

9.1. note_id

9.2. account_user_id

9.3. created

9.4. updated

9.5. contact_id

9.6. activity_id

9.7. note

10. groups

10.1. group_id

10.2. account_company_id

10.3. group_name

11. contact_groups

11.1. group_id

11.2. contact_id

12. account_users

12.1. account_user_id

12.2. account_company_id

12.3. email

12.4. password

12.5. is_admin

12.6. signup_date

12.7. last_active

12.8. first_name

12.9. last_name

12.10. photo

12.11. phone_number

13. account_companies

13.1. account_company_id

13.2. subdomain

13.3. company

13.4. logo

13.5. timezone

14. contacts

14.1. contact_id

14.2. company_id

14.3. status_id

14.4. first_name

14.5. last_name

14.6. email

14.7. photo

14.8. rating

14.9. birthday

14.10. referred_by (contact_id)

14.11. mobile_number

14.12. work_phone

14.13. address1

14.14. address2

14.15. city

14.16. state

14.17. country

14.18. postal

15. companies

15.1. company_id

15.2. company_name

15.3. logo

15.4. website

15.5. phone_number

15.6. address1

15.7. address2

15.8. city

15.9. state

15.10. country

15.11. postal

16. statuses

16.1. status_id

16.2. account_company_id

16.3. status