/* ================================================================================ 档案代号: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; |