Re: FN-FORUM: [OT] flippancy - What's the best development platform for creating Web 2.0 business applications?

date posted 22nd November 2007 10:27



Anthony Cartmell wrote:
>
> I've never had much DB training, apart from as part of a Mechanical
> Engineering degree, but in my mind using an auto-incrementing integer
> ID seems quite logical. Allows any of the data for an "item" to change
> without it becoming a new item. Also makes for consistency, as all
> tables that need to be referred to have `id` as their primary key name.
>
>
It's about working out where not to use it. A table that manages a
relationship probably shouldn't (e.g. user has many roles). I do however
agree that most tables need an id column. It makes life easier.