/* ================================================================================ 档案代号:idj_file 档案名称:ICD发票资料转入作业单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table idj_file ( idj01 varchar2(10) DEFAULT '' NOT NULL, /*厂商编号*/ idj02 varchar2(10) DEFAULT '' NOT NULL, /*厂别*/ idj03 number(5) DEFAULT '0' NOT NULL, /*顺序*/ idj04 varchar2(20), /*档案编号 */ idj05 varchar2(20), /*栏位编号 */ idj06 varchar2(1), /*no use */ idj07 varchar2(1), /*no use */ idj08 varchar2(1), /*no use */ idj09 varchar2(1), /*no use */ idj10 varchar2(1) /*no use */ ); create unique index idj_pk on idj_file (idj01,idj02,idj03); alter table idj_file add constraint idj_pk primary key (idj01,idj02,idj03) enable validate; grant select on idj_file to public; grant index on idj_file to public; grant update on idj_file to public; grant delete on idj_file to public; grant insert on idj_file to public; |