AIS_Basic - Laravel Schema Designer

ais_airport

id increments
sector_id integer
icao string (4)
iata string (3)
name string (50)
latitude decimal (8,6)
longitude decimal (8,6)
display boolean
timestamps timestamps
softDeletes softDeletes

ais_facility

id increments
name string (60)
timestamps timestamps
softDeletes softDeletes

ais_facility_position

id increments
facility_id integer
callsign string (10)
frequency decimal (6,3)
logon_order smallInteger
timestamps timestamps
softDeletes softDeletes

ais_airport_to_facility

id increments
airport_id integer
facility_id integer
top_down_order smallInteger
timestamps timestamps

ais_fir

id increments
icao string (4)
name string (50)
timestamps timestamps
softDeletes softDeletes

ais_fir_sector

id increments
fir_id integer
name string (50)
callsign_default string (10)
callsign_rule string (100)
frequency decimal (6,3)
timestamps timestamps
covered_by integer
softDeletes softDeletes

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