Database Date Field Naming Convention
Naming is hard. When it comes to naming conventions, the key is to keep things simple. Here's how I like to name the date and time fields in my databases.
I use a simple naming convention for most of my date fields:
{Past Tense Action Verb}On -- Date only fields
{Past Tense Action Verb}At -- Date/time fieldsThis tells me at a glance whether a field contains:
- A date-only value
- A date/time value
- A non-date value
It also informs me of the user action that corresponds with the date/time value.
Let's say I want to keep track of when a user marked a record as inactive. I would use one of the following field names:
InactivatedOnInactivatedAt
What's your preferred date field naming convention? Let me know in the comments below.
Photo by Dave Hoefler on Unsplash
