Home
Stats Tracking
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (1)
stats_flight
flight_id
bigIncrements
account_id
integer
callsign
string
(10)
pos_lat
decimal
(12,8)
pos_lon
decimal
(12,8)
altitude
smallInteger
speed
smallInteger
connected_at
timestamp
departed_at
timestamp
arrived_at
timestamp
disconnected_at
timestamp
timestamps
timestamps
softDeletes
softDeletes
stats_flight_route
flight_route_id
increments
flight_id
bigInteger
departure
string
(4)
route_raw
text
route_clean
text
route_md5
string
(32)
arrival
string
(4)
alternative
string
(4)
flight_level
smallInteger
speed
smallInteger
timestamps
timestamps
softDeletes
softDeletes
stats_flight_route_waypoint
flight_route_waypoint_id
increments
flight_route_id
bigInteger
navaid_id
integer
sort_order
smallInteger
stats_flight_posrep
flight_posrep_id
increments
flight_id
bigInteger
pos_lat
decimal
(12,8)
pos_lon
decimal
(12,8)
altitude
smallInteger
speed
smallInteger
timestamps
timestamps
softDeletes
softDeletes
stats_atc
atc_id
increments
account_id
integer
position_id
integer
connected_at
timestamp
disconnected_at
timestamp
timestamps
timestamps
ais_facility_position
position_id
increments
facility_id
integer
callsign
string
(10)
callsign_relief
string
(10)
frequency
decimal
(6,3)
logon_order
smallInteger
timestamps
timestamps
softDeletes
softDeletes
mship_account
account_id
increments
ais_facility
facility_id
increments
airport_id
integer
name
string
(45)
type
smallInteger
timestamps
timestamps
ais_airport
airport_id
increments
icao
string
(4)
iata
string
(3)
name
string
(125)
region_id
integer
type
smallInteger
elevation
smallInteger
longitude
decimal
(12,8)
latitude
decimal
(12,8)
timestamps
timestamps
i18n_region
region_id
increments
country_id
integer
code
string
(5)
name
string
(100)
i18n_country
country_id
increments
continent_id
integer
code
string
(2)
name
string
(50)
i18n_continent
continent_id
increments
code
string
(2)
name
string
(80)
ais_airport_runway
id
increments
airport_id
integer
recipricol_id
integer
identifier
string
(3)
course
smallInteger
elevation
smallInteger
longitude
decimal
(12,8)
latitude
decimal
(12,8)
ils
boolean
ils_course
smallInteger
ils_freq
decimal
(6,3)
ils_glidepath
smallInteger
timestamps
timestamps
softDeletes
softDeletes
×
Comments for Stats Tracking
alawrence66 . 27 August 2015
Process for storing data:
Get all active flights as a collection
Check all collections for callsign of aircraft - once found, remove.
After, anything in collection not used set deleted_at
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01