Database naming conventions

[eluser]Dam1an[/eluser]
General:
Exactly the same as yours
Tables:
- short, unambiguous names
- tables storing 'Objects' are plural, eg users, messages, comments etc
- avoid abbreviated, concatenated, or acronym-based names
- many to many relationship tables are [singular of table 1]_[plural of table 2] eg account_users, message_comments
Fields:
- no table name prefix, I rarely get any ambiguous fields, and if so, just do table.field, I also prefer to do $user->first_name instead of $user->user_first_name
- PK is always id (auto increment)
- FK is always [foreign table name]_id (Assuming I'm linking to the PK, which I always do)
- Booleabs, is_[name]