/*
================================================================================
档案代号:cqh_file
档案名称:员工请假明细资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cqh_file
(
cqh01       varchar2(10) NOT NULL,   /*员工代号                               */
cqh02       number(5) NOT NULL,      /*行序                                   */
cqh04       date NOT NULL,           /*归属日期                               */
cqh05       date,                    /*起始日期                               */
cqh051      varchar2(5),             /*起始时分                               */
cqh06       date,                    /*截止日期                               */
cqh061      varchar2(5),             /*截止时分                               */
cqh07       number(8,4),             /*请假时数                               */
cqh071      number(15,3),            /*请假天数                               */
cqh08       varchar2(1),             /*预先借假否                             */
cqh09       varchar2(1),             /*No Use                                 */
cqh10       varchar2(1),             /*No Use                                 */
cqh11       varchar2(120)            /*加班说明                               */
);

create unique index cqh_pk on cqh_file (cqh01,cqh02,cqh04);
alter table cqh_file add  constraint cqh_pk primary key  (cqh01,cqh02,cqh04) enable validate;
grant select on cqh_file to public;
grant index on cqh_file to public;
grant update on cqh_file to public;
grant delete on cqh_file to public;
grant insert on cqh_file to public;