Kazi_tour - Laravel Schema Designer

expedition

id increments
sender_id ^FK integer
receiver_id ^FK integer
reference string (50)
type_payment integer
type_expedition integer
status integer
cost float (200)
user_id ^FK integer
package_nbr integer
timestamps timestamps
code_agence string

client

id increments
timestamps timestamps
first_name string (50)
last_name string (50)
phone_number string (10)
address string (200)
id_state ^FK integer
id_town ^FK integer

package

id increments
id_expedition ^FK integer
id_package_type ^FK integer
weight float (200)
volume float
timestamps timestamps

package_tracking

id increments
id_sending_agency ^FK integer
id_reception_agency ^FK integer
curent_position string (100)
path_positions string (100)
timestamps timestamps

agency

id increments
timestamps timestamps
code_agency string (10)
nomination string (30)
phone_number string (30)
address string (100)
id_state ^FK integer
id_town ^FK integer

package_type

id increments
name string (100)
timestamps timestamps

state

id increments
timestamps timestamps
code string (10)
name string (100)

town

id increments
timestamps timestamps
code_postal string (10)
name string (100)
id_state ^FK integer

users

id increments
timestamps timestamps
first_name string
last_name string
login string
password string
phone_number string

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