Daop - Laravel Schema Designer

users

id bigIncrements
timestamps timestamps
softDeletes softDeletes
type enum
username string
password string
fullname string
email string
active enum
company_id ^FK bigInteger
first_name string
second_name string
third_name string
last_name string
id_number string
mobile string
driver_licence string
licence_expire_date date

fuels

id bigIncrements
timestamps timestamps
softDeletes softDeletes
fuel_91 string
fuel_95 string
diesel string
notes text

stations

id bigIncrements
timestamps timestamps
softDeletes softDeletes
name string
manager_id ^FK bigInteger

vehicles

id bigIncrements
timestamps timestamps
softDeletes softDeletes
company_id ^FK bigInteger
driver_id ^FK bigInteger
name string
auto_code string
barcode string
fuel_type enum
dashboard string
notes text
active enum

companies

id bigIncrements
timestamps timestamps
softDeletes softDeletes
manager_id ^FK bigInteger
name string
manager_name string
mobile string
another_mobile string
notes text
active enum

stations_pivot_table

id bigIncrements
timestamps timestamps
station_id ^FK bigInteger
relational_id bigInteger
relational_type string

supports

id bigIncrements
timestamps timestamps
softDeletes softDeletes
title string
type_id ^FK bigInteger
user_id ^FK bigInteger
attachment string

support_type

id bigIncrements
timestamps timestamps
softDeletes softDeletes
title json

support_threads

id bigIncrements
timestamps timestamps
softDeletes softDeletes
support_id ^FK bigInteger
sender_id ^FK bigInteger
receiver_id ^FK bigInteger
body text
attachment text

device_tokens

id bigIncrements
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
token string
status enum
language enum

otps

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
code string
valid enum

invoices

id bigIncrements
timestamps timestamps
softDeletes softDeletes
number string
company_id ^FK bigInteger
vehicle_id ^FK bigInteger
driver_id ^FK bigInteger
driver_number string
station_id ^FK bigInteger
fuel_type enum
letres integer
total_price string
employe_id ^FK bigInteger

notifications

id bigIncrements
timestamps timestamps
softDeletes softDeletes
user_id ^FK bigInteger
title json
body json

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