This content originally appeared on Bram.us and was authored by Bramus!
There are plenty of times in my career when I’ve stored a boolean and later wished I’d had a timestamp. There are zero times when I’ve stored a timestamp and regretted that decision.
Hear hear! Over the years I’ve come to include 9 meta fields for most of the tables I create: added_at
, added_by
, added_ip
, edited_at
, edited_by
, edited_ip
, deleted_at
, deleted_by
, and deleted_ip
. Handy for whenever you receive a phone call saying that a record has disappeared, allowing you to pinpoint it to a user and a specific timestamp.
You might as well timestamp it →
This content originally appeared on Bram.us and was authored by Bramus!
Bramus! | Sciencx (2021-06-04T21:20:05+00:00) You might as well timestamp it. Retrieved from https://www.scien.cx/2021/06/04/you-might-as-well-timestamp-it/
Please log in to upload a file.
There are no updates yet.
Click the Upload button above to add an update.