worksuite - Laravel Schema Designer

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

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