create table js_member(
  email varchar(30) not null,
  company varchar(50),
  name varchar(30),
  password varchar(30),
  degree varchar(11),
  resume varchar(30),
  skill1 varchar(30),
  skill2 varchar(30),
  skill3 varchar(30),
  skill4 varchar(30),
  skill5 varchar(30),
  skill6 varchar(30),
  primary key(email));

create table js_contact_info(
  email varchar(30) not null,
  street varchar(30),
  city varchar(30),
  state varchar(2),
  zip varchar(5),
  phone varchar(14),
  primary key(email));

create table js_job(
  id int unsigned not null,
  description text,
  positions int unsigned,
  salary int unsigned,
  posting_date date,
  primary key(id));

create table js_contact(
  email varchar(30) not null,
  primary key(email));

create table js_post_search(
  email varchar(30) not null,
  id int unsigned not null,
  primary key(email, id));
