/* ================================================================================ 档案代号:imt_file 档案名称:款式材质成分说明资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table imt_file ( imt01 varchar2(80) DEFAULT '' NOT NULL, /*款式编号*/ imt02 number(10) DEFAULT '0' NOT NULL, /*说明项次*/ imt03 varchar2(80) /*说明内容 */ ); create unique index imt_pk on imt_file (imt01,imt02); alter table imt_file add constraint imt_pk primary key (imt01,imt02) enable validate; grant select on imt_file to public; grant index on imt_file to public; grant update on imt_file to public; grant delete on imt_file to public; grant insert on imt_file to public; |