/*
================================================================================
档案代号:qdc_file
档案名称:Xbar-R管制数据单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table qdc_file
(
qdc01       varchar2(16) NOT NULL,   /*QC 单号                                */
qdc011      number(5) NOT NULL,      /*QC 项次                                */
                                     /*QC 项次  (For IQC)                     */
qdc012      number(5) NOT NULL,      /*QC 分批检验项次                        */
                                     /*QC 分批检验项次 (For IQC)              */
qdc013      number(5) NOT NULL,      /*QC 单身项次                            */
qdc02       number(5) NOT NULL,      /*组号                                   */
qdc03       date,                    /*日期                                   */
qdc04       varchar2(8),             /*时间                                   */
qdc05       number(15,3),            /*数量                                   */
qdc06       number(15,3),            /*合计                                   */
qdc07       number(15,3),            /*Xbar                                   */
qdc08       number(15,3),            /*R                                      */
qdc09       varchar2(1),             /*No Use                                 */
qdc10       varchar2(1)              /*No Use                                 */
);

create unique index qdc_pk on qdc_file (qdc01,qdc011,qdc012,qdc013,qdc02);
alter table qdc_file add  constraint qdc_pk primary key  (qdc01,qdc011,qdc012,qdc013,qdc02) enable validate;
grant select on qdc_file to public;
grant index on qdc_file to public;
grant update on qdc_file to public;
grant delete on qdc_file to public;
grant insert on qdc_file to public;