Answers.Body: <p>In most cases you would not use direct sql queries to look up or manipulate CiviCRM data.</p>
  
  <p>Activity contacts, like most CiviCRM data, has an api which you can use to read, write, update and delete contacts in an activity.</p>
  
  <p>You can browser this api on your own site using the Api Explorer:</p>
  
  <p><img src="https://i.sstatic.net/zPgKc.png" alt="API Explorer"></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-04-28T15:12:47.407Z
Answers.LastActivityDate: 2015-04-28T16:09:39.867Z
Answers.LastEditDate: 2015-04-28T16:09:39.867Z
Answers.UserDisplayName: Coleman
Answers.Body: <p>Depends on your version. From CiviCRM 4.4 the activity assignee can be found in the table civicrm_activity_contact, where record_type_id = 1 is 1 for source contact, 2 for assignee contact and 3 for target contact.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-04-28T14:03:57.033Z
Answers.Text: Thanks. How can I find the connection between civicm_contact table and record_type_id ? I don't seem to find the link..
Answers.UserDisplayName: Tapash
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-04-28T16:33:04.133Z
Answers.Text: @Tapash the civicrm_activity_contact table also has a contact_id field, use that? But I totally agree with Coleman that you should use the CiviCRM API to get to the activity contacts rather than poking directly in the tables.
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-04-28T13:59:44.677Z
Answers.LastActivityDate: 2015-04-28T16:13:32.587Z
Answers.LastEditDate: 2015-04-28T16:13:32.587Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>I'm looking for the table in which Activity assignee contact information is stored in mysql.</p>
  
Tags: <activities>
Title: In which table is Activity assignee contact information stored in mysql?
ThreadText: # In which table is Activity assignee contact information stored in mysql?
  
  (Asked by: username_0 on 2015-04-28)
  
  I'm looking for the table in which Activity assignee contact information is stored in mysql.
  
  **Tags:** activities
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2015-04-28. Score: 3 | Accepted answer
  
  In most cases you would not use direct sql queries to look up or manipulate CiviCRM data.
  
  Activity contacts, like most CiviCRM data, has an api which you can use to read, write, update and delete contacts in an activity.
  
  You can browser this api on your own site using the Api Explorer:
  
  ![API Explorer](https://i.sstatic.net/zPgKc.png)
  
  
  ---
  
  ### Answer by username_2 on 2015-04-28. Score: 5
  
  Depends on your version. From CiviCRM 4.4 the activity assignee can be found in the table civicrm\_activity\_contact, where record\_type\_id = 1 is 1 for source contact, 2 for assignee contact and 3 for target contact.
  
  > **Comments:**
  > **username_0**: Thanks. How can I find the connection between civicm_contact table and record_type_id ? I don't seem to find the link..  
  > **username_2**: @username_0 the civicrm_activity_contact table also has a contact_id field, use that? But I totally agree with username_1 that you should use the CiviCRM API to get to the activity contacts rather than poking directly in the tables.  
  
  ---
  
  