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