/* ================================================================================ 档案代号:cpo_file 档案名称:员工学历资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cpo_file ( cpo01 varchar2(10) NOT NULL, /*员工代号 */ cpo02 number(5) NOT NULL, /*行序 */ cpo03 varchar2(1), /*学历代号 */ cpo04 varchar2(80), /*毕业学校 */ cpo05 varchar2(80), /*毕业科系 */ cpo06 varchar2(1) NOT NULL /*资料来源 */ /*资料来源 1.应征人员 2.正式员工 */ ); create unique index cpo_pk on cpo_file (cpo06,cpo01,cpo02); alter table cpo_file add constraint cpo_pk primary key (cpo06,cpo01,cpo02) enable validate; grant select on cpo_file to public; grant index on cpo_file to public; grant update on cpo_file to public; grant delete on cpo_file to public; grant insert on cpo_file to public; |