How to properly name record creation(insertion) datetime field?
Why not just use plain on Created
, or CreatedOn
. Windows OS uses three date properties for files.
Created:
Modified:
Accessed:
So you could try to keep that sort of convention if you prefer.
I tend to InsertedDateTime
and InsertedBy
(and Updated%
, Affected%
for indirect updates perhaps, Deleted%
for logical deletes).
OperationDateTime
for general auidt table
If I was storing a date only, it would be StartDate
. Likewise, time only would be BookedTime
Another rule is to avoid "SQL" terms, so Added/Changed rather then Inserted/Updated. I inherited Inserted/Updated and it's consistent at least
Just be consistent: no mixing Created%
with Inserted%
with Added%
I always use CreatedDate
in these circumstances, and it gives a template for other dates: UpdatedDate
, DeletedDate
, PurchasedDate
and so on.