BobSharp wrote:
As a complete newbie in MySQL, I need a database
to store URLs related to Tenpin Bowling.
There are several Categories ... Equipment Manufacturers,
Organistations, (UK) ProShops, (UK) Bowling Centres, Personal
Websites, Misc., Coaching & Instructional websites, etc.
There will be some sub-categories.
eg: Organistions will have ... Zones of WTBC, National Organisations
within
the Zones, UK organisations, Disabled Bowling organisations, ...
eg: Personal Website might have ... Bowler's, Pro Bowler's, Leagues,
etc.
Can anyone suggest how I should set out tables for this database ?
Here's one suggestion
Table:
URLs:
URL_ID
URL_TEXT
CATEGORY
CATEGORY_ID
CATEGORY_TEXT
SUBCAT
SUBCAT_ID
CATEGORY_ID
SUBCAT_TEXT
URL_CATEGORY
URL_ID
CATEGORY_ID
SUBCATEGORY_ID
PK: (URL_ID, CATEGORY_ID)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org