operator_operator - Laravel Schema Designer

users

id increments
role_id smallInteger
first_name string (255)
last_name string (255)
email string (320)
timezone tinyInteger
last_activity datetime
mobile_number string (50)
password char (60)
notification_badge tinyInteger
organisation_id smallInteger
profile_image string (255)
profile_image_thumb string (255)
remember_token string (255)
softDeletes softDeletes
timestamps timestamps

organisation

id smallInteger
name string (255)
parent string (255)
manager_id smallInteger
timestamps timestamps

role_permissions

role_id tinyInteger
permission_1 tinyInteger
permission_2 tinyInteger
permission_3 tinyInteger
permission_4 tinyInteger
permission_5 tinyInteger
permission_6 tinyInteger
timestamps timestamps

roles

id increments
name string (190)

vehicles

id increments
type_id smallInteger
license_plate string (190)
maker string (255)
year smallInteger
model string (255)
capacity string (255)
current_mileage integer
profile_image string (255)
profile_image_thumb string (255)
tow_registration string (255)
euro_ispuh string (255)
creator_id smallInteger
broj_komora mediumInteger
obujam_spremnika mediumInteger
gornje_punjenje string (255)
donje_punjenje string (255)
pump tinyInteger
tanko_crijevo smallInteger
pistol tinyInteger
preci_turbo tinyInteger
mjerni_sustav string (255)
softDeletes softDeletes
created_date date

vehicle_type

id increments
name string (255)

work_orders

id increments
user_id integer
work_order_id integer
start_date datetime
end_date datetime
start_location string (255)
end_location string (255)
vehicle_id smallInteger
fuel_id smallInteger
mileage smallInteger
quantity smallInteger
unit_price float (8,2)
total_price float (8,2)
multi_route smallInteger
pump_use tinyInteger
pump_price float (8,2)
island_id smallInteger
toll_cost smallInteger
toll_discounted smallInteger
location_tracker_id smallInteger
escort smallInteger
softDeletes softDeletes
timestamps timestamps
uploaded_location_id smallInteger
supplier_id integer

fuels

id increments
name string (255)
unit_price float (8,2)
price_expiration date

location_tracker

id increments
work_order_id integer
user_id mediumInteger
latitude decimal (10,8)
longitude decimal (11,8)
gps_paused datetime
gps_lost datetime
softDeletes softDeletes
timestamps timestamps

driver

id increments
father_name string (255)
mother_name string (255)
birth_date string (255)
birth_place string (255)
birth_district string (255)
birth_state string (255)
citizenship string (255)
oib string (255)
position string (255)
degree string (255)
entered_date datetime
driver_id integer
entered_name string (255)
other_qualifications string (255)
account string (255)
timestamps timestamps
softDeletes softDeletes

suppliers

id increments
name string (255)
timestamps timestamps

forms

id increments
name string (255)
form_type string (255)
parent mediumInteger
child mediumInteger
form_group string (255)
duration smallInteger
timestamps timestamps

form_location

id increments
form_id smallInteger
user_id smallInteger
vehicle_id smallInteger
checkbox tinyInteger
file_name string (255)
file_thumbnail string (255)
file_type string (255)
expiration_date date
notes string (255)
timestamps timestamps
deleted_at timestamp

work_orders_ann

id increments
start_date datetime
creator_id smallInteger
work_order_id integer
vehicle_id smallInteger
fuel_id smallInteger
quantity smallInteger
user_id smallInteger
customer string (255)
annotation string (255)
annotation_internal string (255)
location_city string (255)
location_street string (255)
annotation_traffic string (255)
timestamps timestamps
softDeletes softDeletes
supplier_id smallInteger
uploaded_location_id mediumInteger

notifications

id char (36)
type string (191)
notifiable_id integer
notifiable_type string (191)
data text
read_at timestamp
timestamps timestamps
softDeletes softDeletes

form_history_track_template

id increments
user_id smallInteger
form_location_id smallInteger
form_date date
method string (255)
driving_ban string (255)
mitigated_date date
creator_id smallInteger
history_track_added_date date
notes string (255)
softDeletes softDeletes
timestamps timestamps

vehicle_monthly

id increments
vehicle_id tinyInteger
location_city string (255)
inspected_date datetime
driver_id smallInteger
inspected_inspector tinyInteger
quantity string (255)
document_prometna tinyInteger
document_adr_vehicle tinyInteger
document_adr_driver tinyInteger
document_workorder tinyInteger
document_osobna tinyInteger
document_prijevozopasnih tinyInteger
document_prijevozopasnih_isprava tinyInteger
document_prijevozopasnih_ostalo tinyInteger
document_upute tinyInteger
document_propisana tinyInteger
vehicle_vlasnik tinyInteger
vehicle_masa_praznog tinyInteger
vehicle_masa_najveca tinyInteger
vehicle_kotaci tinyInteger
vehicle_armaturni_uredan tinyInteger
vehicle_armaturni_mehanicka tinyInteger
vehicle_armaturni_odvodi tinyInteger
vehicle_armaturni_propusti tinyInteger
vehicle_akumulator tinyInteger
vehicle_cisterna_nepropusno tinyInteger
vehicle_cisterna_opasna tinyInteger
vehicle_cisterna_spremna tinyInteger
vehicle_crijeva_neostecena tinyInteger
vehicle_crijeva_kape tinyInteger
vehicle_crijeva_spojevi tinyInteger
vehicle_elektrika_kabeli tinyInteger
vehicle_elektrika_uredjaji tinyInteger
vehicle_spremnici_zatvoreni tinyInteger
vehicle_spremnici_tekucina tinyInteger
vehicle_spremnici_odvod tinyInteger
vehicle_rukohvati tinyInteger
vehicle_stupanj tinyInteger
vehicle_vatra_mrezica tinyInteger
vehicle_vatra_poklopac tinyInteger
vehicle_vatra_vod tinyInteger
vehicle_zastitna_potpuna tinyInteger
vehicle_zastitna_podmetac tinyInteger
vehicle_zastitna_samostojeci tinyInteger
vehicle_zastitna_ozs tinyInteger
vehicle_zastitna_svjetiljka tinyInteger
vehicle_zastitna_dodatno tinyInteger
vehicle_protupozarni tinyInteger
vehicle_maska tinyInteger
vehicle_trokut tinyInteger
vehicle_prvapomoc tinyInteger
vehicle_pex tinyInteger
vehicle_uzemljenje tinyInteger
vehicle_narancaste_ispravne tinyInteger
vehicle_narancaste_unbroj tinyInteger
vehicle_narancaste_listici tinyInteger
vehicle_narancaste_pakovanje_natpisi tinyInteger
vehicle_narancaste_pakovanje_listici tinyInteger
vehicle_zavrsno_pakovanja tinyInteger
vehicle_zavrsno_pakovanja_broj tinyInteger
vehicle_zavrsno_male_kolicine tinyInteger
vehicle_zavrsno_vidljiva tinyInteger
vehicle_zavrsno_teret tinyInteger
vehicle_notes string (255)
current_mileage integer
timestamps timestamps
softDeletes softDeletes

vehicle_daily

id increments
location_city string (255)
inspected_date datetime
vehicle_id smallInteger
driver_id smallInteger
inspected_inspector tinyInteger
quantity string (255)
documents tinyInteger
tires tinyInteger
visual tinyInteger
safety_gear tinyInteger
protupozarni tinyInteger
safety_light tinyInteger
first_aid tinyInteger
pex tinyInteger
notes string (255)
current_mileage integer
timestamps timestamps
softDeletes softDeletes

vehicle_check_files

id increments
table string (255)
vehicle_table_id smallInteger
column_name string
notes string (255)
file_name string (255)
file_thumbnail string (255)
file_type string (255)
timestamps timestamps
softDeletes softDeletes

documents

id increments
name string (255)
created_by smallInteger
type string (255)
value string (255)
expiration_date date
location_id smallInteger
child smallInteger
parent smallInteger
group string (255)
role string
timestamps timestamps
softDeletes softDeletes

islands

id increments
name string
unit_price float (8,2)
price_expiration date

document_type

id increments
input_type string (255)
timestamps timestamps

document_location

id increments
document_id smallInteger
file_name string (255)
file_thumbnail string (255)
file_type string (255)
expiration_date date
timestamps timestamps
deleted_at timestamp

timesheet

id increments
user_id smallInteger
timesheet_entered datetime
timesheet_startTime datetime
timesheet_endTime datetime
type smallInteger
timesheet_approved datetime
timesheet_approver smallInteger
notes string (255)
timestamps timestamps
softDeletes softDeletes

timesheet_type

id increments
name string (255)

maintenance

id increments
type_id smallInteger
vehicle_id smallInteger
maintenance_date date
maintenance_company string (255)
maintenance_cost string (255)
current_mileage integer
expected_date date
notes string (255)
group_id integer
expected_mileage integer
softDeletes softDeletes
timestamps timestamps

maintenance_type

id increments
name string (255)
expected_again integer
timestamps timestamps
softDeletes softDeletes

uploaded_location

id increments
object_table string (255)
object_id smallInteger
file_name string (255)
file_thumbnail string (255)
file_type string (255)
expiration_date date
notes string (255)
checkbox tinyInteger
timestamps timestamps
softDeletes softDeletes

fuel_consumption

id increments
creator_id smallInteger
driver_id smallInteger
vehicle_id smallInteger
entered_date date
current_mileage integer
quantity integer
total_price float (8,2)
timestamps timestamps
consumption float (8,2)
softDeletes softDeletes