网上招聘系统的设计与实现-前后端分离 毕业设计 毕业论文 毕业答辩

-------------------------------------------------------- -- 文件已创建 - 星期一-六月-05-2017 -------------------------------------------------------- -------------------------------------------------------- -- DDL for Sequence SEQ -------------------------------------------------------- CREATE SEQUENCE "BRIUP"."SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 201 CACHE 20 NOORDER NOCYCLE ; -------------------------------------------------------- -- DDL for Sequence SEQ_COMMON -------------------------------------------------------- CREATE SEQUENCE "BRIUP"."SEQ_COMMON" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ; -------------------------------------------------------- -- DDL for Table BLACKRECORD -------------------------------------------------------- CREATE TABLE "BRIUP"."BLACKRECORD" ( "ID" NUMBER, "SELFNAME" VARCHAR2(20 BYTE), "BLACKNAME" VARCHAR2(20 BYTE) ) 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 "SYSTEM" ; -------------------------------------------------------- -- DDL for Table COMPANY -------------------------------------------------------- CREATE TABLE "BRIUP"."COMPANY" ( "ID" NUMBER, "USERNAME" VARCHAR2(20 BYTE), "PASSWORD" VARCHAR2(20 BYTE), "NAME" VARCHAR2(200 BYTE), "LOCATION" VARCHAR2(200 BYTE), "PHONE" VARCHAR2(20 BYTE), "EMAIL" VARCHAR2(20 BYTE), "TRADE" VARCHAR2(20 BYTE), "TIP" VARCHAR2(500 BYTE), "SALARY" VARCHAR2(20 BYTE), "PUBTIME" DATE ) 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 "SYSTEM" ; -------------------------------------------------------- -- DDL for Table EMPLOYEE -------------------------------------------------------- CREATE TABLE "BRIUP"."EMPLOYEE" ( "ID" NUMBER, "P_ID" NUMBER, "C_ID" NUMBER, "ISAGREED" NUMBER DEFAULT 0 ) 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 "SYSTEM" ; -------------------------------------------------------- -- DDL for Table FRIENDRECORD -------------------------------------------------------- CREATE TABLE "BRIUP"."FRIENDRECORD" ( "ID" NUMBER, "SELFNAME" VARCHAR2(20 BYTE), "FRIENDNAME" VARCHAR2(20 BYTE) ) 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 "SYSTEM" ; -------------------------------------------------------- -- DDL for Table GRADERECORD -------------------------------------------------------- CREATE TABLE "BRIUP"."GRADERECORD" ( "ID" NUMBER, "MINPOINT" NUMBER, "MAXPOINT" NUMBER, "GRADENAME" VARCHAR2(20 BYTE), "ICONPATH" VARCHAR2(50 BYTE) ) 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 "SYSTEM" ; -------------------------------------------------------- -- DDL for Table MEMBERINFO -------------------------------------------------------- CREATE TABLE "BRIUP"."MEMBERINFO" ( "ID" NUMBER, "NICKNAME" VARCHAR2(20 BYTE), "PASSWORD" VARCHAR2(50 BYTE), "GENDER" VARCHAR2(1 BYTE), "AGE" NUMBER, "EMAIL" VARCHAR2(100 BYTE), "PROVINCECITY" VARCHAR2(10 BYTE), "ADDRESS" VARCHAR2(200 BYTE), "PHONE" VARCHAR2(50 BYTE), "PASSWORDQUESTION" VARCHAR2(200 BYTE), "PASSWORDANSWER" VARCHAR2(200 BYTE), "RECOMMENDER" VARCHAR2(20 BYTE), "POINT" NUMBER DEFAULT 0, "REGISTERDATE" DATE, "LATESTDATE" DATE, "STATUS" NUMBER DEFAULT 0, "ISONLINE" NUMBER DEFAULT 0, "GRADEID" NUMBER ) 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 "SYSTEM" ; -------------------------------------------------------- -- DDL for Table MEMBERSPACE -------------------------------------------------------- CREATE TABLE "BRIUP"."MEMBERSPACE" ( "ID" NUMBER, "OPINION" VARCHAR2(200 BYTE), "RUNTIME" VARCHAR2(20 BYTE), "RUNPLACE" VARCHAR2(20 BYTE), "RUNSTAR" VARCHAR2(50 BYTE), "RUNHABIT" VARCHAR2(50 BYTE), "CELLPHONE" VARCHAR2(50 BYTE), "ICON" VARCHAR2(200 BYTE), "MEMBERID" NUMBER ) 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 "SYSTEM" ; -------------------------------------------------------- -- DDL for Table MESSAGERECORD -------------------------------------------------------- CREATE TABLE "BRIUP"."MESSAGERECORD" ( "ID" NUMBER, "SENDER" VARCHAR2(20 BYTE), "RECEIVER" VARCHAR2(20 BYTE), "SENDDATE" DATE, "TITLE" VARCHAR2(100 BYTE), "CONTENT" VARCHAR2(300 BYTE), "SENDERSTATUS" NUMBER DEFAULT 0, "RECEIVERSTATUS" NUMBER DEFAULT 0, "STATUS" NUMBER DEFAULT 0 ) 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 "SYSTEM" ; -------------------------------------------------------- -- DDL for Table PERSON -------------------------------------------------------- CREATE TABLE "BRIUP"."PERSON" ( "ID" NUMBER, "USERNAME" VARCHAR2(20 BYTE), "PASSWORD" VARCHAR2(20 BYTE), "NAME" VARCHAR2(20 BYTE), "SEX" VARCHAR2(4 BYTE), "BIRTHDAY" VARCHAR2(20 BYTE), "SCHOOL" VARCHAR2(20 BYTE), "PHONE" VARCHAR2(20 BYTE), "EMAIL" VARCHAR2(20 BYTE), "TRADE" VARCHAR2(20 BYTE), "SALARY" VARCHAR2(20 BYTE), "TIP" VARCHAR2(200 BYTE), "PUBTIME" DATE ) 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 "SYSTEM" ; -------------------------------------------------------- -- DDL for Table POINTACTION -------------------------------------------------------- CREATE TABLE "BRIUP"."POINTACTION" ( "ID" NUMBER, "ACTIONNAME" VARCHAR2(20 BYTE), "POINT" NUMBER, "DESCRIPTION" VARCHAR2(200 BYTE) ) 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 "SYSTEM" ; -------------------------------------------------------- -- DDL for Table POINTRECORD -------------------------------------------------------- CREATE TABLE "BRIUP"."POINTRECORD" ( "ID" NUMBER, "NICKNAME" VARCHAR2(20 BYTE), "RECEIVEDATE" DATE, "POINTACTIONID" NUMBER ) 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 "SYSTEM" ; REM INSERTING into BRIUP.BLACKRECORD SET DEFINE OFF; REM INSERTING into BRIUP.COMPANY SET DEFINE OFF; Insert into BRIUP.COMPANY (ID,USERNAME,PASSWORD,NAME,LOCATION,PHONE,EMAIL,TRADE,TIP,SALARY,PUBTIME) values (1,'sam2','jk123789','国信清软科技有限责任公司','山西太原','1212121','343242@qq.com','平面设计师','国信清软科技有限公司注册在北京中关村高科技园区，始创于2005年3月，已通过软件企业认证，是�