Database naming conventions

[eluser]jedd[/eluser]
Differences ...

Table name is never part of column name (something I'm passionately opposed to).

I tend to use SERIAL (MySQL specific) for PK's, though I'm moving away from that lately. PHP6 might see me move back to that standard. And/or if MySQL's tools start to ack that keyword (none of them seem to at the moment, which is sad/odd).

FK's are usually table_field, and though I'm not strict about this, I don't think I've ever not done it that way.

Date fields are not uniquely identified, but do tend to contain certain keywords - _when - for example.

Booleans aren't handled in a particular fashion, though I like your approach of is_ and will probably adopt that.

Oh, kudos on sticking with singular for all field names - the other thing I'm pretty passionate about is eschewing plurals in schemas. Just seems wrong, and has been an assumption that's turned me off many AR implementations.