/*
================================================================================
档案代号:shr_file
档案名称:RUN CARD合并资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table shr_file
(
shr01       varchar2(16) NOT NULL,   /*合并单号                               */
shr02       date,                    /*合并日期                               */
shr03       varchar2(19),            /*Run Card(母批)                         */
shr04       number(5),               /*制程顺序                               */
shr05       varchar2(6),             /*作业编号                               */
shr06       number(15,3),            /*WIP 数量                               */
shr07       varchar2(10),            /*员工编号                               */
shr09       varchar2(1),             /*WIP数量                                */
shr10       varchar2(1),             /*No Use                                 */
shrconf     varchar2(1),             /*确认码                                 */
shrtime     varchar2(5),             /*分割时间                               */
shracti     varchar2(1),             /*资料有效码                             */
shruser     varchar2(10),            /*资料所有者                             */
shrgrup     varchar2(10),            /*资料所有群                             */
shrmodu     varchar2(10),            /*资料更改者                             */
shrdate     date                     /*最近修改日                             */
);

create        index shr_02 on shr_file (shr03);
create unique index shr_pk on shr_file (shr01);
alter table shr_file add  constraint shr_pk primary key  (shr01) enable validate;
grant select on shr_file to public;
grant index on shr_file to public;
grant update on shr_file to public;
grant delete on shr_file to public;
grant insert on shr_file to public;