/*
================================================================================
档案代号:qcb_file
档案名称:单次抽样计划资料维护作业
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table qcb_file
(
qcb01       varchar2(1) NOT NULL,    /*检验程度                               */
                                     /* (N:正常检验 T:加严检验 R:减量检验)    */
qcb02       number(7,3) NOT NULL,    /*允收水准                               */
qcb03       varchar2(1) NOT NULL,    /*样本字号                               */
qcb04       varchar2(1),             /*调整样本字号                           */
qcb05       number(5),               /*接受数量                               */
                                     /*Accept数量                             */
qcb06       number(5)                /*拒绝数量                               */
                                     /*Rejcet数量                             */
);

create unique index qcb_pk on qcb_file (qcb01,qcb02,qcb03);
alter table qcb_file add  constraint qcb_pk primary key  (qcb01,qcb02,qcb03) enable validate;
grant select on qcb_file to public;
grant index on qcb_file to public;
grant update on qcb_file to public;
grant delete on qcb_file to public;
grant insert on qcb_file to public;