COE Database Table Naming Conventions
For all College of Education Databases, table names shall:
- Contain only alpha-numeric characters: those in the ASCII ranges 48-57, 65-90, & 97-112 ("0-9", "A-Z", & "a-z").
- Be limited in length to 32 characters, including the prefix.
- Begin with a pre-defined prefix that explains their function. The current convention uses:
- tbl -- Table (Tables containing data that is read and written)
- lst -- List (Tables containing data that is read-only, such as lists to populate drop-down boxes, etc)
- qry -- Query (This applies mostly to MS Access)
- Follow a consitent case scheme for capitalization without spaces or underscores in its name.
- The first character of the table name is always capitalized.
- Other characters in the table name will be lower-case, except those that start words in a table with multiple words.
- Not use reserved words for any systems or software that may be used to interact with the database (i.e. system, select, and level). Diligent application of the above prefix rule will ensure that this rule is satisfied.
- Be descriptive of the data contained in the table.
These naming conventions have been adopted on April 2, 2003, by the College of Education IT Services and Database Group and may be amended by majority consensus of the group.
|
