/*
================================================================================
档案代号:qcu_file
档案名称:品质检验单身不良原因档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table qcu_file
(
qcu01       varchar2(16),            /*收货单号                               */
qcu02       number(5),               /*收货项次                               */
qcu021      number(5),               /*分批检验顺序                           */
qcu03       number(5),               /*行序                                   */
qcu04       varchar2(6),             /*不良原因                               */
                                     /*不良原因 (ref. qce_file for qce02)     */
qcu05       number(15,3),            /*不良数量                               */
qcuicd01    varchar2(3),             /*Wafer刻号                              */
qcuicd02    varchar2(5)              /*检验区域                               */
);

create        index qcu_01 on qcu_file (qcu01,qcu02,qcu021,qcu03);
grant select on qcu_file to public;
grant index on qcu_file to public;
grant update on qcu_file to public;
grant delete on qcu_file to public;
grant insert on qcu_file to public;