/*
================================================================================
档案代号:cza_file
档案名称:加班申请资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cza_file
(
cza011      varchar2(16) NOT NULL,   /*加班单号                               */
cza01       varchar2(10) NOT NULL,   /*员工代号                               */
cza02       date NOT NULL,           /*实际归属日                             */
cza03       varchar2(5) NOT NULL,    /*起始时分                               */
cza04       varchar2(5) NOT NULL,    /*截止时分                               */
cza05       varchar2(1),             /*比对                                   */
cza06       varchar2(1),             /*更新                                   */
cza07       number(5),               /*休息分钟数                             */
cza08       varchar2(1),             /*换休否                                 */
                                     /*换休否(Y/N)                            */
cza09       varchar2(1),             /*No Use                                 */
cza10       date NOT NULL,           /*加班出勤起始日期                       */
cza11       date NOT NULL            /*加班出勤截止日期                       */
);

create unique index cza_pk on cza_file (cza011,cza01,cza02,cza03,cza04,cza10,cza11);
alter table cza_file add  constraint cza_pk primary key  (cza011,cza01,cza02,cza03,cza04,cza10,cza11) enable 
validate;
grant select on cza_file to public;
grant index on cza_file to public;
grant update on cza_file to public;
grant delete on cza_file to public;
grant insert on cza_file to public;