Home
tudite
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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
shares
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
×
Comments for tudite
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01