Please help me to design database for job site

linux1880 · #1 (**permalink**) 08-05-10, 04:07

Hi all, I would like this job site to list result according to country, and search jobs according to country. How do I achieve it ? So far, I have normalised this far, I don't know how to do countrywise. pls help

Code:

CREATE TABLE `categories` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
);


CREATE TABLE `jobs` (
  `id` int(11) NOT NULL auto_increment,
  `category_id` int(11) default NULL,
  `title` varchar(250) default NULL,
  `description` text,
  `location` varchar(100) default NULL,
  `company` varchar(100) default NULL,
  `posted` decimal(10,0) default NULL,
  `type` varchar(30) default NULL,
  `email` varchar(250) default NULL,
  `url` varchar(250) default NULL,
  PRIMARY KEY  (`id`)
);

CREATE TABLE `employers` (
 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
 `group_id` mediumint(8) unsigned NOT NULL,
 `username` varchar(15) NOT NULL,
 `password` varchar(40) NOT NULL,
 `salt` varchar(40) DEFAULT NULL,
 `email` varchar(40) NOT NULL,
 `created_on` int(11) unsigned NOT NULL,
 `last_login` int(11) unsigned DEFAULT NULL,
 `active` int(1) unsigned DEFAULT NULL,
 PRIMARY KEY (`id`)
)