Answers.Body: <p>It's in civicrm_log. Entity_id matches civicrm_contact.id and entity_table='civicrm_contact'. Modified_id is the contact id of who modified it.</p>
  
  <p>Or if you have detailed logging turned on there's also entries in the log_civicrm_xxx tables.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-10-15T19:45:30.707Z
Answers.LastActivityDate: 2019-10-15T22:17:47.617Z
Answers.LastEditDate: 2019-10-15T22:17:47.617Z
Answers.UserDisplayName: Demerit
Answers.Body: <p>It's in the civicrm_contact table</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-10-15T09:52:25.077Z
Answers.Text: There are created_date and modified_date tables in civicrm_contact. But there is no user information created and modified.
Answers.UserDisplayName: Fatih ATEŞ
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-10-15T08:00:12.723Z
Answers.LastActivityDate: 2019-10-15T08:00:12.723Z
Answers.UserDisplayName: Xavier
Body: <p>Created and where is the Last Change data held?</p>
  
  <p>Can I get information about the table location in SQL.</p>
  
  <p><a href="https://www.yaparimben.com/wp-content/uploads/2019/10/Last_Change.png" rel="nofollow noreferrer"><img src="https://www.yaparimben.com/wp-content/uploads/2019/10/Last_Change.png" alt="enter image description here"></a></p>
  
  <p><strong>System:</strong></p>
  
  <ul>
  <li>Joomla! 3.9.10</li>
  <li>CiviCRM 5.18.2</li>
  </ul>
  
Tags: <joomla><database><datatables>
Title: Created and Last Change Data
ThreadText: # Created and Last Change Data
  
  (Asked by: username_0 on 2019-10-15)
  
  Created and where is the Last Change data held?
  
  Can I get information about the table location in SQL.
  
  [![enter image description here](https://www.yaparimben.com/wp-content/uploads/2019/10/Last_Change.png)](https://www.yaparimben.com/wp-content/uploads/2019/10/Last_Change.png)
  
  **System:**
  
  * Joomla! 3.9.10
  * CiviCRM 5.18.2
  
  **Tags:** joomla, database, datatables
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2019-10-15. Score: 1 | Accepted answer
  
  It's in civicrm\_log. Entity\_id matches civicrm\_contact.id and entity\_table='civicrm\_contact'. Modified\_id is the contact id of who modified it.
  
  Or if you have detailed logging turned on there's also entries in the log\_civicrm\_xxx tables.
  
  
  ---
  
  ### Answer by username_2 on 2019-10-15. Score: 1
  
  It's in the civicrm\_contact table
  
  > **Comments:**
  > **username_0**: There are created_date and modified_date tables in civicrm_contact. But there is no user information created and modified.  
  
  ---
  
  