/*
================================================================================
档案代号:rmg_file
档案名称:RMA 人工工资率档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table rmg_file
(
rmg01       date NOT NULL,           /*生效日期                               */
rmg02       number(20,6),            /*工资单价($/hr)                         */
rmguser     varchar2(10),            /*资料所有者                             */
rmggrup     varchar2(10),            /*资料所有部门                           */
rmgmodu     varchar2(10),            /*资料修改者                             */
rmgdate     date                     /*最近修改日                             */
);

create unique index rmg_pk on rmg_file (rmg01);
alter table rmg_file add  constraint rmg_pk primary key  (rmg01) enable validate;
grant select on rmg_file to public;
grant index on rmg_file to public;
grant update on rmg_file to public;
grant delete on rmg_file to public;
grant insert on rmg_file to public;