/* ================================================================================ 档案代号:tpk_file 档案名称:员工底薪异动明细档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tpk_file ( tpk01 varchar2(16) NOT NULL, /*异动单号 */ tpk02 number(5) NOT NULL, /*行序 */ tpk03 varchar2(10), /*员工代号 */ tpk04 varchar2(10), /*原职等 */ tpk05 varchar2(10), /*新职等 */ tpk06 number(5), /*原职级 */ tpk07 number(5), /*新职级 */ tpk08 number(20,6), /*原底薪金额 */ /*原底薪金额 NO.A066 */ tpk09 number(20,6), /*新底薪金额 */ /*新底薪金额 NO.A066 */ tpk10 varchar2(6), /*原因代码 */ tpk11 varchar2(255), /*备注 */ tpk12 varchar2(1), /*No Use */ tpk13 varchar2(1), /*No Use */ tpk14 varchar2(1), /*No Use */ tpk15 varchar2(1), /*No Use */ tpkud01 varchar2(255), /*自订栏位-Textedit */ tpkud02 varchar2(40), /*自订栏位-文字 */ tpkud03 varchar2(40), /*自订栏位-文字 */ tpkud04 varchar2(40), /*自订栏位-文字 */ tpkud05 varchar2(40), /*自订栏位-文字 */ tpkud06 varchar2(40), /*自订栏位-文字 */ tpkud07 number(15,3), /*自订栏位-数值 */ tpkud08 number(15,3), /*自订栏位-数值 */ tpkud09 number(15,3), /*自订栏位-数值 */ tpkud10 number(10), /*自订栏位-整数 */ tpkud11 number(10), /*自订栏位-整数 */ tpkud12 number(10), /*自订栏位-整数 */ tpkud13 date, /*自订栏位-日期 */ tpkud14 date, /*自订栏位-日期 */ tpkud15 date /*自订栏位-日期 */ ); create unique index tpk_pk on tpk_file (tpk01,tpk02); alter table tpk_file add constraint tpk_pk primary key (tpk01,tpk02) enable validate; grant select on tpk_file to public; grant index on tpk_file to public; grant update on tpk_file to public; grant delete on tpk_file to public; grant insert on tpk_file to public; |