/* ================================================================================ 档案代号:zao_file 档案名称:定义查询输出格式(Layout) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table zao_file ( zao01 varchar2(80) NOT NULL, /*查询单id */ zao02 varchar2(1) NOT NULL, /*layout 项目 */ zao03 varchar2(1) NOT NULL, /*输入格式 */ zao04 varchar2(1), /*执行否 */ zao05 varchar2(1) NOT NULL /*客制码 */ ); create unique index zao_pk on zao_file (zao01,zao02,zao03,zao05); alter table zao_file add constraint zao_pk primary key (zao01,zao02,zao03,zao05) enable validate; grant select on zao_file to public; grant index on zao_file to public; grant update on zao_file to public; grant delete on zao_file to public; grant insert on zao_file to public; |