/*
================================================================================
档案代号:czb_file
档案名称:职委会给付类别代号说明资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table czb_file
(
czb01       varchar2(4) NOT NULL,    /*类别代号                               */
czb02       varchar2(80),            /*类别说明                               */
czbacti     varchar2(1),             /*资料有效否                             */
czbuser     varchar2(10),            /*资料所有者                             */
czbgrup     varchar2(10),            /*资料所有群                             */
czbmodu     varchar2(10),            /*资料更改者                             */
czbdate     date                     /*最近修改日                             */
);

create unique index czb_pk on czb_file (czb01);
alter table czb_file add  constraint czb_pk primary key  (czb01) enable validate;
grant select on czb_file to public;
grant index on czb_file to public;
grant update on czb_file to public;
grant delete on czb_file to public;
grant insert on czb_file to public;