/* ================================================================================ 档案代号:dpc_file 档案名称:员工技能资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table dpc_file ( dpc01 varchar2(10) NOT NULL, /*员工代号 */ dpc02 number(5) NOT NULL, /*行序 */ dpc03 varchar2(2), /*技能代号 */ dpc06 varchar2(1) NOT NULL /*资料来源 */ /*资料来源 1.应征人员 2.正式员工 */ ); create unique index dpc_pk on dpc_file (dpc06,dpc01,dpc02); alter table dpc_file add constraint dpc_pk primary key (dpc06,dpc01,dpc02) enable validate; grant select on dpc_file to public; grant index on dpc_file to public; grant update on dpc_file to public; grant delete on dpc_file to public; grant insert on dpc_file to public; |