/* ================================================================================ 档案代号: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; |