scada analytics - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string (255)
gender string (1)
email string (100)
password string (100)
shift_id ^FK integer
status string (1)
type string (3)

user_attendance

id increments
timestamps timestamps
user_id ^FK integer
date timestamp
first_in_time timestamp
last_out_time timestamp
softDeletes softDeletes

process_area

id increments
timestamps timestamps
name string (100)
softDeletes softDeletes

equipments

id increments
timestamps timestamps
tag string (100)
name string (255)
process_area_id ^FK integer
parent_id ^FK integer
softDeletes softDeletes
make string (40)
model string (40)

equipment_issues

id increments
timestamps timestamps
softDeletes softDeletes
equipment_id ^FK integer
description text

maintenance_schedules

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
frequency string (100)
run_at string (50)
equipment_id ^FK integer
description string (500)

vendors

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
address text
contact string (20)

inventory

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
available_qty integer
min_qty integer
category string (1)
price float
uom string (100)
is_reusable string (1)
equipment_id ^FK integer

weigh_bridge_entries

id increments
timestamps timestamps
softDeletes softDeletes
date timestamp
gross_wt float
tare_wt float
net_wt float
item_name string (100)

op_params

id increments
timestamps timestamps
softDeletes softDeletes
equipments_id ^FK integer
name string (100)
data_type string (50)
is_editable string (1)
uom string (100)
key string (100)

op_data

id increments
timestamps timestamps
softDeletes softDeletes
equipments_id ^FK integer
op_param_id ^FK integer
value text

contracts

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
address string (255)
due_date timestamp
start_date timestamp
is_new string (1)
status string (10)
user_id ^FK integer

bills

id increments
timestamps timestamps
softDeletes softDeletes
title string (100)
reason string (255)
date timestamp
price float
status string (1)
reciept text
user_id ^FK integer

maintenance_records

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)
is_sheduled string (1)
frequency string (100)
status string (10)
equipment_id ^FK integer
closed_on timestamp
reason_id ^FK integer
user_id ^FK integer
schedule_id ^FK integer
description text
run_at string (50)

maintenance_inventory

id increments
timestamps timestamps
softDeletes softDeletes
maintenance_id ^FK integer
inventory_id ^FK integer
requested_qty integer

leave_request

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
leave_start_date timestamp
leave_end_date timestamp
total_days integer
status string (10)
approved_by ^FK integer

leave_config

id increments
timestamps timestamps
softDeletes softDeletes
leave_range_start time
leave_range_end time

shifts

id increments
timestamps timestamps
softDeletes softDeletes
name string (50)
start_time time
end_time time

allocated_leave

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
allocated_leaves float
year integer

permissions

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)

roles

id increments
timestamps timestamps
softDeletes softDeletes
name string (100)

user_roles

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
role_id ^FK integer

role_permissions

id increments
timestamps timestamps
softDeletes softDeletes
role_id ^FK integer
permission_id ^FK integer

equipment_documents

id increments
timestamps timestamps
softDeletes softDeletes
equipment_id ^FK integer
file text

inventory_vendors

id increments
timestamps timestamps
softDeletes softDeletes
item_id ^FK integer
vendor_id ^FK integer

inventory_order_documents

id increments
timestamps timestamps
softDeletes softDeletes
order_id ^FK integer
file text

contract_documents

id increments
timestamps timestamps
softDeletes softDeletes
contract_id ^FK integer
file text

bill_documents

id increments
timestamps timestamps
softDeletes softDeletes
bill_id ^FK integer
file text

inventory_orders

id increments
timestamps timestamps
softDeletes softDeletes
order_qty integer
order_date date
vendor_id ^FK integer
item_id ^FK integer