/*
================================================================================
档案代号:zw_file
档案名称:权限类别档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zw_file
(
zw01        varchar2(10) NOT NULL,   /*权限类别                               */
zw02        varchar2(80),            /*权限说明                               */
zw03        varchar2(10),            /*使用目录编号                           */
zw04        varchar2(1),             /*test                                   */
zw05        varchar2(1),             /*闲置处理                               */
zw06        number(5),               /*闲置时间(秒)                           */
zwacti      varchar2(1),             /*Active flag                            */
zwuser      varchar2(10),            /*OWNER                                  */
zwgrup      varchar2(10),            /*GROUP                                  */
zwmodu      varchar2(10),            /*MODIFY USER                            */
zwdate      date                     /*MODIFY DATE                            */
);

create unique index zw_pk on zw_file (zw01);
alter table zw_file add  constraint zw_pk primary key  (zw01) enable validate;
grant select on zw_file to public;
grant index on zw_file to public;
grant update on zw_file to public;
grant delete on zw_file to public;
grant insert on zw_file to public;