For computed data ( SUM() or AVG()) use the name you would give it were it.Always include the AS keyword-makes it easier to read as it is explicit.If there is already a correlation with the same name then append a number.As a rule of thumb the correlation name should be the first letter of each word.Should relate in some way to the object or expression they are aliasing.Always use lowercase except where it may make sense not to such as proper nouns.Do not add a column with the same name as its table and vice versa.Where possible avoid simply using id as the primary identifier for the table.Rather than cars_mechanics prefer services. Avoid, where possible, concatenating two table names together to create the name.Never give a table the same name as one of its columns and vice versa.Do not prefix with tbl or any other such descriptive prefix or Hungarian.Use a collective name or, less ideally, a plural form. Avoid abbreviations and if you have to use them make sure they are commonly.Use underscores where you would naturally include a space in the name (first.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |