create table BILLINGCYCLE
(
  BILLINGCYCLEID   NUMBER not null,
  BILLINGCYCLEDESC VARCHAR2(2000),
  STARTDATE        DATE,
  ENDDATE          DATE,
  NUMWORKINGDAYS   NUMBER,
  MAKERID          VARCHAR2(32) not null,
  MAKEDATE         DATE not null,
  STATUS           VARCHAR2(2) not null
);

-- Create/Recreate primary, unique and foreign key constraints 
alter table BILLINGCYCLE
  add constraint PK_BILLINGCYCLEID primary key (BILLINGCYCLEID);

 -------------
 -- Create table
create table PROJECT
(
  PROJECTID      NUMBER not null,
  PROJECTDESC    VARCHAR2(2000),
  EFFORTESTIMATE NUMBER,
  MAKERID        VARCHAR2(32) not null,
  MAKEDATE       DATE not null,
  STATUS         VARCHAR2(2) not null
);

-- Create/Recreate primary, unique and foreign key constraints 
alter table PROJECT
  add constraint PK_PROJECTID_PR primary key (PROJECTID);
  ----Sample data
  
  insert into billingcycle (BILLINGCYCLEID, BILLINGCYCLEDESC, STARTDATE, ENDDATE, NUMWORKINGDAYS, MAKERID, MAKEDATE, STATUS)
values (1, 'JULY-2008 Billing Cycle', to_date('21-06-2008', 'dd-mm-yyyy'), to_date('20-07-2008', 'dd-mm-yyyy'), 20, 'SYSTEMM', to_date('04-08-2008', 'dd-mm-yyyy'), 'A');

insert into billingcycle (BILLINGCYCLEID, BILLINGCYCLEDESC, STARTDATE, ENDDATE, NUMWORKINGDAYS, MAKERID, MAKEDATE, STATUS)
values (2, 'AUG-2008 Billing Cycle', to_date('21-07-2008', 'dd-mm-yyyy'), to_date('20-08-2008', 'dd-mm-yyyy'), 22, 'SYSTEMM', to_date('04-08-2008', 'dd-mm-yyyy'), 'A');

insert into billingcycle (BILLINGCYCLEID, BILLINGCYCLEDESC, STARTDATE, ENDDATE, NUMWORKINGDAYS, MAKERID, MAKEDATE, STATUS)
values (3, 'SEP-2008 Billing Cycle', to_date('21-08-2008', 'dd-mm-yyyy'), to_date('20-09-2008', 'dd-mm-yyyy'), 21, 'SYSTEMM', to_date('04-08-2008', 'dd-mm-yyyy'), 'A');

insert into billingcycle (BILLINGCYCLEID, BILLINGCYCLEDESC, STARTDATE, ENDDATE, NUMWORKINGDAYS, MAKERID, MAKEDATE, STATUS)
values (4, 'OCT-2008 Billing Cycle', to_date('21-09-2008', 'dd-mm-yyyy'), to_date('20-10-2008', 'dd-mm-yyyy'), 17, 'SYSTEMM', to_date('04-08-2008', 'dd-mm-yyyy'), 'A');

insert into billingcycle (BILLINGCYCLEID, BILLINGCYCLEDESC, STARTDATE, ENDDATE, NUMWORKINGDAYS, MAKERID, MAKEDATE, STATUS)
values (5, 'NOV-2008 Billing Cycle', to_date('21-10-2008', 'dd-mm-yyyy'), to_date('20-11-2008', 'dd-mm-yyyy'), 23, 'SYSTEMM', to_date('04-08-2008', 'dd-mm-yyyy'), 'A');

insert into billingcycle (BILLINGCYCLEID, BILLINGCYCLEDESC, STARTDATE, ENDDATE, NUMWORKINGDAYS, MAKERID, MAKEDATE, STATUS)
values (6, 'DEC2008 Billing Cycle', to_date('21-11-2008', 'dd-mm-yyyy'), to_date('20-12-2008', 'dd-mm-yyyy'), 21, 'SYSTEMM', to_date('04-08-2008', 'dd-mm-yyyy'), 'A');

insert into billingcycle (BILLINGCYCLEID, BILLINGCYCLEDESC, STARTDATE, ENDDATE, NUMWORKINGDAYS, MAKERID, MAKEDATE, STATUS)
values (7, 'JAN-2009 Billing Cycle', to_date('21-12-2008', 'dd-mm-yyyy'), to_date('20-01-2009', 'dd-mm-yyyy'), 22, 'SYSTEMM', to_date('04-08-2008', 'dd-mm-yyyy'), 'A');

insert into billingcycle (BILLINGCYCLEID, BILLINGCYCLEDESC, STARTDATE, ENDDATE, NUMWORKINGDAYS, MAKERID, MAKEDATE, STATUS)
values (8, 'FEB-2009 Billing Cycle ', to_date('21-01-2009', 'dd-mm-yyyy'), to_date('20-02-2009', 'dd-mm-yyyy'), 22, 'SYSTEMM', to_date('04-08-2008', 'dd-mm-yyyy'), 'A');

----
insert into project (PROJECTID, PROJECTDESC, EFFORTESTIMATE, MAKERID, MAKEDATE, STATUS)
values (1, 'Risk based pricing', 14, 'SYSTEMM', to_date('04-08-2008 15:12:04', 'dd-mm-yyyy hh24:mi:ss'), 'A');

insert into project (PROJECTID, PROJECTDESC, EFFORTESTIMATE, MAKERID, MAKEDATE, STATUS)
values (2, 'LO Corporate Enhancements', 15, 'SYSTEMM', to_date('04-08-2008 15:12:04', 'dd-mm-yyyy hh24:mi:ss'), 'A');

insert into project (PROJECTID, PROJECTDESC, EFFORTESTIMATE, MAKERID, MAKEDATE, STATUS)
values (3, 'Data upload features (LO Application Web Service)', 8, 'SYSTEMM', to_date('04-08-2008 15:12:04', 'dd-mm-yyyy hh24:mi:ss'), 'A');

insert into project (PROJECTID, PROJECTDESC, EFFORTESTIMATE, MAKERID, MAKEDATE, STATUS)
values (4, 'Dedupe features', 3, 'SYSTEMM', to_date('04-08-2008 15:12:04', 'dd-mm-yyyy hh24:mi:ss'), 'A');

insert into project (PROJECTID, PROJECTDESC, EFFORTESTIMATE, MAKERID, MAKEDATE, STATUS)
values (5, 'Project Finance', 20, 'SYSTEMM', to_date('04-08-2008 15:12:04', 'dd-mm-yyyy hh24:mi:ss'), 'A');

insert into project (PROJECTID, PROJECTDESC, EFFORTESTIMATE, MAKERID, MAKEDATE, STATUS)
values (6, 'Leasing - conventional', 20, 'SYSTEMM', to_date('04-08-2008 15:12:04', 'dd-mm-yyyy hh24:mi:ss'), 'A');

insert into project (PROJECTID, PROJECTDESC, EFFORTESTIMATE, MAKERID, MAKEDATE, STATUS)
values (7, 'Diff.types of repayment methods (Cheque, ECS¿), Diff types of Amort Schedules ( Free format, Bullet¿), Value dating, Floating rate of interest', 50, 'SYSTEMM', to_date('04-08-2008 15:12:04', 'dd-mm-yyyy hh24:mi:ss'), 'A');

insert into project (PROJECTID, PROJECTDESC, EFFORTESTIMATE, MAKERID, MAKEDATE, STATUS)
values (8, 'Limit Management', 7, 'SYSTEMM', to_date('04-08-2008 15:12:04', 'dd-mm-yyyy hh24:mi:ss'), 'A');

insert into project (PROJECTID, PROJECTDESC, EFFORTESTIMATE, MAKERID, MAKEDATE, STATUS)
values (9, 'Corporate LO-LM integration', 15, 'SYSTEMM', to_date('04-08-2008 15:12:04', 'dd-mm-yyyy hh24:mi:ss'), 'A');

insert into project (PROJECTID, PROJECTDESC, EFFORTESTIMATE, MAKERID, MAKEDATE, STATUS)
values (10, 'Restructuring / rescheduling improvements', 13, 'SYSTEMM', to_date('04-08-2008 15:12:04', 'dd-mm-yyyy hh24:mi:ss'), 'A');