tbl_employee

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
employeeid varchar 500 null
tbl_aboutyourself.employeeid fk_tbl_aboutyourself_employeeid R
tbl_aboutyourselfhistory.employeeid fk_tbl_aboutyourselfhistory_employeeid R
tbl_allotleaveaftereligibility.employeeid Implied Constraint R
tbl_arrears.employeeid Implied Constraint R
tbl_arrearshistory.employeeid Implied Constraint R
tbl_assigneddocument.employeeid Implied Constraint R
tbl_attendanceoutstation.employeeid fk_ao_employee R
tbl_attendancerequest.employeeid fk_at_employee R
tbl_company_contribution_process_salary.employeeid Implied Constraint R
tbl_daily_tracker.employee_id fk_dt_employee R
tbl_dailyattendancen.employeeid fk_da_employee R
tbl_employee_attendance_policy.employeeid Implied Constraint R
tbl_employee_attendance_policy_history.employeeid Implied Constraint R
tbl_employee_contract.employeeid fk_employee R
tbl_employee_geofencing_tracking.employeeid Implied Constraint R
tbl_employee_geofencing_tracking_report.employeeid Implied Constraint R
tbl_employeebankdetailhistory.employeeid fk_tbl_employeebankdetailhistory_employeeid R
tbl_employeecoff.employeeid fk_empcom_employee R
tbl_employeecompliancehistory.employeeid Implied Constraint R
tbl_employeecontactinfohistory.employeeid fk_tbl_employeecontactinfohistory_employeeid R
tbl_employeegeofencingrule.employeeid fk_tbl_employeegeofencingrule_employeeid R
tbl_employeehistory.employeeid fk_eh_employee R
tbl_employeelocation.employeeid fk_tbl_employeelocation_employeeid R
tbl_employeelocation.statusby fk_tbl_employeelocation_statusby R
tbl_employeenomineehistory.employeeid Implied Constraint R
tbl_employeepayelementmaster.employeeid Implied Constraint R
tbl_employeesalaryon.employeeid Implied Constraint R
tbl_employeestructure.employeeid fk_employee R
tbl_employeetdsmaster.employeeid Implied Constraint R
tbl_esicaccountdeductionmapping.employeeid Implied Constraint R
tbl_fuelexpenseemployeemapping.employee_id fk_fe_employee R
tbl_geofencingrulenotification.employeeid fk_tbl_geofencingrulenotification_employeeid R
tbl_gratuityaccountmapping.employeeid Implied Constraint R
tbl_holdsalary.employeeid Implied Constraint R
tbl_holdsalaryhistory.employeeid Implied Constraint R
tbl_holidayemployeemapping.employeeid fk_tbl_holidayemployeemapping_employeeid R
tbl_inactiveemployee.employeeid fk__tbl_inact__emplo__338937f1 R
tbl_leaveapplicationheader.employeeid fk_leave_employee R
tbl_leavebalancetransactions.employeeid Implied Constraint R
tbl_leavecancellationhistory.employeeid fk_tbl_leavecancellationhistory_employeeid R
tbl_leavecarryforwardhistory.employeeid Implied Constraint R
tbl_leavecodepolicyemployeemapping.employeeid fk_tbl_leavecodepolicyemployeemapping_employeeid R
tbl_liability.employeeid Implied Constraint R
tbl_liability_history.employeeid Implied Constraint R
tbl_lwfaccountdeductionmapping.employeeid Implied Constraint R
tbl_milestone_mails.employeeid Implied Constraint R
tbl_monthlyattendance.employeeid fk_ma_employee R
tbl_moodmeterdata.employeeid Implied Constraint R
tbl_outofrangepunch.employeeid Implied Constraint R
tbl_overtimepolicyemployeemapping.employeeid fk_tbl_overtimepolicyemployeemapping_employeeid R
tbl_payrolladjustments.employeeid Implied Constraint R
tbl_payrolladjustmentshistory.employeeid Implied Constraint R
tbl_payrollprocesserror.employeeid Implied Constraint R
tbl_pfaccountdeductionmapping.employeeid Implied Constraint R
tbl_pms_cycle_employee.employee_id fk__tbl_pms_c__emplo__7f170660 R
tbl_project_employee_mapping.employeeid Implied Constraint R
tbl_ptaccountdeductionmapping.employeeid Implied Constraint R
tbl_regenerateapplicablecriteria.employeeid fk_tbl_regenerateapplicablecriteria_employeeid R
tbl_reminder_mails.employeeid Implied Constraint R
tbl_reporthistorymaster.employeeid Implied Constraint R
tbl_resetsalarydata.employeeid Implied Constraint R
tbl_salarystructuretemplateemployeemapping.employeeid Implied Constraint R
tbl_task.employeeid Implied Constraint R
tbl_task_hours.employeeid Implied Constraint R
tbl_taskhistory.employeeid Implied Constraint R
tbl_tds_master.employeeid fk_tds_employee R
tbl_teamtransfer.employeeid fk_tbl_teamtransfer_employeeid R
tbl_teamtransfer.statusby fk_tbl_teamtransfer_statusby R
tbl_teamtransfermembers.employeeid fk_tbl_teamtransfermembers_employeeid R
tbl_teamtransfermembers.reportingperson1 fk_tbl_teamtransfermembers_reportingperson1 R
tbl_teamtransfermembers.reportingperson2 fk_tbl_teamtransfermembers_reportingperson2 R
tbl_ticket.assigneeid fk_tbl_ticket_assigneeid R
tbl_tickethistory.assigneeid fk_tbl_tickethistory_assigneeid R
tbl_tracking_master.employee_id fk_tm_employee R
tbl_transferrequisitionmaster.employeeid fk_tbl_transferrequisitionmaster_employeeid R
tbl_transferrequisitionmaster.reportingperson1 fk_tbl_transferrequisitionmaster_reportingperson1 R
tbl_transferrequisitionmaster.reportingperson2 fk_tbl_transferrequisitionmaster_reportingperson2 R
tbl_transferrequisitionmaster.statusby fk_tbl_transferrequisitionmaster_statusby R
tbl_user_tracker.employee_id fk_ut_employee R
view_employeedetail.employeeid Implied Constraint R
companyid int4 10 null
tbl_companymaster.companyid fk_employee_sbu R
euserid varchar 500 √ null
efirstname varchar 500 null
emiddlename varchar 50 √ null
elastname varchar 50 √ null
employeephoto varchar 200 √ null
employeementdate timestamp 29,6 √ null
edateofbirth timestamp 29,6 √ null
ereqattendance bool 1 √ false
ecompanyemail varchar 100 √ null
enationality varchar 40 √ null
ereligion varchar 40 √ null
egender varchar 6 √ null
emaritalstatus varchar 10 √ null
eanniversarydate date 13 √ null
ezipcode varchar 10 √ null
ehight numeric 0 √ null
eweight numeric 0 √ null
emarkidentification varchar 100 √ null
ebloodgroup varchar 10 √ null
edrivinglicenseno varchar 20 √ null
edrivinglicenseexpiry timestamp 29,6 √ null
enomineename varchar 60 √ null
enomineerelationship varchar 30 √ null
ebankname varchar 60 √ null
ebranchcode varchar 12 √ null
ebankbranchname varchar 60 √ null
ebankphone varchar 15 √ null
eaccounttype varchar 50 √ null
eaccountno varchar 30 √ null
epayabalat varchar 100 √ null
epaymentmethod varchar 20 √ null
esalaryon varchar 10 √ null
eesiapplicable bool 1 √ false
eesino varchar 30 √ null
eesidispensary varchar 60 √ null
epfapplicable bool 1 √ false
epfno varchar 40 √ null
epfspecial bool 1 √ false
eptapplicable bool 1 √ true
epanno varchar 20 √ null
egratuityapplicable bool 1 √ true
eotapplicable bool 1 √ false
erfidno varchar 30 √ null
efingerno varchar 30 √ null
eresignationdate timestamp 29,6 √ null
eblocked bool 1 √ false
eblockeddate timestamp 29,6 √ null
eprobation bool 1 √ false
eattendancegen bool 1 √ false
eleavegen bool 1 √ false
etdsapplicable bool 1 √ false
eemployeestatus varchar 15 √ null
ecreatedate timestamp 29,6 √ null
eother varchar 50 √ null
eotamount numeric 0 √ '0'::numeric
elateearlyday bool 1 √ true
elateearlyhour bool 1 √ true
eresignationperiod int4 10 √ null
econformationdate timestamp 29,6 √ null
eextra varchar 50 √ null
eottype varchar 50 √ null
econtracterid int8 19 √ null
ebankpayee varchar 100 √ null
ecomme1 bool 1 √ false
ecomme2 varchar 100 √ null
ecomme3 varchar 2147483647 √ null
eaadhaarno varchar 2147483647 √ null
egratuityno varchar 2147483647 √ null
edlino varchar 2147483647 √ null
ifsccode varchar 2147483647 √ null
comm1 varchar 2147483647 √ null
comm2 varchar 2147483647 √ null
comm3 varchar 2147483647 √ null
comm4 varchar 2147483647 √ null
comm5 varchar 2147483647 √ null
comm6 varchar 2147483647 √ null
comm7 varchar 2147483647 √ null
comm8 varchar 2147483647 √ null
comm9 varchar 2147483647 √ null
comm10 varchar 2147483647 √ null
resigstatus varchar 50 √ null
resigeffdate timestamp 29,6 √ null
nextapprdate timestamp 29,6 √ null
deskno varchar 50 √ null
floorno varchar 50 √ null
modifiedon timestamp 29,6 √ null
modifiedby varchar 50 √ null
isgeographicalassign bool 1 √ false
countoffdayinattendance bool 1 √ true
countholidayinattendance bool 1 √ true
tmpcomp1 bool 1 √ false
tmpcomp2 bool 1 √ false
tmpcomp3 varchar 100 √ null
tmpcomp4 varchar 100 √ null
holidaypay bool 1 √ null
holidaycalucatedon varchar 50 √ null
holidayamount numeric 0 √ null
punch_access int4 10 √ null
includeexcludepf int4 10 0
basedon int4 10 0
vpf bool 1 false
vpftype int4 10 0
fixedpf numeric 0 '0'::numeric
twelvepercent bool 1 false
actualbasicpercent numeric 0 '0'::numeric
iscertified varchar 50 √ '''UNKNOWN'''::character varying
isexperienced varchar 50 √ '''UNKNOWN'''::character varying
isimmigrate varchar 50 √ '''UNKNOWN'''::character varying
otshifthours numeric 0 √ null
elwfapplicable bool 1 √ null
showemployeeinemployeesearch bool 1 true
ptrulestateid int8 19 √ null
dynamicfields varchar 2147483647 √ null
creationprocess varchar 25 √ '''COMPLETED'''::character varying
pfruleid int8 19 √ null
vpfamount numeric 0 √ '0'::numeric
billing int8 19 √ null
candidate_id int8 19 √ null
joining_form_id int8 19 √ null
actual_date_of_birth date 13 √ null
name_as_per_pan varchar 500 √ null
name_as_per_aadhar varchar 500 √ null
is_login_detail_send bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_employee_pk__tbl_empl__7ad04ff1e504c2be Primary key Asc employeeid
tbl_employee_idx_employee_tbl_employee Performance Asc employeeid

Relationships

Close relationships within degrees of separation