/*
================================================================================
档案代号:skp_file
档案名称:款式版片基本资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table skp_file
(
skp01       varchar2(40) DEFAULT '' NOT NULL, /*款式料号*/
skp02       number(10) DEFAULT '0' NOT NULL, /*版片序号*/
skp03       varchar2(40) DEFAULT '' NOT NULL, /*元件料号*/
skp04       varchar2(10) DEFAULT '' NOT NULL, /*部位*/
skp05       number(15,3) DEFAULT '0' NOT NULL /*单件片数*/
);

create unique index skp_pk on skp_file (skp01,skp02);
alter table skp_file add  constraint skp_pk primary key  (skp01,skp02) enable validate;
grant select on skp_file to public;
grant index on skp_file to public;
grant update on skp_file to public;
grant delete on skp_file to public;
grant insert on skp_file to public;