DATETIME列的命名约定是什么(在我的例子中,使用MS SQL Server)
对于存储行创建时间的列,CreatedDatetime或LastModifiedDatetime是有意义的.
但是对于一个简单的表,假设有一个名为Event的表,您是否会创建名为:
EventID, // Primary key
EventDatetime, // When the event is happening
EventEnabled // Is the event is on
或
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.