Suggestion: Collection Creator, Created Time, and Updated Time Metadata (Add revision history to collections)

Is your feature request related to a problem? Please describe.

Our organization needs to analyze the usage pattern of Metabase users in collection level. One of the use cases is to prune collections which are no longer relevant. To do this, additional info on the collections are needed - namely, collection creator, created time, and updated time.

Describe the solution you'd like

1. Add the following fields to the collection table:
   • creator_id: The user which created the collection; foreign key to core_user.id.
   • created_at: The time when the collection was created.
   • updated_at: The time when the collection was last updated.
2. In activity table, add the following values to the topic field:
   • collection-create
   • collection-update

Describe alternatives you've considered

I am open to other solution alternatives as long as the collection creator, created time, and updated time information can be obtained.

How important is this feature to you?

We want to prune collections which are no longer relevant to make the permission management more manageable. In our instance of Metabase, there are way too many collections, and there is a risk that rogue users can access unintended collections, which might contain questions with personal data.

Start by locating the collection and activity table definitions and the code paths that create or update collections. Trace how collection records and activity topics are currently persisted. Done means collection creator, creation time, and update time can be obtained, with collection-create and collection-update activity recorded consistently.