For new apps, and eventually for updated apps, we should have consistent naming conventions used in our databases. This will help with ease of reviewing and debugging databases across all of our systems.

All new database tables have to have the following fields:

pkTablenameID

.

.

.

Notes

Active

CreatedBy

CreatedDate

ModifiedBy

ModifiedDate

This list can be discussed and modified by Devs as needed before putting in to place.