y_timesi
t早退天数PRIMARYKEYMo
thsWorker_IDFOREIGNKEYWorker_IDREFERENCESBase_dataWorker_ID工资信息表Wage_i
foCREATETABLEWage_i
foRecord_IDbigi
tPRIMARYKEY记录编号Worker_IDvarchar15Worker_Namevarchar8Base_Wagefloat基本工资Allowa
ce1float公共补贴Allowa
ce2float出差补贴Rewardfloat奖金Overtime_Mo
eyfloat加班费Deduct_Checkfloat扣考核Aged_Mo
eyfloat养老保险Medical_Mo
eyfloat医疗保险Compo_Mo
eyfloat工伤保险U
employ_Mo
eyfloat失业保险Housi
g_Mo
eyfloat住房公积金I
come_taxfloat所得税
12
f重庆科技学院《数据库原理》课程设计报告
Real_wagefloat实发工资Give_datefloat发放月份FROEIGNKEYWorker_IDREFERENCESBase_dataWorker_ID奖惩记录表Reward_pu
CREATETABLEReward_pu
Record_IDbigi
tPRIMARYKEY记录编号Worker_IDvarchar15Worker_Namevarchar8Record_datedatetime奖惩日期Record_typevarchar2奖惩类型Record_co
te
tvarchar30奖惩内容Record_reaso
varchar30奖惩原因Allow_u
itvarchar20批准单位Remarkvarchar200备注FORERGNKEYWorker_IDREFERENCESBase_dataWorker_ID职称评定信息表Pro_titleCREATETABLEPro_titleWorker_IDvarchar15PRIMARYKEY员工编号Worker_Namevarchar8Assess_datedatetime评定日期Assess_u
itvarchar20评定单位Assess_titlevarchar8评定职称Remarkvarchar200备注
13
f重庆科技学院《数据库原理》课程设计报告
工作履历表Work_ageCREATETABLEWork_ageRecord_IDBigi
tPRIMARYKEY记录编号
Worker_IDvarchar15Begi
_datedatetime起始日期Over_datedatetime结束日期U
it_Namevarchar20单位名称Work_timefloat本单位工作时间Dutyvarchar10担任职务Level1varchar4级别Remarkvarchar200备注FORERGNKEYWorker_IDREFERENCESBase_dataWorker_ID用户账号表User_tableCREATETABLEUser_tableUser_Namevarchar30PRIMARYKEY用户名User_pwdvarchar30用户密码Power_levelvarchar8权限级别
43创建存储过程
在奖惩记录表中创建更新奖惩的存储过程：USEsalaryGOCREATEPROCEDUREupdate_奖惩记录表_1
Record_ID_1bigi
tRecord_ID_2bigi
tWorker_ID_3varchar15
14
f重庆科技学院《数据库原理》课程设计报告
Worker_Name_4varchar8Record_date_5datetimeRecord_type_6varchar2Record_co
te
t_7varchar30Record_reaso
_8varchar30Allow_u
it_9varchar20ASUPDATEsalarydbo奖惩记录表SETRecord_IDRecord_ID_2Worker_IDWorker_ID_3Worker_NameWorker_Name_4Record_dateRecord_date_5Record_typeRecord_type_6Record_co
te
tRecord_co
te
t_7Record_reaso
Record_reasr