/*
================================================================================
档案代号:zaq_file
档案名称:SQL Wizard  Table 记录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zaq_file
(
zaq01       varchar2(80) NOT NULL,   /*测试栏位1                              */
zaq02       varchar2(15) NOT NULL,   /*测试栏位2                              */
zaq03       varchar2(1),             /*outer                                  */
zaq04       number(5) NOT NULL,      /*序号                                   */
zaq05       varchar2(1) NOT NULL     /*客制码                                 */
);

create unique index zaq_pk on zaq_file (zaq01,zaq02,zaq05);
alter table zaq_file add  constraint zaq_pk primary key  (zaq01,zaq02,zaq05) enable validate;
grant select on zaq_file to public;
grant index on zaq_file to public;
grant update on zaq_file to public;
grant delete on zaq_file to public;
grant insert on zaq_file to public;