drop table login;
create table login (
username varchar2(20) not null,
password varchar2(20) not null
);
insert into login values('NAVEEN','admin');
drop table applicantinterview;
create table applicantinterview(
interviewid number(10) primary key,
interviewtype varchar2(25),
interviewby varchar2(25),
skillrate varchar2(25),
commrate varchar2(25),
comments varchar2(60));
drop table applicantsdetails;
create table applicantsdetails (
applicantid	number(10),
state		varchar2(25),	
dateofbirth	varchar2(25),
title		varchar2(25),
firstname	varchar2(25),
lastname	 	varchar2(25),
middleinitial	varchar2(25),
applicationdate	varchar2(25),
dayphone	varchar2(25),
availability	varchar2(25),
extension	varchar2(25),
immigration	varchar2(25),
martialstatus	varchar2(25),
eveningphone	varchar2(25),
gender		varchar2(25),
mobilephone	varchar2(25),
address		varchar2(25),
email		varchar2(25),
city		varchar2(25),
zip		varchar2(25),
qulification	varchar2(25),
specialization	varchar2(25),
experience	varchar2(25),
reference	varchar2(25),
presentsalary	varchar2(25),
expectedsalary	varchar2(25),
securitynumber	varchar2(25),
comments 	varchar2(25)
);
drop table clientdetails;
create table clientdetails(
clientid 		number(10) primary key,
companyname	varchar2(25),
contactname	varchar2(25),
address		varchar2(40),
city		varchar2(25),
state		varchar2(25),
zip		varchar2(25),
title		varchar2(25),
extension	varchar2(25),
telephone	varchar2(25),
fax		varchar2(25),
country		varchar2(25),
email		varchar2(25),
department	varchar2(25)
);
drop table applicantskills;
create table applicantskills(
applicantid number(20),
skills varchar2(25),
experience varchar2(25),
lastused varchar2(25));
drop table joborder;
create table joborder(
jobid number(10),
clientid number(10),
opendate 	varchar2(15),
enddate		varchar2(15),
education	varchar2(25),
experiencs	varchar2(25),
experienceinfield	varchar2(25),
status		varchar2(25),
jobcategory	varchar2(15),
numberofvacancies   varchar2(25),
assigned		varchar2(25),
jobdescription	varchar2(40)
);
drop table employeedetails;
create table employeedetails
(
employeeid	 number(10),
state 		varchar2(25),
dateofbirth	varchar2(25),
password	varchar2(25),
firstname	varchar2(25),
lastname		varchar2(25),
init		varchar2(25),
designation	varchar2(25),
dayphone	varchar2(25),
extension	varchar2(25),
role		varchar2(25),
martialstatus	varchar2(25),
country		varchar2(25),
gender		varchar2(25),
mobileno		varchar2(25),
address		varchar2(45),
email		varchar2(25),
city		varchar2(25),
zip		varchar2(25),
clientid		number(10));
drop table interviewdetails;
create table interviewdetails
(applicantid	number(10),
Interviewtype varchar2(20),idate  varchar2(15),
comments varchar2(40));

drop table placementdetails;
create table placementdetails
(
clientid number(10),
companyname varchar2(25),
department varchar2(25),
position varchar2(25),
status varchar2(25),
appointmentdate varchar2(25),
employeeid number(10),
name varchar2(25),
qulification varchar2(25),
specilization varchar2(25),
experience varchar2(25),
salary varchar2(25)
);


create table resume (applicantid	number(10),resume1 clob );

create sequence clientid start with 2000 increment by 1;
create sequence empid start with 3000 increment by 1;
create sequence appid start with 4000 increment by 1;