truckandtrace - Laravel Schema Designer

shipment_request

id increments
timestamps timestamps
client_accepted boolean
driver_accepted boolean
status enum
price decimal
client_id ^FK integer
driver_id ^FK integer
freight_id ^FK integer
capacity string (255)
request_text text
pickup_address string (255)
pickup_address_no string (255)
pickup_postcode string (255)
pickup_city string (255)
pickup_region string (255)
telephone string (255)
response_text text

shipment

id increments
timestamps timestamps
shipmentrequest_id ^FK integer
tracking_number string (255)
route_id ^FK integer
status enum
pickup_time timestamp
delivery_time timestamp

route

id increments
timestamps timestamps
departure_place string (255)
arrival_place string (255)
departure_time timestamp
arrival_fulladdress string (255)
arrival_time timestamp
freight_id ^FK integer
driver_id ^FK integer
departure_street string (255)
departure_street_no string (255)
departure_city string (255)
departure_postcode string (255)
departure_region string (255)
arrival_city string (255)
arrival_street string (255)
arrival_street_no string (255)
arrival_postcode string (255)
arrival_region string (255)
max_load string (255)
load string (255)

freight

id increments
timestamps timestamps
freight_type string (255)
max_load string (255)
current_load string (255)
current_capacity string (255)
max_capacity string (255)

client

id increments
timestamps timestamps
firstname string (255)
lastname string (255)
address string (255)
address_no string (255)
city string (255)
postcode string (255)
region string (255)
country string (255)
telephone string (255)
vat string (255)

driver

id increments
timestamps timestamps
firstname string (255)
lastname string (255)
address string (255)
address_no string (25)
city string (255)
postcode string (255)
region string (255)
country string (255)
telephone string (255)
license text
status string (255)
vat string (25)

fleet

id increments
timestamps timestamps
plate string (255)
seller_id ^FK integer
license text

shipmenttext

id increments
timestamps timestamps
shipment_request_id ^FK integer
text text
type enum

payment

id increments
timestamps timestamps
client_id ^FK integer
amount string (25)
status enum

rating

id increments
timestamps timestamps
driver_id ^FK integer
client_id ^FK integer
stars integer
comment text

freightcategories

id increments
timestamps timestamps
name string (255)
parent_id ^FK integer

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