Restdrivers

-1-
create table companys(
companyid int(11) not null auto_increment,
companyname varchar(50),
address varchar(255),
postcode int(4),
city varchar(30),
country varchar(30),
phonenumber varchar(30),
faxnumber varchar(30),
email varchar(30),
unique key (companyname),
primary key (companyid)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-2-
create table drivers(
driverid int(11) not null auto_increment,
companyid int(11),
fname varchar(14),
mname varchar(14),
lname varchar(14),
birthday date,
licensenumber int,
unique key(licensenumber),
primary key (driverid),
foreign key (companyid) references companys(companyid) on delete cascade on update cascade
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-3-

create table staffs(
staffid int(11) not null auto_increment,
companyid int(11),
fname varchar(14),
mname varchar(14),
lname varchar(14),
jobtitle varchar(50),
primary key (staffid),
foreign key (companyid) references companys(companyid) on delete cascade on update cascade

) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-4-
create table places(
placeid int(11) not null auto_increment,
placename varchar(50),
primary key (placeid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-5-
create table restdrivers(
restdriverid int(11) not null auto_increment,
companyid int(11),
staffid int(11),
driverid int(11),
fromH time,
fromD date,
toH time,
toD date,
ifill boolean,
ifrestyear boolean,
ifoutof561 boolean,
placestaffid int(11),
datestaff date,
placedriverid int(11),
datedriver date,
primary key (restdriverid),
foreign key (companyid) references companys(companyid) on delete cascade on update cascade,
foreign key (staffid) references staffs(staffid) on delete cascade on update cascade,
foreign key (driverid) references drivers(driverid) on delete cascade on update cascade,
foreign key (placestaffid) references places(placeid) on delete cascade on update cascade,
foreign key (placedriverid) references places(placeid) on delete cascade on update cascade
) ENGINE=InnoDB DEFAULT CHARSET=utf8;