Database name convention: DATETIME column

Question

What is your naming convention for DATETIME columns (in my case, using MS SQL Server)

For a column that stores when the row was created CreatedDatetime makes sense, or LastModifiedDatetime.

But for a simple table, let's say one called Event, would you create columns called:

EventID,                 // Primary key EventDatetime,           // When the event is happening EventEnabled             // Is the event is on 

or

ID,                      // Primary key Datetime,                // When the event is happening Enabled                  // Is the event is on 

If you'd use neither convention: Please provide the column name you would use.

Answer 1

I normally name DATETIME columns as ACTION_WORD_on: created_on, completed_on, etc.

The ACTION_WORD defines what the column represents, and the suffix (_on) indicates that the column represents time.

Other suffixes (or even prefixes) may be used to specify the data type (_at, _UTC, when_, etc).

Be descriptive. Be consistent.