/*
================================================================================
档案代号:qch_file
档案名称:特殊检验水准样本代码资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table qch_file
(
qch01       number(10) NOT NULL,     /*起始批量                               */
qch02       number(10) NOT NULL,     /*截止批量                               */
qch03       varchar2(1) NOT NULL,    /*样本字号                               */
qch04       number(5),               /*正常检验样本收                         */
qch05       number(5),               /*加严检验样本收                         */
qch06       number(5),               /*减量检验样本收                         */
qch07       varchar2(1) NOT NULL     /*级数                                   */
);

create unique index qch_pk on qch_file (qch01,qch02,qch03,qch07);
alter table qch_file add  constraint qch_pk primary key  (qch01,qch02,qch03,qch07) enable validate;
grant select on qch_file to public;
grant index on qch_file to public;
grant update on qch_file to public;
grant delete on qch_file to public;
grant insert on qch_file to public;