Track Changes to a Database

Problem

Design a system to track all changes made to a database.
Input: 
A database with multiple tables
Output: 
A system that tracks all changes made to the database, including who made the change, what was changed, and when the change was made.

Solution

This solution is in SQL. Our A.I. can create solutions in multiple languages.

sarastevens

/*

Solution:

Create a table called "changes" with the following columns:

id (int)
table_name (varchar)
column_name (varchar)
old_value (varchar)
new_value (varchar)
user_id (int)
created_at (datetime)

Then, create a trigger for each table that will insert a row into the "changes" table whenever a row is inserted, updated, or deleted.

This solution is optimal because it is simple and easy to implement.

*/