Al Nkhel - Laravel Schema Designer

room_types

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

rooms

timestamps timestamps
id increments
softDeletes softDeletes
room_type_id integer
all_rooms integer
available_rooms integer
booked_rooms integer
travel_id integer

ages

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

countries

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
code string

airports

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
code string
country_id integer

travel_prices

id increments
timestamps timestamps
softDeletes softDeletes
age_id integer
room_id integer
price double
travel_id integer

travels

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
from_date datetime
to_date datetime
from_country_id integer
to_country_id integer
period_en string
period_ar string
best_offer enum
flight_instructions string
going_date datetime
going_from_city_id integer
going_to_city_id integer
going_flight_number string
going_aircraft_id integer
going_from_airport_id integer
going_to_airport_id integer
going_airplane_id integer
going_from_lounge string
going_to_lounge string
going_departure_time string
going_arrival_time string
coming_date datetime
coming_from_city_id integer
coming_to_city_id integer
coming_flight_number string
coming_aircraft_id integer
coming_airplane_id integer
coming_from_airport_id integer
coming_to_airport_id integer
coming_from_lounge string
coming_to_lounge string
coming_departure_time string
coming_arrival_time string
electric_port enum
display enum
class_id integer
lock boolean
adult_id integer
adult_number integer
children_id integer
children_number integer
baby_id integer
baby_number integer
room_type_id integer

commissions

id increments
timestamps timestamps
softDeletes softDeletes
category_id integer
item_id integer
value double
type enum
user_id integer

user

id increments
timestamps timestamps
softDeletes softDeletes

programs

id increments
timestamps timestamps
softDeletes softDeletes
title_en string
title_ar string
details_en longText
details_ar longText
travel_id integer

cities

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
country_id integer

flights

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
flight_type_id integer
electric_port enum
display enum
best_offer enum
stop_ability enum
cancel_before_departure enum
cancel_before_departure_price double
cancel_after_departure enum
cancel_after_departure_price double
absence enum
absence_price double
change_after_departure enum
change_after_departure_price double
change_before_departure enum
change_before_departure_price double
going_date datetime
going_flight_number string
going_aircraft_id integer
going_from_city_id integer
going_to_city_id integer
going_airplane_id integer
going_from_airport_id integer
going_to_airport_id integer
going_from_lounge string
going_to_lounge string
going_departure_time string
going_arrival_time string
coming_date datetime
coming_from_city_id integer
coming_to_city_id integer
coming_aircraft_id integer
coming_flight_number string
coming_airplane_id integer
coming_from_airport_id integer
coming_to_airport_id integer
coming_from_lounge string
coming_to_lounge string
coming_departure_time string
coming_arrival_time string
from_country_id integer
to_country_id integer
economy_seats integer
business_seats integer
pay_later enum
pay_duration string
flight_instructions string
lock boolean
adult_id integer
adult_number integer
children_id integer
children_number integer
baby_id integer
baby_number integer

flight_types

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

class_types

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

categories

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

weights

id increments
timestamps timestamps
softDeletes softDeletes
category_id integer
item_id integer
class_type_id integer
weight double

aircrafts

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

airplane_types

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

pricing_classes

id increments
timestamps timestamps
softDeletes softDeletes
name string

flight_seats

id increments
timestamps timestamps
softDeletes softDeletes
class_id integer
price_class_id integer
seats integer
available_seats integer
booked_seats integer
flight_id integer

flight_prices

id increments
timestamps timestamps
softDeletes softDeletes
seat_id integer
flight_type_id integer
age_id integer
price double
duration_id integer
flight_id integer

durations

id increments
timestamps timestamps
softDeletes softDeletes
months integer

charters

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
flight_type_id integer
electric_port enum
display enum
best_offer enum
stop_ability enum
flight_instructions string
pay_later enum
pay_duration string
void enum
void_duration string
client_can_cancel enum
cancel_fees double
from_country_id integer
to_country_id integer
going_date datetime
giong_flight_number string
going_aircraft_id integer
going_from_city_id integer
going_to_city_id integer
going_from_airport_id integer
going_to_airport_id integer
going_airplane_id integer
going_from_lounge string
going_to_lounge string
going_departure_time string
going_arrival_time string
coming_date datetime
coming_flight_number string
coming_aircraft_id integer
coming_from_city_id integer
coming_to_city_id integer
coming_from_airport_id integer
coming_to_airport_id integer
coming_airplane_id integer
coming_from_lounge string
coming_to_lounge string
coming_departure_time string
coming_arrival_time string
economy_seats integer
business_seats integer
lock boolean
adult_id integer
adult_number integer
children_id integer
children_number integer
baby_id integer
baby_number integer

charter_seats

id increments
timestamps timestamps
softDeletes softDeletes
charter_id integer
name string
class_id integer
price_class_id integer
saets integer
available_seats integer
booked_seats integer

charter_prices

id increments
timestamps timestamps
softDeletes softDeletes
charter_id integer
seat_id integer
flight_type_id integer
age_id integer
price double
duration_id integer

flights_classes

id increments
timestamps timestamps
softDeletes softDeletes
flight_id integer
class_id integer

charters_classes

id increments
timestamps timestamps
softDeletes softDeletes
charter_id integer
class_id integer

visas

id increments
softDeletes softDeletes
name_en string
name_ar string
type enum
price double
papers_en string
papers_ar string
best_offer enum
description_en string
description_ar string
timestamps timestamps
country_id integer
lock boolean

passengers

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
first_name string
last_name string
title enum
status enum
price double
ticket string
ticket_number string
birth_date datetime
birth_place string
nationality_id integer
passport_number string
passport_issuance_date datetime
passport_expire_date datetime
father_name string
mother_name string
age_id integer

orders

id increments
timestamps timestamps
softDeletes softDeletes
category_id integer
item_id integer
status enum
user_id integer
phone string
pnr string
total_price double
commission double
subtotal double
note string

reserved_seats

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
seat_id integer
charter_id integer
class_id integer
price_class_id integer
seats_number integer
total_price string

messages

id increments
timestamps timestamps
softDeletes softDeletes
title string
content string
from_user_id integer
to_user_id integer

news

id increments
timestamps timestamps
softDeletes softDeletes
content_en string
content_ar string

pages

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
title_en string
title_ar string
content_en string
content_ar string

transactions

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
category_id integer
item_id integer
order_id integer
type enum
direction enum
balance_before double
amount double
balance_after double
comment string

invoices

id increments
timestamps timestamps
softDeletes softDeletes
user_id integer
from_date datetime
to_date datetime

order_travels

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
travel_id integer
room_type_id integer
room_id integer
travel_price_id integer

order_flights

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
going_flight_id integer
coming_flight_id integer
class_id integer
price_class_id integer
flight_seat_id string
flight_price_id integer
flight_type_id integer
flight_count integer

order_charters

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
going_charter_id integer
coming_charter_id integer
class_id integer
price_class_id integer
charter_seat_id integer
charter_price_id integer
flight_type_id integer
flight_count integer

order_visas

id increments
timestamps timestamps
softDeletes softDeletes
order_id integer
visa_id integer
number integer