/*
================================================================================
档案代号:shi_file
档案名称:工单生产日报维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table shi_file
(
shi01       varchar2(16) NOT NULL,   /*移转单号                               */
shi02       varchar2(16) NOT NULL,   /*转入工单编号                           */
shi03       varchar2(6),             /*作业编号                               */
shi04       number(5) NOT NULL,      /*制程序                                 */
shi05       number(15,3),            /*转入数量                               */
shi06       varchar2(1),             /*No Use                                 */
shi07       varchar2(1),             /*No Use                                 */
shi08       varchar2(1),             /*No Use                                 */
shi09       varchar2(1),             /*No Use                                 */
shi10       varchar2(1)              /*No Use                                 */
);

create unique index shi_pk on shi_file (shi01,shi02,shi04);
alter table shi_file add  constraint shi_pk primary key  (shi01,shi02,shi04) enable validate;
grant select on shi_file to public;
grant index on shi_file to public;
grant update on shi_file to public;
grant delete on shi_file to public;
grant insert on shi_file to public;