/*
================================================================================
档案代号:nnz_file
档案名称:支票作废档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table nnz_file
(
nnz01       varchar2(11) NOT NULL,   /*银行别                                 */
nnz02       varchar2(15) NOT NULL,   /*票号                                   */
nnz03       varchar2(255),           /*备注                                   */
nnzuser     varchar2(10),            /*资料所有者                             */
nnzgrup     varchar2(10),            /*资料所有部门                           */
nnzmodu     varchar2(10),            /*资料修改者                             */
nnzdate     date                     /*最近修改日                             */
);

create unique index nnz_pk on nnz_file (nnz01,nnz02);
alter table nnz_file add  constraint nnz_pk primary key  (nnz01,nnz02) enable validate;
grant select on nnz_file to public;
grant index on nnz_file to public;
grant update on nnz_file to public;
grant delete on nnz_file to public;
grant insert on nnz_file to public;