/* ================================================================================ 档案代号:zae_file 档案名称:报表连查sql设定档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table zae_file ( zae01 varchar2(10) NOT NULL, /*报表连查sql 代号 */ zae02 varchar2(80), /*代号说明 */ zae03 varchar2(255), /*sql内容 */ zae04 number(5) NOT NULL, /*序号 */ zae05 varchar2(1) NOT NULL, /*语言别 */ zae06 varchar2(20), /*栏位代号 */ zae07 varchar2(80), /*栏位说明 */ zae08 number(5) NOT NULL, /*报表下阶联查序号 */ zae09 varchar2(1), /*报表下阶联查类型 1:程式代号 */ zae10 varchar2(20) /*报表下阶连查内容 */ ); create unique index zae_pk on zae_file (zae01,zae04,zae05,zae08); alter table zae_file add constraint zae_pk primary key (zae01,zae04,zae05,zae08) enable validate; grant select on zae_file to public; grant index on zae_file to public; grant update on zae_file to public; grant delete on zae_file to public; grant insert on zae_file to public; |