For most of the tables in our DB will have some kind of auditing fields. Following are the column names I used to use for those auditing fields.
|CreationTime||datetime2(7)||NOT NULL||eg. 2019-09-15 13:56:13.8955178|
If you have worked with ABP before, you know from where I adopted the naming convention.
When I work on a non-ABP project, I used to follow the same column names.
Let me know what you used to name for auditing columns in the comments. 👇