Wow I'm amazed and thankful for such help and advice
I thought I would attack this project piecemeal but that will not give a
clear view that will allow helpful comment without the full view.
I have a website at http://geocities.com/efoxfiles  a labor of love
So now it has become so detail intensive that I want to expand the scope
to include all field sports with a
Hunting...Foxhunting, Tree hunting Shooting Sports, Arena
Sports...rodeos, horse events, 4H, all linking to Contact table
Pedigrees...Hound,Whelping Date, Sire, Dam, Owner, Breeder... links to
Contact Table/zip/city/state/address
Timeline...back to Origin of each sport....all linking to Contact Table
Field Trial and Show Associations ...linking to Contact table

So I did not present the true picture as I was assuming that I could
piggyback all the tips and replicate them into a complete database.
Practically all cities and zip codes may have to be in linking tables
and the ID used in each category....So I know just enough to get me in
trouble.

So reflecting what advice I have received to date:
[Sportsmen] name to be registered of www

ContactID
FirstN,MidN,LastN,Suffix,Cityid,Stateid,Zip_Codepk,Addr1,Addr2,Other

Cityid pk
CityName

Stateid pk
Statename

Assnid
Assn  (Associations)

Trials/Showsid
Trials/Show

Houndsid
Registry# /*Date to be a Timestamp?...reflecting yyyymmdd001 to infinity
refecting how many hounds born on that date*/
IFSB#
SFSB#
UKC#
AKC#
Whelping Date /*Is there such a thing as Dateid (linking table)*/
Sire   (houndid)
Dam   (houndid)
Owner (contactid)
Breeder  (contactid)
Colorid   (20+ color combinations)
/*I have developed a CSS file that will display hound names in a
heirarchial display to display a pedigree. My hope is to be able to use
only the Sireid and Damid to present 5 generations???*/

/*I will have a large server thus excess capacity, php, mysql, pop3,
mailing lists...maybe I can reward some of my helpers down the road*/

Russell Griechen


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to