/*
================================================================================
档案代号:cqu_file
档案名称:员工计薪绩效资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cqu_file
(
cqu01       varchar2(5) NOT NULL,    /*计薪指标                               */
cqu02       varchar2(10) NOT NULL,   /*员工代号                               */
cqu03       number(8,4),             /*考核分数                               */
cquacti     varchar2(1),             /*资料有效否                             */
cquuser     varchar2(10),            /*资料所有者                             */
cqugrup     varchar2(10),            /*资料所有群                             */
cqumodu     varchar2(10),            /*资料更改者                             */
cqudate     date                     /*最近修改日                             */
);

create unique index cqu_pk on cqu_file (cqu01,cqu02);
alter table cqu_file add  constraint cqu_pk primary key  (cqu01,cqu02) enable validate;
grant select on cqu_file to public;
grant index on cqu_file to public;
grant update on cqu_file to public;
grant delete on cqu_file to public;
grant insert on cqu_file to public;