[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