flotta - Laravel Schema Designer

users

id increments
timestamps timestamps
name string
email string
password string

cars

id increments
timestamps timestamps
engine_type ^FK bigInteger
car_type_id ^FK bigInteger
car_status_id ^FK bigInteger
station_id ^FK bigInteger
licence_plate string (10)
manufacturer string (40)
model string (40)
engine_capacity smallInteger
service_start date
certificate_valid date
VIN string (40)
mileage mediumInteger
service_distance mediumInteger

user_cars

id increments
timestamps timestamps
car_id ^FK bigInteger
user_id ^FK bigInteger
active tinyInteger
assign_start datetime
assign_end datetime
distance_limit integer

engine_types

id increments
timestamps timestamps
name enum

accidents

id increments
timestamps timestamps
car_id ^FK bigInteger
time datetime
descrtiption text
responsible string
injured tinyInteger

documents

id increments
timestamps timestamps
file string

accident_documents

id increments
timestamps timestamps
accident_id ^FK bigInteger
document_id ^FK bigInteger

handovers

id increments
timestamps timestamps

services

id increments
timestamps timestamps

service_events

id increments
timestamps timestamps

handover_documents

id increments
timestamps timestamps

car_types

id increments
timestamps timestamps
name enum

service_event_documents

id increments
timestamps timestamps

station

id increments
timestamps timestamps

car_status

id increments
timestamps timestamps
name string

tankings

id increments
timestamps timestamps
car_id ^FK bigInteger
date datetime
milage mediumInteger
price mediumInteger
product string
quantity decimal
unit_price decimal

contract

id increments
timestamps timestamps
company string
monthly_fee mediumInteger
car_id ^FK bigInteger
contract_start date
contract_end date

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