Home
truckandtrace
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (1)
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