Vereinbarungen des DFG Projekts
- ensure the name is unique and does not exist as a reserved keyword (often problem with word group!) → http://dev.mysql.com/doc/refman/5.7/en/keywords.html
- names must begin with a letter and may not end with an underscore
- only use letters, numbers and underscores in names
- avoid the use of multiple consecutive underscores
- use underscores where you would naturally include a space in the name e.g. first_name
- avoid abbreviations and if you have to use them make sure they are commonly understood
- singular, start from capital letter e.g. User
- avoid long names, but in case they are necessary don't use underscores (exception many to many relation) e.g. HomeAddress
- many to many relations with x e.g. Group_x_User
- no prefixes e.g. tbl, Table or any other
- singular, start from small letter, camel case e.g. postalCode
- primary key always id
- foreign key table_id e.g. user_id
- no column with the same name as its table
- foreign key FK_table_field e.g. FK_User_address_id
