question about structure

[gnome]

Hello all,
I was looking through the forums and did not see anything that will get me started, so here I am.

Scenario:
3 clients
3 jobs each client
100 html files containing image mapping (map name, href, shape, & coords)

Goal:
What I would like to do is have php parse the data from the image mapped pages into a database.

Software:
php, mysql

I have a database structure like so:

table 1
Client_____________
JID --Auto increment
name -- client name

table 2
Job_____________
JOB_ID -- auto increment
JID -- identify client
name -- name of job

table 3
Image_Map________
MID -- Auto increment
JID -- to identify client
JOB_ID -- identify job name
map_name -- pulled from each map.html | there can be more than
shape -- pulled from each map.html |-- one entry for each html
coords -- pulled from each map.html | and some may have none


Am I on the correct path? This is the first big project I have had to do and I know that more than anything your database needs to be setup properly from the beginning.

If any further information is needed, please let me know.

Thank you

[redemption]

Here's what I think.

Client
------
JID
name

Job
---
JOB_ID
JID
name

Image_Map
---------
MID
JOB_ID
map_name
shape
coords

Exactly like what you did, except I removed the JID attribute from the Image_Map table because it seemed redundant. Can't really say more - I don't understand how the map_name, shape and coords attributes work.

[gnome]

Hey
Thank you redemption

I appreciate your help.
I have started the db design and we will go from there. If I have anymore questions, I know where to go.
Have a good one.