class Airport < Sequel::Model(:'airport')
  # NOTE - Count of instances as of 06/01/2009 => 28304
  
  # Associations
  #~ one_to_many :trip_leg_arrivals, :class=>:TripLeg, :key=>nil, :dataset=>proc{TripLeg.filter(:'arrival-icao/iata/id'=>1, :'arrival icao'=>self[:'icao']).union(TripLeg.filter(:'arrival-icao/iata/id'=>2, :'arrival iata'=>self[:'iata'])).union(TripLeg.filter(:'arrival-icao/iata/id'=>3, :'arrival a/p prefix'.like("%#{self[:'airport id prefix']}"), :'arrival airport id'.like("%#{self[:'airport id']}")))} 
  one_to_many :trip_leg_arrivals, :class=>:TripLeg, :key=>nil, :dataset=>proc{TripLeg.filter(:'arrival-icao/iata/id'=>1, :'arrival icao'=>self[:'icao']).union(TripLeg.filter(:'arrival-icao/iata/id'=>2, :'arrival iata'=>self[:'iata'])).union(TripLeg.filter(:'arrival a/p prefix'.like("%#{self[:'airport id prefix']}"), :'arrival airport id'.like("%#{self[:'airport id']}"), :'arrival-icao/iata/id'=>3))} 
  #~ one_to_many :trip_leg_departures, :class=>:TripLeg, :key=>nil, :dataset=>proc{TripLeg.filter(:'depart-icao/iata/id'=>1, :'departure icao'=>self[:'icao']).union(TripLeg.filter(:'depart-icao/iata/id'=>2, :'departure iata'=>self[:'iata'])).union(TripLeg.filter(:'depart-icao/iata/id'=>3, :'depart a/p prefix'.like("%#{self[:'airport id prefix']}"), :'depart airport id'.like("%#{self[:'airport id']}")))} 

  one_to_many :airport_fbos, :class=>:AirportFbo, :key=>nil, :dataset=>proc{ 
     map = Airport.filter(:iata=>iata).graph( AirportFbo, {:'airport kid - date'=>:kid_date, :'airport kid - time'=>:kid_time,:'airport kid - user'=>:kid_user,:'airport kid - mult'=>:kid_mult,:'airport kid - comm'=>:kid_comm}, :table_alias=>:fbo);
     result = map.inject([]){|array, hash| array<<hash[:fbo];array};
     def result.all; self; end;
     result;
  } 
  
#### BEGIN GENERATED SECTION ####
	set_primary_key [:'kid - user', :'kid - mult', :'kid - comm', :'kid - date', :'kid - time']

	column_alias :acn_pcn, :'acn pcn'
	column_alias :acn_pcn_old, :'acn pcn old'
	column_alias :aftn_sita, :'aftn/sita'
	column_alias :apis_id, :'apis id'
	column_alias :aro, :'aro'
	column_alias :atis_frequency, :'atis frequency'
	column_alias :awos_frequency, :'awos frequency'
	column_alias :awos_phone, :'awos phone'
	column_alias :access_code, :'access code'
	column_alias :address, :'address'
	column_alias :airport_closed_sat, :'airport closed sat'
	column_alias :airport_closed_sun, :'airport closed sun'
	column_alias :airport_id, :'airport id'
	column_alias :airport_id_prefix, :'airport id prefix'
	column_alias :airport_open_sat, :'airport open sat'
	column_alias :airport_open_sun, :'airport open sun'
	column_alias :appr_category, :'appr category'
	column_alias :area_code, :'area code'
	column_alias :area_id, :'area id'
	column_alias :arr_freq, :'arr freq'
	column_alias :arrival_dst_code, :'arrival dst - code'
	column_alias :arrival_dst_data1, :'arrival dst - data1'
	column_alias :arrival_dst_data2, :'arrival dst - data2'
	column_alias :arrival_dst_data3, :'arrival dst - data3'
	column_alias :arrival_dst2_code, :'arrival dst2 code'
	column_alias :arrival_dst2_data1, :'arrival dst2 data1'
	column_alias :arrival_dst2_data2, :'arrival dst2 data2'
	column_alias :arrival_dst2_data3, :'arrival dst2 data3'
	column_alias :atis_phone, :'atis phone'
	column_alias :attendance, :'attendance'
	column_alias :avgas, :'avgas'
	column_alias :avgas_cost, :'avgas cost'
	column_alias :avgas_effective_date, :'avgas effective date'
	column_alias :avgas_unit, :'avgas unit'
	column_alias :cbp_appr, :'cbp appr'
	column_alias :cbp_id, :'cbp id'
	column_alias :cert_139, :'cert 139'
	column_alias :cert_139_class, :'cert 139 class'
	column_alias :city, :'city'
	column_alias :city_key, :'city key'
	column_alias :city_sounds_like_key, :'city sounds like key'
	column_alias :city_state_zip, :'city state zip'
	column_alias :clearance_frequency, :'clearance frequency'
	column_alias :closed, :'closed'
	column_alias :closed_no_warning, :'closed no warning'
	column_alias :color, :'color'
	column_alias :compass_variation, :'compass variation'
	column_alias :country, :'country'
	column_alias :country_name, :'country name'
	column_alias :county, :'county'
	column_alias :curfew_begin_sat, :'curfew begin sat'
	column_alias :curfew_begin_sun, :'curfew begin sun'
	column_alias :curfew_comment_key, :'curfew comment key'
	column_alias :curfew_end_sat, :'curfew end sat'
	column_alias :curfew_end_sun, :'curfew end sun'
	column_alias :custom_international, :'custom international'
	column_alias :customs, :'customs'
	column_alias :customs_city, :'customs city'
	column_alias :customs_closed_sat, :'customs closed sat'
	column_alias :customs_closed_sun, :'customs closed sun'
	column_alias :customs_email, :'customs email'
	column_alias :customs_fax, :'customs fax'
	column_alias :customs_open_sat, :'customs open sat'
	column_alias :customs_open_sun, :'customs open sun'
	column_alias :customs_phone_1, :'customs phone 1'
	column_alias :customs_phone_2, :'customs phone 2'
	column_alias :customs_phone_2_desc, :'customs phone 2 desc'
	column_alias :customs_phone_3, :'customs phone 3'
	column_alias :customs_phone_3_desc, :'customs phone 3 desc'
	column_alias :customs_state, :'customs state'
	column_alias :data_source, :'data source'
	column_alias :dep_freq, :'dep freq'
	column_alias :departure_dst_code, :'departure dst - code'
	column_alias :departure_dst_dat1, :'departure dst - dat1'
	column_alias :departure_dst_dat2, :'departure dst - dat2'
	column_alias :departure_dst_dat3, :'departure dst - dat3'
	column_alias :departure_dst2_code, :'departure dst2 code'
	column_alias :departure_dst2_data1, :'departure dst2 data1'
	column_alias :departure_dst2_data2, :'departure dst2 data2'
	column_alias :departure_dst2_data3, :'departure dst2 data3'
	column_alias :discount_cost, :'discount cost'
	column_alias :discount_qty, :'discount qty'
	column_alias :discount_units, :'discount units'
	column_alias :elevation, :'elevation'
	column_alias :extra_time_depart, :'extra time depart'
	column_alias :extra_time_ground, :'extra time ground'
	column_alias :extra_time_landing, :'extra time landing'
	column_alias :extra_time_taxi, :'extra time taxi'
	column_alias :faa_comment_key, :'faa comment key'
	column_alias :fbi_phone, :'fbi phone'
	column_alias :fss_id, :'fss id'
	column_alias :fss_phone, :'fss phone'
	column_alias :facility_code, :'facility code'
	column_alias :facility_name, :'facility name'
	column_alias :fax, :'fax'
	column_alias :fire_category, :'fire category'
	column_alias :fuel_credit_cards, :'fuel credit cards'
	column_alias :fuel_tax_credit, :'fuel tax credit'
	column_alias :ground_frequency, :'ground frequency'
	column_alias :iata, :'iata'
	column_alias :iata_country_code, :'iata country code'
	column_alias :icao, :'icao'
	column_alias :ifr, :'ifr'
	column_alias :image_name, :'image name'
	column_alias :instruments, :'instruments'
	column_alias :internal01, :'internal01'
	column_alias :internal02, :'internal02'
	column_alias :internal03, :'internal03'
	column_alias :internal04, :'internal04'
	column_alias :jar_ops_cat, :'jar ops cat'
	column_alias :jet_fuel, :'jet fuel'
	column_alias :jet_fuel_cost, :'jet fuel cost'
	column_alias :jet_fuel_effect_date, :'jet fuel effect date'
	column_alias :jet_fuel_unit, :'jet fuel unit'
	column_alias :kid_comm, :'kid - comm'
	column_alias :kid_date, :'kid - date'
	column_alias :kid_mult, :'kid - mult'
	column_alias :kid_time, :'kid - time'
	column_alias :kid_user, :'kid - user'
	column_alias :landing_max_weight, :'landing max weight'
	column_alias :last_flight, :'last flight'
	column_alias :last_flight_ac, :'last flight ac'
	column_alias :latitude, :'latitude'
	column_alias :latitude_key, :'latitude key'
	column_alias :lighting_code, :'lighting code'
	column_alias :locked, :'locked'
	column_alias :longitude, :'longitude'
	column_alias :longitude_key, :'longitude key'
	column_alias :max_temp, :'max temp'
	column_alias :max_wind, :'max wind'
	column_alias :min_ceiling, :'min ceiling'
	column_alias :min_visibility, :'min visibility'
	column_alias :name, :'name'
	column_alias :name_key, :'name key'
	column_alias :name_sounds_like_key, :'name sounds like key'
	column_alias :night_curfew, :'night curfew'
	column_alias :owner, :'owner'
	column_alias :ppr, :'ppr'
	column_alias :pax_comment_key, :'pax comment key'
	column_alias :per_diem_cost1, :'per diem cost1'
	column_alias :per_diem_cost2, :'per diem cost2'
	column_alias :per_diem_cost3, :'per diem cost3'
	column_alias :per_diem_cost4, :'per diem cost4'
	column_alias :per_diem_cost5, :'per diem cost5'
	column_alias :per_diem_int1, :'per diem int1'
	column_alias :per_diem_int2, :'per diem int2'
	column_alias :per_diem_int3, :'per diem int3'
	column_alias :per_diem_int4, :'per diem int4'
	column_alias :phone, :'phone'
	column_alias :phone_prefix, :'phone prefix'
	column_alias :rw_hard_surface, :'rw hard surface'
	column_alias :region_code, :'region code'
	column_alias :runway_composition, :'runway composition'
	column_alias :runway_length, :'runway length'
	column_alias :runway_length_water, :'runway length water'
	column_alias :runway_max_weight, :'runway max weight'
	column_alias :runway_threshold, :'runway threshold'
	column_alias :runway_width, :'runway width'
	column_alias :runways, :'runways'
	column_alias :rural, :'rural'
	column_alias :sita, :'sita'
	column_alias :safety_check, :'safety check'
	column_alias :sat_aro_begin, :'sat aro begin'
	column_alias :sat_aro_end, :'sat aro end'
	column_alias :security_phone, :'security phone'
	column_alias :single_axle_limit, :'single axle limit'
	column_alias :special_training_req, :'special training req'
	column_alias :stage_1_begin, :'stage 1 begin'
	column_alias :stage_1_end, :'stage 1 end'
	column_alias :stage_1_type, :'stage 1 type'
	column_alias :stage_2_begin, :'stage 2 begin'
	column_alias :stage_2_end, :'stage 2 end'
	column_alias :stage_2_type, :'stage 2 type'
	column_alias :stage_3_begin, :'stage 3 begin'
	column_alias :stage_3_end, :'stage 3 end'
	column_alias :stage_3_type, :'stage 3 type'
	column_alias :state, :'state'
	column_alias :state_abbreviation, :'state abbreviation'
	column_alias :sun_aro_begin, :'sun aro begin'
	column_alias :sun_aro_end, :'sun aro end'
	column_alias :telex_email, :'telex/email'
	column_alias :time_aro_begin, :'time aro begin'
	column_alias :time_aro_end, :'time aro end'
	column_alias :time_airport_closed, :'time airport closed'
	column_alias :time_airport_open, :'time airport open'
	column_alias :time_curfew_begin, :'time curfew begin'
	column_alias :time_curfew_end, :'time curfew end'
	column_alias :time_customs_closed, :'time customs closed'
	column_alias :time_customs_open, :'time customs open'
	column_alias :time_zone, :'time zone'
	column_alias :tower, :'tower'
	column_alias :tower_frequency, :'tower frequency'
	column_alias :tower_phone, :'tower phone'
	column_alias :uv_id, :'uv id'
	column_alias :unicom_freq, :'unicom freq'
	column_alias :updated_date, :'updated date'
	column_alias :uv_updated, :'uv updated'
	column_alias :vor_1, :'vor 1'
	column_alias :vor_1_dist, :'vor 1 dist'
	column_alias :vor_1_freq, :'vor 1 freq'
	column_alias :vor_1_radial, :'vor 1 radial'
	column_alias :vor_2, :'vor 2'
	column_alias :vor_2_dist, :'vor 2 dist'
	column_alias :vor_2_freq, :'vor 2 freq'
	column_alias :vor_2_radial, :'vor 2 radial'
	column_alias :web_page, :'web page'
	column_alias :weight_dbl_tandem, :'weight dbl tandem'
	column_alias :weight_dual, :'weight dual'
	column_alias :weight_tandem, :'weight tandem'
	column_alias :wx_comment_key, :'wx comment key'
	column_alias :zone_225, :'zone 225'
	column_alias :key0, :'key0'
	column_alias :key1, :'key1'
	column_alias :key10, :'key10'
	column_alias :key11, :'key11'
	column_alias :key12, :'key12'
	column_alias :key13, :'key13'
	column_alias :key2, :'key2'
	column_alias :key3, :'key3'
	column_alias :key4, :'key4'
	column_alias :key5, :'key5'
	column_alias :key6, :'key6'
	column_alias :key7, :'key7'
	column_alias :key8, :'key8'
	column_alias :key9, :'key9'
#### END GENERATED SECTION ####

end