/*
================================================================================
档案代号:zam_file
档案名称:定义查询分群(Group)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zam_file
(
zam01       varchar2(80) NOT NULL,   /*查询单id                               */
zam02       number(5) NOT NULL,      /*序号                                   */
zam03       varchar2(1),             /*group否                                */
zam04       varchar2(1),             /*排序否                                 */
zam05       number(5),               /*排序顺序                               */
zam06       varchar2(255),           /*备注                                   */
zam07       varchar2(1),             /*是否BY Group跳页                       */
zam08       varchar2(1),             /*排序方式                               */
                                     /*1.升幂 2.降幂                          */
zam09       varchar2(1) NOT NULL     /*客制码                                 */
);

create unique index zam_pk on zam_file (zam01,zam02,zam09);
alter table zam_file add  constraint zam_pk primary key  (zam01,zam02,zam09) enable validate;
grant select on zam_file to public;
grant index on zam_file to public;
grant update on zam_file to public;
grant delete on zam_file to public;
grant insert on zam_file to public;