At a Startup, especially one that's "long in the teeth", the senior engineering team are those that have been there the longest and have the largest institutional knowledge.
"Why are there 4 unique keys on this table named masterkey, masterkey2, mk1, mk4?"
Principle Engineer. "Well, the masterkey indicates which key this was mastered on, if you check the masterkey db, which is just "id, timestamp, masterid", this is required to comprehensively log the creation date of the row to maintain the db's audibility in case of SOC audit.
masterkey2, refers to the masterkey2 db, which contains "id, timestamp". Any change to the row requires an update to masterkey2, again for auditbility for last modification reason.
mk1, contains "id, userid". Which is the user that created the row.
Finally, mk4 refers to the new mk4link table, which is a LinkTable that links the main table to the mk4update table.
mk4update is 'mk4id, username, timestamp, creator' and contains a list of any changes to the table and a flag indicating this is the creation date. Have you done a SOC compliance report before? No? Well, all of this is mandated by the SOC compliance, its kind of ugly, but it works and is absolutely required."
"Why are there 4 unique keys on this table named masterkey, masterkey2, mk1, mk4?"
Principle Engineer. "Well, the masterkey indicates which key this was mastered on, if you check the masterkey db, which is just "id, timestamp, masterid", this is required to comprehensively log the creation date of the row to maintain the db's audibility in case of SOC audit.
masterkey2, refers to the masterkey2 db, which contains "id, timestamp". Any change to the row requires an update to masterkey2, again for auditbility for last modification reason.
mk1, contains "id, userid". Which is the user that created the row.
Finally, mk4 refers to the new mk4link table, which is a LinkTable that links the main table to the mk4update table. mk4update is 'mk4id, username, timestamp, creator' and contains a list of any changes to the table and a flag indicating this is the creation date. Have you done a SOC compliance report before? No? Well, all of this is mandated by the SOC compliance, its kind of ugly, but it works and is absolutely required."