/*
================================================================================
档案代号:srh_file
档案名称:报工资料 异常&例外资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table srh_file
(
srh01       varchar2(16) NOT NULL,   /*报工单号                               */
srh02       number(5) NOT NULL,      /*项次                                   */
srh03       number(5),               /*报工项次                               */
srh04       varchar2(10),            /*异常代号                               */
srh05       number(15,3),            /*异常例外工时                           */
srh06       varchar2(255),           /*备注                                   */
srh07       varchar2(1)              /*No Use                                 */
);

create unique index srh_pk on srh_file (srh01,srh02);
alter table srh_file add  constraint srh_pk primary key  (srh01,srh02) enable validate;
grant select on srh_file to public;
grant index on srh_file to public;
grant update on srh_file to public;
grant delete on srh_file to public;
grant insert on srh_file to public;