baabood - Laravel Schema Designer

users

id increments
name string (255)
email string (255)
password string (255)
rememberToken rememberToken
timestamps timestamps

vessels

id increments
name string (255)
desc text
vessel_number string (255)
width integer
created_by ^FK integer
vessel_model ^FK integer
length mediumText
speed integer
image string (255)
vessel_type enum
grouping enum
max_passengers integer
default_route integer
timestamps timestamps

vessel_models

id increments
name string (255)
timestamps timestamps

cabin_types

id increments
name string (255)
beds_number integer
timestamps timestamps

vessel_cabins_counts

id increments
cabin_type_id ^FK integer
vessel_beds_count integer
seat_calss ^FK integer
timestamps timestamps
vessel_id ^FK integer

seat_calsses

id increments
name string (255)
timestamps timestamps

liens

id increments
name string (255)
height integer
width integer
vessel_id ^FK integer
max_weight integer
max_capacity integer
timestamps timestamps

routes

id increments
from ^FK integer
to ^FK integer
distination integer
timestamps timestamps

ports

id increments
name string
timestamps timestamps

trips

id increments
route_id integer
vessel_id integer
departure datetime
trip_number string (255)
timestamps timestamps

tickets

id increments
seat_calss ^FK integer
ticket_class ^FK integer
pax integer
share_type enum
seat_from integer
seat_to integer
price float
trip_id ^FK integer
timestamps timestamps

tickets_classes

id increments
name string (255)

clients

id increments
name string (255)
country_id ^FK integer
mobile string (255)
license_number string
iata string (255)
address string (255)
current_balance float
username string (255)
password string (255)
logo string (255)
timestamps timestamps

countries

id increments
name string
timestamps timestamps

transactions

id increments
client_id ^FK integer
action_type enum
amount float
new_balance float
created_by integer
timestamps timestamps

vessel_routes

id increments
route_id ^FK integer
vessel_id ^FK integer

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