/* ================================================================================ 档案代号: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; |