Stats Tracking - Laravel Schema Designer

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

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