/*
================================================================================
档案代号:qcp_file
档案名称:品质异常单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table qcp_file
(
qcp01       varchar2(16) NOT NULL,   /*品质异常单单号                         */
qcp02       number(5) NOT NULL,      /*项次                                   */
qcp03       varchar2(30),            /*异常状况                               */
qcp04       number(15,3),            /*不良数量                               */
qcp05       varchar2(80),            /*处理对策                               */
qcp06       varchar2(6),             /*异常项目                               */
qcpud01     varchar2(255),           /*自订栏位-Textedit                      */
qcpud02     varchar2(40),            /*自订栏位-文字                          */
qcpud03     varchar2(40),            /*自订栏位-文字                          */
qcpud04     varchar2(40),            /*自订栏位-文字                          */
qcpud05     varchar2(40),            /*自订栏位-文字                          */
qcpud06     varchar2(40),            /*自订栏位-文字                          */
qcpud07     number(15,3),            /*自订栏位-数值                          */
qcpud08     number(15,3),            /*自订栏位-数值                          */
qcpud09     number(15,3),            /*自订栏位-数值                          */
qcpud10     number(10),              /*自订栏位-整数                          */
qcpud11     number(10),              /*自订栏位-整数                          */
qcpud12     number(10),              /*自订栏位-整数                          */
qcpud13     date,                    /*自订栏位-日期                          */
qcpud14     date,                    /*自订栏位-日期                          */
qcpud15     date                     /*自订栏位-日期                          */
);

create unique index qcp_pk on qcp_file (qcp01,qcp02);
alter table qcp_file add  constraint qcp_pk primary key  (qcp01,qcp02) enable validate;
grant select on qcp_file to public;
grant index on qcp_file to public;
grant update on qcp_file to public;
grant delete on qcp_file to public;
grant insert on qcp_file to public;