baabood_demo - Laravel Schema Designer

users

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

vessels

id increments
vessel_number string (255)
width integer
length mediumText
speed integer
image string (255)
max_weight integer
max_capacity integer
max_passengers integer
vessel_model_id ^FK integer
vessel_type enum
grouping enum
created_by ^FK integer
timestamps timestamps
deleted_at timestamp

vessel_models

id increments
active boolean
timestamps timestamps

cabin_types

id increments
beds_number integer
active boolean
timestamps timestamps

vessel_cabins_counts

id increments
cabin_type_id ^FK integer
cabins_count integer
seat_class_id ^FK integer
vessel_id ^FK integer
timestamps timestamps

seat_classes

id increments
active boolean
timestamps timestamps

liens

id increments
height integer
width integer
vessel_id ^FK integer
timestamps timestamps

routes

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

ports

id increments
active boolean
code string (255)
country_id ^FK integer
lat string (255)
lng string (255)
timestamps timestamps

trips

id increments
route_id ^FK integer
vessel_id ^FK integer
departure datetime
trip_number string (255)
estimated_time decimal (8,2)
timestamps timestamps

ticket_availabilities

id increments
trip_id ^FK integer
seat_class_id ^FK integer
ticket_class_id ^FK integer
cabin_type_id ^FK integer
pax integer
seat_from integer
seat_to integer
price_one_way decimal (8,2)
price_two_way decimal (8,2)
timestamps timestamps

ticket_classes

id increments
active boolean
type tinyInteger
direction tinyInteger
timestamps timestamps

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
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

vessels_trans

vessel_id ^FK bigInteger
lang_id integer
name string
description text

seat_classes_trans

seat_class_id ^FK bigInteger
lang_id tinyInteger
name string

cabin_types_trans

cabin_type_id ^FK bigInteger
lang_id tinyInteger
name string

ports_trans

port_id ^FK integer
lang_id tinyInteger
name string

vessel_models_trans

vessel_model_id ^FK integer
lang_id tinyInteger
name string (255)

ticket_classes_trans

ticket_class_id ^FK integer
lang_id tinyInteger
name string (255)

countries_trans

country_id ^FK integer
lang_id tinyInteger
name string (255)

currencies

id increments
timestamps timestamps

currencies_trans

currency_id ^FK integer
lang_id tinyInteger
name string (255)

ticket_policies

ticket_class_id ^FK integer
configuration tinyInteger
days smallInteger
deduction smallInteger