/*
================================================================================
档案代号: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;