/*
================================================================================
档案代号:shs_file
档案名称:RUN CARD合并资料单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table shs_file
(
shs01       varchar2(16) NOT NULL,   /*合并单号                               */
shs011      number(5),               /*合并项次                               */
shs02       varchar2(19) NOT NULL,   /*Run Card                               */
                                     /*要合并的Run Card                       */
shs03       number(15,3),            /*WIP 数量                               */
shs04       varchar2(30),            /*合并数量                               */
shs05       varchar2(255),           /*备注                                   */
shs06       varchar2(1),             /*No Use                                 */
shs07       varchar2(1),             /*No Use                                 */
shs08       varchar2(1),             /*No Use                                 */
shs09       varchar2(1),             /*No Use                                 */
shs10       varchar2(1)              /*No Use                                 */
);

create unique index shs_pk on shs_file (shs01,shs02);
alter table shs_file add  constraint shs_pk primary key  (shs01,shs02) enable validate;
grant select on shs_file to public;
grant index on shs_file to public;
grant update on shs_file to public;
grant delete on shs_file to public;
grant insert on shs_file to public;