/*
================================================================================
档案代号:cpy_file
档案名称:员工班别单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cpy_file
(
cpy01       varchar2(10) NOT NULL,   /*员工代码                               */
cpy02       number(5) NOT NULL,      /*年度                                   */
cpy021      number(5) NOT NULL,      /*月份                                   */
cpy03       number(5) NOT NULL,      /*日期                                   */
cpy04       varchar2(10),            /*班别                                   */
cpy05       varchar2(1)              /*假日别                                 */
                                     /*0:工作天 1:休全天  2:休半天            */
                                     /*3:节日(for 大陆版)                     */
);

create unique index cpy_pk on cpy_file (cpy01,cpy02,cpy021,cpy03);
alter table cpy_file add  constraint cpy_pk primary key  (cpy01,cpy02,cpy021,cpy03) enable validate;
grant select on cpy_file to public;
grant index on cpy_file to public;
grant update on cpy_file to public;
grant delete on cpy_file to public;
grant insert on cpy_file to public;