/*
================================================================================
档案代号:cpw_file
档案名称:学历代号资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cpw_file
(
cpw01       varchar2(1) NOT NULL,    /*学历代号                               */
cpw02       varchar2(80),            /*学历名称                               */
cpw03       varchar2(255),           /*备注                                   */
cpwacti     varchar2(1),             /*资料有效否                             */
cpwuser     varchar2(10),            /*资料所有者                             */
                                     /*系统维护                               */
cpwgrup     varchar2(10),            /*资料所有群                             */
                                     /*系统维护                               */
cpwmodu     varchar2(10),            /*资料更改者                             */
                                     /*系统维护                               */
cpwdate     date                     /*最近修改日                             */
                                     /*系统维护                               */
);

create unique index cpw_pk on cpw_file (cpw01);
alter table cpw_file add  constraint cpw_pk primary key  (cpw01) enable validate;
grant select on cpw_file to public;
grant index on cpw_file to public;
grant update on cpw_file to public;
grant delete on cpw_file to public;
grant insert on cpw_file to public;