class Aircraft < Sequel::Model(:'aircraft') # NOTE - Count of instances as of 06/01/2009 => 83 # One to many to one associations with atomic primary keys one_to_many :trips, :class=>:Trip, :key=>:'aircraft id', :primary_key=>:'aircraft id' one_to_many :trip_legs, :class=>:TripLeg, :key=>:'aircraft id', :primary_key=>:'aircraft id' code_association :company_code_value, :company_code, :company code_association :base_code_value, :base_code, :location #### BEGIN GENERATED SECTION #### set_primary_key [:'kid - user', :'kid - mult', :'kid - comm', :'kid - date', :'kid - time'] column_alias :ac_110v, :'ac 110v' column_alias :ac_833_mhz, :'ac 833 mhz' column_alias :ac_aed_med, :'ac aed med' column_alias :ac_afis, :'ac afis' column_alias :ac_air, :'ac air' column_alias :ac_apu, :'ac apu' column_alias :ac_airshow, :'ac airshow' column_alias :ac_cd, :'ac cd' column_alias :ac_cloth, :'ac cloth' column_alias :ac_dvd, :'ac dvd' column_alias :ac_dataport, :'ac dataport' column_alias :ac_egwps, :'ac egwps' column_alias :ac_etops, :'ac etops' column_alias :ac_fa, :'ac fa' column_alias :ac_fax, :'ac fax' column_alias :ac_gpws, :'ac gpws' column_alias :ac_galley_full, :'ac galley full' column_alias :ac_galley_mini, :'ac galley mini' column_alias :ac_lav, :'ac lav' column_alias :ac_leather, :'ac leather' column_alias :ac_medlink, :'ac medlink' column_alias :ac_mnps, :'ac mnps' column_alias :ac_maint_update_stat, :'ac maint update stat' column_alias :ac_over_water, :'ac over water' column_alias :ac_pet, :'ac pet' column_alias :ac_phone, :'ac phone' column_alias :ac_rnp10, :'ac rnp10' column_alias :ac_rnp5, :'ac rnp5' column_alias :ac_sat_tv, :'ac sat tv' column_alias :ac_sat_comm, :'ac sat comm' column_alias :ac_smoking, :'ac smoking' column_alias :ac_taws, :'ac taws' column_alias :ac_tcas_i, :'ac tcas i' column_alias :ac_tcas_ii, :'ac tcas ii' column_alias :ac_unused, :'ac unused' column_alias :ac_vcr_tv, :'ac vcr tv' column_alias :ac_wx_radar, :'ac wx radar' column_alias :acmaint_nextdue_proj, :'acmaint nextdue proj' column_alias :afm_rev_date, :'afm rev date' column_alias :afm_rev_number, :'afm rev number' column_alias :apis_company, :'apis company' column_alias :apu_cost, :'apu cost' column_alias :abbr_cycle_factor, :'abbr cycle factor' column_alias :ac_acc_1_ata_code, :'ac acc 1 ata code' column_alias :ac_acc_1_cycles_util, :'ac acc 1 cycles util' column_alias :ac_acc_1_hours_util, :'ac acc 1 hours util' column_alias :ac_acc_2_ata_code, :'ac acc 2 ata code' column_alias :ac_acc_2_cycles_util, :'ac acc 2 cycles util' column_alias :ac_acc_2_hours_util, :'ac acc 2 hours util' column_alias :ac_acc1_not_apu, :'ac acc1 not apu' column_alias :ac_acc2_not_apu, :'ac acc2 not apu' column_alias :ac_options, :'ac options' column_alias :ac_options_old, :'ac options old' column_alias :acc_excl_next_due, :'acc excl next due' column_alias :account_code, :'account code' column_alias :additional_phone, :'additional phone' column_alias :addl_crew, :'addl crew' column_alias :air_ambulance, :'air ambulance' column_alias :aircraft_acc_1_cycle, :'aircraft acc 1 cycle' column_alias :aircraft_acc_1_hours, :'aircraft acc 1 hours' column_alias :aircraft_acc_2_cycle, :'aircraft acc 2 cycle' column_alias :aircraft_acc_2_hours, :'aircraft acc 2 hours' column_alias :aircraft_cycles_util, :'aircraft cycles util' column_alias :aircraft_hours, :'aircraft hours' column_alias :aircraft_hours_util, :'aircraft hours util' column_alias :aircraft_id, :'aircraft id' column_alias :aircraft_landings, :'aircraft landings' column_alias :aircraft_log_gmt_day, :'aircraft log gmt day' column_alias :aircraft_status, :'aircraft status' column_alias :arm, :'arm' column_alias :avail_away_minimum, :'avail away minimum' column_alias :avail_dh_leg_minimum, :'avail dh leg minimum' column_alias :avail_dh_leg_pickup, :'avail dh leg pickup' column_alias :avail_dh_leg_return, :'avail dh leg return' column_alias :avail_home_minimum, :'avail home minimum' column_alias :avail_mode, :'avail mode' column_alias :avionics_update_date, :'avionics update date' column_alias :bow, :'bow' column_alias :base_code, :'base code' column_alias :broker_aircraft, :'broker aircraft' column_alias :cad, :'cad' column_alias :cg, :'cg' column_alias :cargo_aircraft, :'cargo aircraft' column_alias :catering_cart, :'catering cart' column_alias :certification_1, :'certification 1' column_alias :certification_2, :'certification 2' column_alias :certification_3, :'certification 3' column_alias :chats, :'chats' column_alias :charter_ac, :'charter ac' column_alias :cockpit_phone, :'cockpit phone' column_alias :color, :'color' column_alias :colors, :'colors' column_alias :company_code, :'company code' column_alias :crew_cost, :'crew cost' column_alias :crew_cost_sell, :'crew cost sell' column_alias :currency_type, :'currency type' column_alias :current_total_date, :'current total date' column_alias :current_total_fuel, :'current total fuel' column_alias :current_total_time, :'current total time' column_alias :date_inactive, :'date inactive' column_alias :date_last_flown, :'date last flown' column_alias :day_cost, :'day cost' column_alias :day_cost_sell, :'day cost sell' column_alias :decal_number, :'decal number' column_alias :default_ac_rate, :'default ac rate' column_alias :depreciation, :'depreciation' column_alias :dispatcher, :'dispatcher' column_alias :dontuse_ap_fuel_cost, :'dontuse ap fuel cost' column_alias :dontuse_ap_fuel_sell, :'dontuse ap fuel sell' column_alias :etops_time, :'etops time' column_alias :email, :'email' column_alias :empty_wt, :'empty wt' column_alias :endurance, :'endurance' column_alias :eng_acc_prop, :'eng acc prop' column_alias :engine_1_acc_cycles, :'engine 1 acc cycles' column_alias :engine_1_acc_hours, :'engine 1 acc hours' column_alias :engine_1_cp_cycles, :'engine 1 cp cycles' column_alias :engine_1_gp_cycles, :'engine 1 gp cycles' column_alias :engine_1_ip_cycles, :'engine 1 ip cycles' column_alias :engine_1_maint_cycle, :'engine 1 maint cycle' column_alias :engine_1_maint_hours, :'engine 1 maint hours' column_alias :engine_1_maint_start, :'engine 1 maint start' column_alias :engine_1_pt_cycles, :'engine 1 pt cycles' column_alias :engine_1_reversers, :'engine 1 reversers' column_alias :engine_2_acc_cycles, :'engine 2 acc cycles' column_alias :engine_2_acc_hours, :'engine 2 acc hours' column_alias :engine_2_cp_cycles, :'engine 2 cp cycles' column_alias :engine_2_gp_cycles, :'engine 2 gp cycles' column_alias :engine_2_ip_cycles, :'engine 2 ip cycles' column_alias :engine_2_maint_cycle, :'engine 2 maint cycle' column_alias :engine_2_maint_hours, :'engine 2 maint hours' column_alias :engine_2_maint_start, :'engine 2 maint start' column_alias :engine_2_pt_cycles, :'engine 2 pt cycles' column_alias :engine_2_reversers, :'engine 2 reversers' column_alias :engine_3_acc_cycles, :'engine 3 acc cycles' column_alias :engine_3_acc_hours, :'engine 3 acc hours' column_alias :engine_3_cp_cycles, :'engine 3 cp cycles' column_alias :engine_3_gp_cycles, :'engine 3 gp cycles' column_alias :engine_3_ip_cycles, :'engine 3 ip cycles' column_alias :engine_3_maint_cycle, :'engine 3 maint cycle' column_alias :engine_3_maint_hours, :'engine 3 maint hours' column_alias :engine_3_maint_start, :'engine 3 maint start' column_alias :engine_3_pt_cycles, :'engine 3 pt cycles' column_alias :engine_3_reversers, :'engine 3 reversers' column_alias :engine_4_acc_cycles, :'engine 4 acc cycles' column_alias :engine_4_acc_hours, :'engine 4 acc hours' column_alias :engine_4_cp_cycles, :'engine 4 cp cycles' column_alias :engine_4_gp_cycles, :'engine 4 gp cycles' column_alias :engine_4_ip_cycles, :'engine 4 ip cycles' column_alias :engine_4_maint_cycle, :'engine 4 maint cycle' column_alias :engine_4_maint_hours, :'engine 4 maint hours' column_alias :engine_4_maint_start, :'engine 4 maint start' column_alias :engine_4_pt_cycles, :'engine 4 pt cycles' column_alias :engine_4_reversers, :'engine 4 reversers' column_alias :engine_acc_ata_code, :'engine acc ata code' column_alias :engine_cycles_util, :'engine cycles util' column_alias :engine_hours_util, :'engine hours util' column_alias :engine_type, :'engine type' column_alias :engineacc_cycle_util, :'engineacc cycle util' column_alias :engineacc_hours_util, :'engineacc hours util' column_alias :exec_aft_phone, :'exec aft phone' column_alias :exec_forward_phone, :'exec forward phone' column_alias :fl_update_by_user, :'fl update by user' column_alias :fax, :'fax' column_alias :fixed_cost, :'fixed cost' column_alias :fixed_util, :'fixed util' column_alias :flight_ct_factor, :'flight ct factor' column_alias :flight_cycle_factor, :'flight cycle factor' column_alias :flog_ac_hours, :'flog a/c hours' column_alias :flog_acc_1_cycles, :'flog acc 1 cycles' column_alias :flog_acc_1_hours, :'flog acc 1 hours' column_alias :flog_acc_1_name, :'flog acc 1 name' column_alias :flog_acc_2_cycles, :'flog acc 2 cycles' column_alias :flog_acc_2_hours, :'flog acc 2 hours' column_alias :flog_acc_2_name, :'flog acc 2 name' column_alias :flog_eng_acc_cycles, :'flog eng acc cycles' column_alias :flog_eng_acc_hours, :'flog eng acc hours' column_alias :flog_eng_acc_name, :'flog eng acc name' column_alias :flog_eng_hours, :'flog eng hours' column_alias :flt_attend_cost_sell, :'flt attend cost sell' column_alias :flt_attendant_cost, :'flt attendant cost' column_alias :flt_follow_exclude, :'flt follow exclude' column_alias :flt_follow_tail_no, :'flt follow tail no' column_alias :fuel_burn_kg, :'fuel burn kg' column_alias :fuel_cost_unit, :'fuel cost/unit' column_alias :fuel_cost_unit_sell, :'fuel cost/unit sell' column_alias :fuel_units, :'fuel units' column_alias :fuel_units_sell, :'fuel units sell' column_alias :hobbs, :'hobbs' column_alias :home_airport, :'home airport' column_alias :home_airport_prefix, :'home airport prefix' column_alias :hot_food, :'hot food' column_alias :ic_check, :'ic check' column_alias :image_name, :'image name' column_alias :insurance, :'insurance' column_alias :interior_date, :'interior date' column_alias :internal_24, :'internal 24' column_alias :internal01, :'internal01' column_alias :internal02, :'internal02' column_alias :internal03, :'internal03' column_alias :internal04, :'internal04' column_alias :international_cost, :'international cost' column_alias :internatnl_cost_sell, :'internatnl cost sell' 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 :lrc_endurance, :'lrc endurance' column_alias :landing_fee, :'landing fee' column_alias :landing_fee_sell, :'landing fee sell' column_alias :last_fl_update_time, :'last fl update time' column_alias :last_flight_log_upd, :'last flight log upd' column_alias :last_flown_fuel, :'last flown fuel' column_alias :last_flown_time, :'last flown time' column_alias :layover_cost_sell, :'layover cost sell' column_alias :layover_day_cost, :'layover day cost' column_alias :list_order, :'list order' column_alias :locked, :'locked' column_alias :mel, :'mel' column_alias :mglndw, :'mglndw' column_alias :mgtow, :'mgtow' column_alias :mzfw, :'mzfw' column_alias :maint_cycles_acc1, :'maint cycles acc1' column_alias :maint_cycles_acc2, :'maint cycles acc2' column_alias :maint_cycles_offset, :'maint cycles offset' column_alias :maint_date_offset, :'maint date offset' column_alias :maint_export_sched, :'maint export sched' column_alias :maint_hours_acc1, :'maint hours acc1' column_alias :maint_hours_acc2, :'maint hours acc2' column_alias :maint_hours_offset, :'maint hours offset' column_alias :maint_imp_wo_details, :'maint imp wo details' column_alias :maint_imp_workorders, :'maint imp workorders' column_alias :maint_import_cycles, :'maint import cycles' column_alias :maint_import_days, :'maint import days' column_alias :maint_import_eom, :'maint import eom' column_alias :maint_import_hours, :'maint import hours' column_alias :maint_import_items, :'maint import items' column_alias :maint_import_proj, :'maint import proj' column_alias :maint_import_status, :'maint import status' column_alias :maint_import_times, :'maint import times' column_alias :maint_program_code, :'maint program code' column_alias :maint_program_date, :'maint program date' column_alias :maint_scheduled_days, :'maint scheduled days' column_alias :maint_tech, :'maint tech' column_alias :maint_update_date, :'maint update date' column_alias :maint_update_time, :'maint update time' column_alias :maint_update_user, :'maint update user' column_alias :maintenance_cycles, :'maintenance cycles' column_alias :maintenance_hours, :'maintenance hours' column_alias :manufacture_date, :'manufacture date' column_alias :max_bag_length, :'max bag length' column_alias :max_bag_volume, :'max bag volume' column_alias :max_cruise_endurance, :'max cruise endurance' column_alias :max_fuel_payload, :'max fuel payload' column_alias :max_pax, :'max pax' column_alias :max_payload, :'max payload' column_alias :mobile_access, :'mobile access' column_alias :mode_2_ehs, :'mode 2 ehs' column_alias :mode_s_els, :'mode s els' # column_alias :model, :'model' this alias causes havoc so dont use it. column_alias :moments, :'moments' column_alias :next_maint_date, :'next maint date' column_alias :next_maint_date_acc1, :'next maint date acc1' column_alias :next_maint_date_acc2, :'next maint date acc2' column_alias :off_certificate_date, :'off certificate date' column_alias :on_certificate_date, :'on certificate date' column_alias :oven_convection, :'oven convection' column_alias :oven_microwave, :'oven microwave' column_alias :oven_slot, :'oven slot' column_alias :oven_toaster, :'oven toaster' column_alias :owner_address, :'owner address' column_alias :owner_approval, :'owner approval' column_alias :owner_apt_suite, :'owner apt./suite' column_alias :owner_city, :'owner city' column_alias :owner_code, :'owner code' column_alias :owner_comment, :'owner comment' column_alias :owner_country, :'owner country' column_alias :owner_kid_comm, :'owner kid - comm' column_alias :owner_kid_date, :'owner kid - date' column_alias :owner_kid_mult, :'owner kid - mult' column_alias :owner_kid_time, :'owner kid - time' column_alias :owner_kid_user, :'owner kid - user' column_alias :owner_name, :'owner name' column_alias :owner_percent, :'owner percent' column_alias :owner_state, :'owner state' column_alias :owner_zip, :'owner zip' column_alias :oxygen_masks, :'oxygen masks' column_alias :pbh, :'pbh' column_alias :parking_fee, :'parking fee' column_alias :parking_fee_sell, :'parking fee sell' column_alias :parts_cost, :'parts cost' column_alias :phone_10, :'phone 10' column_alias :phone_11, :'phone 11' column_alias :phone_12, :'phone 12' column_alias :phone_13, :'phone 13' column_alias :phone_14, :'phone 14' column_alias :phone_15, :'phone 15' column_alias :phone_16, :'phone 16' column_alias :phone_17, :'phone 17' column_alias :phone_18, :'phone 18' column_alias :phone_19, :'phone 19' column_alias :phone_20, :'phone 20' column_alias :phone_6, :'phone 6' column_alias :phone_7, :'phone 7' column_alias :phone_8, :'phone 8' column_alias :phone_9, :'phone 9' column_alias :phone_desc_11, :'phone desc 11' column_alias :phone_desc_12, :'phone desc 12' column_alias :phone_desc_13, :'phone desc 13' column_alias :phone_desc_14, :'phone desc 14' column_alias :phone_desc_15, :'phone desc 15' column_alias :phone_desc_16, :'phone desc 16' column_alias :phone_desc_17, :'phone desc 17' column_alias :phone_desc_18, :'phone desc 18' column_alias :phone_desc_19, :'phone desc 19' column_alias :phone_desc_20, :'phone desc 20' column_alias :rin_factor_lift, :'rin factor lift' column_alias :rin_factor_takeoff, :'rin factor takeoff' column_alias :ron_cost, :'ron cost' column_alias :ron_cost_sell, :'ron cost sell' column_alias :rvsm, :'rvsm' column_alias :reg, :'reg' column_alias :release_date, :'release date' column_alias :release_time, :'release time' column_alias :repaint_date, :'repaint date' column_alias :report_id, :'report id' column_alias :rest_type, :'rest type' column_alias :reverser_default, :'reverser default' column_alias :reverser_full_cycles, :'reverser full cycles' column_alias :reverser_part_1_cyc, :'reverser part 1 cyc' column_alias :reverser_part_2_cyc, :'reverser part 2 cyc' column_alias :run_station, :'run station' column_alias :runway_elevation, :'runway elevation' column_alias :runway_length, :'runway length' column_alias :runway_width, :'runway width' column_alias :serial_number, :'serial number' column_alias :set_ft_from_hobbs, :'set ft from hobbs' column_alias :show_cp, :'show cp' column_alias :show_eng_cycles, :'show eng cycles' column_alias :show_gp, :'show gp' column_alias :show_ip, :'show ip' column_alias :show_lift, :'show lift' column_alias :show_pt, :'show pt' column_alias :shuttle_aircraft, :'shuttle aircraft' column_alias :stage, :'stage' column_alias :standby_hour_cost, :'standby hour cost' column_alias :standby_hr_cost_sell, :'standby hr cost sell' column_alias :static_check_date, :'static check date' column_alias :tas, :'tas' column_alias :tail_number, :'tail number' column_alias :trim, :'trim' column_alias :trip_req_ac, :'trip req ac' column_alias :type_id, :'type id' column_alias :unverified_date, :'unverified date' column_alias :unverified_hours, :'unverified hours' column_alias :unverified_landings, :'unverified landings' column_alias :update_components, :'update components' column_alias :utilization_days, :'utilization days' column_alias :vendor_id, :'vendor id' column_alias :web_page, :'web page' column_alias :weight_balance_date, :'weight balance date' column_alias :wyvern, :'wyvern' column_alias :xmax_fuel_payload, :'xmax fuel payload' column_alias :xmax_payload, :'xmax payload' column_alias :key0, :'key0' column_alias :key1, :'key1' column_alias :key10, :'key10' 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