/*
================================================================================
档案代号:shp_file
档案名称:RUN CARD分割资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table shp_file
(
shp01       varchar2(16) NOT NULL,   /*分割单号                               */
shp02       date,                    /*分割日期                               */
shp03       varchar2(19),            /*Run Card                               */
shp04       number(5),               /*制程顺序                               */
shp05       varchar2(6),             /*作业编号                               */
shp06       number(15,3),            /*WIP 数量                               */
shp07       varchar2(10),            /*员工编号                               */
shp08       varchar2(1),             /*No Use                                 */
shp09       varchar2(1),             /*WIP数量                                */
shp10       varchar2(1),             /*No Use                                 */
shpconf     varchar2(1),             /*确认码                                 */
shptime     varchar2(5),             /*分割时间                               */
shpacti     varchar2(1),             /*资料有效码                             */
shpuser     varchar2(10),            /*资料所有者                             */
shpgrup     varchar2(10),            /*资料所有群                             */
shpmodu     varchar2(10),            /*资料更改者                             */
shpdate     date                     /*最近修改日                             */
);

create        index shp_02 on shp_file (shp03);
create unique index shp_pk on shp_file (shp01);
alter table shp_file add  constraint shp_pk primary key  (shp01) enable validate;
grant select on shp_file to public;
grant index on shp_file to public;
grant update on shp_file to public;
grant delete on shp_file to public;
grant insert on shp_file to public;