/*
================================================================================
档案代号:zas_file
档案名称:SQL Wizard 条件式记录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zas_file
(
zas01       varchar2(80) NOT NULL,   /*查询单id                               */
zas02       number(5) NOT NULL,      /*条件式序号                             */
zas03       varchar2(5),             /*(                                      */
zas04       varchar2(15),            /*档案代码                               */
zas05       varchar2(20),            /*栏位代码                               */
zas06       varchar2(5),             /*条件式                                 */
zas07       varchar2(20),            /*档案代码                               */
zas08       varchar2(80),            /*栏位代码/数值                          */
zas09       varchar2(5),             /*)                                      */
zas10       varchar2(1),             /*or/and                                 */
zas11       varchar2(1) NOT NULL     /*客制码                                 */
);

create unique index zas_pk on zas_file (zas01,zas02,zas11);
alter table zas_file add  constraint zas_pk primary key  (zas01,zas02,zas11) enable validate;
grant select on zas_file to public;
grant index on zas_file to public;
grant update on zas_file to public;
grant delete on zas_file to public;
grant insert on zas_file to public;