MySQL Table layout

[Mike]

I am new to designing databases, so I need help with some tables.

OK, for my new site, which will be a type of directory, I am collecting the following info:

Company Name, URL, Description, Contact Name, Contact EMail, Catagory, Price, Username, Password, Expire Date, and their Logo (which is uploaded)

My original idea for tables is this:

|------------------------------------------------|
| Hosts
|------------------------------------------------|
|ID|CName|URL|Description|Price|Logo|Expire|ConID|
|------------------------------------------------|

|-----------------|
| ConInfo
|-----------------|
|ID|Name|Email|PID|
|-----------------|

|-----------|
| Relate
|-----------|
|HID | CatID|
|-----------|

|-----------|
|Catagories|
|-----------|
| ID | Name |
|-----------|


|-----------------|
| Users
|-----------------|
|ID|Username|Pword|
|-----------------|


So is there anything I should change? Any tables which could be combined?

I can give you more info about each colom if you need it. Thanks.

[samsm]

I'm no database expert but...

I think everything looks good and nothing nessesarily needs or should be combined.

However... if you are only going to have one contact for each host (and one host for each contact) then you could combine hosts and contacts.

If you were to allow for more than one contact for each host, then you'd need a separate contact-host lookup table. (which would also mean that you might want to rename your "relate" table so that it has a more meaningful name).

Just some thoughts .

[Mike]

ok, I think I'll combine the hosts and contact table. Thanks!

[Maelstrom]

I would tend to agree. Although for extensiblities sake I would leave them seperate. That way if it ever comes up where you need multiple contacts

1 - billing
2 - support
3 - your best friend

Having the extra table already built in removes the need to hack at it later