/*
================================================================================
档案代号:qca_file
档案名称:一般检验水准样本代码资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table qca_file
(
qca01       number(10) NOT NULL,     /*起始批量                               */
qca02       number(10) NOT NULL,     /*截止批量                               */
qca03       varchar2(1) NOT NULL,    /*样本字号                               */
qca04       number(5),               /*正常检验样本收                         */
qca05       number(5),               /*加严检验样本收                         */
qca06       number(5),               /*减量检验样本收                         */
qca07       varchar2(1) NOT NULL     /*级数                                   */
);

create unique index qca_pk on qca_file (qca01,qca02,qca03,qca07);
alter table qca_file add  constraint qca_pk primary key  (qca01,qca02,qca03,qca07) enable validate;
grant select on qca_file to public;
grant index on qca_file to public;
grant update on qca_file to public;
grant delete on qca_file to public;
grant insert on qca_file to public;