/*
================================================================================
档案代号:qcj_file
档案名称:C=0抽样计划样本代码资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table qcj_file
(
qcj01       number(10) NOT NULL,     /*起始批量                               */
qcj02       number(10) NOT NULL,     /*截止批量                               */
qcj03       number(7,3) NOT NULL,    /*AQL指标                                */
qcj04       varchar2(1) NOT NULL,    /*级数                                   */
qcj05       number(5)                /*检验样本                               */
);

create unique index qcj_pk on qcj_file (qcj01,qcj02,qcj03,qcj04);
alter table qcj_file add  constraint qcj_pk primary key  (qcj01,qcj02,qcj03,qcj04) enable validate;
grant select on qcj_file to public;
grant index on qcj_file to public;
grant update on qcj_file to public;
grant delete on qcj_file to public;
grant insert on qcj_file to public;