Home
worksuite
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
user
user_id
increments
timestamps
timestamps
firstname
string
(255)
lastname
string
(255)
username
string
(255)
password
string
(255)
telephone
string
(255)
email
string
(255)
employee_id
FK
integer
enterprise
enterprise_id
increments
timestamps
timestamps
enterpriseName
string
(255)
ofiplanCode
string
(255)
enterpriseUnit
enterpriseunit_id
increments
timestamps
timestamps
enterpriseunitName
string
(255)
ruc
string
(255)
address
string
(255)
enterpriseHeadquarter
enterpriseheadquarter_id
increments
timestamps
timestamps
enterpriseheadquarterName
string
(255)
city_id
FK
integer
enterprise_id
FK
integer
turn
turn_id
increments
timestamps
timestamps
name
string
(255)
beginDateTime
datetime
endDateTime
datetime
tareoType
integer
status
boolean
planningTurn
planingturn_id
increments
timestamps
timestamps
beginDateTime
datetime
endDateTime
datetime
user_id
FK
integer
planning_id
FK
integer
turn_id
FK
integer
activity
activity_id
increments
timestamps
timestamps
title
string
(255)
description
string
(255)
expectedProductivity
string
(255)
kpi
string
(255)
measurementUnit
string
(255)
manHours
string
(255)
status
boolean
turnActivity
turnactivity_id
increments
timestamps
timestamps
turn_id
FK
integer
activity_id
FK
integer
beginDateTime
datetime
endDateTime
datetime
employee
employee_id
increments
timestamps
timestamps
firstname
string
(255)
lastname
string
(255)
dni
string
(255)
payroll
string
(255)
costCenter
string
(255)
adminPosition
string
(255)
enterpriseheadquarter_id
FK
integer
status
boolean
enterprise_id
FK
integer
activityEmployee
activityemployee_id
increments
timestamps
timestamps
activity_id
FK
integer
employee_id
FK
integer
leader
boolean
beginDateTime
datetime
endDateTime
datetime
turnEmployee
turnemployee_id
increments
timestamps
timestamps
beginDateTime
datetime
endDateTime
datetime
turn_id
FK
integer
employee_id
FK
integer
city
city_id
increments
timestamps
timestamps
name
string
(255)
activityObservations
activityobservations_id
increments
timestamps
timestamps
title
string
(255)
description
string
(255)
obsAntesDespues
boolean
turnactivity_id
FK
integer
planning
planning_id
increments
timestamps
timestamps
beginDateTime
datetime
endDateTime
datetime
name
string
(255)
description
string
(255)
enterpriseheadquarter_id
FK
integer
isRoster
boolean
status
boolean
assistance
assistance_id
increments
timestamps
timestamps
isMissing
boolean
missingReason
string
(255)
isLate
boolean
lateReason
string
(255)
tiempoEntroTarde
datetime
tiempoSalioAntes
datetime
turnemployee_id
FK
integer
turnObservations
turnobservations_id
increments
timestamps
timestamps
title
string
(255)
description
string
(255)
planningturn_id
FK
integer
enterpriseEnterpriseUnit
id
increments
timestamps
timestamps
enterprise_id
FK
integer
emterpirseunit_id
FK
integer
×
Comments for worksuite
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01