/*
================================================================================
档案代号:zaj_file
档案名称:定义执行query前应执行的process
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zaj_file
(
zaj01       varchar2(80) NOT NULL,   /*查询单ID                               */
zaj02       number(5) NOT NULL,      /*执行顺序                               */
zaj03       varchar2(1),             /*启动否                                 */
zaj04       varchar2(1),             /*来源类别                               */
zaj05       varchar2(255),           /*执行命令                               */
zaj06       varchar2(255),           /*备注                                   */
zaj07       varchar2(1) NOT NULL     /*客制码                                 */
);

create unique index zaj_pk on zaj_file (zaj01,zaj02,zaj07);
alter table zaj_file add  constraint zaj_pk primary key  (zaj01,zaj02,zaj07) enable validate;
grant select on zaj_file to public;
grant index on zaj_file to public;
grant update on zaj_file to public;
grant delete on zaj_file to public;
grant insert on zaj_file to public;