/*
================================================================================
档案代号:cpm_file
档案名称:劳保、健保投保金额分级资料
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cpm_file
(
cpm00       varchar2(1) NOT NULL,    /*级距种类                               */
                                     /*级距种类 1:劳保 2:健保                 */
cpm01       number(5) NOT NULL,      /*投保等级                               */
cpm02       number(20,6),            /*每月实际所得之下限                     */
cpm03       number(20,6),            /*每月实际所得之上限                     */
cpm04       number(20,6),            /*投保金额                               */
cpm05       varchar2(1),             /*No Use                                 */
cpmacti     varchar2(1),             /*资料有效否                             */
cpmuser     varchar2(10),            /*资料所有者                             */
cpmgrup     varchar2(10),            /*资料所有群                             */
cpmmodu     varchar2(10),            /*资料更改者                             */
cpmdate     date                     /*最近修改日                             */
);

create unique index cpm_pk on cpm_file (cpm00,cpm01);
alter table cpm_file add  constraint cpm_pk primary key  (cpm00,cpm01) enable validate;
grant select on cpm_file to public;
grant index on cpm_file to public;
grant update on cpm_file to public;
grant delete on cpm_file to public;
grant insert on cpm_file to public;