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