/*
================================================================================
档案代号:cps_file
档案名称:员工班别单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cps_file
(
cps01       varchar2(10) NOT NULL,   /*员工代码                               */
cps02       number(5) NOT NULL,      /*年度                                   */
cps021      number(5) NOT NULL,      /*月份                                   */
cps03       varchar2(10),            /*公司别                                 */
cps04       varchar2(10),            /*部门别                                 */
cps05       varchar2(1),             /*No Use                                 */
cpsacti     varchar2(1),             /*资料有效否                             */
cpsuser     varchar2(10),            /*资料所有者                             */
                                     /*系统维护                               */
cpsgrup     varchar2(10),            /*资料所有群                             */
                                     /*系统维护                               */
cpsmodu     varchar2(10),            /*资料更改者                             */
                                     /*系统维护                               */
cpsdate     date                     /*最近修改日                             */
                                     /*系统维护                               */
);

create unique index cps_pk on cps_file (cps01,cps02,cps021);
alter table cps_file add  constraint cps_pk primary key  (cps01,cps02,cps021) enable validate;
grant select on cps_file to public;
grant index on cps_file to public;
grant update on cps_file to public;
grant delete on cps_file to public;
grant insert on cps_file to public;