[thelist] DB Design question

rudy rudy937 at rogers.com
Mon Sep 15 12:38:52 CDT 2003

> or, assume if the record exists in this joining table that the breed is
> active, otherwise it's inactive, in which case you can drop the isactive
> column entirely.

dude, i like the way you think

that's clever

so basically, you get the active ones by doing a join, and the rows that
don't match are dropped

another advantage of this design is that there might be situations where you
could use the joining table as the "driver" in some other query to some
other table, and since it contains the primary keys of only the active ones,
it might be faster than a join which includes a condition which interrogates
an active/inactive column

still, unless this app is going to be as big as amazon or ebay, i'd probably
stick to the active/inactive column (option 1)

i wouldn't use a boolean datatype, simply because it's so poorly supported
across databases, but rather something like a tinyint or a char(1)


More information about the thelist mailing list