tbl_user_tracker

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('tbl_user_tracker_id_seq'::regclass)
daily_tracker_id int4 10 √ null
employee_id varchar 500 null
tbl_employee.employeeid fk_ut_employee R
date timestamp 29,6 null
latitude varchar 30 √ null
longitude varchar 30 √ null
punch_type varchar 10 null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
networking varchar 100 √ null
siteid varchar 100 √ null
punchfrom int4 10 √ null
batterystatus varchar 50 √ null
expensetracking varchar 50 √ null
locationname varchar 500 √ null
punchinoutimageid int4 10 √ null
original_punch_type varchar 10 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_user_tracker_pk__tbl_user__3213e83f9e97650c Primary key Asc id
tbl_user_tracker_idx_employee_punchtype_date_tbl_user_tracker Performance Asc/Asc/Asc employee_id + punch_type + date
tbl_user_tracker_idx_employee_tbl_user_tracker Performance Asc employee_id

Relationships

Close relationships within degrees of separation