/*
================================================================================
档案代号:cqf_file
档案名称:员工往来银行档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cqf_file
(
cqf01       varchar2(10) NOT NULL,   /*员工代号                               */
cqf02       varchar2(11) NOT NULL,   /*教育训练单位                           */
cqf03       varchar2(80) NOT NULL,   /*教育训练全名                           */
cqf04       varchar2(58),            /*认定日期                               */
cqf05       varchar2(1),             /*教育训练起始日                         */
cqfacti     varchar2(1)              /*资料所效否                             */
);

create unique index cqf_pk on cqf_file (cqf01,cqf02,cqf03);
alter table cqf_file add  constraint cqf_pk primary key  (cqf01,cqf02,cqf03) enable validate;
grant select on cqf_file to public;
grant index on cqf_file to public;
grant update on cqf_file to public;
grant delete on cqf_file to public;
grant insert on cqf_file to public;