pln_daily_attendance - Laravel Schema Designer

m_attendance

id increments
timestamps timestamps
pernr integer
personnel_area string
personnel_subarea string
org_unit integer
date date
time time
type integer
description string
is_active integer
is_backlog boolean
range decimal
created_by integer
updated_by integer
latitude string
file_id integer
longitude string
approved integer
in_range boolean
is_correction boolean
last_id integer

attendance_clean

id increments
timestamps timestamps
attendance_id integer
file_id integer
pernr integer
personnel_area string
personnel_subarea string
org_unit string
date date
time time
type integer
status_sent boolean
sent_date date
created_by integer
updated_by integer
message text

m_attendance_approval

id increments
timestamps timestamps
pernr integer
created_by integer
updated_by integer
status integer
description string

m_files

id increments
timestamps timestamps
filesName string
files binary
fileSize decimal
created_by integer
updated_by integer

m_lock_corrections

id increments
timestamps timestamps
start_date string
end_date date
max_correction_date timestamp
created_by integer
updated_by integer

planned_working_time

id increments
timestamps timestamps
pernr integer
start_date date
end_date date
ws_id integer
daily_working_hours decimal
weekly_working_hours decimal
monthly_working_hours decimal
annual_working_hours decimal
weekly_workdays decimal
created_by integer
updated_by integer

m_attendance_type

id increments
timestamps timestamps
name string
created_by integer
updated_by integer

parameter

id increments
timestamps timestamps
date date
type string
status string

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01