data base design (newbie)

[phpmysqlrules]

Greetings, thank you for taking the time to view this thread.

I am a new developer...my first database...
I am making a site that allows private sellers and dealers to post ads on a website that sells hockey cards...

The user of the web site will be able to search by the following:
dealer, private seller,country,state,province (for Canada) date,featured card or not featured.

Should I create seperate tables for dealers or private sellers or should i just group them into one table under members...

( any help or critism would be appreciated..or even a recommendation of a good booK

here is what i have done so far:

(all searches will be done from the search table ..see below)
MEMBER
member_id,member name,password,fname,lname,address,country_id,state_id,province_id,company_name,company_url

DEALER
dealer_id,member_id

PRIVATE
private_id,member_id

COUNTRY
country_id,country

STATE
state_id,state

PROVINCE
province_id,province

POSITION
position_id,position ...eg forward,defence,goalie

AD ( ads will be posted via of form input )
ad_id,member_id,headline,picture,comments,state_id,country_id,province_id,date,price,feature_id,

Featured Ads
feature_id,ad_id

Thanks for your help...I hope you can understand the logic..( or lack thereof 🙂

Have a great holiday season

phpmysqlrules🙂

[planetsim]

Id say make it one table.

Now you could/should however make other tables if the data from that table is to be spread across the site in other situations (This is called a Relational database).

[ahundiak]

It depends in part on if you plan on having dealer specific information and private seller specific information.

For example, you have company_name and company_url in the members table. Do you really need company information for private sellers? If not then those fields might be moved to the dealer table.

[phpmysqlrules]

Thanks for your help with the tips.

phpmysqlrules 😉