Need Database structure! $200 fri or more if needed

billybob

Hi,
I am in need of a database structure for a new website that I and a freind am creating, the site will allow a user to register and input all the following feilds:

The site will also allow the user to log in with there username and password they registerd with. The main problem we are having is that the users will be able to have more than one site so all the site information i.e. site title, site url, site category, site description will have to be able to link to the user along with the multiple site details.

All I am asking for here is a entity relationship diogram on which this site would be able to use, i fyou need any more information please ask. 200$fri is up for grabs for one person who manages to produce this if you wish for more just ask.
thanks
Ryan

DoctorBeaver

I would do it like this:-

MEMBER_TABLE
member_id int(n) auto key
title
forename
surname
email
username
password

SITE_TABLE
member_id int(n) key - taken from member_table.member_id
title
url
category
description

Using this method a member can have any number of sites. They are all linked by the member_code field in both tables.
You can set the actual field definitions to whatever you want them to be (don't make the mistake I did when I first did something similar and make the email field too small. I settled for char(50) in the end. The size of the member id field depends on how many members you anticipate having. On my site I've used int(6) just to be safe.