oracle-表创建

创建oracle 表

-- 个人基本信息表 

create   table personalBaseInfo 
  ( 
  pid number(2) primary key,
  idCard varchar2(40),
  names varchar2(30),
  sex varchar2(4),
  age number,
  marryied varchar2(4),
  grade varchar2(35),   
  major varchar2(50)    
  )     

-- 职位信息表
  create   table officeVacancy
  (
  jobid number(2) primary key,
  worktype varchar2(35),
  tempSal  varchar2(30),
  salary   varchar2(30),
  recruitQuantity number,
  endDate date,
  createdate date  ,
  workLoc varchar2(55)，
  grade varchar2(20)，
  telNum number，
  jobInfo varchar2(500)
  ）


// references xx(xid); 外键的关联
-- 求职记录表  
  create   table recommend
  (
  rid number(2) primary key,
  pid number(2) references personalBaseInfo(pid),
  jobid number(2) references officeVacancy(jobid),
  sendDate date
  )

select * from personalBaseInfo;
select * from officeVacancy;
select * from recommend;