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