/*
================================================================================
档案代号:aww_file
档案名称:部门归属档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table aww_file
(
aww01       number(5) NOT NULL,      /*年度                                   */
aww02       varchar2(1) NOT NULL,    /*部门分类别                             */
                                     /*部门分类别 ( 1/2  ==> aglr991/aglr992 )*/
aww03       varchar2(10) NOT NULL,   /*归属部门                               */
aww04       varchar2(10) NOT NULL,   /*明细部门                               */
awwacti     varchar2(1),             /*资料有效码                             */
awwuser     varchar2(10),            /*资料所有者                             */
                                     /*系统维护                               */
awwgrup     varchar2(10),            /*资料所有群                             */
                                     /*系统维护                               */
awwmodu     varchar2(10),            /*资料更改者                             */
                                     /*系统维护                               */
awwdate     date                     /*最近修改日                             */
                                     /*系统维护                               */
);

create unique index aww_pk on aww_file (aww01,aww02,aww03,aww04);
alter table aww_file add  constraint aww_pk primary key  (aww01,aww02,aww03,aww04) enable validate;
grant select on aww_file to public;
grant index on aww_file to public;
grant update on aww_file to public;
grant delete on aww_file to public;
grant insert on aww_file to public;