FRON bATETOTAL LEAVESLEAVE TYRETRANSNOMONTHYEARTOTALEARNINGNETPAYATEDATEVARCHARISTtabielDECNALOT$0.$ OARCHARITO$)$YVARCHAR$(201$DECINAL$4,0)$DECIMAL$(10,$ O$)$DECIMAL$/10.0)$LEAVE oEMP PAYROLLemptoyee infeEEMPIDEMPNA MEDEPTIDJOINING DTDOBYRS OF EXPEMPLOYEE CATEGORYtabte$)$VARCHARIO$)$VARCHAR$($Z$0)$VARCHARI$0)$ODATEDATEempioyee info ibfk $1$DECIMAL$(10,0)$VARCHAR$($Leemployee info ibflk $3$employee infobfk $2$CLDEPTIDEMPLOYEE CATE GORYELLOCATONM$1$salary infoEMPLOYEE CATEGORYBASICDECIMAODECIMALUS,TRAVELLING ALLOWANCEDEARNESS ALLOWANCEHOUSE RENT ALLOWANCELOCATION ALLOWNANCEPROVIDENT FUNDMEDICAL ALLOWANCEPROFTAXINSURANCEVARCHARILDECIIAALI$7,21$DECIMALIS, $21$DECIMALIS, $21$DECIMALIS, $21$DECIMALU$6.21$DECIMALI$6,2)$DECECIMALODECIMAL$62)$DECIMALI$6.2)$