/*
================================================================================
档案代号:cib_file
档案名称:劳工退休金每月提缴工资明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cib_file
(
cib01       varchar2(5) NOT NULL,    /*计薪周期编号                           */
cib02       varchar2(10) NOT NULL,   /*员工代号                               */
cib03       varchar2(1),             /*No Use                                 */
cib04       number(5),               /*工资等级                               */
cib05       varchar2(1),             /*No Use                                 */
cib06       number(9,4),             /*自愿提缴率                             */
cib07       number(20,6),            /*自愿提缴金额                           */
cib08       number(9,4),             /*雇主提缴率                             */
cib09       number(20,6),            /*雇主提缴金额                           */
cib10       number(5),               /*应计工资天数                           */
cib11       number(20,6),            /*提缴工资                               */
cib12       number(5)                /*员工提缴天数                           */
);

create unique index cib_pk on cib_file (cib01,cib02);
alter table cib_file add  constraint cib_pk primary key  (cib01,cib02) enable validate;
grant select on cib_file to public;
grant index on cib_file to public;
grant update on cib_file to public;
grant delete on cib_file to public;
grant insert on cib_file to public;