/* ================================================================================ 档案代号:skk_file 档案名称:计薪系数档 档案目的:计薪系数档 假双档 上游档案: 下游档案: ============.========================.========================================== */ create table skk_file ( skk01 varchar2(10) DEFAULT '' NOT NULL, /*部门编号*/ skk02 number(5) DEFAULT '0' NOT NULL, /*年度*/ skk03 number(10) DEFAULT '0' NOT NULL, /*月份*/ skk04 varchar2(1) DEFAULT '' NOT NULL, /*类型*/ skk05 number(15,3) DEFAULT '0' NOT NULL, /*系数*/ skk06 varchar2(80), /*说明 */ skkacti varchar2(1) DEFAULT '' NOT NULL /*有效否*/ ); create unique index skk_pk on skk_file (skk01,skk02,skk03,skk04); alter table skk_file add constraint skk_pk primary key (skk01,skk02,skk03,skk04) enable validate; grant select on skk_file to public; grant index on skk_file to public; grant update on skk_file to public; grant delete on skk_file to public; grant insert on skk_file to public; |