/*
================================================================================
档案代号:zaw_file
档案名称:CR报表格式设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zaw_file
(
zaw01       varchar2(20) NOT NULL,   /*程式代号                               */
zaw02       varchar2(30) NOT NULL,   /*样板代号                               */
zaw03       varchar2(1) NOT NULL,    /*客制否                                 */
zaw04       varchar2(10) NOT NULL,   /*权限类别                               */
zaw05       varchar2(10) NOT NULL,   /*使用者                                 */
zaw06       varchar2(1) NOT NULL,    /*语言别                                 */
zaw07       number(5) NOT NULL,      /*序号                                   */
zaw08       varchar2(80),            /*cr样板名称(.rpt)                       */
zaw09       varchar2(80),            /*cr样板说明                             */
zaw10       varchar2(10) DEFAULT 'std' NOT NULL, /*行业别*/
zaw11       varchar2(1),             /*no use                                 */
zaw12       varchar2(1),             /*no use                                 */
zawdate     date,                    /*最近修改日                             */
zawgrup     varchar2(10),            /*资料所有部门                           */
zawmodu     varchar2(10),            /*资料修改者                             */
zawuser     varchar2(10)             /*资料所有者                             */
);

create unique index zaw_pk on zaw_file (zaw01,zaw02,zaw03,zaw04,zaw05,zaw06,zaw07,zaw10);
alter table zaw_file add  constraint zaw_pk primary key  (zaw01,zaw02,zaw03,zaw04,zaw05,zaw06,zaw07,zaw10) 
enable validate;
grant select on zaw_file to public;
grant index on zaw_file to public;
grant update on zaw_file to public;
grant delete on zaw_file to public;
grant insert on zaw_file to public;