[thelist] function_id
Russell Griechen
russgri at bellsouth.net
Sun Feb 16 18:01:01 CST 2003
> the structure you may want to use for your categories is a hierarchy or
tree
>
> create table categories
> ( catid integer not null primary key
> , catname varchar(100) not null
> , parentcat integer null
> , foreign key (parentcat) references categories
> )
>
> if each sportsman, er, sportsperson can belong to only one category, then
>
> create table sportspeople
> ( personid integer not null primary key
> , personname varchar(100) not null
> , personcat integer null
> , foreign key (personcat) references categories
> )
>
> sample categories
> 103 hunters --
> 104 fishers --
> 106 foxhunters 103
> 107 trawlers 104
> 108 wabbithunters 103
>
> sample sportspeople
> 502 prince charles 106
> 504 fontsize troll 107
> 505 elmer fudd 108
>
wow! (not over snipping for research purposes)
rudy, you are the best.
certainly a good solution and on one site that is what I will use for the:
"if each sportsman, er, sportsperson can belong to only one category, then"
I am trying to use a scenario that ...The Foxhunter's Historical Society...
that would have:
On another situation:
'if each sportsperson ..pc here...can belong to several categories including
a genealogical pedigree as well
Trying to fashion that table/tables is a learning task for me ...so I will
present it later for comment.
Speaking of pedigrees I have created a absolutely positioned pedigree tree
that would load a hound's pedigree and I was losing sleep over its
implementation when...bhambob@ came up with a add-on to a good genealogical
software which I have bought and took trees to a different level.
This can be viewed at
http://www.bnbcarver.us/FamilyTree/pedigree.php?personID=I177&tree=Default
stripping it out of the frames. The link for the software is at the bottom
of the page.
So I am going to merge the Sportsmen/Hunter/ tables into the NextGen
software.
Russell Griechen
More information about the thelist
mailing list