LightGroup - Laravel Schema Designer

companies

id increments
timestamps timestamps
softDeletes softDeletes
address string (255)
name string (255)
phone integer
website string
logo string
start_date date
expected_end_date date
email string

service_stations

id increments
timestamps timestamps
softDeletes softDeletes
name string
description string
town_id ^FK integer
latitude string
longitude string
status boolean
back_image_link string
address string
gmt string

users

id increments
timestamps timestamps
softDeletes softDeletes
adress string
profil_image string
email string
first_name string
last_name string
password string
phone integer
status boolean
token string
is_confirm boolean
private_mail string
is_first_conn boolean

company_user_service_stations

id increments
timestamps timestamps
softDeletes softDeletes
service_station_id ^FK integer
user_id ^FK integer
company_id ^FK integer

towns

id increments
timestamps timestamps
softDeletes softDeletes
name string
region_id ^FK integer

product_station_tanks

id increments
timestamps timestamps
softDeletes softDeletes
product_id ^FK integer
service_station_id ^FK integer
pistolets integer

tanks

id increments
timestamps timestamps
softDeletes softDeletes
abacus string
diameter float
liquid_type string
file_path string
man_hole_height float
sensor_depth float
sensor_reference string
level_active_depotage float
product_station_tank_id ^FK integer
jauge_id ^FK integer

products

id increments
timestamps timestamps
softDeletes softDeletes
code string
name string
price float

depotages

id increments
timestamps timestamps
softDeletes softDeletes
end_at datetime
end_liquid_temperature float
end_height float
end_volume float
start_height float
start_liquid_temperature float
start_volume float
status string
take_at datetime
tank_id ^FK integer

quart_workings

id increments
timestamps timestamps
softDeletes softDeletes
time_start date
time_close date
service_station_id ^FK integer

jauges

id increments
timestamps timestamps
softDeletes softDeletes
name string
code string
price string

remaining_notification_parameters

id increments
timestamps timestamps
softDeletes softDeletes
scdp_delay_day float
critic_limit float
service_station_id ^FK integer

records

id increments
timestamps timestamps
softDeletes softDeletes
battery_level float
density double
depotage integer
env_temperature float
level double
liquid_height double
liquid_temperature float
sensor_reference string
tank_id ^FK integer
total_volume float
volume float
volume_at_fift float

correction_data

id increments
timestamps timestamps
softDeletes softDeletes
data_level string
data_temp string
data_pressure string
tank_id ^FK integer

raw_data

id increments
timestamps timestamps
softDeletes softDeletes
refKit string
level_drt float
level_mrc integer
temperature float
env_temperature float
current float
density float
date_time string
pressure float
depotage float
raw_data string
is_depotage boolean
current_value float
value_to_store float
f1 float
f2 float
dep integer

probe_sensors

id increments
timestamps timestamps
softDeletes softDeletes
sensor_ref string
density_up float
density_down float
temperature_down float
level_up float
level_down float
pressure_up float
pressure_down float
hourkit string
temperature_up float

notifications

id increments
timestamps timestamps
softDeletes softDeletes
battery float
liquid_height float
liquid_temperature float
percent float
remaining_day integer
tank_id ^FK integer
type_notification_id ^FK integer
volume float
company_user_service_station_id ^FK integer

type_notifications

id increments
timestamps timestamps
softDeletes softDeletes
wording string
code string

sensor_bases

id increments
timestamps timestamps
softDeletes softDeletes
eui string
reference string
in_maintenance boolean

user_loggings

id increments
timestamps timestamps
softDeletes softDeletes
token string
expiry_date string
user_id ^FK integer

regions

id increments
timestamps timestamps
softDeletes softDeletes
name string

configurations

id increments
timestamps timestamps
softDeletes softDeletes

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