Add a “date last modified” attribute to submissions

[mslarae13]

To make evaluating if test submissions should have a deletion policy, we should have a "date last modified" attribute for each submission that can be tracked and exported when we evaluate metrics.

@pkalita-lbl & @eecavanna worked on a process to export a summary table for the NMDC submission portal, this will also need updated to include

• is this a test submission?
• date last edited?

[eecavanna]

I am in favor of storing createdAt and updatedAt timestamps for submissions.

So far, we have been generating the summary table by issuing a SQL query directly to the database. I think modifying the query to include this information will be straightforward (i.e. a < 5 minute task), once this information exists in the database.

In https://github.com/microbiomedata/nmdc-server/pull/1290, I am working on implementing an API endpoint that administrators can use to get the same table from the API. It is still in a "draft" state because I haven't yet added a test that focuses on the auth aspect (to ensure regular users cannot access this endpoint, but admin users can).