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?