/*
================================================================================
档案代号:sgn_file
档案名称:Run Card 制程单元资料
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table sgn_file
(
sgn00       varchar2(19) NOT NULL,   /*Run Card                               */
sgn01       varchar2(40) NOT NULL,   /*料件编号                               */
sgn02       varchar2(10) NOT NULL,   /*制程编号                               */
sgn03       number(5) NOT NULL,      /*制程序号                               */
sgn04       varchar2(10) NOT NULL,   /*工作站编号                             */
sgn05       varchar2(10) NOT NULL,   /*单元代号                               */
sgn06       number(10),              /*零件数                                 */
sgn07       number(8,3),             /*单位工时                               */
                                     /*单位工时(分)                           */
sgn08       number(8,3),             /*单元工时                               */
                                     /*单元工时(分)                           */
sgn09       number(15,3),            /*单位人力                               */
sgn10       number(15,3),            /*单位机时                               */
                                     /*单位机时(分)                           */
sgn11       number(15,3)             /*单元机时                               */
                                     /*单元机时(分)                           */
);

create unique index sgn_pk on sgn_file (sgn00,sgn01,sgn02,sgn03,sgn04,sgn05);
alter table sgn_file add  constraint sgn_pk primary key  (sgn00,sgn01,sgn02,sgn03,sgn04,sgn05) enable 
validate;
grant select on sgn_file to public;
grant index on sgn_file to public;
grant update on sgn_file to public;
grant delete on sgn_file to public;
grant insert on sgn_file to public;