Style guide for database metadata naming
- by Nulldevice
We want to establish some database metadata naming rules in our new project. For example:
tables are named as nouns in a plural
form (courses, books, lessons)
if present, an adjective goes before
a noun in a table name and is separated
by an underscore (red_books,
new_lessons)
table index column is always named
"id"
foreign key names are derived from a
table name with suffix _id (book_id,
red_book_id)
so on
Does someone know any guide like this?