create table project_details
(
	project_name varchar2(20),
	project_id number primary key,
	project_desc varchar2(100),
	project_category varchar2(20),
	domain varchar2(20),
	preferable_tech varchar2(20),
	estimated_budget number,
	estimated_duration varchar2(20),
	reported_date date,
	status varchar2(20),
	remarks varchar2(100),
	client_UID number,
	client_name varchar2(20),
	client_location varchar2(20),
	client_contacts varchar2(50),
	planned_start_date date,
	planned_end_date date,
	actual_start_date date
);


create table project_users
(
	client_UID number primary key,
	user_name varchar2(20) unique,
	password varchar2(20)
);

insert into project_users
values
(
	1000,
	'guest1',
	'welcome'
);

insert into project_users
values
(
	1001,
	'guest2',
	'welcome'
);

commit;

insert into project_details
values
(
	'Project Inventory',
	100,
	'A web Application',
	'Web Application',
	'Utilities',
	'Java/J2EE',
	100,
	'Two Months',
	'02-jul-2006',
	'In Progress',
	'A first Project',
	1000,
	'Inspira',
	'United States',
	'09346752425',
	'15-jul-2006',
	'15-aug-2006',
	'27-Jul-2006'
);

insert into project_details
values
(
	'Gemini',
	101,
	'A web Application',
	'Web Application',
	'Utilities',
	'Java/J2EE',
	3000,
	'Two Months',
	'02-jul-2006',
	'Closed',
	'Second Project',
	1001,
	'Wipro Technologies',
	'United Kingdom',
	'09346752425',
	'15-jul-2003',
	'15-aug-2004',
	'27-Jul-2005'
);



insert into project_details
values
(
	'OSS',
	102,
	'OSS ERP solutions',
	'ERP Application',
	'EDU',
	'OA Framework',
	300000,
	'Two years',
	'02-jul-2006',
	'In Progress',
	'First Project',
	1001,
	'Oracle Pvt ltd',
	'United States',
	'09346752425',
	'15-jul-2003',
	'15-aug-2004',
	'27-Jul-2005'
);

commit;

create sequence project_seq start with 100;

select project_seq.nextval from dual;