/*
================================================================================
档案代号: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;