tudite - Laravel Schema Designer

flight_bookings

id bigIncrements
timestamps timestamps
trip_id ^FK bigInteger
start_at date
end_at date
is_confirmed boolean
flight_id ^FK bigInteger

countries

id bigIncrements
iso2 string
iso3 string
cctld string
name string
dial_code string
currency string
ioc string
languages string
status string
continent_id ^FK bigInteger
timestamps timestamps

user_countries

id bigIncrements
timestamps timestamps
user_id ^FK bigInteger
type enum
country_id ^FK bigInteger

users

id bigIncrements
timestamps timestamps
email string
phone string
isd_code string
city_id ^FK bigInteger

documents

id bigIncrements
timestamps timestamps
notes text
name string
user_id ^FK bigInteger
document_type_id ^FK bigInteger

action_points

id bigIncrements
points bigInteger
timestamps timestamps

user_actions

id bigIncrements
timestamps timestamps
user_id ^FK bigInteger
action_id ^FK bigInteger
points integer

actions

id bigIncrements
timestamps timestamps
name string
points integer

continents

id bigIncrements
name string
iso2 string
timestamps timestamps

regions

id bigIncrements
timestamps timestamps
name string

region_countries

id bigIncrements
timestamps timestamps
region_id ^FK bigInteger
country_id ^FK bigInteger

passports

id increments
timestamps timestamps
document_id ^FK bigInteger
passport_number string
issue_at date
expiry_at date
nationality_country_id ^FK bigInteger
given_name string
surname string
place_of_issue string

visa_results

id increments
timestamps timestamps
document_id ^FK bigInteger
visa_number string
name string
birth_at date
issue_at date
expiry_at date
entries string

visas

id increments
timestamps timestamps
short_description string
country_id ^FK bigInteger
purpose_id ^FK bigInteger
detailed_description text
success_rate integer
order integer
is_evisa boolean
is_flight_mandatory boolean
is_insurance_mandatory boolean

trips

id bigIncrements
timestamps timestamps
purpose_id ^FK bigInteger

purposes

id increments
timestamps timestamps
name string

flights

id bigIncrements
iata string
icao string
to_airport_id ^FK integer
from_airport_id ^FK integer
airline_id ^FK integer
timestamps timestamps

airports

id bigIncrements
name string
iata string
icao string
latitude decimal (10,7)
longitude decimal (10,7)
city_id integer
country_id ^FK bigInteger
timestamps timestamps

airlines

id bigIncrements
name string
iata string
icao string
alias string
callsign string
country string
status string
timestamps timestamps

document_types

id increments
timestamps timestamps
name string

id increments
timestamps timestamps
soft_deletes softDeletes
name string

share_documents

id increments
timestamps timestamps
softDeletes softDeletes
document_id ^FK bigInteger
share_id ^FK bigInteger

offers

id increments
timestamps timestamps
s3_object_id string
background_color string
title string
subtitle string
details text
link string
redeem_details text
tncs text
expiry_at datetime

brands

id increments
timestamps timestamps
name string
about string
logo_url string

user_offers

id increments
timestamps timestamps
user_id ^FK bigInteger
offer_id ^FK bigInteger
offer_code string

wants

id increments
timestamps timestamps

user_wants

id increments
timestamps timestamps
is_upvoted boolean
user_id ^FK bigInteger
want_id ^FK bigInteger

trip_countries

id increments
timestamps timestamps
trip_id ^FK bigInteger
country_id ^FK bigInteger

flight_schedules

id increments
timestamps timestamps
departure_at datetime
arrival_at datetime
status string
departure_terminal string
arrival_terminal string
flight_id ^FK bigInteger

leads

id increments
timestamps timestamps
trip_id ^FK bigInteger
lead_type_id ^FK bigInteger

lead_types

id increments
timestamps timestamps
name string

share_logs

id increments
timestamps timestamps
share_user_id ^FK bigInteger
ip_address string
user_agent string

share_users

id increments
timestamps timestamps
share_id ^FK bigInteger
user_id ^FK bigInteger
emails string

roles

id increments
timestamps timestamps
name string

user_roles

id increments
timestamps timestamps
user string
user_id ^FK bigInteger
role_id ^FK bigInteger

offer_options

id increments
timestamps timestamps
name string
offer_id ^FK bigInteger

trip_users

id increments
is_confirmed boolean
user_id ^FK bigInteger
trip_id ^FK bigInteger
timestamps timestamps

cities

id increments
timestamps timestamps
name string
accent_city string
population float
latitude string
longitude string
country_id ^FK bigInteger

document_pages

id increments
timestamps timestamps
s3_object_id string
order smallInteger
document_id ^FK bigInteger

user_preferences

id increments
timestamps timestamps
user_id ^FK bigInteger
preference_id ^FK bigInteger
value string

preferences

id increments
timestamps timestamps
name string