worldtruck - Laravel Schema Designer

generators

id increments
name string (100)
nit string (20)
email string (70)
address string (200)
timestamps timestamps
phone string (20)
contact_person string (60)

transporters

id increments
name string (70)
address string (100)
phone string
contact string (70)
truck_id ^FK integer
timestamps timestamps

generator_transporters

id increments
generator_id integer
transporter_id integer
timestamps timestamps

parking_zones

id increments
name string (70)
address string (70)
latitude string (20)
longitude string (20)
perimeter integer
timestamps timestamps
city_id ^FK integer

generator_parkings

id increments
generator_id integer
parking_id integer
timestamps timestamps
softDeletes softDeletes

charges

id increments
content string (70)
dispatch_parking_id ^FK integer
delivery_parking_id ^FK integer
quantity float (10,2)
reference_cost_id ^FK integer
generator_id ^FK integer
charge_type_id ^FK integer
timestamps timestamps
softDeletes softDeletes

trucks

id increments
mark string (70)
model string (20)
plate string (10)
capacity float
year string (4)
transporter_id ^FK integer
axe_id ^FK integer
truck_uses_id ^FK integer
state_id ^FK integer
truck_structure_id ^FK integer
image string (100)
timestamps timestamps
softDeletes softDeletes

charge_trucks

id increments
timestamps timestamps
softDeletes softDeletes

transporter_trucks

id increments
timestamps timestamps
softDeletes softDeletes

truck_uses

id increments
name string (70)
timestamps timestamps
softDeletes softDeletes

axes

id increments
axe integer
timestamps timestamps
softDeletes softDeletes

drivers

id increments
name string (20)
last string (20)
dni string (20)
phone string (20)
birthday date
timestamps timestamps
softDeletes softDeletes

ratings

id increments
star integer
comments text
driver_id ^FK integer
truck_id ^FK integer
timestamps timestamps
softDeletes softDeletes

fare

id increments
timestamps timestamps
softDeletes softDeletes

payments

id increments
timestamps timestamps
softDeletes softDeletes

state_trucks

id increments
timestamps timestamps
softDeletes softDeletes

states

id increments
state string (70)
truck_id ^FK integer
timestamps timestamps
softDeletes softDeletes

images

id increments
name string (70)
path string (70)
timestamps timestamps
softDeletes softDeletes

truck_structures

id increments
name string (50)
cubicaje string (50)
weight_load float
timestamps timestamps
softDeletes softDeletes
description text

charge_types

id increments
name string (200)
code string (15)
timestamps timestamps
softDeletes softDeletes
description text

ride_truck

id increments
timestamps timestamps
softDeletes softDeletes

offers

id increments
generador_id ^FK integer
charge_id ^FK integer
dispatch_parking_id ^FK integer
delivery_parking_id ^FK integer
deadline_to_bid date
reference_cost_id ^FK integer
transporter_id ^FK integer
selected_transporter_id integer
timestamps timestamps
softDeletes softDeletes

cities

id increments
name string (100)
code string (15)
timestamps timestamps
softDeletes softDeletes

reference_costs

id increments
city_origin_id ^FK integer
destination_city_id string
reference_costs decimal
year string (4)
timestamps timestamps
softDeletes softDeletes

offer_transporter

id increments
transporter_id ^FK integer
offer_id ^FK integer
date datetime
value decimal
assigned boolean
timestamps timestamps
softDeletes softDeletes

quotation

id increments
timestamps timestamps
transporter_id integer
generador_id integer
offer_id integer
quotation_value decimal
validity date
description longText