Design Help plaese

[lucilue2003]

I want to create a job site. I am using mysql. I really want my site to be very quick.

What do you think about my design ?

[zipLoaction]
pk - z_zipCode int (5)
- z_City varchar(25)
- z_stateAbbr char(2)

[CompanyName]
pk c_id
c_Name varchar(50)

[Experience]
pk e_id int
e_Name varchar(30) #1-2 years ; #3-4 years ..

[JobItems]
pk j_id int
z_zipCode
c_cid
j_title varchar(50)
j_link
j_description
j_date timestamp
j_salary integer
e_id

This designs forces me to do things like where jobitems.c_cid = CompanyName.c_id and jobitems.e_id = Experience.e_id

Any ideas on how to make this better?
Do you guys know where i can get free zipcode and city information .. I want to populate my tables with that data.

[leatherback]

Hi Luci,

Looks pretty good to me. The seperation of colums is a good thing, and will enable you to change the name of functions / companies very easily, without going through the whole database. In your queries use the join commands. I am not sure, but I think it is quicker then the ..ID = ..id construction.

J

[lucilue2003]

So what do you think ?

CREATE TABLE zipLocations(
z_zipCode int(5) NOT NULL default '00000',
z_cityName varchar(50) NOT NULL default '',
z_stateAbbr char (2) NOT NULL default '',
z_stateName varchar(25) NOT NULL default '',
PRIMARY KEY (z_zipCode)
) ;

CREATE TABLE companyName(
c_id int(11) NOT NULL default '0',
c_Name varchar(50)NOT NULL default '',
PRIMARY KEY (c_id)
) ;

CREATE TABLE experienceLevel(
e_id int(2) NOT NULL default '0',
e_Name varchar(50) NOT NULL default '',
PRIMARY KEY (e_id)
) ;

CREATE TABLE jobItem(
j_id int(11) NOT NULL default '0',
z_zipCode int(5) NOT NULL default '00000',
c_id int(11) NOT NULL default '0',

j_title varchar(50) NOT NULL default '',

j_link varchar(50) NOT NULL default '',

j_description varchar(255) NOT NULL default '',

j_date datetime NOT NULL default '0000-00-00 00:00:00',

j_salary varchar(15) NOT NULL default '',
PRIMARY KEY (j_id)
) ;