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