/* ================================================================================ 档案代号:idm_file 档案名称:ICD厂商WIP资料设定单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table idm_file ( idm01 varchar2(10) DEFAULT '' NOT NULL, /*厂商编号*/ idm02 varchar2(10) DEFAULT '' NOT NULL, /*厂别 预设为 00*/ idm03 varchar2(255), /*档案存放位置 */ idm04 varchar2(1), /*no use */ idm05 varchar2(1), /*栏位分隔符号 */ /*0.TAB 1.分号 */ idm07 varchar2(1), /*no use */ idm08 number(5), /*序号 */ idm09 varchar2(1), /*no use */ idm10 varchar2(1), /*no use */ idm11 varchar2(1), /*no use */ idm12 varchar2(1), /*no use */ idm13 varchar2(1), /*no use */ idm14 varchar2(1), /*no use */ idm15 varchar2(1) /*no use */ ); create unique index idm_pk on idm_file (idm01,idm02); alter table idm_file add constraint idm_pk primary key (idm01,idm02) enable validate; grant select on idm_file to public; grant index on idm_file to public; grant update on idm_file to public; grant delete on idm_file to public; grant insert on idm_file to public; |