[thelist] function_id

[Erik Mattheis]

I think what whoever was suggesting would look something like

categories table:
category         cat_id      parent_cat_id
sportsmen      1               <null>
hunters            2              1
foxhunters       3              2
birdhunters     4               2
WMDhunters   5              2

people table:
person    person_id     cat_id
fred          1                     4

You could tell fred's cat_id indicates that he's a birdhunter, hunter
and sportsman.

On Sunday, February 16, 2003, at 01:39  PM, Russell Griechen wrote:

> I am trying to grasp the idea of using function_id as a shorthand for
> normalizing.
>
> I have a categorie
> and create table sportsmen(
>
> subfolders? would be
> hunters
> subfolders of hunters:
>
> foxhunters
> birdhunters
> treehunters
> deerstalkers
>

> if rather than
> creating one column for each category (ie, foxhunder_id, hunter_id,
> etc),
> you instead created one column and called it "function_id"
-----------------------
Erik Mattheis
GoZz Digital
<http://goZz.com/>
Flash and ColdFusion Development
Minneapolis, MN
-----------------------