airline-manager - Laravel Schema Designer

airlines

id increments
timestamps timestamps
name string (50)
funds integer
ceo string (100)
iata_code string (4)
headquarters_airport_id ^FK integer

airports

id increments
iata_code string (4)
name string
country string (3)
slots_per_hour smallInteger
runway_length smallInteger
night_operations boolean
lat float (10,8)
lng float (10,8)

airplane_models

id increments
name string (60)
shortname string (4)
seats_capacity smallInteger
cargo_capacity integer
range smallInteger
speed smallInteger
fuel_usage float
price integer
cabin_crew tinyInteger
min_runway_length smallInteger
manufacturer string (25)
introduction_year smallInteger

airplanes

id increments
timestamps timestamps
airplane_model_id ^FK integer
airline_id ^FK integer
base_airport_id ^FK integer
built date
registration string (8)
last_maintenance_service datetime

flights

id increments
timestamps timestamps
airline_id ^FK integer
airplane_id ^FK integer
origin_airport_id ^FK integer
destination_airport_id ^FK integer
distance smallInteger
departure_time datetime
arrival_time datetime
delay smallInteger
flight_number string (6)
has_arrived boolean
passengers_economy smallInteger
passengers_business smallInteger
passengers_firstclass smallInteger
cargo integer

slots

id increments
timestamps timestamps

timetables

id increments

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