/*
================================================================================
档案代号:rqa_file
档案名称:每日资源维护作业
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table rqa_file
(
rqa01       varchar2(10) NOT NULL,   /*资源代号                               */
rqa02       varchar2(10) NOT NULL,   /*版本                                   */
rqa03       date NOT NULL,           /*起始日期                               */
rqa04       date NOT NULL,           /*截止日期                               */
rqa05       number(15,3),            /*当日产能                               */
rqa06       number(15,3),            /*已秏产能                               */
rqa07       varchar2(255),           /*备注                                   */
rqa08       varchar2(1)              /*No Use                                 */
);

create unique index rqa_pk on rqa_file (rqa01,rqa02,rqa03,rqa04);
alter table rqa_file add  constraint rqa_pk primary key  (rqa01,rqa02,rqa03,rqa04) enable validate;
grant select on rqa_file to public;
grant index on rqa_file to public;
grant update on rqa_file to public;
grant delete on rqa_file to public;
grant insert on rqa_file to public;