/*
================================================================================
档案代号:nmk_file
档案名称:银行调节码资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table nmk_file
(
nmk01       varchar2(2) NOT NULL,    /*调节码                                 */
nmk02       varchar2(80),            /*调节说明                               */
nmk03       varchar2(1),             /*银行存款加减方式 ( + / - )             */
nmkacti     varchar2(1),             /*有效码                                 */
nmkuser     varchar2(10),            /*资料所有者                             */
nmkgrup     varchar2(10),            /*资料所有部门                           */
nmkmodu     varchar2(10),            /*资料修改者                             */
nmkdate     date                     /*最近修改日                             */
);

create unique index nmk_pk on nmk_file (nmk01);
alter table nmk_file add  constraint nmk_pk primary key  (nmk01) enable validate;
grant select on nmk_file to public;
grant index on nmk_file to public;
grant update on nmk_file to public;
grant delete on nmk_file to public;
grant insert on nmk_file to public;