Created and Last Change Data

Question

Created and where is the Last Change data held?

Can I get information about the table location in SQL.

System:

Demerit · Accepted Answer · 2019-10-15 22:17:47Z

1

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.

answered Oct 15, 2019 at 19:45

Demerit

21.8k2 gold badges11 silver badges33 bronze badges

Add a comment |

Xavier · Accepted Answer · 2019-10-15 08:00:12Z

1

It's in the civicrm_contact table

answered Oct 15, 2019 at 8:00

Xavier

10.2k10 silver badges35 bronze badges

There are created_date and modified_date tables in civicrm_contact. But there is no user information created and modified.
– Fatih ATEŞ
Oct 15, 2019 at 9:52

Add a comment |

2 Answers 2