test
Tables (18)
airport
- id — integer — Primary key — NOT NULL
- nm — varchar(255) — NOT NULL
- lat — double — NOT NULL
- lon — double — NOT NULL
- draw_yn — boolean
- icao — varchar(20)
airport_rwy
- id — integer
- start_latitude — double — NOT NULL — 활주로
- start_longitude — double — NOT NULL
- end_latitude — double — NOT NULL — 활주로
- end_longitude — double — NOT NULL
- airport_id — integer — NOT NULL
airspace
- id — integer
- nm — varchar(255) — NOT NULL
- ty — varchar(20) — NOT NULL
- shape — varchar(20) — NOT NULL
airspace_detail
- id — integer
- lat — double — NOT NULL
- lon — double — NOT NULL
- height — double
- extruded_height — double
- rad — double
- airspace_id — integer
branch
- id — integer
- nm — varchar(255) — NOT NULL
- icao — varchar(20) — NOT NULL
- lat — double — NOT NULL
- lon — double — NOT NULL
corridor
- id — integer
- width — double — NOT NULL
- height — double — NOT NULL
- extruded_height — double — NOT NULL
- speed_limit — double — NOT NULL
- nm — varchar(255) — NOT NULL
- shape_id — integer
- start_branch_id — integer
- end_branch_id — integer
- start_vp_id — integer
- end_vp_id — integer
corridor_point
- seq — integer — Primary key — NOT NULL
- corridor_id — integer — Foreign key → corridor.id
- lat — double
- lon — double
route
- id — integer
- nm — varchar(255) — NOT NULL
- start_vertiport_id — integer — NOT NULL
- end_vertiport_id — integer — NOT NULL
- land_height — double — NOT NULL
- vertical_height — double — NOT NULL
- enr_height — double — NOT NULL
route_corridor
- route_id — integer — Foreign key → corridor.id
- corridor_id — integer — Foreign key → route.id
- seq — integer — NOT NULL
schedule
- id — integer
- takeoff_dt — integer
- entry_dt — integer
- exit_dt — integer
- land_dt — integer
- use_yn — boolean — NOT NULL
- status — varchar(255)
- route_id — integer
- uam_id — integer
- taxi_dep_id — integer
- taxi_arr_id — integer
taxi_route
- id — integer
- fato_id — integer — NOT NULL
- gate_id — integer — NOT NULL
- vertiport_id — integer — NOT NULL
- nm — varchar(255) — NOT NULL
taxi_route_corridor
- taxi_route_id — integer — Foreign key → taxi_route.id
- seq — integer — NOT NULL
- lat — double — NOT NULL
- lon — double — NOT NULL
uam
- id — serial
- call — varchar(20) — NOT NULL
- type_id — integer
uam_type
- id — integer
- nm — varchar(20) — NOT NULL
- wingspan — double
- length — double
- weight — double
- speed_vertical — double — NOT NULL
- speed_takeoff — double — NOT NULL
- speed_corridor — double — NOT NULL
- speed_taxi — double — NOT NULL
vertiport
- id — integer
- nm — varchar(255) — NOT NULL
- desc — varchar(2000)
- lat — double — NOT NULL
- lon — double — NOT NULL
- rad — double — NOT NULL
- height — double — NOT NULL
- extruded_height — double — NOT NULL
- icao — varchar(20)
- vertax1_lat — double
- vertax1_lon — double
- vertax2_lat — double
- vertax2_lon — double
- vertax3_lat — double
- vertax3_lon — double
- vertax4_lat — double
- vertax4_lon — double
- image_name — varchar(255)
- image_angle — double
- image_height — double
vertiport_fato
- id — integer — Primary key — NOT NULL
- vertiport_id — integer — Foreign key → vertiport.id
- nm — varchar(255) — NOT NULL
- available — boolean — NOT NULL
- lat — double — NOT NULL
- lon — double — NOT NULL
vertiport_gate
- id — integer — Primary key — NOT NULL
- vertiport_id — integer — Foreign key → vertiport.id
- nm — varchar(255) — NOT NULL
- available — boolean — NOT NULL
- lat — double — NOT NULL
- lon — double — NOT NULL
vertiport_meteology
- vertiport_id — integer — Foreign key → vertiport.id
- qnh — varchar(255)
- temp — varchar(255)
- ceiling — varchar(255)
- precip — varchar(255)
- visibility — varchar(255)
- gust — varchar(255)