/*
================================================================================
档案代号:qctt_file
档案名称:品质检验单身测量值档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table qctt_file
(
qctt01      varchar2(16),            /*收货单号                               */
                                     /*收货单号      (qcs01)                  */
qctt02      number(5),               /*收货项次                               */
                                     /*收货项次      (qcs02)                  */
qctt021     number(5),               /*分批检验顺序                           */
                                     /*分批检验顺序  (qcs05)                  */
qctt03      number(5),               /*单身行序                               */
qctt04      number(15,3)             /*测量值                                 */
);

create        index qctt_01 on qctt_file (qctt01,qctt02,qctt021,qctt03);
grant select on qctt_file to public;
grant index on qctt_file to public;
grant update on qctt_file to public;
grant delete on qctt_file to public;
grant insert on qctt_file to public;