/*
================================================================================
档案代号:srj_file
档案名称:报工资料 人员报工资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table srj_file
(
srj01       varchar2(16) NOT NULL,   /*报工单号                               */
srj02       number(5) NOT NULL,      /*项次                                   */
srj03       number(5),               /*报工项次                               */
srj04       varchar2(10),            /*员工编号                               */
srj05       number(15,3),            /*工时(分)                               */
srj06       number(15,3),            /*数量                                   */
srj08       varchar2(255),           /*备注                                   */
srj07       varchar2(1)              /*No Use                                 */
);

create unique index srj_pk on srj_file (srj01,srj02);
alter table srj_file add  constraint srj_pk primary key  (srj01,srj02) enable validate;
grant select on srj_file to public;
grant index on srj_file to public;
grant update on srj_file to public;
grant delete on srj_file to public;
grant insert on srj_file to public;