Anomalies


Things that might not be 'quite right' about your database and schema

Columns whose name and type imply a relationship to another table's primary key

Child Column Implied Parent Column
eventmailermailconfiguration.[companyid] tbl_companymaster.[companyid]
hr_documentmaster.[doccategoryid] hr_documentcategorymaster.[doccategoryid]
photos.[imageid] imagegallery.[imageid]
pmsformprocess.[formid] tbl_formdetail.[formid]
probationformstatus.[formid] tbl_formdetail.[formid]
probationformstatuspmsnew.[formid] tbl_formdetail.[formid]
tbl_aboutyourself.[companyid] tbl_companymaster.[companyid]
tbl_aboutyourselfhistory.[companyid] tbl_companymaster.[companyid]
tbl_allotleaveaftereligibility.[employeeid] tbl_employee.[employeeid]
tbl_allotleaveaftereligibility.[leavecodeid] tbl_leavecodemaster.[leavecodeid]
tbl_announcement.[companyid] tbl_companymaster.[companyid]
tbl_announcement.[stateid] tbl_statemaster.[stateid]
tbl_arrears.[employeeid] tbl_employee.[employeeid]
tbl_arrears.[payelementid] tbl_employeepayelement.[payelementid]
tbl_arrearshistory.[employeeid] tbl_employee.[employeeid]
tbl_arrearshistory.[payelementid] tbl_employeepayelement.[payelementid]
tbl_assigneddocument.[documentid] hr_documentmaster.[documentid]
tbl_assigneddocument.[employeeid] tbl_employee.[employeeid]
tbl_attendance_workschedule_detail.[shiftid] tbl_shiftmasterv1.[shiftid]
tbl_attendance_workschedule_detail_history.[shiftid] tbl_shiftmasterv1.[shiftid]
tbl_attendanceoutstation.[companyid] tbl_companymaster.[companyid]
tbl_attendancerequest.[companyid] tbl_companymaster.[companyid]
tbl_branchmasterhistory.[branchid] tbl_branchmaster.[branchid]
tbl_categorymaster.[companyid] tbl_companymaster.[companyid]
tbl_clubbing.[leavecodeid] tbl_leavecodemaster.[leavecodeid]
tbl_company_contribution_process_salary.[employeeid] tbl_employee.[employeeid]
tbl_companymaster.[stateid] tbl_statemaster.[stateid]
tbl_complianceaccount.[stateid] tbl_statemaster.[stateid]
tbl_dailyattendancen.[shiftid] tbl_shiftmasterv1.[shiftid]
tbl_dailyreport.[taskid] tbl_schedulemaster.[taskid]
tbl_documenthistory.[documentid] hr_documentmaster.[documentid]
tbl_downloadorviewdocumenthistory.[documentid] hr_documentmaster.[documentid]
tbl_employee_attendance_policy.[employeeid] tbl_employee.[employeeid]
tbl_employee_attendance_policy_history.[employeeid] tbl_employee.[employeeid]
tbl_employee_attendance_policy_history.[historyid] tbl_shiftmasterv1history.[historyid]
tbl_employee_geofencing_tracking.[employeeid] tbl_employee.[employeeid]
tbl_employee_geofencing_tracking_report.[employeeid] tbl_employee.[employeeid]
tbl_employee_previous_pf.[companyid] tbl_companymaster.[companyid]
tbl_employeeaddress.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeeaddresshistory.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeeagreementacceptance.[employeeagreementid] tbl_employeeagreement.[employeeagreementid]
tbl_employeebankdetailhistory.[companyid] tbl_companymaster.[companyid]
tbl_employeecertification.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeecertificationhistory.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeecompliancehistory.[employeeid] tbl_employee.[employeeid]
tbl_employeecontactinfohistory.[companyid] tbl_companymaster.[companyid]
tbl_employeecontactinfohistory.[eaddressid] tbl_employeeaddress.[eaddressid]
tbl_employeedocument.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeedocumenthistory.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeeemergancy.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeeemergancyhistory.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeeexperience.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeeexperiencehistory.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeeguarantors.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeeguarantorshistory.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeehistory.[companyid] tbl_companymaster.[companyid]
tbl_employeeimmigration.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeeimmigrationhistory.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeeinsurance.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeelanguage.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeelanguagehistory.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeenomineehistory.[companyid] tbl_companymaster.[companyid]
tbl_employeenomineehistory.[employeeid] tbl_employee.[employeeid]
tbl_employeepayelement.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeepayelementmaster.[employeeid] tbl_employee.[employeeid]
tbl_employeepayment.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeequalification.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeequalificationhistory.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeereferences.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeereferenceshistory.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeereimbursementpaycycle.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeereimbursementpayment.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeerelation.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeerelationhistory.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeesalaryon.[employeeid] tbl_employee.[employeeid]
tbl_employeeselectedtdsslab.[companyid] tbl_companymaster.[companyid]
tbl_employeeselectedtdsslab.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_employeeselectedtdsslab.[financialyearid] tbl_financialyear.[financialyearid]
tbl_employeestructure.[branchid] tbl_branchmaster.[branchid]
tbl_employeestructure.[categoryid] tbl_categorymaster.[categoryid]
tbl_employeestructure.[subcategoryid] tbl_subcategorymaster.[subcategoryid]
tbl_employeetdsmaster.[employeeid] tbl_employee.[employeeid]
tbl_esicaccountdeductionmapping.[branchid] tbl_branchmaster.[branchid]
tbl_esicaccountdeductionmapping.[employeeid] tbl_employee.[employeeid]
tbl_expenceapproval.[expid] tbl_expenceclaimmaster.[expid]
tbl_expensepaymentbunch.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_fndfheader.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_fndfheaderhistory.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_fndfheaderhistory.[fnfheaderid] tbl_fndfheader.[fnfheaderid]
tbl_fndfheadertemp.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_fndfheadertemp.[fnfheaderid] tbl_fndfheader.[fnfheaderid]
tbl_fndfline.[fnfheaderid] tbl_fndfheader.[fnfheaderid]
tbl_fndfline.[payelementid] tbl_employeepayelement.[payelementid]
tbl_fndflinetemp.[fnfheaderid] tbl_fndfheader.[fnfheaderid]
tbl_fndflinetemp.[fnflineid] tbl_fndfline.[fnflineid]
tbl_formassign.[formid] tbl_formdetail.[formid]
tbl_formassignhistory.[assignid] tbl_formassign.[assignid]
tbl_formassignv1.[formid] tbl_formdetail.[formid]
tbl_formfinalrat.[formid] tbl_formdetail.[formid]
tbl_generalpolicy.[branchid] tbl_branchmaster.[branchid]
tbl_generalpolicy.[categoryid] tbl_categorymaster.[categoryid]
tbl_generalpolicy.[companyid] tbl_companymaster.[companyid]
tbl_generalpolicy.[stateid] tbl_statemaster.[stateid]
tbl_gratuityaccountmapping.[branchid] tbl_branchmaster.[branchid]
tbl_gratuityaccountmapping.[employeeid] tbl_employee.[employeeid]
tbl_gratuitycalculation.[branchid] tbl_branchmaster.[branchid]
tbl_holdsalary.[employeeid] tbl_employee.[employeeid]
tbl_holdsalaryhistory.[employeeid] tbl_employee.[employeeid]
tbl_holidaybranchmaster.[branchid] tbl_branchmaster.[branchid]
tbl_holidaybranchmaster.[stateid] tbl_statemaster.[stateid]
tbl_hrsetupmaster.[companyid] tbl_companymaster.[companyid]
tbl_kratypemasterhistory.[kraid] tbl_pmskratypemaster.[kraid]
tbl_leaveapplicationheader.[companyid] tbl_companymaster.[companyid]
tbl_leavebalancetransactions.[employeeid] tbl_employee.[employeeid]
tbl_leavecarryforwardhistory.[employeeid] tbl_employee.[employeeid]
tbl_leaveencashment.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_leaveencashmentv1.[leavecodeid] tbl_leavecodemaster.[leavecodeid]
tbl_leaveentitlment.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_leaveentitlment.[leavecodeid] tbl_leavecodemaster.[leavecodeid]
tbl_leavereport.[companyid] tbl_companymaster.[companyid]
tbl_liability.[employeeid] tbl_employee.[employeeid]
tbl_liability.[payelementid] tbl_employeepayelement.[payelementid]
tbl_liability_history.[employeeid] tbl_employee.[employeeid]
tbl_liability_history.[payelementid] tbl_employeepayelement.[payelementid]
tbl_lookupmaster.[lookuptypeid] tbl_lookuptypemaster.[lookuptypeid]
tbl_lwfaccountdeductionmapping.[branchid] tbl_branchmaster.[branchid]
tbl_lwfaccountdeductionmapping.[employeeid] tbl_employee.[employeeid]
tbl_masterformassign.[formid] tbl_formdetail.[formid]
tbl_milestone_mails.[employeeid] tbl_employee.[employeeid]
tbl_monthlyattendance.[stateid] tbl_statemaster.[stateid]
tbl_moodmeterdata.[companyid] tbl_companymaster.[companyid]
tbl_moodmeterdata.[employeeid] tbl_employee.[employeeid]
tbl_outofrangepunch.[employeeid] tbl_employee.[employeeid]
tbl_paidretentiondetails.[companyid] tbl_companymaster.[companyid]
tbl_paidunpaidperformancerewards.[companyid] tbl_companymaster.[companyid]
tbl_payelementshistory.[payelementid] tbl_employeepayelement.[payelementid]
tbl_payrolladjustments.[employeeid] tbl_employee.[employeeid]
tbl_payrolladjustments.[payelementid] tbl_employeepayelement.[payelementid]
tbl_payrolladjustmentshistory.[employeeid] tbl_employee.[employeeid]
tbl_payrolladjustmentshistory.[payelementid] tbl_employeepayelement.[payelementid]
tbl_payrollprocesserror.[employeeid] tbl_employee.[employeeid]
tbl_pfaccountdeductionmapping.[branchid] tbl_branchmaster.[branchid]
tbl_pfaccountdeductionmapping.[employeeid] tbl_employee.[employeeid]
tbl_pfmaster.[stateid] tbl_statemaster.[stateid]
tbl_pms_prespective.[formid] tbl_formdetail.[formid]
tbl_pms_prespective.[sactionid] tbl_pms_sactionweightage.[sactionid]
tbl_pms_sactionweightage.[formid] tbl_formdetail.[formid]
tbl_pmscompetencytypemaster.[formid] tbl_formdetail.[formid]
tbl_pmsglobalrating.[formid] tbl_formdetail.[formid]
tbl_pmsgoallist.[formid] tbl_formdetail.[formid]
tbl_pmskratypemaster.[formid] tbl_formdetail.[formid]
tbl_pmskratypemaster.[prespectiveid] tbl_pms_prespective.[prespectiveid]
tbl_pmskratypemaster.[sactionid] tbl_pms_sactionweightage.[sactionid]
tbl_probationcategory.[formid] tbl_formdetail.[formid]
tbl_probationcategorypms.[formid] tbl_formdetail.[formid]
tbl_probationcategorypms.[sactionid] tbl_pms_sactionweightage.[sactionid]
tbl_probationpipform.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_probationquestion.[formid] tbl_formdetail.[formid]
tbl_probationquestionpms.[formid] tbl_formdetail.[formid]
tbl_probationquestionpms.[sactionid] tbl_pms_sactionweightage.[sactionid]
tbl_probationrating.[formid] tbl_formdetail.[formid]
tbl_probationratingnew.[formid] tbl_formdetail.[formid]
tbl_probratingmaster.[formid] tbl_formdetail.[formid]
tbl_probratingmaster.[probationformstatusid] probationformstatus.[id]
tbl_probratingmasterpms.[formid] tbl_formdetail.[formid]
tbl_processsalary.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_processsalary.[payelementid] tbl_employeepayelement.[payelementid]
tbl_project_employee_mapping.[employeeid] tbl_employee.[employeeid]
tbl_ptaccountdeductionmapping.[branchid] tbl_branchmaster.[branchid]
tbl_ptaccountdeductionmapping.[employeeid] tbl_employee.[employeeid]
tbl_ptheadermaster.[stateid] tbl_statemaster.[stateid]
tbl_ptlinemaster.[ptheaderid] tbl_ptheadermaster.[ptheaderid]
tbl_reminder_mails.[employeeid] tbl_employee.[employeeid]
tbl_reportfooterreference.[companyid] tbl_companymaster.[companyid]
tbl_reporthistorymaster.[employeeid] tbl_employee.[employeeid]
tbl_resetsalarydata.[employeeid] tbl_employee.[employeeid]
tbl_resignationclearance.[rcheaderid] tbl_resignationclearancehead.[rcheaderid]
tbl_resignationclearancehead.[resignationid] tbl_resignationmaster.[resignationid]
tbl_resignationmaster.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_rolemaster.[companyid] tbl_companymaster.[companyid]
tbl_rolemasterhistory.[companyid] tbl_companymaster.[companyid]
tbl_rolemasterhistory.[roleid] tbl_rolemaster.[roleid]
tbl_salarystructuretemplateelements.[payelementid] tbl_employeepayelement.[payelementid]
tbl_salarystructuretemplateemployeemapping.[employeeid] tbl_employee.[employeeid]
tbl_sepexitinterview.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_shiftgroup.[shiftid] tbl_shiftmasterv1.[shiftid]
tbl_shiftgroup_history.[shiftid] tbl_shiftmasterv1.[shiftid]
tbl_shiftmasterv1history.[companyid] tbl_companymaster.[companyid]
tbl_shiftmasterv1history.[shiftid] tbl_shiftmasterv1.[shiftid]
tbl_subcategorymaster.[categoryid] tbl_categorymaster.[categoryid]
tbl_suggestion.[employeeid] tbl_employee_previous_pf.[employeeid]
tbl_task.[employeeid] tbl_employee.[employeeid]
tbl_task_hours.[employeeid] tbl_employee.[employeeid]
tbl_task_hours.[taskid] tbl_schedulemaster.[taskid]
tbl_taskcustomfieldsvaluehistory.[historyid] tbl_shiftmasterv1history.[historyid]
tbl_taskhistory.[employeeid] tbl_employee.[employeeid]
tbl_taskhistory.[historyid] tbl_shiftmasterv1history.[historyid]
tbl_tds_master.[financialyearid] tbl_financialyear.[financialyearid]
tbl_template_assign_mapping.[assignid] tbl_formassign.[assignid]
tbl_templatecustomfieldvaluehistory.[historyid] tbl_shiftmasterv1history.[historyid]
tbl_todaysthought.[branchid] tbl_branchmaster.[branchid]
tbl_todaysthought.[companyid] tbl_companymaster.[companyid]
tbl_todaysthought.[stateid] tbl_statemaster.[stateid]
tbl_userlogin.[companyid] tbl_companymaster.[companyid]
tbl_userlogin_bkp2023121.[companyid] tbl_companymaster.[companyid]
tbl_userlogin_bkp2023121.[roleid] tbl_rolemaster.[roleid]
tbl_userrole.[roleid] tbl_rolemaster.[roleid]
tbl_userrolehistory.[userrolegid] tbl_userrole.[userrolegid]
tbl_workscheduleallocation_history.[shiftid] tbl_shiftmasterv1.[shiftid]
tds_declarationcategorymaster.[companyid] tbl_companymaster.[companyid]

Tables without indexes

Table Rows
htmlfile_configuration 206
log_table -1
tbl_departmentofcompanyhistory -1
tbl_employeeemergancyhistory -1
tbl_employeeexperiencehistory -1
tbl_employeerelationhistory -1
tbl_expense_policy -1
tbl_expense_policy_payment_calculation -1
tbl_fndfheadertemp -1
tbl_fndflinetemp -1
tbl_leave_code_reason -1
tbl_pagemenulistnew 492
tbl_rolemasterhistory -1
tbl_scheduler -1
tbl_userlogin_bkp2023121 -1
tbl_userrolehistory -1

Tables that contain a single column

Table Column
Anomaly not detected

Tables with incrementing column names, potentially indicating denormalization

Table
hr_documentcategorymaster
hr_documentmaster
probationformstatus
probationformstatuspmsnew
tbl_announcement
tbl_assets_vendor
tbl_attendanceoutstation
tbl_attendancerequest
tbl_candidate_offer
tbl_categorymasterpms
tbl_companymaster
tbl_currencymaster
tbl_dailyattendancen
tbl_emailsmtpmaster
tbl_employee
tbl_employee_geofencing_tracking_report
tbl_employeeaddress
tbl_employeeaddresshistory
tbl_employeeagreement
tbl_employeeagreementacceptance
tbl_employeecoff
tbl_employeeemergancy
tbl_employeeemergancyhistory
tbl_employeeexitdata
tbl_employeeguarantors
tbl_employeeguarantorshistory
tbl_employeepromotion
tbl_employeereferences
tbl_employeereferenceshistory
tbl_employeeselectedtdsslab
tbl_expenceapproval
tbl_expenceclaimmaster
tbl_fndfheader
tbl_fndfheaderhistory
tbl_fndfheadertemp
tbl_fndfline
tbl_fndflinetemp
tbl_fnfstatusupdate
tbl_formassign
tbl_formdetail
tbl_formfinalrat
tbl_generalpolicy
tbl_gratuitycalculation
tbl_jdmaster
tbl_kraapprovelpms
tbl_leaveapplicationheader
tbl_leaveapplicationline
tbl_leavecodepolicyconfig
tbl_leavecreditdebit
tbl_logindetail
tbl_masterformassign
tbl_okr_template_assign
tbl_overtimepolicyconfig
tbl_paidretentiondetails
tbl_paidunpaidperformancerewards
tbl_pms_cycleyear
tbl_pms_level
tbl_pms_prespective
tbl_pms_reportingmaster
tbl_pms_sactionweightage
tbl_pmscompetencytypemaster
tbl_pmscycledetailinfo
tbl_pmsgoallist
tbl_pmskratypemaster
tbl_probationcategory
tbl_probationcategorypms
tbl_probationratingnew
tbl_probratingmaster
tbl_probratingmasterpms
tbl_questionmaster_pms
tbl_reportfooterreference
tbl_resignationmaster
tbl_schedulemaster
tbl_suggestion
tbl_systemworkflow
tbl_tds_previous_employer
tbl_teamtransfermembers
tbl_templeavedetail
tbl_thinktodomaster
tbl_tniformcategorymaster
tbl_tniformemployeemaster
tbl_tniformquestionmaster
tbl_transferrequisitionmaster
tbl_travel_expense
tbl_travelrequestmaster
tds_declarationcategorymaster
tds_declarationtitlemaster

Columns whose default value is the word 'NULL' or 'null'

Table
Anomaly not detected