/*
================================================================================
档案代号:skr_file
档案名称:工单版片资料单身档
档案目的:工单版片资料单身档
上游档案:
下游档案:
============.========================.==========================================
*/
create table skr_file
(
skr01       varchar2(16) DEFAULT '' NOT NULL, /*工单单号*/
skr02       number(10) NOT NULL,     /*制程序号                               */
skr03       number(10) DEFAULT '0' NOT NULL, /*版片序号*/
skr04       varchar2(40) DEFAULT '' NOT NULL, /*元件料号*/
skr05       varchar2(10) DEFAULT '' NOT NULL, /*部位*/
skr06       number(15,3) DEFAULT '0' NOT NULL, /*单件片数*/
skr07       number(15,3) DEFAULT '0' NOT NULL, /*良品件数*/
skr08       number(15,3)             /*已移转件数                             */
);

create unique index skr_pk on skr_file (skr01,skr02,skr03);
alter table skr_file add  constraint skr_pk primary key  (skr01,skr02,skr03) enable validate;
grant select on skr_file to public;
grant index on skr_file to public;
grant update on skr_file to public;
grant delete on skr_file to public;
grant insert on skr_file to public;