The scope of this document is to propose a naming convention for the database schema. The main objectives are:
Portability to databases other than MySQL is out of scope of this document.
account_name
.table
, column
, index
, etc.In addition to the constraints above, particular database identifier types have additional constraints. Maximum lengths were initially derived from the MySQL manual. While some of these restrictions are not mandatory, following them to the letter will help ensure database portability.
Identifier Type |
Max length (characters) |
Example |
---|---|---|
database/schema |
64 |
|
table |
64 |
|
column |
64 |
|
index |
64 |
|
view |
64 |
|
alias |
255 |
|