HSE data analysis - Laravel Schema Designer

project

id increments
timestamps timestamps
softDeletes softDeletes
name string (250)
code integer
pm string
hse_manager string
owner string
sector_id integer
status boolean

engineer

id increments
timestamps timestamps
softDeletes softDeletes
project_id integer
name string
position string
hr_code integer
email string
phone string
type_id integer

event

id increments
timestamps timestamps
softDeletes softDeletes
type_id integer
project_id integer
issuer string
engineer_id integer
event_location string
reference string
description text
category_id integer

equipment

id increments
timestamps timestamps
type_id integer
project_id integer
model string
sr string
manufacture string
owner string

equipment_det

id increments
timestamps timestamps
softDeletes softDeletes
project_id integer
equipment_id integer
color_code boolean
insp_date datetime
3party_date datetime
join_date datetime
date_color datetime
notes longText

event_type

id increments
timestamps timestamps
softDeletes softDeletes
name string

category

id increments
timestamps timestamps
softDeletes softDeletes
name string

sector

id increments
timestamps timestamps
softDeletes softDeletes
name string
bu_director string

instant_closure

id increments
timestamps timestamps
softDeletes softDeletes
description string
due_date datetime
responsible_id integer
closure_date datetime
incident_id integer
type enum
status enum

incident

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
title string
description text
activity_id integer
type_id integer
direct_manager_id integer
time string
investigation_team string
incident_location string
incident_category string
project_id integer

the_case

id increments
timestamps timestamps
softDeletes softDeletes
name string
date_of_birth datetime
exp integer
start_date datetime
direct_manager_id integer
occupation string
national_id string
hr_code integer
nature_of_injury string
place_of_injury string
incident_id integer
injury_type_id integer
no_of_lti string

witness

id increments
timestamps timestamps
softDeletes softDeletes
name string
position string
statement string
national_id string
hr_code integer
incident_id integer

cause

id increments
timestamps timestamps
softDeletes softDeletes
description string
type enum
incident_id integer

event_closure

id increments
timestamps timestamps
softDeletes softDeletes
description string
closure_date datetime
event_id integer
equipment_id integer
due_date datetime
status enum

equipment_type

id increments
timestamps timestamps
softDeletes softDeletes
name string

engineer_type

id increments
timestamps timestamps
softDeletes softDeletes
name string

maintenance_log

id increments
timestamps timestamps
softDeletes softDeletes
equipment_id integer
project_id integer
task string
performer string
note text
date datetime

incident_type

id increments
timestamps timestamps
softDeletes softDeletes
name string

accident_equipment

id increments
timestamps timestamps
softDeletes softDeletes
equipment_id integer
incident_id integer

general_activity

id increments
timestamps timestamps
softDeletes softDeletes
name string

injury_type

id increments
timestamps timestamps
softDeletes softDeletes
name string

voc

id increments
timestamps timestamps
softDeletes softDeletes
engineer_id integer
project_id integer
note text
date datetime

ptw

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
project_id integer
ptw_type_id integer
time string
ptw_location string
company string
note text

ptw_type

id increments
timestamps timestamps
softDeletes softDeletes
name string

statistic

id increments
timestamps timestamps
softDeletes softDeletes
project_id integer
man_power integer
man_hour integer
date datetime

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