/* ================================================================================ 档案代号:idn_file 档案名称:ICD厂商WIP资料设定单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table idn_file ( idn01 varchar2(10) DEFAULT '' NOT NULL, /*厂商编号*/ idn02 varchar2(10) DEFAULT '' NOT NULL, /*厂别*/ idn03 number(5) DEFAULT '0' NOT NULL, /*顺序*/ idn04 varchar2(20), /*档案编号 */ idn05 varchar2(20), /*栏位编号 */ idn06 varchar2(1), /*no use */ idn07 varchar2(1), /*no use */ idn08 varchar2(1), /*no use */ idn09 varchar2(1), /*no use */ idn10 varchar2(1) /*no use */ ); create unique index idn_pk on idn_file (idn01,idn02,idn03); alter table idn_file add constraint idn_pk primary key (idn01,idn02,idn03) enable validate; grant select on idn_file to public; grant index on idn_file to public; grant update on idn_file to public; grant delete on idn_file to public; grant insert on idn_file to public; |