I’m not a DBA, and I don’t do a lot of SQL. What I do use is Hibernate! Some conventions have been kept around for years, when they aren’t really needed.
I’m not a big fan of my column names repeating my tables names:
For instance an Address table with column names like address_id, address_street1, state_id.
I understand that when your doing SQL joins this allows you to avoid naming collisions. But in my world, I’m never using the table names or column names except for in my annotations.
Following this convention actually requires me to add @Column(name = “address_street1″) to my object, instead of simply @Column
With my preferred approach, my columns match up nicely with my domain objects/data models. I don’t want to have to add the “name” part to my @Column annotation.
Can we all agree that from now on, we write our model objects and database tables so that we don’t need the (name = “address_street1″) part? Please?
