/*
================================================================================
档案代号:cqy_file
档案名称:员工每月薪资负余额表
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cqy_file
(
cqy01       varchar2(5) NOT NULL,    /*计薪指标                               */
cqy02       varchar2(10) NOT NULL,   /*员工编号                               */
cqy03       number(20,6)             /*拖欠金额                               */
);

create unique index cqy_pk on cqy_file (cqy01,cqy02);
alter table cqy_file add  constraint cqy_pk primary key  (cqy01,cqy02) enable validate;
grant select on cqy_file to public;
grant index on cqy_file to public;
grant update on cqy_file to public;
grant delete on cqy_file to public;
grant insert on cqy_file to public;