
  CREATE TABLE "ASPIRIN"."OCP_APPEALS" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"POSAVAILID" NUMBER NOT NULL ENABLE, 
	"CVID" NUMBER NOT NULL ENABLE, 
	"WRITING" VARCHAR2(500 BYTE), 
	"ANSWER" VARCHAR2(500 BYTE), 
	"DATEOFAPPEAL" DATE NOT NULL ENABLE, 
	 CONSTRAINT "OCP_APPEALS_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS"  ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS" ;
 
  CREATE TABLE "ASPIRIN"."OCP_CITIES" 
   (	"ID" NUMBER(*,0) NOT NULL ENABLE, 
	"NAME" VARCHAR2(4000 BYTE) NOT NULL ENABLE, 
	"VALUE" VARCHAR2(4000 BYTE) NOT NULL ENABLE, 
	 CONSTRAINT "CITIES_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS"  ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS" ;
 
  CREATE TABLE "ASPIRIN"."OCP_CV" 
   (	"ID" NUMBER, 
	"JOBSEEKERID" NUMBER NOT NULL ENABLE, 
	"SITEINFO" NUMBER, 
	"FIRSTNAME" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"LASTNAME" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"TCKIMLIKNO" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"GENDER" VARCHAR2(10 BYTE) NOT NULL ENABLE, 
	"DATEOFBIRTH" DATE NOT NULL ENABLE, 
	"PLACEOFBIRTHCOUNTRY" VARCHAR2(20 BYTE), 
	"PLACEOFBIRTHCITY" VARCHAR2(20 BYTE), 
	"MARITALSTATUS" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"PHONE" VARCHAR2(20 BYTE), 
	"CELLPHONE" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"EMAIL" VARCHAR2(50 BYTE) NOT NULL ENABLE, 
	"ADDRESS" VARCHAR2(200 BYTE), 
	"EDUCATIONLEVEL" NUMBER, 
	"HIGHSCHOOL" VARCHAR2(100 BYTE), 
	"UNIVERSITY" VARCHAR2(100 BYTE), 
	"DEPARTMENT" VARCHAR2(100 BYTE), 
	"LANGUAGES" VARCHAR2(200 BYTE), 
	"EXPERIENCE" NUMBER, 
	"KNOWLEDGE" VARCHAR2(500 BYTE), 
	"POSITIONS" VARCHAR2(200 BYTE), 
	"CVTITLE" VARCHAR2(30 BYTE) NOT NULL ENABLE, 
	"JOBAREA" VARCHAR2(100 BYTE), 
	"EXTID" NUMBER, 
	 PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS"  ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS" ;
 
  CREATE TABLE "ASPIRIN"."OCP_JOBPOSITIONS" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"POSITIONNAME" VARCHAR2(100 BYTE) NOT NULL ENABLE, 
	"VALUE" VARCHAR2(100 BYTE), 
	 CONSTRAINT "JOBPOSITIONS_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS"  ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS" ;
 
  CREATE TABLE "ASPIRIN"."OCP_MESSAGES" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"SENDERID" NUMBER NOT NULL ENABLE, 
	"RECEIVERID" NUMBER NOT NULL ENABLE, 
	"TITLE" VARCHAR2(100 BYTE) NOT NULL ENABLE, 
	"MESSAGE" VARCHAR2(1000 BYTE) NOT NULL ENABLE, 
	 CONSTRAINT "OCP_MESSAGES_PK" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS"  ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS" ;
 
  CREATE TABLE "ASPIRIN"."OCP_POSITIONAVAILABLE" 
   (	"ID" NUMBER, 
	"EMPLOYERID" NUMBER NOT NULL ENABLE, 
	"SITEINFO" NUMBER, 
	"COMPANYNAME" VARCHAR2(30 BYTE) NOT NULL ENABLE, 
	"COMPANYINFO" VARCHAR2(200 BYTE) NOT NULL ENABLE, 
	"JOBDATE" DATE NOT NULL ENABLE, 
	"JOBNAME" VARCHAR2(50 BYTE) NOT NULL ENABLE, 
	"CITY" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"EDUCATIONLEVEL" NUMBER NOT NULL ENABLE, 
	"EXPERIENCE" NUMBER, 
	"GENDER" CHAR(1 BYTE), 
	"POSITIONS" VARCHAR2(200 BYTE), 
	"JOBDESC" VARCHAR2(1000 BYTE), 
	"JOBAREA" VARCHAR2(100 BYTE) NOT NULL ENABLE, 
	"EXTID" NUMBER, 
	 PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS"  ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS" ;
 
  CREATE TABLE "ASPIRIN"."OCP_USER" 
   (	"ID" NUMBER, 
	"FIRSTNAME" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"LASTNAME" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"EMAIL" VARCHAR2(30 BYTE) NOT NULL ENABLE, 
	"PASSWRD" VARCHAR2(50 BYTE) NOT NULL ENABLE, 
	"COMPANYNAME" VARCHAR2(50 BYTE), 
	"COMPANYINFOR" VARCHAR2(200 BYTE), 
	"HINTQUESTION" VARCHAR2(20 BYTE), 
	"HINTANSWER" VARCHAR2(20 BYTE), 
	"ACTIVITY" NUMBER, 
	"CUSTOMERLEVEL" NUMBER, 
	"TCKIMLIKNO" VARCHAR2(20 BYTE), 
	"TIPI" CHAR(1 BYTE) NOT NULL ENABLE, 
	"USERNAME" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	 PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS"  ENABLE, 
	 CONSTRAINT "OCP_USER_UK1" UNIQUE ("EMAIL")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS"  ENABLE, 
	 CONSTRAINT "OCP_USER_UK2" UNIQUE ("USERNAME")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS"  ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "USERS" ;
 