/*
================================================================================
档案代号:bgt_file
档案名称:劳健保费率档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bgt_file
(
bgt01       number(10) NOT NULL,     /*起始薪资级距                           */
bgt02       number(10) NOT NULL,     /*截止薪资级距                           */
bgt03       number(20,6),            /*劳保费                                 */
bgt04       number(20,6),            /*健保费                                 */
bgtacti     varchar2(1),             /*资料有效码                             */
bgtuser     varchar2(10),            /*资料所有者                             */
bgtgrup     varchar2(10),            /*资料所有部门                           */
bgtmodu     varchar2(10),            /*资料修改者                             */
bgtdate     date                     /*最近修改日                             */
);

create unique index bgt_pk on bgt_file (bgt01,bgt02);
alter table bgt_file add  constraint bgt_pk primary key  (bgt01,bgt02) enable validate;
grant select on bgt_file to public;
grant index on bgt_file to public;
grant update on bgt_file to public;
grant delete on bgt_file to public;
grant insert on bgt_file to public;