/*
================================================================================
档案代号:cpe_file
档案名称:班别资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cpe_file
(
cpe01       varchar2(10) NOT NULL,   /*班别代码                               */
cpe02       varchar2(40),            /*班别简称                               */
cpe03       number(8,4),             /*班别之基础日总时数                     */
cpe04       number(15,3),            /*班别之基础月总天数                     */
cpe05       number(5,3),             /*No Use                                 */
cpe06       varchar2(10),            /*津贴代号                               */
cpe07       varchar2(1),             /*No Use                                 */
cpe08       number(5),               /*No Use                                 */
cpe09       number(5),               /*No Use                                 */
cpe10       number(5),               /*No Use                                 */
cpeacti     varchar2(1),             /*资料有效否                             */
cpeuser     varchar2(10),            /*资料所有者                             */
cpegrup     varchar2(10),            /*资料所有群                             */
cpemodu     varchar2(10),            /*资料更改者                             */
cpedate     date                     /*最近修改日                             */
);

create unique index cpe_pk on cpe_file (cpe01);
alter table cpe_file add  constraint cpe_pk primary key  (cpe01) enable validate;
grant select on cpe_file to public;
grant index on cpe_file to public;
grant update on cpe_file to public;
grant delete on cpe_file to public;
grant insert on cpe_file to public;