
clauses
partition_descr(0,"in_file","SSCORE.DBA").
table_descr("actual_night_count",[field("airport",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season")])),field("operator",strty(slen(3)),props([sworst("WWW"),upper,prompt("Operator")])),field("actual_qc",realty,props([sworst("1345667.25"),prompt("Actual QC points")])),field("actual_movement",intty,props([sworst("200000"),prompt("Actual Movements")])),field("actual_seat",intty,props([sworst("200000"),prompt("Actual Seats")])),field("usage_date",datety,props([upper,prompt("Usage date")])),field("constraint_id",intty,props([prompt("Quota constraint")]))],props([partition(0)])).
table_descr("additional_si_text",[field("airport",strty(slen(3)),props([sworst("WWW"),prompt("Airport")])),field("season",strty(slen(3)),props([sworst("WWW"),prompt("Season")])),field("active",boolty,props([prompt("Active")])),field("si_text",strty(slen(3900)),props([prompt("Additional SI text")])),field("generic_auto_reply",strty(slen(500)),props([prompt("Generic auto reply")])),field("baseline_automation_below_text",strty(slen(500)),props([prompt("Non historical change")])),field("baseline_automation_above_text",strty(slen(500)),props([prompt("Historical change")]))],props([partition(0)])).
table_descr("agent_response",[field("request_id",intty,props([prompt("Request Id")])),field("request_response_id",intty,props([prompt("Request Response Id")])),field("response_created",strty(slen(24)),props([prompt("Created")])),field("response_sent",strty(slen(24)),props([prompt("Sent")])),field("msg_id",intty,props([prompt("Msg Id")])),field("shndl",intty,props([prompt("Service handle")])),field("agent_id",strty(slen(20)),props([prompt("Agent")])),field("short_response",strty(slen(200)),props([prompt("Response")])),field("recipient",strty(slen(300)),props([prompt("Recipients")]))],props([partition(0)])).
table_descr("aircraft_type",[field("aircraft_type",strty(slen(3)),props([sworst("WWW"),upper,prompt("IATA Aircraft Type")])),field("general_designator",strty(slen(4)),props([sworst("WWW"),upper,prompt("General designator")])),field("comment",strty(slen(80)),props([prompt("Comment")])),field("icao_aircraft_type",strty(slen(4)),props([upper,prompt("ICAO Aircraft Type")])),field("from_date",datety,props([upper,prompt("Valid from")])),field("to_date",datety,props([upper,prompt("Valid to")])),field("icao_aircraft_size",strty(slen(1)),props([sworst("W"),upper,prompt("ICAO aircraft size")]))],props([partition(0)])).
table_descr("aircraft_type_expanded",[field("id",intty,none),field("aircraft_type",strty(slen(4)),none),field("comment",strty(slen(80)),props([prompt("Comment")]))],props([partition(0)])).
table_descr("aircraft_type_group",[field("aircraft_type_group",intty,props([sworst("GROUPNAMEWWW"),prompt("Group")])),field("aircraft_type",strty(slen(3)),props([prompt("Aircraft Type")])),field("airport",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport")]))],props([partition(0)])).
table_descr("aircraft_type_group_name",[field("id",intty,none),field("name",strty(slen(40)),props([upper,prompt("Aircraft type group name")])),field("comment",strty(slen(80)),props([prompt("Comment")])),field("blocking_time",intty,props([prompt("Blocking Time")])),field("valid_from_season",strty(slen(3)),props([sworst("WWW"),upper,prompt("Valid from")]))],props([partition(0)])).
table_descr("airport",[field("airport_id",intty,none),field("IATA_code",strty(slen(3)),props([sworst("WWW"),upper,prompt("IATA Code")])),field("ICAO_code",strty(slen(4)),props([sworst("WWWW"),upper,prompt("ICAO Code")])),field("name",strty(slen(80)),props([prompt("Name")])),field("country",intty,props([prompt("Country")])),field("city_served",strty(slen(80)),props([prompt("City served")]))],props([partition(0)])).
table_descr("airport_setting",[field("setting",intty,props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Setting")])),field("airport",strty(slen(3)),props([prompt("Airport")])),field("active",boolty,props([prompt("Active")])),field("comment",strty(slen(200)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Comment")]))],props([partition(0)])).
table_descr("archive",[field("archive_id",intty,none),field("telex_ref",strty(slen(80)),props([prompt("Telex Ref.")])),field("sender",strty(slen(80)),props([prompt("Sender")])),field("airport",strty(slen(4)),props([sworst("WWW"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season")])),field("date",minutety,props([prompt("Date")])),field("msg_type",strty(slen(10)),props([prompt("Msg. Typ.")])),field("ssim_lines",intty,props([prompt("SSim Lines")])),field("ssim_lines_illegal",intty,props([prompt("Illegal Lines")])),field("ssim_lines_nomatch",intty,props([prompt("Not Matching Lines")])),field("ssim_lines_processed",intty,props([prompt("Processed Lines")])),field("user_id",strty(slen(40)),props([prompt("User")])),field("msg_group",strty(slen(1)),props([prompt("Group")])),field("msg_id",intty,props([prompt("Msg Id")])),field("msg_status",strty(slen(3)),props([prompt("Status")])),field("response_time",intty,props([prompt("Response Time")])),field("change_lines",intty,props([prompt("Change lines")])),field("delete_lines",intty,props([prompt("Delete lines")])),field("new_lines",intty,props([prompt("New lines")])),field("subject",strty(slen(200)),props([prompt("Subject")])),field("cc",strty(slen(1000)),props([prompt("Cc")])),field("reason_no_autoreply",intty,props([upper,prompt("Reason for no auto-reply")])),field("si",strty(slen(100)),props([prompt("SI")])),field("manually_added",boolty,props([upper,prompt("Manually added")]))],props([partition(0)])).
table_descr("arr_dep_constraint",[field("arr_dep_constraint_id",intty,none),field("name",strty(slen(25)),props([upper,prompt("Name")])),field("description",strty(slen(40)),props([prompt("Description")])),field("period",intty,props([sworst("120"),prompt("Period")])),field("rolling_factor",intty,props([sworst("120"),prompt("Rolling factor")])),field("offset",intty,props([sworst("55"),prompt("Offset")])),field("reason_code",strty(slen(4)),props([sworst("ILIL"),prompt("Reason Code")])),field("use_in_ocs",boolty,props([prompt("Use in OCS")]))],props([partition(0)])).
table_descr("audit_log",[field("id",intty,none),field("table_name",strty(slen(40)),props([prompt("Table")])),field("user_id",strty(slen(40)),props([prompt("User id")])),field("date_time",minutety,props([prompt("Date/time")])),field("log_kind",intty,props([prompt("Kind")])),field("details",strty(slen(300)),props([prompt("Details")])),field("update_string",strty(slen(3900)),none)],props([partition(0)])).
table_descr("audit_kind",[field("id",intty,none),field("kind",strty(slen(40)),props([prompt("KIND")]))],props([partition(0)])).
table_descr("aux_actype_or_group",[field("linking_type",strty(slen(20)),props([prompt("Link by")]))],props([partition(0)])).
table_descr("aux_no_yes_onlyooh",[field("no_yes_onlyooh",strty(slen(10)),props([prompt("Value")]))],props([partition(0)])).
table_descr("aux_singleday_adhoc_seasonal",[field("singleday_adhoc_seasonal",strty(slen(25)),props([prompt("Value")]))],props([partition(0)])).
table_descr("base_table_update",[field("table_name",strty(slen(60)),none),field("last_update_sequence_no",intty,none)],props([partition(0)])).
table_descr("baseline_automation_parameter",[field("airport",strty(slen(3)),props([sworst("WWW"),prompt("Airport")])),field("season",strty(slen(3)),props([sworst("WWW"),prompt("Season")])),field("apply_to_ocs",boolty,props([prompt("Apply to OCS")])),field("apply_to_amp",boolty,props([prompt("Apply to AMP")])),field("only_live_if_change_below",intty,props([prompt("Only Live if Change Below")])),field("whole_baseline_if_change_above",intty,props([prompt("Whole Baseline if Change Above")]))],props([partition(0)])).
table_descr("catagories",[field("cat_id",intty,none),field("category",strty(slen(50)),props([upper,prompt("Name")]))],props([partition(0)])).
table_descr("cats",[field("cat_index",intty,none),field("cat_id",intty,props([prompt("Category")])),field("contact_id",intty,props([prompt("Contact")]))],props([partition(0)])).
table_descr("change_report",[field("report_time",minutety,none),field("sender",strty(slen(80)),none),field("carrier",strty(slen(3)),none),field("date",strty(slen(9)),none),field("time",strty(slen(4)),none),field("airport",strty(slen(3)),none),field("season",strty(slen(3)),none),field("msg_type",strty(slen(10)),none),field("num_blocks",intty,none),field("days_from_op",intty,none),field("adhoc_new",intty,none),field("adhoc_time",intty,none),field("adhoc_actype",intty,none),field("adhoc_route",intty,none),field("adhoc_stype",intty,none),field("adhoc_seats",intty,none),field("adhoc_other",intty,none),field("adhoc_delete",intty,none),field("hist_new",intty,none),field("hist_time",intty,none),field("hist_actype",intty,none),field("hist_route",intty,none),field("hist_stype",intty,none),field("hist_seats",intty,none),field("hist_other",intty,none),field("hist_delete",intty,none)],props([partition(0)])).
table_descr("change_report_time",[field("last_report_time",minutety,none)],props([partition(0)])).
table_descr("checkin_adv_constraint",[field("constraint_id",intty,none),field("generic_name_id",intty,props([prompt("Area")])),field("resource_id",intty,none),field("description",strty(slen(40)),props([prompt("Description")])),field("below_level_4",intty,props([sworst("8888"),prompt("Below Level4")])),field("below_level_3",intty,props([sworst("8888"),prompt("Below Level3")])),field("below_level_2",intty,props([sworst("8888"),prompt("Below Level2")])),field("below_level_1",intty,props([sworst("8888"),prompt("Below Level1")])),field("above_level",intty,props([sworst("8888"),prompt("Above Level")])),field("array_id",intty,none),field("tolerance_rule",strty(slen(2000)),props([prompt("Tolerance rule")]))],props([partition(0)])).
table_descr("checkin_adv_constraint_details",[field("constraint_id",intty,none),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("from_time",strty(slen(4)),props([upper,prompt("From time")])),field("to_time",strty(slen(4)),props([upper,prompt("To time")])),field("doop",strty(slen(7)),props([sworst("0000000"),prompt("Doop")])),field("warning",intty,props([sworst("10000"),prompt("Warning")])),field("limit",intty,props([sworst("10000"),prompt("Limit")]))],props([partition(0)])).
table_descr("checkin_adv_constraint_new",[field("constraint_id",intty,none),field("generic_name_id",intty,props([prompt("Area")])),field("resource_id",intty,none),field("description",strty(slen(40)),props([prompt("Description")])),field("below_level_4",intty,props([sworst("8888"),prompt("Below Level4")])),field("below_level_3",intty,props([sworst("8888"),prompt("Below Level3")])),field("below_level_2",intty,props([sworst("8888"),prompt("Below Level2")])),field("below_level_1",intty,props([sworst("8888"),prompt("Below Level1")])),field("above_level",intty,props([sworst("8888"),prompt("Above Level")])),field("tolerance_rule",strty(slen(2000)),props([prompt("Tolerance rule")])),field("profile_constraint_type",strty(slen(30)),none)],props([partition(0)])).
table_descr("checkin_client",[field("constraint_id",intty,none),field("checkin_client_id",intty,none),field("client_name",strty(slen(30)),props([prompt("Client Name")])),field("description",strty(slen(100)),props([prompt("Description")])),field("checkin_type",strty(slen(20)),props([prompt("Check-in Type")])),field("usage_expression",strty(slen(2000)),props([prompt("Usage expression")])),field("use_smoothing",boolty,props([prompt("Use Smoothing")])),field("min_desks",intty,props([prompt("Min desks")])),field("max_desks",intty,props([prompt("Max desks")])),field("array_id",intty,none),field("zone_id",intty,none),field("colour",intty,props([prompt("Colour")]))],props([partition(0)])).
table_descr("checkin_common",[field("checkin_client_id",intty,none),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("doop",strty(slen(7)),props([sworst("0000000"),prompt("Doop")])),field("from_time",strty(slen(4)),props([upper,prompt("From time")])),field("to_time",strty(slen(4)),props([upper,prompt("To time")])),field("seat_percent",realty,props([prompt("Seat Factor")])),field("load_factor_percent",realty,props([prompt("Load Factor")])),field("checkin_percent",realty,props([prompt("Check-in Factor")])),field("reporting_profile_name",intty,props([prompt("Reporting Profile name")])),field("transaction_time",intty,props([prompt("Transaction time (s)")])),field("service_factor",realty,props([prompt("Service Factor")])),field("smoothing_lead",intty,props([prompt("Smoothing - Lead")])),field("smoothing_lag",intty,props([prompt("Smoothing - Lag")]))],props([partition(0)])).
table_descr("checkin_constraint",[field("constraint_id",intty,none),field("name",strty(slen(20)),none),field("resource_id",intty,none),field("description",strty(slen(40)),props([sworst("long long gate description"),prompt("Description")])),field("usage_exp",strty(slen(2000)),props([prompt("Usage expression")])),field("release_before_departure",intty,props([prompt("Release before departure")])),field("below_level_4",intty,props([sworst("100"),prompt("Below Level4")])),field("below_level_3",intty,props([sworst("100"),prompt("Below Level3")])),field("below_level_2",intty,props([sworst("100"),prompt("Below Level2")])),field("below_level_1",intty,props([sworst("100"),prompt("Below Level1")])),field("above_level",intty,props([sworst("100"),prompt("Above Level")])),field("array_id",intty,none),field("generic_name_id",intty,props([prompt("Generic Name")]))],props([partition(0)])).
table_descr("checkin_constraint_details",[field("constraint_id",intty,none),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("from_time",strty(slen(4)),props([sworst("0000"),upper,prompt("From time")])),field("to_time",strty(slen(4)),props([sworst("0000"),upper,prompt("To time")])),field("doop",strty(slen(7)),props([sworst("0000000"),prompt("Doop")])),field("warning",intty,props([sworst("1234"),prompt("Warning")])),field("limit",intty,props([sworst("1234"),prompt("Limit")]))],props([partition(0)])).
table_descr("checkin_counters_minimum",[field("airport",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport")])),field("operator",strty(slen(3)),props([prompt("Operator")])),field("valid_from_date",datety,props([upper,prompt("Valid from date")])),field("minimum_number_of_counters",intty,props([sworst("100"),prompt("Minimum number of counters")]))],props([partition(0)])).
table_descr("checkin_counters_maximum",[field("airport",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport")])),field("operator",strty(slen(3)),props([prompt("Operator")])),field("valid_from_date",datety,props([upper,prompt("Valid from date")])),field("maximum_number_of_counters",intty,props([sworst("100"),prompt("Maximum number of counters")]))],props([partition(0)])).
table_descr("checkin_dedicated",[field("checkin_client_id",intty,none),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("doop",strty(slen(7)),props([sworst("0000000"),prompt("Doop")])),field("from_time",strty(slen(4)),props([upper,prompt("From time")])),field("to_time",strty(slen(4)),props([upper,prompt("To time")])),field("no_of_desks",intty,props([upper,prompt("No of Desks")]))],props([partition(0)])).
table_descr("checkin_desks_profile",[field("id",intty,none),field("name",strty(slen(30)),props([prompt("Name")])),field("description",strty(slen(80)),props([prompt("Description")]))],props([partition(0)])).
table_descr("checkin_desks_profile_period",[field("checkin_desks_profile_id",intty,none),field("time_slot_before_dep",intty,props([prompt("Before Departure")])),field("number_of_desks",intty,props([prompt("Number of Desks")]))],props([partition(0)])).
table_descr("checkin_flight",[field("checkin_client_id",intty,none),field("checkin_flight_id",intty,none),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("doop",strty(slen(7)),props([sworst("0000000"),prompt("Doop")])),field("from_time",strty(slen(4)),props([upper,prompt("From time")])),field("to_time",strty(slen(4)),props([upper,prompt("To time")])),field("min_seats",intty,props([prompt("Min Seats")])),field("max_seats",intty,props([prompt("Max Seats")])),field("checkin_desks_profile",intty,props([prompt("Desks Profile")])),field("usage_expression",strty(slen(2000)),props([prompt("Usage expression")])),field("description",strty(slen(100)),props([prompt("Description")]))],props([partition(0)])).
table_descr("checkin_flight_period",[field("checkin_flight_id",intty,none),field("time_slot_before_dep",intty,props([prompt("Before Departure")])),field("number_of_desks",intty,props([prompt("Number of Desks")]))],props([partition(0)])).
table_descr("checkin_ope_use",[field("id",intty,none),field("airport",strty(slen(3)),props([prompt("Airport")])),field("terminal",strty(slen(30)),props([upper,prompt("Terminal")])),field("operator",strty(slen(3)),props([prompt("Operator")])),field("servno",strty(slen(5)),props([upper,prompt("Service Number")])),field("from_seats",intty,props([sworst("999"),prompt("From Seats")])),field("to_seats",intty,props([sworst("999"),prompt("To Seats")])),field("from_date",datety,props([prompt("Valid from")])),field("to_date",datety,props([prompt("Valid to")])),field("nof_counters",intty,props([sworst("999"),prompt("Nof Counters")])),field("alloc_before_departure",intty,props([sworst("999"),prompt("Period before dep.")]))],props([partition(0)])).
table_descr("checkin_reporting_profile",[field("id",intty,none),field("name",strty(slen(30)),props([prompt("Name")])),field("description",strty(slen(80)),props([prompt("Description")]))],props([partition(0)])).
table_descr("checkin_reporting_profile_period",[field("checkin_reporting_profile_id",intty,none),field("time_slot_before_dep",intty,props([prompt("Before Departure")])),field("passenger_percentage",intty,props([prompt("Passenger Percentage")]))],props([partition(0)])).
table_descr("checkin_type",[field("type",strty(slen(20)),none)],props([partition(0)])).
table_descr("checkin_zone",[field("zone_id",intty,none),field("constraint_id",intty,none),field("name",strty(slen(30)),props([sworst("NAMEOFTHECHECKINZONELLLLL"),prompt("Name")])),field("description",strty(slen(40)),props([sworst("NAMEOFTHECHECKINZONELLLLL"),prompt("Description")])),field("usage_exp",strty(slen(2000)),props([prompt("Usage expression")]))],props([partition(0)])).
table_descr("checkin_zone_details",[field("zone_id",intty,none),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("from_time",strty(slen(4)),props([upper,prompt("From time")])),field("to_time",strty(slen(4)),props([upper,prompt("To time")])),field("doop",strty(slen(7)),props([sworst("0000000"),prompt("Doop")])),field("warning",intty,props([sworst("10000"),prompt("Warning")])),field("limit",intty,props([sworst("10000"),prompt("Limit")]))],props([partition(0)])).
table_descr("client_request",[field("request_id",intty,props([prompt("Request Id")])),field("request_created",strty(slen(24)),props([prompt("Created")])),field("user_name",strty(slen(40)),props([prompt("User Name")])),field("msg_id",intty,props([prompt("Msg Id")])),field("shndl",intty,props([prompt("Service Handle")])),field("service_name",strty(slen(30)),props([prompt("Service Name")])),field("short_request",strty(slen(200)),props([prompt("Request")])),field("request",binty,none),field("agent_id",strty(slen(20)),props([prompt("Agent")])),field("request_taken",strty(slen(24)),props([prompt("Created")]))],props([partition(0)])).
table_descr("color_setup",[field("color_setup_id",intty,none),field("COLOR_SETUP_name",strty(slen(30)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Colour Set-up Name")])),field("COLOR_SETUP",strty(slen(5000)),props([prompt("Colour Set-up")]))],props([partition(0)])).
table_descr("cph_actype_conversion",[field("actype",strty(slen(3)),props([sworst("WWW"),upper,prompt("A/C Type")])),field("cph_actype",strty(slen(3)),props([sworst("WWW"),upper,prompt("CPH A/C Type")]))],props([partition(0)])).
table_descr("cph_flight_conversion",[field("operator",strty(slen(3)),props([sworst("WWW"),upper,prompt("Operator")])),field("service_no",intty,props([sworst("12345"),prompt("Service Number")])),field("cph_operator",strty(slen(3)),props([sworst("WWW"),upper,prompt("CPH Operator")])),field("cph_service_no",intty,props([sworst("12345"),prompt("CPH Service Number")]))],props([partition(0)])).
table_descr("cph_operator_conversion",[field("operator",strty(slen(3)),props([sworst("WWW"),upper,prompt("Operator")])),field("from_service_no",intty,props([sworst("12345"),prompt("From service number")])),field("to_service_no",intty,props([sworst("12345"),prompt("To service number")])),field("cph_operator",strty(slen(3)),props([sworst("WWW"),upper,prompt("CPH Operator")]))],props([partition(0)])).
table_descr("constraint_array",[field("resource_set_id",intty,none),field("branch_id",intty,none),field("array_id",intty,none),field("use_taxi_time",boolty,none),field("array",binty,none)],props([partition(0)])).
table_descr("contact",[field("contact_id",intty,none),field("contact_name",strty(slen(80)),props([prompt("Contact Name")])),field("description",strty(slen(80)),props([prompt("Description")])),field("contact_group",intty,props([prompt("Contact Group")])),field("sita_address",strty(slen(40)),props([prompt("SITA Address")])),field("email_address",strty(slen(80)),props([prompt("E-mail")])),field("use_email",boolty,props([prompt("Use e-mail")])),field("handling_agent_flag",boolty,props([prompt("Handling Agent")])),field("online_account_flag",boolty,props([prompt("Online Account")])),field("online_account",intty,props([prompt("Online Details")])),field("company_name",strty(slen(50)),props([prompt("Company")])),field("department",strty(slen(50)),props([prompt("Department")])),field("job_title",strty(slen(40)),props([prompt("Job Title")])),field("address1",strty(slen(50)),props([prompt("Address1")])),field("address2",strty(slen(50)),props([prompt("Address2")])),field("city",strty(slen(30)),props([prompt("City")])),field("state",strty(slen(30)),props([prompt("State")])),field("post_code",strty(slen(10)),props([prompt("Post Code")])),field("country",strty(slen(80)),props([prompt("Country")])),field("company_phone",strty(slen(20)),props([prompt("Company Phone")])),field("ddi_phone",strty(slen(20)),props([prompt("DDI Phone")])),field("extension",strty(slen(10)),props([prompt("Extension")])),field("fax",strty(slen(20)),props([prompt("Fax")])),field("mobile",strty(slen(20)),props([prompt("Mobile")])),field("keywords",strty(slen(50)),props([prompt("Keywords")])),field("notes",strty(slen(255)),props([prompt("Notes")])),field("website",strty(slen(30)),props([prompt("Web Site")])),field("assistant",strty(slen(50)),props([prompt("Assistant")])),field("owner",strty(slen(50)),props([prompt("Owner")])),field("lastupdate",datety,props([upper,prompt("Last Update")])),field("type",strty(slen(20)),props([prompt("Type")])),field("location_acl_staff",strty(slen(10)),props([prompt("ACL Location")])),field("it_staff",boolty,props([prompt("IT Staff")])),field("verified",boolty,props([prompt("Verified")])),field("xmas_list",boolty,props([prompt("Xmas List")])),field("xmas_elist",boolty,props([prompt("Xmas Elist")])),field("requested_by",strty(slen(50)),props([prompt("Requested by")])),field("key_cat",strty(slen(50)),props([prompt("Key Category")])),field("updated",boolty,props([prompt("Updated")])),field("family_name",strty(slen(80)),props([prompt("Family Name")])),field("country_code",strty(slen(20)),props([prompt("Country Code")])),field("no_dist",boolty,props([prompt("No distribution")])),field("online_account_name",strty(slen(10)),props([prompt("Online Account Name")])),field("online_address",strty(slen(50)),props([prompt("Online Reply E-mail")]))],props([partition(0)])).
table_descr("contact_airport",[field("contact_group",intty,none),field("airport",strty(slen(3)),props([upper,prompt("Airport")])),field("current_season",boolty,props([prompt("Edit current season (SCR)")])),field("next_season",boolty,props([prompt("Edit next season (SCR)")])),field("horizon",intty,props([sworst("000"),prompt("Horizon")])),field("edit_gaba",boolty,props([prompt("Edit GA/BA current season (GCR)")])),field("edit_gaba_next_season",boolty,props([prompt("Edit GA/BA next season (GCR)")])),field("edit_airline_current_season",boolty,props([prompt("Edit airline info current season")])),field("edit_airline_next_season",boolty,props([prompt("Edit airline info next season")]))],props([partition(0)])).
table_descr("contact_group",[field("id",intty,none),field("name",strty(slen(20)),props([prompt("Name")])),field("description",strty(slen(80)),props([prompt("Description")]))],props([partition(0)])).
table_descr("contact_operator",[field("contact_group",intty,none),field("operator",strty(slen(3)),props([sworst("ARF"),upper,prompt("Operator")])),field("airport",strty(slen(3)),props([upper,prompt("Airport")])),field("service_no_from",strty(slen(5)),props([sworst("8888W"),upper,prompt("From ServNo")])),field("service_no_to",strty(slen(5)),props([sworst("8888W"),upper,prompt("To ServNo")])),field("valid_from",datety,props([upper,prompt("Valid from")])),field("valid_to",datety,props([upper,prompt("Valid to")])),field("operator_group",intty,props([upper,prompt("Operator Group")]))],props([partition(0)])).
table_descr("contact_operator_group",[field("contact_operator_group",intty,props([prompt("Contact Operator Group")])),field("contact_operator",strty(slen(3)),props([sworst("www"),prompt("Operator")]))],props([partition(0)])).
table_descr("contact_operator_group_name",[field("id",intty,none),field("name",strty(slen(40)),props([upper,prompt("Contact Operator group name")])),field("comment",strty(slen(80)),props([prompt("Comment")]))],props([partition(0)])).
table_descr("coordinated_airport",[field("airport_id",intty,none),field("IATA_code",strty(slen(3)),props([sworst("WWW"),upper,prompt("IATA Code")])),field("time_zone",intty,props([sworst("-820"),prompt("Time zone")])),field("use_daylight_saving_time",boolty,props([prompt("Daylight Saving Time")])),field("parking_gap",intty,props([sworst("20"),prompt("Parking Gap")])),field("parking_slot",intty,props([sworst("20"),prompt("Parking Slot")])),field("preIATACheckAgainstDB",boolty,props([prompt("Check SSIM against DB before SCC")])),field("operation_counts_below_slot_margin",intty,none),field("operation_counts_above_slot_margin",intty,none),field("hist_slot_range",intty,props([sworst("30"),prompt("Historic Slot")])),field("use_hist_slot_range_as_margin",boolty,props([prompt("Historic Slot As Margin")])),field("preSCCsplitPeriodExtension",boolty,props([prompt("Split period extension before SCC")])),field("preIATADontCheckConstraints",boolty,props([prompt("Don't check constraints in changescreen before SCC")])),field("preIATAHandleMultiCSingleR",boolty,props([prompt("Allow C...CR before SCC")])),field("offer_generation_range",intty,props([sworst("0000"),prompt("Offer Range Minutes")])),field("operation_counts_below_slot_margin_arr",intty,props([sworst("1000"),prompt("Slot Mon. Arr Below Margin")])),field("operation_counts_above_slot_margin_arr",intty,props([sworst("1000"),prompt("Slot Mon. Arr Above Margin")])),field("operation_counts_below_slot_margin_dep",intty,props([sworst("1000"),prompt("Slot Mon. Dep Below Margin")])),field("operation_counts_above_slot_margin_dep",intty,props([sworst("1000"),prompt("Slot Mon. Dep Above Margin")])),field("use_extended_hist_status_code",boolty,props([prompt("Extended Historic Status Codes")])),field("slot_mon_early_arr_limit",intty,props([sworst("1000"),prompt("Early Arr Limit")])),field("slot_mon_late_arr_limit",intty,props([sworst("1000"),prompt("Late Arr Limit")])),field("slot_mon_early_dep_limit",intty,props([sworst("1000"),prompt("Early Dep Limit")])),field("slot_mon_late_dep_limit",intty,props([sworst("1000"),prompt("Late Dep Limit")])),field("amp_hour_margin",intty,props([sworst("10000"),prompt("AMP/OCS Minutes Offset from Now for Insertions")])),field("min_ground_time",intty,props([sworst("10"),prompt("Default Minimum Ground Time")])),field("amp_hour_margin2",intty,props([sworst("10000"),prompt("AMP/OCS Minutes Offset from Now for Deletions")])),field("default_gaba_operator",strty(slen(3)),props([sworst("ARF"),upper,prompt("Default GABA permission code")]))],props([partition(0)])).
table_descr("copy_telex_address",[field("address",strty(slen(50)),props([prompt("Address")])),field("airport",strty(slen(3)),props([sworst("WWW"),prompt("Airport")])),field("copy_address",strty(slen(50)),props([prompt("Copy Address")])),field("comment",strty(slen(40)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Comment")]))],props([partition(0)])).
table_descr("country",[field("country_id",intty,none),field("country",strty(slen(20)),props([upper,prompt("Country")])),field("comment",strty(slen(80)),props([prompt("Comment")]))],props([partition(0)])).
table_descr("country_group",[field("country_group",strty(slen(20)),props([prompt("Group")])),field("country_id",intty,props([sworst("afghanistan"),prompt("Country")])),field("comment",strty(slen(80)),props([prompt("Comment")]))],props([partition(0)])).
table_descr("database_version",[field("time_stamp",strty(slen(13)),none)],props([partition(0)])).
table_descr("daylight_saving_time_period",[field("airport",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport")])),field("from_date_time",minutety,props([upper,prompt("From")])),field("to_date_time",minutety,props([upper,prompt("To")]))],props([partition(0)])).
table_descr("db_ini",[field("id",intty,none),field("user_name",strty(slen(20)),none),field("section",strty(slen(40)),none),field("item",strty(slen(200)),none),field("data",strty(slen(5000)),none)],props([partition(0)])).
table_descr("db_mark",[field("date",datety,none),field("sequence",intty,none)],props([partition(0)])).
table_descr("disable_message_parameter",[field("airport",strty(slen(3)),props([sworst("WWW"),prompt("Airport")])),field("from_date_time",minutety,props([prompt("From")])),field("to_date_time",minutety,props([prompt("To")])),field("disable_new",boolty,props([prompt("Disable New")])),field("disable_retiming",boolty,props([prompt("Disable Retiming")])),field("disable_acupgrade",boolty,props([prompt("Disable A/C Upgrade")]))],props([partition(0)])).
table_descr("dubai_terminal_code",[field("terminal_name",strty(slen(30)),props([prompt("Terminal Name")])),field("dubai_terminal_code",strty(slen(1)),props([sworst("WWW"),prompt("Dubai Terminal Code")]))],props([partition(0)])).
table_descr("eschedule_fcsu_fragment",[field("replicate_id",intty,props([sworst("8888888888"),prompt("ReplicateID")])),field("flight_id",intty,props([sworst("8888888888"),prompt("FlightId")])),field("arr_dep_mode",strty(slen(1)),props([sworst("A"),upper,prompt("A/D")])),field("airport",strty(slen(3)),props([sworst("ARF"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("W01"),upper,prompt("Season")])),field("start_date",datety,props([upper,prompt("From")])),field("end_date",datety,props([upper,prompt("To")])),field("doop",strty(slen(7)),props([sworst("1234567"),prompt("DOOP")])),field("fcsu_xml",strty(slen(7900)),none)],props([partition(0)])).
table_descr("favorite_view",[field("user_id",strty(slen(40)),none),field("tablename",strty(slen(40)),none),field("viewname",strty(slen(80)),props([prompt("View Name")])),field("sort_order",intty,none)],props([partition(0)])).
table_descr("filter_expression",[field("filter_expression_id",intty,none),field("filter_expression_name",strty(slen(30)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Filter Expression Name")])),field("filter_expression",strty(slen(20000)),props([prompt("Flight Filter Expression")]))],props([partition(0)])).
table_descr("filter_valuelist",[field("id",intty,none),field("name",strty(slen(30)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Name")])),field("table_name",strty(slen(30)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Table")])),field("valuelist",strty(slen(20000)),props([prompt("Filter Values")]))],props([partition(0)])).
table_descr("flight",[field("flight_id",intty,props([sworst("8888888888"),prompt("FlightId")])),field("airport_code",strty(slen(3)),props([sworst("ARF"),upper,prompt("Airport")])),field("season_code",strty(slen(3)),props([sworst("W01"),upper,prompt("Season")])),field("operator_arrival_departure",strty(slen(3)),props([prompt("ADOp")])),field("service_no_arrival_departure",strty(slen(5)),props([prompt("ADServNo")])),field("operator_arrival",strty(slen(3)),props([sworst("ARF"),upper,prompt("AOpe")])),field("service_no_arrival",strty(slen(5)),props([sworst("8888W"),upper,prompt("AServNo")])),field("operator_departure",strty(slen(3)),props([sworst("ARF"),upper,prompt("DOpe")])),field("service_no_departure",strty(slen(5)),props([sworst("8888W"),upper,prompt("DServNo")])),field("start_date",datety,props([upper,prompt("From")])),field("end_date",datety,props([upper,prompt("To")])),field("doop",strty(slen(7)),props([sworst("1234567"),prompt("DOOP")])),field("num_seats",intty,props([sworst("8888"),prompt("Seats")])),field("aircraft_type",strty(slen(3)),props([sworst("ARF"),upper,prompt("A/C")])),field("origin_station",strty(slen(3)),props([sworst("MOW"),upper,prompt("Orig")])),field("last_station",strty(slen(3)),props([sworst("MOW"),upper,prompt("Last")])),field("cleared_time_arrival",strty(slen(4)),props([prompt("ATime")])),field("cleared_time_departure",strty(slen(4)),props([prompt("DTime")])),field("turnaround_days",intty,props([sworst("0"),prompt("TD")])),field("next_station",strty(slen(3)),props([sworst("MOW"),upper,prompt("Next")])),field("destination_station",strty(slen(3)),props([sworst("MOW"),upper,prompt("Dest")])),field("service_type_arrival",strty(slen(1)),props([sworst("I"),upper,prompt("AST")])),field("service_type_departure",strty(slen(1)),props([sworst("I"),upper,prompt("DST")])),field("woop",intty,props([sworst("8"),prompt("WOOP")])),field("aircraft_registration",strty(slen(9)),props([upper,prompt("ACReg")])),field("required_time_arrival",strty(slen(5)),props([upper,prompt("AReq")])),field("required_time_departure",strty(slen(5)),props([upper,prompt("DReq")])),field("reason_code_arr",strty(slen(4)),props([sworst("ILIL"),prompt("AReasonCode")])),field("reason_code_dep",strty(slen(4)),props([sworst("ILIL"),prompt("DReasonCode")])),field("hist_status_arr",strty(slen(5)),props([sworst("ILIL"),prompt("AHistStat")])),field("hist_status_dep",strty(slen(5)),props([sworst("ILIL"),prompt("DHistStat")])),field("slot_holder_arr",strty(slen(3)),props([sworst("ARF"),upper,prompt("ASlotHold")])),field("slot_holder_service_no_arr",strty(slen(17)),props([upper,prompt("ASlotHolNo")])),field("slot_holder_dep",strty(slen(3)),props([sworst("ARF"),upper,prompt("DSlotHold")])),field("slot_holder_service_no_dep",strty(slen(17)),props([upper,prompt("DSlotHolNo")])),field("ssim_action_flag",strty(slen(1)),props([upper,prompt("SSIM")])),field("no_of_operations",intty,props([prompt("NofOp")])),field("creation_date",minutety,props([prompt("CreDate")])),field("user_id",strty(slen(40)),props([prompt("User")])),field("historic_time_arr",strty(slen(5)),props([upper,prompt("AHist")])),field("historic_time_dep",strty(slen(5)),props([upper,prompt("DHist")])),field("initial_required_time_arr",strty(slen(5)),props([upper,prompt("AInitReq")])),field("initial_required_time_dep",strty(slen(5)),props([prompt("DInitReq")])),field("arrival_qc_points",realty,props([prompt("AQC")])),field("departure_qc_points",realty,props([prompt("DQC")])),field("min_ground_time",intty,props([prompt("MinGTime")])),field("telex_ref",strty(slen(80)),props([prompt("TelexRef")])),field("terminal_arr_id",intty,props([upper,prompt("ATerm")])),field("resource_arr_id",intty,props([upper,prompt("ARes")])),field("terminal_dep_id",intty,props([upper,prompt("DTerm")])),field("resource_dep_id",intty,props([upper,prompt("DRes")])),field("priority_arr",intty,props([prompt("APrio")])),field("priority_dep",intty,props([prompt("DPrio")])),field("company_name",strty(slen(80)),props([prompt("Company")])),field("note_id",intty,props([prompt("Note")])),field("ssim_action_flag_operator",strty(slen(1)),props([prompt("SSIM ope.")])),field("branch_id",intty,none),field("aux_flag",strty(slen(9)),props([sworst("123456789"),prompt("Aux Flag")])),field("operator_arrival_group",intty,props([prompt("AOpeGroup")])),field("operator_departure_group",intty,props([prompt("DOpeGroup")])),field("aircraft_type_group",intty,props([prompt("A/C Type Group")])),field("origin_station_country",intty,props([prompt("OrigCountry")])),field("last_station_country",intty,props([prompt("LastCountry")])),field("next_station_country",intty,props([prompt("NextCountry")])),field("destination_station_country",intty,props([prompt("DestCountry")])),field("last_edit_date",minutety,props([prompt("EditDate")])),field("historical_percentage",intty,props([sworst("100"),prompt("Hist. Perc.")])),field("runway_time_arr",strty(slen(4)),props([prompt("ARunwTime")])),field("runway_time_dep",strty(slen(4)),props([prompt("DRunwTime")])),field("ringfenced",boolty,props([prompt("Ringfenced")])),field("offer_time_arr_from",strty(slen(4)),props([prompt("AOfferTimeFrom")])),field("offer_time_arr_to",strty(slen(4)),props([prompt("AOfferTimeTo")])),field("offer_time_dep_from",strty(slen(4)),props([prompt("DOfferTimeFrom")])),field("offer_time_dep_to",strty(slen(4)),props([prompt("DOfferTimeTo")])),field("line_of_flying",strty(slen(80)),props([prompt("LineOfFlying")])),field("slot_swap_id",intty,props([prompt("SlotSwapId")])),field("low_priority",boolty,props([prompt("LowPriority")])),field("si_ocs_note_id",intty,props([prompt("SI OCS")])),field("icao_aircraft_type",strty(slen(4)),props([prompt("Icao Aircraft Type")])),field("icao_origin_station",strty(slen(4)),props([prompt("Icao Origin Station")])),field("icao_last_station",strty(slen(4)),props([prompt("Icao Last Station")])),field("icao_next_station",strty(slen(4)),props([prompt("Icao Next Station")])),field("icao_destination_station",strty(slen(4)),props([prompt("Icao Dest Station")])),field("gaba_flag",boolty,props([prompt("GA/BA")])),field("slot_link_flag",boolty,props([prompt("Slot Link (Y/N)")])),field("hist_period_flag",strty(slen(1)),props([prompt("Hist period (Y/N/M)")])),field("no_of_weekly_operations",intty,props([prompt("NofWOp")])),field("required_terminal_arr_id",intty,props([sworst("WWW"),upper,prompt("AReqTerm")])),field("required_terminal_dep_id",intty,props([sworst("WWW"),upper,prompt("DReqTerm")])),field("short_note",strty(slen(50)),props([prompt("Short Note")])),field("gaba_operator",strty(slen(3)),props([sworst("ARF"),prompt("PermOp")])),field("last_stn_dep_time",strty(slen(4)),props([sworst("1000"),prompt("LastSTD")])),field("next_stn_arr_time",strty(slen(4)),props([sworst("1000"),prompt("NextSTA")])),field("orig_stn_dep_time",strty(slen(4)),props([sworst("1000"),prompt("OrigSTD")])),field("last_stn_arr_time",strty(slen(4)),props([sworst("1000"),prompt("LastSTA")])),field("next_stn_dep_time",strty(slen(4)),props([sworst("1000"),prompt("NextSTD")])),field("dest_stn_arr_time",strty(slen(4)),props([sworst("1000"),prompt("DestSTA")])),field("pax_load_arr",realty,props([prompt("APaxLoad")])),field("pax_load_dep",realty,props([prompt("DPaxLoad")])),field("arr_via_stn",strty(slen(3)),props([sworst("MOW"),upper,prompt("ArrVia")])),field("dep_via_stn",strty(slen(3)),props([sworst("MOW"),upper,prompt("DepVia")])),field("rotation_id",strty(slen(20)),props([prompt("RotationId")])),field("arr_via2_stn",strty(slen(3)),props([sworst("MOW"),upper,prompt("ArrVia2")])),field("dep_via2_stn",strty(slen(3)),props([sworst("MOW"),upper,prompt("DepVia2")])),field("status_information_reason_arr",strty(slen(10)),props([upper,prompt("AStInf")])),field("status_information_reason_dep",strty(slen(10)),props([upper,prompt("DStInf")])),field("contact_details",strty(slen(50)),props([prompt("Contact Details")])),field("special_ops_arr",strty(slen(10)),props([sworst("WWWWW"),prompt("ASpecialOps")])),field("special_ops_dep",strty(slen(10)),props([sworst("WWWWW"),prompt("DSpecialOps")])),field("waitlist_date",datety,props([prompt("Waitl.Date")])),field("historic_aircraft_type",strty(slen(3)),props([sworst("ARF"),upper,prompt("Hist A/C")])),field("historic_num_seats",intty,props([sworst("8888"),prompt("Hist Seats")])),field("required_aircraft_type",strty(slen(3)),props([sworst("ARF"),upper,prompt("Req A/C")])),field("required_num_seats",intty,props([sworst("8888"),prompt("ReqSeats")])),field("refer_time_arrival",strty(slen(5)),props([upper,prompt("ARefTime")])),field("refer_time_departure",strty(slen(5)),props([upper,prompt("DRefTime")])),field("historic_terminal_arr",strty(slen(10)),props([sworst("WWW"),upper,prompt("AHistTerm")])),field("historic_terminal_dep",strty(slen(10)),props([sworst("WWW"),upper,prompt("DHistTerm")])),field("checkin_zone_area",strty(slen(30)),props([sworst("CHECKIN ZONE NUM 1"),prompt("Check-in Zone")])),field("security_area",strty(slen(30)),props([sworst("SECURITY AREA NUM 1"),prompt("Security Area")]))],props([partition(0)])).
table_descr("flight_ad",[field("flight_ad",strty(slen(1)),props([sworst("A"),upper,prompt("Mode (A/D)")]))],props([partition(0)])).
table_descr("flight_adt",[field("flight_adt",strty(slen(1)),props([sworst("A"),upper,prompt("Type (A/D/T)")]))],props([partition(0)])).
table_descr("flight_aircraft",[field("branch_id",intty,none),field("operator",strty(slen(3)),props([sworst("ARF"),upper,prompt("Ope")])),field("service_no",strty(slen(5)),props([sworst("8888W"),upper,prompt("ServNo")])),field("start_date",datety,props([upper,prompt("From")])),field("num_seats_first",intty,props([sworst("8888"),prompt("Seats first")])),field("num_seats_business",intty,props([sworst("8888"),prompt("Seats business")])),field("num_seats_economy",intty,props([sworst("8888"),prompt("Seats economy")])),field("tonnage",intty,props([sworst("8888"),prompt("Tonnage")])),field("status_flag",intty,none),field("arr_dep_mode",strty(slen(1)),props([sworst("A"),upper,prompt("A/D")]))],props([partition(0)])).
table_descr("flight_branch",[field("branch_id",intty,none),field("user_id",strty(slen(40)),props([prompt("User Id")])),field("IATA_code",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport code")])),field("season_code",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season code")])),field("name",strty(slen(30)),props([prompt("Name")])),field("parent",intty,props([prompt("Branch from")])),field("branch_kind",intty,props([sworst("HISTORICAL BASELINE"),prompt("Branch Kind")])),field("snapshot_date",minutety,props([prompt("Date")])),field("access_rights",strty(slen(2000)),props([prompt("Access Rights")])),field("flight_expression",strty(slen(2000)),none),field("flightdelete_expression",strty(slen(2000)),none)],props([partition(0)])).
table_descr("flight_branch_kind",[field("id",intty,none),field("name",strty(slen(30)),none)],props([partition(0)])).
table_descr("flight_count",[field("airport",strty(slen(3)),none),field("season",strty(slen(3)),none),field("resource_set_id",intty,none),field("branch_id",intty,none),field("last_flight_id",intty,none),field("last_flight_delete_id",intty,none)],props([partition(0)])).
table_descr("flight_delete",[field("id",intty,none),field("flight_id",intty,none),field("branch_id",intty,none),field("date",minutety,none),field("user_id",strty(slen(40)),none),field("telex_ref",strty(slen(80)),none)],props([partition(0)])).
table_descr("flight_link",[field("airport",strty(slen(3)),props([sworst("ARF"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("W01"),upper,prompt("Season")])),field("operator_arrival",strty(slen(3)),props([sworst("ARF"),upper,prompt("AOpe")])),field("service_no_arrival",strty(slen(5)),props([sworst("8888W"),upper,prompt("AServNo")])),field("operator_departure",strty(slen(3)),props([sworst("ARF"),upper,prompt("DOpe")])),field("service_no_departure",strty(slen(5)),props([sworst("8888W"),upper,prompt("DServNo")])),field("start_date",datety,props([upper,prompt("From")])),field("end_date",datety,props([upper,prompt("To")])),field("doop",strty(slen(7)),props([sworst("1234567"),prompt("DOOP")])),field("woop",intty,props([sworst("8"),prompt("WOOP")])),field("turnaround_days",intty,props([sworst("1"),prompt("TD")])),field("branch_id",intty,props([prompt("Schedule")]))],props([partition(0)])).
table_descr("flight_mother",[field("branch_id",intty,none),field("flight_id",intty,none),field("mother_flight_id",intty,none)],props([partition(0)])).
table_descr("flight_resource_set",[field("flight_id",intty,none),field("resource_set_id",intty,none),field("resource_arr_id",intty,none),field("terminal_arr_id",intty,none),field("resource_dep_id",intty,none),field("terminal_dep_id",intty,none)],props([partition(0)])).
table_descr("flight_routing",[field("branch_id",intty,none),field("arr_dep_mode",strty(slen(1)),props([sworst("A"),upper,prompt("A/D")])),field("operator",strty(slen(3)),props([sworst("ARF"),upper,prompt("Ope")])),field("service_no",strty(slen(5)),props([sworst("8888W"),upper,prompt("ServNo")])),field("start_date",datety,props([upper,prompt("From")])),field("orig_dest_time",strty(slen(6)),props([prompt("Orig/Dest Time")])),field("via1_stn",strty(slen(3)),props([sworst("MOW"),upper,prompt("Via1 Sta")])),field("via1_arr_time",strty(slen(6)),props([prompt("Via1 Arr Time")])),field("via1_dep_time",strty(slen(6)),props([prompt("Via1 Dep Time")])),field("via2_stn",strty(slen(3)),props([sworst("MOW"),upper,prompt("Via2 Sta")])),field("via2_arr_time",strty(slen(6)),props([prompt("Via2 Arr Time")])),field("via2_dep_time",strty(slen(6)),props([prompt("Via2 Dep Time")])),field("via3_stn",strty(slen(3)),props([sworst("MOW"),upper,prompt("Via3 Sta")])),field("via3_arr_time",strty(slen(6)),props([prompt("Via3 Arr Time")])),field("via3_dep_time",strty(slen(6)),props([prompt("Via3 Dep Time")])),field("via4_stn",strty(slen(3)),props([sworst("MOW"),upper,prompt("Via4 Sta")])),field("via4_arr_time",strty(slen(6)),props([prompt("Via4 Arr Time")])),field("via4_dep_time",strty(slen(6)),props([prompt("Via4 Dep Time")])),field("via5_stn",strty(slen(3)),props([sworst("MOW"),upper,prompt("Via5 Sta")])),field("via5_arr_time",strty(slen(6)),props([prompt("Via5 Arr Time")])),field("via5_dep_time",strty(slen(6)),props([prompt("Via5 Dep Time")])),field("last_next_arr_time",strty(slen(6)),props([prompt("Last/next Arr Time")])),field("last_next_dep_time",strty(slen(6)),props([prompt("Last/next Dep Time")])),field("status_flag",intty,none)],props([partition(0)])).
table_descr("flight_trans",[field("from_id",intty,props([sworst("8"),prompt("From Id")])),field("to_id",intty,props([sworst("8"),prompt("To Id")]))],props([partition(0)])).
table_descr("flight_codeshare",[field("airport",strty(slen(3)),props([sworst("ARF"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("W01"),upper,prompt("Season")])),field("operator",strty(slen(3)),props([sworst("ARF"),upper,prompt("Ope")])),field("service_no",strty(slen(5)),props([sworst("8888W"),upper,prompt("ServNo")])),field("codeshare_operator",strty(slen(3)),props([sworst("ARF"),upper,prompt("CSHOpe")])),field("codeshare_service_no",strty(slen(5)),props([sworst("8888W"),upper,prompt("CSHServNo")])),field("arr_dep_mode",strty(slen(1)),props([sworst("A"),upper,prompt("A/D")])),field("date_from",datety,props([upper,prompt("From")])),field("date_to",datety,props([upper,prompt("To")])),field("doop",strty(slen(7)),props([sworst("1234567"),prompt("DOOP")])),field("route_from",strty(slen(3)),props([sworst("MOW"),upper,prompt("Route From")])),field("route_to",strty(slen(3)),props([sworst("MOW"),upper,prompt("Route To")]))],props([partition(0)])).
table_descr("flight_marketing",[field("airport",strty(slen(3)),props([sworst("ARF"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("W01"),upper,prompt("Season")])),field("marketing_operator",strty(slen(3)),props([sworst("ARF"),upper,prompt("MKTOpe")])),field("marketing_service_no",strty(slen(5)),props([sworst("8888W"),upper,prompt("MKTServNo")])),field("operating_operator",strty(slen(3)),props([sworst("ARF"),upper,prompt("Ope")])),field("operating_service_no",strty(slen(5)),props([sworst("8888W"),upper,prompt("ServNo")])),field("start_date",datety,props([upper,prompt("From")])),field("end_date",datety,props([upper,prompt("To")])),field("doop",strty(slen(7)),props([sworst("1234567"),prompt("DOOP")])),field("num_seats",intty,props([sworst("8888"),prompt("Seats")])),field("aircraft_type",strty(slen(3)),props([sworst("ARF"),upper,prompt("A/C")])),field("origin_station",strty(slen(3)),props([sworst("MOW"),upper,prompt("Orig")])),field("via1_station",strty(slen(3)),props([sworst("MOW"),upper,prompt("Via1")])),field("via2_station",strty(slen(3)),props([sworst("MOW"),upper,prompt("Via2")])),field("via3_station",strty(slen(3)),props([sworst("MOW"),upper,prompt("Via3")])),field("destination_station",strty(slen(3)),props([sworst("MOW"),upper,prompt("Dest")])),field("service_type",strty(slen(1)),props([sworst("I"),upper,prompt("ST")]))],props([partition(0)])).
table_descr("full_amp_active",[field("active",boolty,none),field("airport_group_name",strty(slen(10)),none)],props([partition(0)])).
table_descr("full_amp_filter",[field("name",strty(slen(40)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Full AMP Filter Name")])),field("register_filter_exp",strty(slen(20000)),props([prompt("Message Filter Expression")])),field("flight_filter_exp",strty(slen(20000)),props([prompt("Flight Filter Expression")])),field("airport_code",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport code")])),field("season_code",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season code")]))],props([partition(0)])).
table_descr("gaba_service_no",[field("airport",strty(slen(3)),none),field("season",strty(slen(3)),none),field("service_no",intty,none)],props([partition(0)])).
table_descr("gantt_carrier_colour",[field("operator",strty(slen(3)),none),field("gantt_colour",intty,none),field("airport",strty(slen(3)),none)],props([partition(0)])).
table_descr("gantt_view",[field("id",intty,none),field("view_name",strty(slen(80)),props([prompt("View Name")])),field("user_id",strty(slen(40)),props([prompt("User")])),field("airport",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season")])),field("branch_id",intty,none),field("resource_id",intty,props([upper,prompt("Resource")])),field("data",strty(slen(7000)),none),field("resource_set_id",intty,props([prompt("Resource Set")]))],props([partition(0)])).
table_descr("gate_adv_array",[field("constraint_id",intty,none),field("aircraft_type_group",intty,none),field("array_id",intty,none)],props([partition(0)])).
table_descr("gate_adv_constraint",[field("constraint_id",intty,none),field("resource_id",intty,none),field("generic_name_id",intty,props([prompt("Generic Name")])),field("description",strty(slen(40)),props([sworst("long long gate description"),prompt("Description")])),field("below_level_4",intty,props([sworst("100"),prompt("Below Level4")])),field("below_level_3",intty,props([sworst("100"),prompt("Below Level3")])),field("below_level_2",intty,props([sworst("100"),prompt("Below Level2")])),field("below_level_1",intty,props([sworst("100"),prompt("Below Level1")])),field("above_level",intty,props([sworst("100"),prompt("Above Level")])),field("usage_exp",strty(slen(2000)),props([prompt("Usage expression")])),field("tolerance_rule",strty(slen(2000)),props([prompt("Tolerance rule")]))],props([partition(0)])).
table_descr("gate_adv_pool",[field("pool_id",intty,none),field("constraint_id",intty,none),field("name",strty(slen(25)),props([sworst("abcdefghijklmno bay"),upper,prompt("Name")])),field("description",strty(slen(40)),props([sworst("long long gate description"),prompt("Description")])),field("allocation_order",intty,props([sworst("20"),prompt("Allocation order")])),field("actype_group",strty(slen(2000)),props([prompt("A/C Type Groups")])),field("usage_exp",strty(slen(2000)),props([prompt("Usage expression")])),field("bay_names",strty(slen(2000)),props([prompt("Bay names")]))],props([partition(0)])).
table_descr("gate_adv_pool_details",[field("pool_id",intty,none),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("from_time",strty(slen(4)),props([sworst("0000"),upper,prompt("From time")])),field("to_time",strty(slen(4)),props([sworst("0000"),upper,prompt("To time")])),field("doop",strty(slen(7)),props([sworst("0000000"),prompt("Doop")])),field("warning",intty,props([sworst("1234"),prompt("Warning")])),field("limit",intty,props([sworst("1234"),prompt("Limit")]))],props([partition(0)])).
table_descr("gate_array",[field("resource_id",intty,none),field("aircraft_type_group",intty,none),field("array_id",intty,none)],props([partition(0)])).
table_descr("gate_constraint",[field("constraint_id",intty,none),field("name",strty(slen(20)),none),field("resource_id",intty,none),field("description",strty(slen(40)),props([sworst("long long gate description"),prompt("Description")])),field("allocation_order",intty,props([sworst("20"),prompt("Allocation order")])),field("below_level_4",intty,props([sworst("100"),prompt("Below Level4")])),field("below_level_3",intty,props([sworst("100"),prompt("Below Level3")])),field("below_level_2",intty,props([sworst("100"),prompt("Below Level2")])),field("below_level_1",intty,props([sworst("100"),prompt("Below Level1")])),field("above_level",intty,props([sworst("100"),prompt("Above Level")])),field("actype_group",strty(slen(2000)),props([prompt("A/C Type Groups")])),field("tolerance_rule",strty(slen(2000)),props([prompt("Tolerance rule")])),field("generic_name_id",intty,props([prompt("Generic Name")])),field("bay_names",strty(slen(2000)),props([prompt("Bay names")])),field("usage_exp",strty(slen(2000)),props([prompt("Usage expression")]))],props([partition(0)])).
table_descr("gate_constraint_details",[field("constraint_id",intty,none),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("from_time",strty(slen(4)),props([sworst("0000"),upper,prompt("From time")])),field("to_time",strty(slen(4)),props([sworst("0000"),upper,prompt("To time")])),field("doop",strty(slen(7)),props([sworst("0000000"),prompt("Doop")])),field("warning",intty,props([sworst("1234"),prompt("Warning")])),field("limit",intty,props([sworst("1234"),prompt("Limit")]))],props([partition(0)])).
table_descr("handling_agent",[field("operator",strty(slen(3)),props([prompt("Operator")])),field("airport",strty(slen(3)),props([prompt("Airport")])),field("contact_id",intty,props([prompt("Contact")])),field("service_no_from",strty(slen(5)),props([sworst("8888W"),upper,prompt("From ServNo")])),field("service_no_to",strty(slen(5)),props([sworst("8888W"),upper,prompt("To ServNo")])),field("valid_from",datety,props([upper,prompt("Valid from")])),field("valid_to",datety,props([upper,prompt("Valid to")]))],props([partition(0)])).
table_descr("header_footer",[field("id",intty,none),field("name",strty(slen(40)),props([prompt("Name")])),field("user_id",strty(slen(40)),props([prompt("User")])),field("text",strty(slen(7900)),props([prompt("Text")]))],props([partition(0)])).
table_descr("hist_status_code",[field("hist_status_code",strty(slen(5)),props([upper,prompt("Historic status code")])),field("comment",strty(slen(80)),props([prompt("Comment")])),field("hist_status_code_group",intty,props([prompt("Hist Status Code Group")]))],props([partition(0)])).
table_descr("hist_status_code_group",[field("id",intty,none),field("name",strty(slen(20)),props([prompt("Group Name")])),field("description",strty(slen(80)),props([prompt("Description")]))],props([partition(0)])).
table_descr("holiday",[field("date",datety,props([prompt("Date")])),field("airport",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport code")])),field("comment",strty(slen(80)),props([prompt("Comment")]))],props([partition(0)])).
table_descr("icao_aircraft_size",[field("icao_aircraft_size",strty(slen(1)),props([upper,prompt("ICAO aircraft size")]))],props([partition(0)])).
table_descr("keycats",[field("keycat",strty(slen(50)),props([upper,prompt("Name")]))],props([partition(0)])).
table_descr("load_factor",[field("resource_id",intty,none),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("from_time",strty(slen(4)),props([upper,prompt("From time")])),field("to_time",strty(slen(4)),props([upper,prompt("To time")])),field("doop",strty(slen(7)),props([sworst("00000000"),prompt("Doop")])),field("allocation_order",intty,props([prompt("Allocation order")])),field("usage_rule",strty(slen(2000)),props([prompt("Usage rule")])),field("arr_load_factor",realty,props([sworst("1234"),prompt("Arrival")])),field("dep_load_factor",realty,props([sworst("1234"),prompt("Departure")]))],props([partition(0)])).
table_descr("locations",[field("location",strty(slen(10)),props([upper,prompt("Name")]))],props([partition(0)])).
table_descr("low_priority",[field("airport",strty(slen(3)),props([sworst("ARF"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("W01"),upper,prompt("Season")])),field("operator",strty(slen(3)),props([sworst("ARF"),upper,prompt("Ope")])),field("from_time",strty(slen(4)),props([sworst("0000"),upper,prompt("From time")])),field("to_time",strty(slen(4)),props([sworst("0000"),upper,prompt("To time")])),field("low_priority",boolty,props([prompt("Low Priority Y/N")]))],props([partition(0)])).
table_descr("max_ground_time",[field("airport",strty(slen(3)),props([sworst("WWW"),prompt("Airport")])),field("operator",strty(slen(3)),props([sworst("JLK"),prompt("Operator")])),field("aircraft_type",strty(slen(3)),props([prompt("Aircraft Type")])),field("max_ground_time",intty,props([sworst("1440"),prompt("Max. Ground time")])),field("service_type",strty(slen(1)),props([sworst("I"),upper,prompt("ST")])),field("valid_from",datety,props([upper,prompt("Valid from")])),field("disregard_overmidnight",boolty,props([prompt("Disregard for overmidnight flight")]))],props([partition(0)])).
table_descr("message",[field("msg_id",intty,none),field("telex_ref",strty(slen(80)),none),field("message",strty(slen(7900)),none),field("long_message",strty(slen(1200000)),none)],props([partition(0)])).
table_descr("message_alert",[field("id",intty,none),field("user_id",strty(slen(40)),props([prompt("User")])),field("label",strty(slen(200)),props([prompt("Text")])),field("label_colour",intty,none),field("description",strty(slen(200)),props([prompt("Description")])),field("filter",strty(slen(2000)),props([prompt("Filter")])),field("visual_alert",boolty,none),field("audio_alert",boolty,none)],props([partition(0)])).
table_descr("message_configuration",[field("message_config_id",intty,none),field("message_config_name",strty(slen(30)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Configuration Name")])),field("airport_code",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport code")])),field("season_code",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season code")])),field("current_config",boolty,props([prompt("Active")])),field("offer_generation_range",intty,none),field("config_filter_expression",strty(slen(20000)),props([prompt("Configuration Filter Expression")])),field("apply_to_ocs",boolty,props([prompt("Apply to OCS")]))],props([partition(0)])).
table_descr("min_ground_time",[field("aircraft_type",strty(slen(3)),props([prompt("Aircraft Type")])),field("airport",strty(slen(3)),props([sworst("WWW"),prompt("Airport")])),field("operator",strty(slen(3)),props([sworst("JLK"),prompt("Operator")])),field("min_ground_time",intty,props([sworst("120"),prompt("Min. Ground time")])),field("service_type",strty(slen(1)),props([sworst("I"),upper,prompt("ST")])),field("valid_from",datety,props([upper,prompt("Valid from")]))],props([partition(0)])).
table_descr("no_autoreply_reason",[field("id",intty,none),field("name",strty(slen(80)),none)],props([partition(0)])).
table_descr("noise_quota_constraint",[field("constraint_id",intty,none),field("name",strty(slen(20)),none),field("resource_id",intty,none),field("description",strty(slen(40)),props([sworst("long parking description"),prompt("Description")])),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("arr_from_time",strty(slen(4)),props([sworst("1000"),prompt("Arr. From time")])),field("arr_to_time",strty(slen(4)),props([sworst("1000"),prompt("Arr. To time")])),field("dep_from_time",strty(slen(4)),props([sworst("1000"),prompt("Dep. From time")])),field("dep_to_time",strty(slen(4)),props([sworst("1000"),prompt("Dep. To time")])),field("usage_exp",strty(slen(2000)),props([prompt("Usage expression")])),field("array_id",intty,none),field("tolerance_rule",strty(slen(2000)),props([prompt("Tolerance rule")])),field("week_period",intty,props([sworst("31"),prompt("Period")])),field("period_kind",intty,props([sworst("Seasonal"),prompt("Period Kind")])),field("doop",strty(slen(7)),props([sworst("1234567"),prompt("DOOP")])),field("generic_name_id",intty,props([prompt("Generic Name")]))],props([partition(0)])).
table_descr("noise_quota_constraint_details",[field("constraint_id",intty,none),field("operator",strty(slen(3)),props([sworst("JKL"),prompt("Operator")])),field("qc_points",realty,props([sworst("345667.8"),prompt("QC points")])),field("movements",intty,props([sworst("200000"),prompt("Movements")])),field("array_id",intty,none),field("seats",intty,props([sworst("20000000"),prompt("Seats")])),field("operator2",strty(slen(3)),props([sworst("JKL"),prompt("Operator2")])),field("array_id2",intty,none)],props([partition(0)])).
table_descr("noise_quota_period_kind",[field("id",intty,none),field("name",strty(slen(30)),none)],props([partition(0)])).
table_descr("note",[field("note_id",intty,none),field("si",boolty,props([prompt("Note is SI text")])),field("text",strty(slen(10000)),props([prompt("Text of this note")])),field("timestamp",minutety,props([prompt("Timestamp")]))],props([partition(0)])).
table_descr("offer",[field("offer_id",intty,none),field("airport_code",strty(slen(3)),props([sworst("ARF"),upper,prompt("Airport")])),field("season_code",strty(slen(3)),props([sworst("W01"),upper,prompt("Season")])),field("creation_time",minutety,props([prompt("CreTime")])),field("operator_arrival",strty(slen(3)),props([sworst("ARF"),upper,prompt("AOpe")])),field("service_no_arrival",strty(slen(5)),props([sworst("8888W"),upper,prompt("AServNo")])),field("operator_departure",strty(slen(3)),props([sworst("ARF"),upper,prompt("DOpe")])),field("service_no_departure",strty(slen(5)),props([sworst("8888W"),upper,prompt("DServNo")])),field("start_date",datety,props([upper,prompt("From")])),field("end_date",datety,props([upper,prompt("To")])),field("doop",strty(slen(7)),props([sworst("1234567"),prompt("DOOP")])),field("woop",intty,props([sworst("8"),prompt("WOOP")])),field("cleared_time_arrival",strty(slen(4)),props([prompt("ATime")])),field("cleared_time_departure",strty(slen(4)),props([prompt("DTime")])),field("required_time_arrival",strty(slen(5)),props([prompt("AReq")])),field("required_time_departure",strty(slen(5)),props([prompt("DReq")])),field("ssim_action_flag_operator",strty(slen(1)),props([prompt("SSIM")])),field("major_id",intty,props([prompt("Major Id")])),field("minor_id",intty,props([prompt("Minor Id")]))],props([partition(0)])).
table_descr("office",[field("id",intty,none),field("name",strty(slen(80)),props([prompt("Name")])),field("opening_time",strty(slen(4)),props([prompt("Opening time")])),field("closing_time",strty(slen(4)),props([prompt("Closing time")])),field("gantt_auto_allocation_interval",intty,props([prompt("Gantt auto reallocation interval (mins)")]))],props([partition(0)])).
table_descr("office_details",[field("id",intty,none),field("airport",strty(slen(3)),props([upper,prompt("Airport")])),field("ooh_si",strty(slen(500)),props([prompt("OOH SI text")])),field("ooh_contact",strty(slen(200)),props([prompt("Contact details for OOH team")]))],props([partition(0)])).
table_descr("online_account",[field("account_id",intty,none),field("account_name",strty(slen(10)),props([upper,prompt("Account Name")])),field("primary_password",strty(slen(80)),props([prompt("Password")])),field("secondary_password",strty(slen(80)),props([prompt("Pass Code")])),field("email_address",strty(slen(50)),props([prompt("Reply E-mail")])),field("enabled",boolty,props([prompt("Enabled")])),field("download_flag",boolty,props([prompt("Download")])),field("single_flag",boolty,props([prompt("Edit Single Date")])),field("series_flag",boolty,props([prompt("Edit Series")])),field("last_access",minutety,none),field("default_next_season",boolty,props([prompt("Default Next Season")])),field("default_airport",strty(slen(3)),props([prompt("Default Airport")])),field("default_operator",strty(slen(3)),props([prompt("Default Operator")])),field("override_flag",boolty,props([prompt("Override Constraints")])),field("report_flag",boolty,props([prompt("Report")])),field("schedule_download_flag",boolty,props([prompt("Schedule Download")])),field("administrator_permission_flag",boolty,props([prompt("Administrator permission")])),field("description",strty(slen(80)),props([prompt("Description")])),field("allow_multiple_login",boolty,props([prompt("Allow Multiple Login")])),field("waitlist_flag",boolty,props([prompt("Waitlist")])),field("automatic_offer_flag",boolty,props([prompt("Automatic Offers")])),field("time_out",intty,props([prompt("Time Out Period (hours)")])),field("gaba_flag",boolty,props([prompt("View/edit GA/BA")])),field("contact_details_required",boolty,props([prompt("Contact Details Required")])),field("view_euaca_flag",boolty,props([prompt("View EUACA")])),field("disable_message_processing_flag",boolty,props([prompt("Disable Message Processing")])),field("airline_information_flag",boolty,props([prompt("Airline Information")])),field("codeshare_flights_flag",boolty,props([prompt("Codeshare Flights")])),field("marketing_flights_flag",boolty,props([prompt("Marketing Flights")])),field("view_restricted_flag",boolty,props([prompt("View own flights only")]))],props([partition(0)])).
table_descr("online_account_local",[field("account_name",strty(slen(10)),props([prompt("Account Name")])),field("contact_group",intty,props([prompt("Contact Group")])),field("mail_address",strty(slen(80)),props([prompt("Mail Address")]))],props([partition(0)])).
table_descr("online_airport_season",[field("airport_code",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport")])),field("season_code",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season")])),field("enabled_flag",boolty,props([prompt("Enabled")])),field("baseline_flag",boolty,props([prompt("Baseline")])),field("peak_week_start_date",datety,props([upper,prompt("Peak Week Start Date")])),field("start_of_period_flag",boolty,props([prompt("Start of Period")])),field("enable_iata",boolty,props([prompt("Enable IATA")])),field("enable_icao",boolty,props([prompt("Enable ICAO")]))],props([partition(0)])).
table_descr("online_season",[field("season_code",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season")])),field("allow_pend_flag",boolty,props([prompt("Allow Ask Us")])),field("allow_shl_flag",boolty,props([prompt("Allow SHL Processing")])),field("shl_deadline_date",datety,props([sworst("25MAR2012W"),upper,prompt("Submission Deadline Date")]))],props([partition(0)])).
table_descr("online_slot_monitoring_result",[field("airport",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season code")])),field("flight_operator",strty(slen(3)),props([sworst("ARF"),upper,prompt("Ope")])),field("flight_service_no",strty(slen(5)),props([sworst("8888W"),upper,prompt("Service No")])),field("arrival_departure",strty(slen(1)),props([sworst("A"),upper,prompt("A/D")])),field("start_date",datety,props([upper,prompt("Start Date")])),field("end_date",datety,props([upper,prompt("End Date")])),field("weekday",intty,props([sworst("1"),prompt("Weekday")])),field("woop",intty,props([sworst("1"),prompt("Woop")])),field("time",strty(slen(4)),props([sworst("1000"),prompt("Time")])),field("baseline_num_ope",intty,props([sworst("30"),prompt("Baseline Num Operations")])),field("use_it_or_lose_it_num_ope",intty,props([sworst("8888"),prompt("Use It or Lose It Num Operations")])),field("target_num_ope",intty,props([sworst("8888"),prompt("Target Num Operations")])),field("cancellations",intty,props([sworst("8888"),prompt("Cancellations")])),field("non_operations",intty,props([sworst("8888"),prompt("Non-operations")])),field("operations_not_counting",intty,props([sworst("8888"),prompt("Not Counting Operations")])),field("operations_counting",intty,props([sworst("8888"),prompt("Counting Operations")])),field("planned_remaining_num_ope",intty,props([sworst("8888"),prompt("Planned Remaining Operations")])),field("projected_slot_usage",intty,props([sworst("8888"),prompt("Projected Slot Usage")])),field("avg_off_cleared_time",intty,props([sworst("8888"),prompt("Avg off Cle")])),field("stdev_off_cleared_time",intty,props([sworst("8888"),prompt("Stdev off Cle")])),field("min_off_cleared_time",intty,props([sworst("8888"),prompt("Min off Cle")])),field("max_off_cleared_time",intty,props([sworst("8888"),prompt("Max off Cle")])),field("slot_link",intty,props([sworst("8888"),prompt("Slot Link")])),field("hist_period",boolty,props([sworst("8888"),prompt("Hist Period (Y/N)")])),field("updated_to_date",datety,props([prompt("Updated to")])),field("sig_off_slot",strty(slen(10)),props([sworst("Early"),prompt("Sig Off Slot")])),field("change_of_day_num_ope",intty,props([sworst("8888"),prompt("Change of Day")])),field("slot_holder",strty(slen(3)),props([sworst("ARF"),upper,prompt("Slot Holder")])),field("slot_holder_link",strty(slen(17)),props([sworst("8888-0000-0000-00"),upper,prompt("Slot Holder Link")])),field("short_note",strty(slen(50)),none),field("num_dispensations",intty,props([sworst("10"),prompt("Dispensation")])),field("origin_destination",strty(slen(3)),props([sworst("MOW"),upper,prompt("OrigDest")])),field("wsg_use_it_or_lose_it",intty,props([sworst("8888"),prompt("WSG U/L ops")])),field("wsg_use_it_or_lose_it_link",intty,props([sworst("8888"),prompt("WSG U/L Link")])),field("seats",intty,props([sworst("8888"),prompt("Seats")])),field("ac_type",strty(slen(3)),props([sworst("ARF"),upper,prompt("A/C")])),field("remaining_cancellations",intty,props([prompt("Remaining Cancellations")])),field("projected_total_usage",intty,props([sworst("8888"),prompt("Projected Total Usage")])),field("ul_sum_seats",intty,props([sworst("8888"),prompt("WSG U/L Sum Seats")])),field("projected_sum_seats",intty,props([sworst("8888"),prompt("Projected Sum Seats")])),field("ul_sum_seats_single_flight",intty,props([sworst("8888"),prompt("U/L Sum Seats")]))],props([partition(0)])).
table_descr("ooh_redirect_message_address",[field("id",intty,none),field("address",strty(slen(80)),none)],props([partition(0)])).
table_descr("operator",[field("id",intty,none),field("IATA_code",strty(slen(3)),props([sworst("WWW"),upper,prompt("IATA Code")])),field("ICAO_code",strty(slen(3)),props([sworst("WWW"),upper,prompt("ICAO Code")])),field("use_icao_code_as_operator",boolty,props([prompt("Use ICAO As Operator")])),field("handling_agent",strty(slen(80)),props([prompt("Name")])),field("comment",strty(slen(80)),props([prompt("Comment")])),field("from_date",datety,props([upper,prompt("Valid from")])),field("to_date",datety,props([upper,prompt("Valid to")])),field("SHL",boolty,props([prompt("Delink SHL")])),field("default_contact",intty,props([sworst("WWWWWWWWWWWWWWWWWWWW"),prompt("Default Contact")])),field("country",intty,props([prompt("Country")])),field("operator_report_name",strty(slen(80)),props([prompt("Report Name")]))],props([partition(0)])).
table_descr("operator_expanded",[field("operator",strty(slen(3)),none),field("id",intty,none),field("additional_information",strty(slen(80)),props([prompt("Description")])),field("SHL",boolty,props([prompt("Description")])),field("country",intty,props([prompt("Country")])),field("operator_report_name",strty(slen(80)),props([prompt("Report Name")]))],props([partition(0)])).
table_descr("operator_group",[field("operator_group",intty,props([prompt("Operator Group")])),field("operator",strty(slen(3)),props([sworst("www"),prompt("Operator")]))],props([partition(0)])).
table_descr("operator_group_name",[field("id",intty,none),field("name",strty(slen(40)),props([upper,prompt("Operator group name")])),field("comment",strty(slen(80)),props([prompt("Comment")])),field("airport",strty(slen(3)),props([sworst("WWW"),prompt("Airport")])),field("valid_from_season",strty(slen(3)),props([sworst("WWW"),upper,prompt("Valid from")]))],props([partition(0)])).
table_descr("params",[field("system_params_id",intty,none),field("historical_rate",intty,props([sworst("888"),prompt("Historical rate")])),field("home_address",strty(slen(12)),none),field("offer_limit",intty,props([sworst("888"),prompt("Max days for offers")])),field("auto_ir_archive",boolty,props([prompt("Archive all incoming messages")])),field("auto_or_archive",boolty,props([prompt("Archive all outgoing messages")])),field("auto_rr_archive",boolty,props([prompt("Archive all processed messages")])),field("max_archive_date",intty,props([sworst("888"),upper,prompt("Max months in archive")])),field("outdated_ar_file",strty(slen(80)),props([prompt("Archive dump file")])),field("strict_ssim",boolty,props([prompt("Use strict SSIM syntax")])),field("new_entrant_rate",intty,none),field("max_telex_length",intty,none),field("daylight_saving_time_is_used",boolty,none),field("always_split_scr",boolty,props([prompt("Always delink linked flights in SCR")])),field("period_of_hist_significance",intty,props([sworst("10"),prompt("Period of Historic Significance (Weeks)")]))],props([partition(0)])).
table_descr("parking_adv_array",[field("constraint_id",intty,none),field("aircraft_type_group",intty,none),field("array_id",intty,none)],props([partition(0)])).
table_descr("parking_adv_constraint",[field("constraint_id",intty,none),field("resource_id",intty,none),field("generic_name_id",intty,props([prompt("Generic Name")])),field("description",strty(slen(40)),props([sworst("Long parking description"),prompt("Description")])),field("parking_gap",intty,props([sworst("120"),prompt("Buffer Time")])),field("below_level_4",intty,props([sworst("100"),prompt("Below Level4")])),field("below_level_3",intty,props([sworst("100"),prompt("Below Level3")])),field("below_level_2",intty,props([sworst("100"),prompt("Below Level2")])),field("below_level_1",intty,props([sworst("100"),prompt("Below Level1")])),field("above_level",intty,props([sworst("100"),prompt("Above Level")])),field("usage_exp",strty(slen(2000)),props([prompt("Usage expression")])),field("tolerance_rule",strty(slen(2000)),props([prompt("Tolerance rule")])),field("give_overload_for_flights_outside_pools",boolty,props([prompt("Give overload for flights outside pools")]))],props([partition(0)])).
table_descr("parking_adv_pool_details",[field("pool_id",intty,none),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("from_time",strty(slen(4)),props([sworst("0000"),upper,prompt("From time")])),field("to_time",strty(slen(4)),props([sworst("0000"),upper,prompt("To time")])),field("doop",strty(slen(7)),props([sworst("0000000"),prompt("Doop")])),field("warning",intty,props([sworst("1234"),prompt("Warning")])),field("limit",intty,props([sworst("1234"),prompt("Limit")]))],props([partition(0)])).
table_descr("parking_adv_pool",[field("pool_id",intty,none),field("constraint_id",intty,none),field("name",strty(slen(25)),props([sworst("Long parking pool name"),prompt("Name")])),field("description",strty(slen(40)),props([sworst("Long parking pool description"),prompt("Description")])),field("allocation_order",intty,props([sworst("20"),prompt("Allocation order")])),field("towing",boolty,props([prompt("Towing Pool")])),field("actype_group",strty(slen(2000)),props([prompt("A/C Type Groups")])),field("usage_exp",strty(slen(2000)),props([prompt("Usage expression")]))],props([partition(0)])).
table_descr("parking_allocation",[field("airport",strty(slen(3)),none),field("season",strty(slen(3)),none),field("branch_id",intty,none),field("resource_set_id",intty,none),field("constraint_id",intty,none),field("bay_number",intty,none),field("allocation",strty(slen(3000000)),none)],props([partition(0)])).
table_descr("parking_template",[field("id",intty,none),field("branch_id",intty,none),field("resource_set_id",intty,none),field("constraint_id",intty,none),field("name",strty(slen(80)),props([prompt("Name")])),field("active",boolty,props([prompt("Active")]))],props([partition(0)])).
table_descr("parking_template_member",[field("template_id",intty,none),field("pool_id",intty,none),field("bay_number",intty,none),field("allocation",strty(slen(3000000)),none),field("update_sequence_id",intty,none)],props([partition(0)])).
table_descr("parking_array",[field("resource_id",intty,none),field("aircraft_type_group",intty,none),field("array_id",intty,none)],props([partition(0)])).
table_descr("parking_constraint",[field("constraint_id",intty,none),field("name",strty(slen(20)),none),field("resource_id",intty,none),field("description",strty(slen(40)),props([sworst("long parking description"),prompt("Description")])),field("parking_gap",intty,props([sworst("120"),prompt("Buffer Time")])),field("allocation_order",intty,props([sworst("20"),prompt("Allocation order")])),field("below_level_4",intty,props([sworst("100"),prompt("Below Level4")])),field("below_level_3",intty,props([sworst("100"),prompt("Below Level3")])),field("below_level_2",intty,props([sworst("100"),prompt("Below Level2")])),field("below_level_1",intty,props([sworst("100"),prompt("Below Level1")])),field("above_level",intty,props([sworst("100"),prompt("Above Level")])),field("actype_group",strty(slen(2000)),props([prompt("A/C Type Groups")])),field("tolerance_rule",strty(slen(2000)),props([prompt("Tolerance rule")])),field("generic_name_id",intty,props([prompt("Generic Name")])),field("bay_names",strty(slen(1900)),none),field("usage_exp",strty(slen(2000)),props([prompt("Usage expression")]))],props([partition(0)])).
table_descr("parking_constraint_details",[field("constraint_id",intty,none),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("from_time",strty(slen(4)),props([sworst("0000"),upper,prompt("From time")])),field("to_time",strty(slen(4)),props([sworst("0000"),upper,prompt("To time")])),field("doop",strty(slen(7)),props([sworst("0000000"),prompt("Doop")])),field("warning",intty,props([sworst("1234"),prompt("Warning")])),field("limit",intty,props([sworst("1234"),prompt("Limit")]))],props([partition(0)])).
table_descr("parking_count",[field("resource_id",intty,none),field("aircraft_type_group",intty,props([prompt("Aircraft Type Group")])),field("from_date",datety,props([upper,prompt("From")])),field("to_date",datety,props([upper,prompt("To")])),field("time",strty(slen(4)),props([sworst("0000"),prompt("Time")])),field("doop",strty(slen(7)),props([sworst("00000000"),prompt("Doop")])),field("no_of_aircraft",intty,props([prompt("Number of Aircraft")]))],props([partition(0)])).
table_descr("parking_links_operator_group",[field("parking_links_operator_group",intty,none),field("operator",strty(slen(3)),props([sworst("WWW"),prompt("Operator")])),field("valid_from_season",strty(slen(3)),props([sworst("WWW"),upper,prompt("Valid from")])),field("valid_to_season",strty(slen(3)),props([sworst("WWW"),upper,prompt("Valid to")]))],props([partition(0)])).
table_descr("parking_links_operator_group_expanded",[field("operator",strty(slen(3)),none),field("season",strty(slen(3)),none)],props([partition(0)])).
table_descr("parking_links_operator_group_name",[field("id",intty,none),field("name",strty(slen(40)),props([upper,prompt("Parking Links Operator Group Name")])),field("comment",strty(slen(80)),props([prompt("Comment")]))],props([partition(0)])).
table_descr("paxflow_constraint",[field("constraint_id",intty,none),field("generic_name_id",intty,props([prompt("Generic Name")])),field("resource_id",intty,none),field("description",strty(slen(40)),props([prompt("Description")])),field("usage_exp",strty(slen(2000)),props([prompt("Usage expression")])),field("below_level_4",intty,props([sworst("8888"),prompt("Below Level4")])),field("below_level_3",intty,props([sworst("8888"),prompt("Below Level3")])),field("below_level_2",intty,props([sworst("8888"),prompt("Below Level2")])),field("below_level_1",intty,props([sworst("8888"),prompt("Below Level1")])),field("above_level",intty,props([sworst("8888"),prompt("Above Level")])),field("array_id",intty,none),field("tolerance_rule",strty(slen(2000)),props([prompt("Tolerance rule")]))],props([partition(0)])).
table_descr("paxflow_constraint_details",[field("constraint_id",intty,none),field("a_d_t",strty(slen(1)),props([sworst("A"),upper,prompt("A/D/T")])),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("from_time",strty(slen(4)),props([upper,prompt("From time")])),field("to_time",strty(slen(4)),props([upper,prompt("To time")])),field("doop",strty(slen(7)),props([sworst("0000000"),prompt("Doop")])),field("warning",intty,props([sworst("10000"),prompt("Warning")])),field("limit",intty,props([sworst("10000"),prompt("Limit")]))],props([partition(0)])).
table_descr("permitted_message_mixed_operator_pair",[field("operator1",strty(slen(3)),props([sworst("WWW"),prompt("Carrier Code1")])),field("operator2",strty(slen(3)),props([sworst("WWW"),prompt("Carrier Code2")])),field("comment",strty(slen(80)),props([prompt("Comment")]))],props([partition(0)])).
table_descr("permitted_shl_code",[field("code",strty(slen(4)),props([sworst("ILIL"),upper,prompt("Code")])),field("comment",strty(slen(80)),props([prompt("Comment")]))],props([partition(0)])).
table_descr("pro_view",[field("view_id",intty,none),field("user_id",strty(slen(40)),props([prompt("User")])),field("tablename",strty(slen(40)),none),field("viewname",strty(slen(80)),props([prompt("Viewname")])),field("current_view",boolty,none),field("report_flag",boolty,none),field("data",strty(slen(20000)),none),field("frozen_column_info",strty(slen(30)),none)],props([partition(0)])).
table_descr("pro_view_current",[field("id",intty,none),field("user_id",strty(slen(40)),none),field("tablename",strty(slen(40)),none),field("viewname",strty(slen(80)),none)],props([partition(0)])).
table_descr("pro_view_state",[field("user_id",strty(slen(40)),none),field("workspace",strty(slen(100)),none),field("workpane_id",intty,none),field("viewtype",strty(slen(40)),none),field("viewname",strty(slen(80)),none),field("state",strty(slen(20000)),none)],props([partition(0)])).
table_descr("qc_points",[field("aircraft_type",strty(slen(4)),props([prompt("Aircraft type")])),field("operator",strty(slen(3)),props([sworst("WWW"),prompt("Operator")])),field("arrival_qc_points",realty,props([sworst("99.25"),prompt("Arrival QC points")])),field("departure_qc_points",realty,props([sworst("99.25"),prompt("Departure QC points")])),field("airport",strty(slen(3)),props([sworst("WWW"),prompt("Coordinated Airport")])),field("acreg",strty(slen(9)),props([prompt("ACReg")]))],props([partition(0)])).
table_descr("quota_operator",[field("quota_constraint_id",intty,none),field("operator",strty(slen(3)),none)],props([partition(0)])).
table_descr("reason_code",[field("reason_code",strty(slen(4)),props([upper,prompt("Reason code")])),field("exempt",boolty,props([prompt("Exempt")])),field("comment",strty(slen(80)),props([prompt("Comment")])),field("priority",intty,props([prompt("Priority")])),field("include_in_telex",boolty,props([prompt("Include Reason Code on Telex Messages")])),field("reason_code_group",intty,props([prompt("Reason Code Group")]))],props([partition(0)])).
table_descr("reason_code_group",[field("id",intty,none),field("name",strty(slen(20)),props([prompt("Group Name")])),field("description",strty(slen(80)),props([prompt("Description")]))],props([partition(0)])).
table_descr("register",[field("register_id",intty,none),field("telex_ref",strty(slen(80)),props([sworst("WWWWWWWWWWWWWWWWWWWWWW:20MAY00:16:11:48"),prompt("Telex Ref.")])),field("sender",strty(slen(80)),props([prompt("Sender")])),field("airport",strty(slen(4)),props([sworst("WWW"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season")])),field("date",minutety,props([prompt("Date")])),field("msg_type",strty(slen(10)),props([prompt("Msg. Type")])),field("ssim_lines",intty,props([prompt("SSim Lines")])),field("ssim_lines_illegal",intty,props([prompt("Illegal Lines")])),field("ssim_lines_nomatch",intty,props([prompt("Non matching lines")])),field("ssim_lines_processed",intty,props([prompt("Processed Lines")])),field("handling_user",strty(slen(40)),props([prompt("Handled by")])),field("user_id",strty(slen(40)),props([prompt("User")])),field("assigned_user_id",strty(slen(40)),props([prompt("Assigned User")])),field("archive_status",boolty,props([prompt("Archive Status")])),field("msg_id",intty,props([prompt("Message Id")])),field("log_id",intty,props([prompt("Log Id")])),field("msg_status",strty(slen(3)),none),field("time_changes",intty,props([prompt("Time Changes")])),field("aircraft_changes",intty,props([prompt("A/C Changes")])),field("route_changes",intty,props([prompt("Route Changes")])),field("service_type_changes",intty,props([prompt("Service Type Changes")])),field("additions",intty,props([prompt("Additions")])),field("deletions",intty,props([prompt("Deletions")])),field("intra_airline_swaps",intty,props([prompt("Intra Airline Swaps")])),field("inter_airline_swaps",intty,props([prompt("Inter Airline Swaps")])),field("pending_reply_sent",boolty,props([prompt("Pending Reply")])),field("incoming_date",minutety,none),field("change_lines",intty,props([prompt("Change lines")])),field("delete_lines",intty,props([prompt("Delete lines")])),field("new_lines",intty,props([prompt("New lines")])),field("generic_email_address",strty(slen(80)),props([prompt("Generic Email Address")])),field("subject",strty(slen(200)),props([prompt("Subject")])),field("cc",strty(slen(1000)),props([prompt("Cc")])),field("unread",boolty,props([prompt("Unread")]))],props([partition(0)])).
table_descr("res_set_parking_type",[field("id",intty,none),field("name",strty(slen(30)),none)],props([partition(0)])).
table_descr("resource",[field("resource_id",intty,none),field("resource_name",strty(slen(30)),props([prompt("Resource name")])),field("parent_resource_id",intty,none),field("resource_set_id",intty,none),field("allocation_order",intty,props([prompt("Allocation order")])),field("allocation_rule",strty(slen(2000)),none),field("terminal_name",strty(slen(30)),props([prompt("Terminal")])),field("split_arr_dep",boolty,props([prompt("Split Arr. and Dep.")])),field("taxi_time_arr",intty,props([prompt("Taxi Time Arr.")])),field("taxi_time_dep",intty,props([prompt("Taxi Time Dep.")]))],props([partition(0)])).
table_descr("resource_set",[field("resource_set_id",intty,none),field("user_id",strty(slen(40)),props([prompt("User Id")])),field("resource_set_name",strty(slen(20)),props([prompt("Resource set name")])),field("active",boolty,none),field("airport",strty(slen(4)),props([upper,prompt("Airport")])),field("season",strty(slen(3)),props([upper,prompt("Season")])),field("access_rights",strty(slen(5000)),props([prompt("Access Rights")])),field("build_parking_allocation",boolty,none),field("type",intty,props([sworst("Baseline"),prompt("Type")])),field("parking_type",intty,props([sworst("Advanced"),prompt("Parking")]))],props([partition(0)])).
table_descr("resource_set_kind",[field("id",intty,none),field("name",strty(slen(30)),none)],props([partition(0)])).
table_descr("result_off_slot_type",[field("type",strty(slen(10)),props([prompt("Type")]))],props([partition(0)])).
table_descr("runway_admix_constraint",[field("constraint_id",intty,none),field("generic_name_id",intty,props([prompt("Generic Name")])),field("resource_id",intty,none),field("description",strty(slen(40)),props([prompt("Description")])),field("usage_exp",strty(slen(2000)),props([prompt("Usage expression")])),field("below_level_4",intty,props([sworst("8888"),prompt("Below Level4")])),field("below_level_3",intty,props([sworst("8888"),prompt("Below Level3")])),field("below_level_2",intty,props([sworst("8888"),prompt("Below Level2")])),field("below_level_1",intty,props([sworst("8888"),prompt("Below Level1")])),field("above_level",intty,props([sworst("8888"),prompt("Above Level")])),field("use_taxi_time",boolty,props([prompt("Use Taxi Time (Y/N)")])),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("from_time",strty(slen(4)),props([upper,prompt("From time")])),field("to_time",strty(slen(4)),props([upper,prompt("To time")])),field("doop",strty(slen(7)),props([sworst("0000000"),prompt("Doop")])),field("array_id",intty,none),field("tolerance_rule",strty(slen(2000)),props([prompt("Tolerance rule")]))],props([partition(0)])).
table_descr("runway_admix_constraint_details",[field("constraint_id",intty,none),field("arr_warning",intty,props([sworst("123"),prompt("Arr. Warn.")])),field("dep_warning",intty,props([sworst("123"),prompt("Dep. Warn.")])),field("tot_warning",intty,props([sworst("123"),prompt("Tot. Warn.")])),field("arr_limit",intty,props([sworst("123"),prompt("Arr. Lim.")])),field("dep_limit",intty,props([sworst("123"),prompt("Dep. Lim.")])),field("tot_limit",intty,props([sworst("123"),prompt("Tot. Lim.")]))],props([partition(0)])).
table_descr("runway_buffer_details",[field("constraint_id",intty,none),field("a_d_t",strty(slen(1)),props([sworst("A"),upper,prompt("A/D/T")])),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("from_time",strty(slen(4)),props([upper,prompt("From time")])),field("to_time",strty(slen(4)),props([upper,prompt("To time")])),field("doop",strty(slen(7)),props([sworst("0000000"),prompt("Doop")])),field("buffer",intty,props([sworst("1234"),prompt("Buffer")]))],props([partition(0)])).
table_descr("runway_constraint",[field("constraint_id",intty,none),field("generic_name_id",intty,props([prompt("Generic Name")])),field("resource_id",intty,none),field("description",strty(slen(40)),props([prompt("Description")])),field("usage_exp",strty(slen(2000)),props([prompt("Usage expression")])),field("below_level_4",intty,props([sworst("8888"),prompt("Below Level4")])),field("below_level_3",intty,props([sworst("8888"),prompt("Below Level3")])),field("below_level_2",intty,props([sworst("8888"),prompt("Below Level2")])),field("below_level_1",intty,props([sworst("8888"),prompt("Below Level1")])),field("above_level",intty,props([sworst("8888"),prompt("Above Level")])),field("array_id",intty,none),field("use_taxi_time",boolty,props([prompt("Use Taxi Time (Y/N)")])),field("tolerance_rule",strty(slen(2000)),props([prompt("Tolerance rule")])),field("exclude_from_buffer",strty(slen(2000)),props([prompt("Exclude From Buffer")])),field("buffer_reason_code",strty(slen(4)),props([sworst("ILIL"),prompt("ReasonCode")]))],props([partition(0)])).
table_descr("runway_constraint_details",[field("constraint_id",intty,none),field("a_d_t",strty(slen(1)),props([sworst("A"),upper,prompt("A/D/T")])),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("from_time",strty(slen(4)),props([upper,prompt("From time")])),field("to_time",strty(slen(4)),props([upper,prompt("To time")])),field("doop",strty(slen(7)),props([sworst("0000000"),prompt("Doop")])),field("warning",intty,props([sworst("1234"),prompt("Warning")])),field("limit",intty,props([sworst("1234"),prompt("Limit")]))],props([partition(0)])).
table_descr("runway_factor",[field("constraint_id",intty,none),field("allocation_order",intty,props([prompt("Allocation order")])),field("usage_rule",strty(slen(2000)),props([prompt("Usage rule")])),field("factor",realty,props([sworst("1234"),prompt("Factor")]))],props([partition(0)])).
table_descr("runway_factor_constraint",[field("constraint_id",intty,none),field("generic_name_id",intty,props([prompt("Generic Name")])),field("resource_id",intty,none),field("description",strty(slen(40)),props([prompt("Description")])),field("usage_exp",strty(slen(2000)),props([prompt("Usage expression")])),field("below_level_4",intty,props([sworst("8888"),prompt("Below Level4")])),field("below_level_3",intty,props([sworst("8888"),prompt("Below Level3")])),field("below_level_2",intty,props([sworst("8888"),prompt("Below Level2")])),field("below_level_1",intty,props([sworst("8888"),prompt("Below Level1")])),field("above_level",intty,props([sworst("8888"),prompt("Above Level")])),field("array_id",intty,none),field("tolerance_rule",strty(slen(2000)),props([prompt("Tolerance rule")]))],props([partition(0)])).
table_descr("runway_factor_constraint_details",[field("constraint_id",intty,none),field("a_d_t",strty(slen(1)),props([sworst("A"),upper,prompt("A/D/T")])),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("from_time",strty(slen(4)),props([upper,prompt("From time")])),field("to_time",strty(slen(4)),props([upper,prompt("To time")])),field("doop",strty(slen(7)),props([sworst("0000000"),prompt("Doop")])),field("warning",intty,props([sworst("1234"),prompt("Warning")])),field("limit",intty,props([sworst("1234"),prompt("Limit")]))],props([partition(0)])).
table_descr("sa_semaphore",[field("name",strty(slen(60)),props([prompt("Name")])),field("agent_name",strty(slen(30)),props([prompt("Agent name")])),field("taken_time_stamp",strty(slen(34)),props([prompt("Taken at time")])),field("service_handle",intty,props([prompt("Service Handle")]))],props([partition(0)])).
table_descr("sam_request_id",[field("id",intty,props([prompt("Id")]))],props([partition(0)])).
table_descr("season",[field("season_code",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season code")])),field("from_date",datety,props([sworst("25MAR2012W"),upper,prompt("Start of season")])),field("to_date",datety,props([sworst("25MAR2012W"),upper,prompt("End of season")])),field("out_gen",boolty,props([prompt("Make reply from Change Screen")])),field("auto_move",boolty,props([prompt("Automove to req. msg. area")])),field("pending_reply",boolty,props([prompt("Make acknowledge message")])),field("scc_date",datety,props([sworst("25MAR2012W"),upper,prompt("End of SCC preparation")])),field("cutover_date",datety,props([sworst("25MAR2012W"),upper,prompt("Cutover date")])),field("scc_start",datety,props([sworst("25MAR2012W"),upper,prompt("SCC start date")])),field("disable_compression_and_bulk_change",boolty,props([prompt("Disable Compression and Bulk Change")]))],props([partition(0)])).
table_descr("send_address",[field("send_address_id",intty,none),field("send_group_id",intty,none),field("contact_id",intty,props([prompt("Contact Name")])),field("comment",strty(slen(50)),props([sworst("WWWWWWWWWWWWWWWWWWWWWW"),prompt("Comment")]))],props([partition(0)])).
table_descr("send_group",[field("send_group_id",intty,none),field("send_group_name",strty(slen(50)),props([prompt("Group Name")])),field("comment",strty(slen(50)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Comment")]))],props([partition(0)])).
table_descr("service_type",[field("service_type",strty(slen(1)),props([sworst("W"),upper,prompt("Service type")])),field("no_pax",boolty,props([prompt("No Seats")])),field("comment",strty(slen(80)),props([prompt("Comment")]))],props([partition(0)])).
table_descr("setting",[field("section_key",strty(slen(80)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Key")])),field("description",strty(slen(160)),props([prompt("Description")])),field("setting_type",intty,props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Type")])),field("setting_value",strty(slen(200)),props([prompt("Value")]))],props([partition(0)])).
table_descr("setting2",[field("id",intty,none),field("name",strty(slen(80)),none),field("details_type",intty,none),field("category",intty,props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Category")])),field("no_airport",boolty,none),field("description",strty(slen(160)),none)],props([partition(0)])).
table_descr("setting_category",[field("id",intty,none),field("name",strty(slen(30)),none)],props([partition(0)])).
table_descr("setting_details_active_string",[field("setting",intty,none),field("airport",strty(slen(3)),none),field("active",boolty,props([prompt("Active")])),field("string_value",strty(slen(200)),props([prompt("Value")]))],props([partition(0)])).
table_descr("setting_details_filter_email",[field("setting",intty,none),field("airport",strty(slen(3)),none),field("filter",strty(slen(80)),props([prompt("Filter")])),field("email",strty(slen(200)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Email")]))],props([partition(0)])).
table_descr("setting_details_integer",[field("setting",intty,none),field("airport",strty(slen(3)),none),field("integer_value",intty,props([sworst("WWWWW"),prompt("Value")]))],props([partition(0)])).
table_descr("setting_details_multi_integer",[field("setting",intty,none),field("airport",strty(slen(3)),none),field("integer_value",intty,props([prompt("Value")]))],props([partition(0)])).
table_descr("setting_details_multi_string",[field("setting",intty,none),field("airport",strty(slen(3)),none),field("string_value",strty(slen(80)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Value")]))],props([partition(0)])).
table_descr("setting_details_season",[field("setting",intty,none),field("airport",strty(slen(3)),none),field("season",strty(slen(3)),props([upper,prompt("Season")])),field("active",boolty,props([prompt("Active")]))],props([partition(0)])).
table_descr("setting_details_season_actype",[field("setting",intty,none),field("airport",strty(slen(3)),none),field("season",strty(slen(3)),props([upper,prompt("Season")])),field("actype_or_group",strty(slen(20)),props([prompt("Type/Group")]))],props([partition(0)])).
table_descr("setting_details_season_active_integer",[field("setting",intty,none),field("airport",strty(slen(3)),none),field("season",strty(slen(3)),props([upper,prompt("Season")])),field("active",boolty,props([prompt("Active")])),field("integer_value",intty,props([prompt("Value")]))],props([partition(0)])).
table_descr("setting_details_season_integer",[field("setting",intty,none),field("airport",strty(slen(3)),none),field("season",strty(slen(3)),props([upper,prompt("Season")])),field("integer_value",intty,props([prompt("Value")]))],props([partition(0)])).
table_descr("setting_details_season_multi_string",[field("setting",intty,none),field("airport",strty(slen(3)),none),field("season",strty(slen(3)),props([upper,prompt("Season")])),field("string_value",strty(slen(3)),props([prompt("Value")]))],props([partition(0)])).
table_descr("setting_details_season_servicetype_integer",[field("setting",intty,none),field("airport",strty(slen(3)),none),field("season",strty(slen(3)),props([upper,prompt("Season")])),field("servicetype",strty(slen(1)),props([prompt("Service type")])),field("integer",intty,props([prompt("Value")]))],props([partition(0)])).
table_descr("setting_details_season_string",[field("setting",intty,none),field("airport",strty(slen(3)),none),field("season",strty(slen(3)),props([upper,prompt("Season")])),field("string_value",strty(slen(200)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Value")]))],props([partition(0)])).
table_descr("setting_details_season_7",[field("setting",intty,none),field("airport",strty(slen(3)),none),field("season",strty(slen(3)),props([upper,prompt("Season")])),field("no_yes_onlyooh",strty(slen(10)),props([prompt("Value")]))],props([partition(0)])).
table_descr("setting_details_season_11",[field("setting",intty,none),field("airport",strty(slen(3)),none),field("season",strty(slen(3)),props([upper,prompt("Season")])),field("singleday_adhoc_seasonal",strty(slen(25)),props([prompt("Value")]))],props([partition(0)])).
table_descr("setting_details_string",[field("setting",intty,none),field("airport",strty(slen(3)),none),field("string_value",strty(slen(200)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Value")]))],props([partition(0)])).
table_descr("setting_details_two_integers",[field("setting",intty,none),field("airport",strty(slen(3)),none),field("integer1",intty,props([sworst("WWWWW"),prompt("From value")])),field("integer2",intty,props([sworst("WWWWW"),prompt("To value")]))],props([partition(0)])).
table_descr("setting_details_type",[field("id",intty,none),field("description",strty(slen(80)),none)],props([partition(0)])).
table_descr("setting_type",[field("type_id",intty,none),field("type_name",strty(slen(20)),props([prompt("Name")])),field("description",strty(slen(80)),props([prompt("Description")]))],props([partition(0)])).
table_descr("shl_params",[field("shl_params_id",intty,none),field("disregard_stations",boolty,props([prompt("Disregard stations")])),field("disregard_actypes_within_weekday",boolty,props([prompt("Disregard A/C Types within a Weekday")])),field("disregard_actypes_across_weekdays",boolty,props([prompt("Disregard A/C Types across Weekdays")])),field("disregard_timings",boolty,props([prompt("Disregard Timings")])),field("disregard_service_types",boolty,props([prompt("Disregard Service Types")])),field("min_week_period",intty,props([upper,prompt("Min Week Period")])),field("max_empty_week_span",intty,props([upper,prompt("Max Empty Week Span")])),field("min_week_overlap",intty,none)],props([partition(0)])).
table_descr("slot_link_sequence",[field("airport",strty(slen(3)),props([sworst("ARF"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("W01"),upper,prompt("Season")])),field("seq",intty,props([prompt("Seq")]))],props([partition(0)])).
table_descr("slot_monitoring",[field("airport",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season code")])),field("date",datety,props([prompt("Last Matched Date")])),field("use_it_lose_it",boolty,none),field("branch_kind",intty,props([sworst("HISTORICAL BASELINE"),prompt("Branch Kind")]))],props([partition(0)])).
table_descr("slot_monitoring_actual",[field("id",intty,none),field("airport",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season code")])),field("operator",strty(slen(3)),props([sworst("ARF"),upper,prompt("Ope")])),field("service_no",strty(slen(8)),props([sworst("8888W"),upper,prompt("Serv.No")])),field("arrival_departure",strty(slen(1)),props([sworst("A"),upper,prompt("Arr/Dep")])),field("date_sched",datety,props([upper,prompt("Sched. Date")])),field("date_actual",datety,props([upper,prompt("Act. Date")])),field("time_sched",strty(slen(4)),props([prompt("Sched. Time")])),field("time_actual",strty(slen(4)),props([prompt("Act. Time")])),field("ac_type",strty(slen(4)),props([sworst("ARF"),upper,prompt("A/C")])),field("seats",intty,props([sworst("8888"),prompt("Seats")])),field("terminal",strty(slen(30)),props([prompt("Terminal")])),field("orig_dest",strty(slen(3)),props([sworst("MOW"),upper,prompt("Orig/Dest Stn")])),field("last_next",strty(slen(3)),props([sworst("MOW"),upper,prompt("Last/Next Stn")])),field("divert_flag",boolty,props([prompt("Diverted flag")])),field("duplicate_no",intty,props([prompt("Duplicate No.")])),field("misc",strty(slen(80)),props([prompt("Misc")])),field("date_touch_down",datety,props([upper,prompt("Runway Date")])),field("time_touch_down",strty(slen(4)),props([prompt("Runway Time")])),field("imma",strty(slen(20)),props([upper,prompt("IMMA")])),field("acreg",strty(slen(9)),props([upper,prompt("ACReg")])),field("iobt_date",datety,props([upper,prompt("IOBT Date")])),field("iobt_time",strty(slen(4)),props([prompt("IOBT Time")])),field("misc2",strty(slen(80)),props([prompt("Misc2")]))],props([partition(0)])).
table_descr("slot_monitoring_actual_filter",[field("slot_monitoring_actual_filter_id",intty,none),field("slot_monitoring_actual_filter_name",strty(slen(30)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Filter Expression Name")])),field("slot_monitoring_actual_filter",strty(slen(20000)),props([prompt("Slot Mon Actual Filter")]))],props([partition(0)])).
table_descr("slot_monitoring_coord_type",[field("coord_type",strty(slen(10)),props([prompt("Coord Type")]))],props([partition(0)])).
table_descr("slot_monitoring_flight",[field("airport",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season code")])),field("flight_operator_coord_actual",strty(slen(3)),props([sworst("ARF"),upper,prompt("Coord/Act Ope")])),field("flight_service_no_coord_actual",strty(slen(9)),props([sworst("8888W"),upper,prompt("Coord/Act Serv.No")])),field("flight_operator_coord",strty(slen(3)),props([sworst("ARF"),upper,prompt("Coord. Ope")])),field("flight_service_no_coord",strty(slen(9)),props([sworst("8888W"),upper,prompt("Coord. Serv.No")])),field("flight_operator_actual",strty(slen(3)),props([sworst("ARF"),upper,prompt("Act. Ope")])),field("flight_service_no_actual",strty(slen(9)),props([sworst("8888W"),upper,prompt("Act. Serv.No")])),field("arrival_departure",strty(slen(1)),props([sworst("A"),upper,prompt("Arr/Dep")])),field("date_coord_actual",datety,none),field("time_coord_actual",strty(slen(4)),none),field("date_coord",datety,props([upper,prompt("Coord. Date")])),field("date_sched",datety,props([upper,prompt("Sched. Date")])),field("date_actual",datety,props([upper,prompt("Act. Date")])),field("time_coord",strty(slen(4)),props([prompt("Coord. Time")])),field("time_required",strty(slen(5)),props([prompt("Req. Time")])),field("time_initial_required",strty(slen(5)),props([prompt("Init. Req. Time")])),field("time_sched",strty(slen(4)),props([prompt("Sched. Time")])),field("time_actual",strty(slen(4)),props([prompt("Act. Time")])),field("off_clear_time",intty,props([prompt("Off Cleared Time")])),field("off_req_time",intty,props([prompt("Off Req. Time")])),field("off_initial_req_time",intty,props([prompt("Off Init. Req. Time")])),field("ac_type_coord",strty(slen(3)),props([sworst("ARF"),upper,prompt("Coord. A/C")])),field("ac_type_actual",strty(slen(3)),props([sworst("ARF"),upper,prompt("Act. A/C")])),field("seats_coord",intty,props([sworst("8888"),prompt("Coord. Seats")])),field("seats_actual",intty,props([sworst("8888"),prompt("Act. Seats")])),field("terminal_coord",strty(slen(30)),props([prompt("Coord. Terminal")])),field("terminal_actual",strty(slen(30)),props([prompt("Act. Terminal")])),field("service_type_coord",strty(slen(1)),props([sworst("I"),upper,prompt("Coord. Service Type")])),field("last_next_coord",strty(slen(3)),props([sworst("MOW"),upper,prompt("Coord. Last/Next Stn")])),field("last_next_actual",strty(slen(3)),props([sworst("MOW"),upper,prompt("Act. Last/Next Stn")])),field("orig_dest_coord",strty(slen(3)),props([sworst("MOW"),upper,prompt("Coord. Orig/Dest Stn")])),field("orig_dest_actual",strty(slen(3)),props([sworst("MOW"),upper,prompt("Act. Orig/Dest Stn")])),field("divert_flag",boolty,props([prompt("Diverted flag")])),field("exclude_flag",boolty,props([prompt("Excluded flag")])),field("dispense_flag",boolty,props([prompt("Dispensation")])),field("record_type",strty(slen(1)),props([sworst("MOW"),upper,prompt("Record type")])),field("match_status",strty(slen(4)),props([sworst("8888"),upper,prompt("Status")])),field("session_number",intty,none),field("date_touch_down",datety,props([upper,prompt("Runway Date")])),field("time_touch_down",strty(slen(4)),props([prompt("Runway Time")])),field("imma",strty(slen(20)),props([prompt("Imma")])),field("actual_misc",strty(slen(80)),props([prompt("Act. Extra")])),field("counting",boolty,props([prompt("Counting")])),field("counting_overwritten",boolty,props([prompt("Counting Overwritten")])),field("doop_coord",strty(slen(1)),props([prompt("Coord. DOOP")])),field("coord_type",strty(slen(10)),props([prompt("Coord. Type")])),field("acreg",strty(slen(9)),props([upper,prompt("ACReg")])),field("iobt_date",datety,props([upper,prompt("IOBT Date")])),field("iobt_time",strty(slen(4)),props([prompt("IOBT Time")])),field("contact_details",strty(slen(50)),props([prompt("Contact Details")])),field("update_result_date",datety,props([upper,prompt("Update Result Date")])),field("actual_misc2",strty(slen(80)),props([prompt("Act. Extra2")]))],props([partition(0)])).
table_descr("slot_monitoring_flight_filter",[field("slot_monitoring_flight_filter_id",intty,none),field("slot_monitoring_flight_filter_name",strty(slen(30)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Filter Expression Name")])),field("slot_monitoring_flight_filter",strty(slen(20000)),props([prompt("Slot Mon Flight Filter")]))],props([partition(0)])).
table_descr("slot_monitoring_result",[field("airport",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season code")])),field("flight_operator",strty(slen(3)),props([sworst("ARF"),upper,prompt("Ope")])),field("flight_service_no",strty(slen(5)),props([sworst("8888W"),upper,prompt("Service No")])),field("arrival_departure",strty(slen(1)),props([sworst("A"),upper,prompt("A/D")])),field("start_date",datety,props([upper,prompt("Start Date")])),field("end_date",datety,props([upper,prompt("End Date")])),field("weekday",intty,props([sworst("1"),prompt("Weekday")])),field("woop",intty,props([sworst("1"),prompt("Woop")])),field("time",strty(slen(4)),props([sworst("1000"),prompt("Time")])),field("baseline_num_ope",intty,props([sworst("8888"),prompt("Baseline Num Operations")])),field("use_it_or_lose_it_num_ope",intty,props([sworst("8888"),prompt("Use It or Lose It Num Operations")])),field("target_num_ope",intty,props([sworst("8888"),prompt("Target Num Operations")])),field("cancellations",intty,props([sworst("8888"),prompt("Cancellations")])),field("non_operations",intty,props([sworst("8888"),prompt("Non-operations")])),field("operations_not_counting",intty,props([sworst("8888"),prompt("Not Counting Operations")])),field("operations_counting",intty,props([sworst("8888"),prompt("Counting Operations")])),field("planned_remaining_num_ope",intty,props([sworst("8888"),prompt("Planned Remaining Operations")])),field("projected_slot_usage",intty,props([sworst("8888"),prompt("Projected Slot Usage")])),field("avg_off_cleared_time",intty,props([sworst("8888"),prompt("Avg off Cle")])),field("stdev_off_cleared_time",intty,props([sworst("8888"),prompt("Stdev off Cle")])),field("min_off_cleared_time",intty,props([sworst("8888"),prompt("Min off Cle")])),field("max_off_cleared_time",intty,props([sworst("8888"),prompt("Max off Cle")])),field("slot_link",intty,props([sworst("8888"),prompt("Slot Link")])),field("hist_period",boolty,props([sworst("8888"),prompt("Hist Period (Y/N)")])),field("updated_to_date",datety,props([prompt("Updated to")])),field("sig_off_slot",strty(slen(10)),props([sworst("Early"),prompt("Sig Off Slot")])),field("change_of_day_num_ope",intty,props([sworst("8888"),prompt("Change of Day")])),field("slot_holder",strty(slen(3)),props([sworst("ARF"),upper,prompt("Slot Holder")])),field("slot_holder_link",strty(slen(17)),props([sworst("8888-0000-0000-00"),upper,prompt("Slot Holder Link")])),field("short_note",strty(slen(50)),props([sworst("kkkkkllllloooooppppphhhhhllllloooookkkkktttttmmmmm"),prompt("Short Note")])),field("num_dispensations",intty,props([sworst("10"),prompt("Dispensation")])),field("origin_destination",strty(slen(3)),props([sworst("MOW"),upper,prompt("OrigDest")])),field("wsg_use_it_or_lose_it",intty,props([sworst("8888"),prompt("WSG U/L ops")])),field("wsg_use_it_or_lose_it_link",intty,props([sworst("8888"),prompt("WSG U/L Link")])),field("seats",intty,props([sworst("8888"),prompt("Seats")])),field("ac_type",strty(slen(3)),props([sworst("ARF"),upper,prompt("A/C")])),field("projected_total_usage",intty,props([sworst("8888"),prompt("Projected Total Usage")])),field("ul_sum_seats",intty,props([sworst("8888"),prompt("WSG U/L Sum Seats")])),field("projected_sum_seats",intty,props([sworst("8888"),prompt("Projected Sum Seats")])),field("ul_sum_seats_single_flight",intty,props([sworst("8888"),prompt("U/L Sum Seats")]))],props([partition(0)])).
table_descr("slot_monitoring_result_filter",[field("slot_monitoring_result_filter_id",intty,none),field("slot_monitoring_result_filter_name",strty(slen(30)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Filter Expression Name")])),field("slot_monitoring_result_filter",strty(slen(20000)),props([prompt("Slot Mon Result Filter")]))],props([partition(0)])).
table_descr("slot_monitoring_type",[field("record_type",strty(slen(1)),props([upper,prompt("Type")]))],props([partition(0)])).
table_descr("slot_mon_cancellation",[field("airport",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season code")])),field("flight_operator",strty(slen(3)),props([sworst("ARF"),upper,prompt("Ope")])),field("flight_service_no",strty(slen(8)),props([sworst("8888W"),upper,prompt("Serv.No")])),field("arrival_departure",strty(slen(1)),props([sworst("A"),upper,prompt("Arr/Dep")])),field("date_coord",datety,props([upper,prompt("Coord. Date")])),field("weekday",intty,props([sworst("1"),prompt("Weekday")])),field("date_deleted",datety,props([upper,prompt("Deleted Date")])),field("included_in_calculation",boolty,props([prompt("In Calculation")])),field("create_date",datety,props([upper,prompt("Create date")])),field("ac_reg",strty(slen(9)),props([prompt("A/C Reg")])),field("slot_holder",strty(slen(3)),props([sworst("ARF"),upper,prompt("Slot Holder")])),field("slot_holder_number",strty(slen(17)),props([sworst("8888-0000-0000-00"),upper,prompt("Slot Holder No")])),field("cancellation_notice",intty,props([sworst("100"),upper,prompt("Canx Notice")])),field("booking_notice",intty,props([sworst("100"),upper,prompt("Booking Notice")])),field("in_live",boolty,props([prompt("In Live Y/N")])),field("dispensation",boolty,props([prompt("Dispensation")])),field("orig_dest",strty(slen(3)),props([sworst("MOW"),upper,prompt("Coord. Orig/Dest Stn")])),field("time_coord",strty(slen(4)),props([prompt("Coord. Time")])),field("time_deleted",strty(slen(4)),props([prompt("Deleted Time")])),field("note",strty(slen(80)),props([prompt("Note")])),field("user_id",strty(slen(40)),props([prompt("User")]))],props([partition(0)])).
table_descr("slot_mon_cancellation_filter",[field("slot_mon_cancellation_filter_id",intty,none),field("slot_mon_cancellation_filter_name",strty(slen(30)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Filter Expression Name")])),field("slot_mon_cancellation_filter",strty(slen(20000)),props([prompt("Slot Mon Cancellation Filter")]))],props([partition(0)])).
table_descr("slot_mon_taxi_time",[field("airport",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season code")])),field("taxi_time_arr",intty,props([prompt("Taxi Time Arr")])),field("taxi_time_dep",intty,props([prompt("Taxi Time Dep")])),field("use_taxi_time",boolty,props([prompt("Use Taxi Time")]))],props([partition(0)])).
table_descr("slot_swap",[field("slot_swap_id",intty,props([prompt("SlotSwapId")])),field("airport",strty(slen(3)),props([sworst("ARF"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("W01"),upper,prompt("Season")])),field("operator_arrival_departure",strty(slen(3)),props([prompt("ADOp")])),field("service_no_arrival_departure",strty(slen(5)),props([prompt("ADServNo")])),field("operator_arrival",strty(slen(3)),props([sworst("ARF"),upper,prompt("AOpe")])),field("service_no_arrival",strty(slen(5)),props([sworst("8888W"),upper,prompt("AServNo")])),field("operator_departure",strty(slen(3)),props([sworst("ARF"),upper,prompt("DOpe")])),field("service_no_departure",strty(slen(5)),props([sworst("8888W"),upper,prompt("DServNo")])),field("start_date",datety,props([upper,prompt("From")])),field("end_date",datety,props([upper,prompt("To")])),field("doop",strty(slen(7)),props([sworst("1234567"),prompt("DOOP")])),field("num_seats",intty,props([sworst("8888"),prompt("Seats")])),field("aircraft_type",strty(slen(3)),props([sworst("ARF"),upper,prompt("A/C")])),field("origin_station",strty(slen(3)),props([sworst("MOW"),upper,prompt("Orig")])),field("last_station",strty(slen(3)),props([sworst("MOW"),upper,prompt("Last")])),field("cleared_time_arrival",strty(slen(4)),props([prompt("ATime")])),field("cleared_time_departure",strty(slen(4)),props([prompt("DTime")])),field("turnaround_days",intty,props([sworst("0"),prompt("TD")])),field("next_station",strty(slen(3)),props([sworst("MOW"),upper,prompt("Next")])),field("destination_station",strty(slen(3)),props([sworst("MOW"),upper,prompt("Dest")])),field("service_type_arrival",strty(slen(1)),props([sworst("I"),upper,prompt("AST")])),field("service_type_departure",strty(slen(1)),props([sworst("I"),upper,prompt("DST")])),field("woop",intty,props([sworst("8"),prompt("WOOP")])),field("aircraft_registration",strty(slen(9)),props([upper,prompt("ACReg")])),field("required_time_arrival",strty(slen(5)),props([prompt("AReq")])),field("required_time_departure",strty(slen(5)),props([prompt("DReq")])),field("reason_code_arr",strty(slen(4)),props([sworst("ILIL"),prompt("AReasonCode")])),field("reason_code_dep",strty(slen(4)),props([sworst("ILIL"),prompt("DReasonCode")])),field("hist_status_arr",strty(slen(4)),props([sworst("ILIL"),prompt("AHistStat")])),field("hist_status_dep",strty(slen(4)),props([sworst("ILIL"),prompt("DHistStat")])),field("slot_holder_arr",strty(slen(3)),props([sworst("ARF"),upper,prompt("ASlotHold")])),field("slot_holder_service_no_arr",strty(slen(17)),props([upper,prompt("ASlotHolNo")])),field("slot_holder_dep",strty(slen(3)),props([sworst("ARF"),upper,prompt("DSlotHold")])),field("slot_holder_service_no_dep",strty(slen(17)),props([upper,prompt("DSlotHolNo")])),field("ssim_action_flag",strty(slen(1)),props([upper,prompt("SSIM")])),field("creation_date",minutety,props([prompt("CreDate")])),field("user_id",strty(slen(40)),props([prompt("User")])),field("historic_time_arr",strty(slen(4)),props([prompt("AHist")])),field("historic_time_dep",strty(slen(4)),props([prompt("DHist")])),field("initial_required_time_arr",strty(slen(5)),props([prompt("AInitReq")])),field("initial_required_time_dep",strty(slen(5)),props([prompt("DInitReq")])),field("min_ground_time",intty,props([prompt("MinGTime")])),field("priority_arr",intty,props([prompt("APrio")])),field("priority_dep",intty,props([prompt("DPrio")])),field("company_name",strty(slen(80)),props([prompt("Company")])),field("note_id",intty,props([prompt("Note")])),field("ssim_action_flag_operator",strty(slen(1)),props([prompt("SSIM ope.")])),field("ringfenced",boolty,props([prompt("Ringfenced")])),field("offer_time_arr_from",strty(slen(4)),props([prompt("OfferATimeFrom")])),field("offer_time_arr_to",strty(slen(4)),props([prompt("OfferATimeTo")])),field("offer_time_dep_from",strty(slen(4)),props([prompt("OfferDTimeFrom")])),field("offer_time_dep_to",strty(slen(4)),props([prompt("OfferDTimeTo")])),field("date_time_stamp",minutety,props([prompt("Date Time")])),field("no_of_operations",intty,props([prompt("NofOp")])),field("artificial_swap",boolty,props([prompt("Artificial Swap (Y/N)")]))],props([partition(0)])).
table_descr("slot_swap_id",[field("airport",strty(slen(3)),props([sworst("ARF"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("W01"),upper,prompt("Season")])),field("id",intty,props([prompt("Id")]))],props([partition(0)])).
table_descr("special_ops_code",[field("special_ops_code",strty(slen(10)),props([upper,prompt("Special Ops Code")])),field("comment",strty(slen(80)),props([sworst("W12345678901234567890"),prompt("Comment")]))],props([partition(0)])).
table_descr("ssim_action_code_coord",[field("name",strty(slen(1)),props([sworst("W"),upper,prompt("NAME")])),field("comment",strty(slen(40)),props([prompt("Comment")]))],props([partition(0)])).
table_descr("ssim_action_code_operator",[field("name",strty(slen(1)),props([sworst("W"),upper,prompt("NAME")])),field("comment",strty(slen(40)),props([prompt("Comment")]))],props([partition(0)])).
table_descr("stand",[field("id",intty,none),field("name",strty(slen(40)),props([prompt("Stand")])),field("constraint_id",intty,none),field("allocation_order",intty,props([sworst("20"),prompt("Allocation Order")])),field("buffer_time",intty,props([sworst("120"),prompt("Buffer Time")])),field("preferred_operators",strty(slen(2000)),none),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("preferred_route",strty(slen(2000)),none),field("preferred_filter_exp",strty(slen(2000)),none),field("preferred_filter_exp_list",strty(slen(2000)),props([prompt("Preferred Expressions")])),field("excluded_filter_exp_list",strty(slen(2000)),props([prompt("Excluded Expressions")]))],props([partition(0)])).
table_descr("stand_adv",[field("id",intty,none),field("name",strty(slen(40)),props([prompt("Stand")])),field("pool_id",intty,none),field("allocation_order",intty,props([sworst("20"),prompt("Allocation Order")])),field("buffer_time",intty,props([sworst("120"),prompt("Buffer Time")])),field("preferred_operators",strty(slen(2000)),none),field("from_date",datety,props([upper,prompt("From date")])),field("to_date",datety,props([upper,prompt("To date")])),field("preferred_route",strty(slen(2000)),none),field("preferred_filter_exp",strty(slen(2000)),none),field("preferred_filter_exp_list",strty(slen(2000)),props([prompt("Preferred Expressions")])),field("excluded_filter_exp_list",strty(slen(2000)),props([prompt("Excluded Expressions")])),field("reserved_filter_exp_list",strty(slen(2000)),props([prompt("Reserved Expressions")]))],props([partition(0)])).
table_descr("stand_adjacency",[field("constraint_id",intty,none),field("stand1_id",intty,props([sworst("WWWWWWWWW"),prompt("1st Stand")])),field("stand1_filter_exp",strty(slen(2000)),props([prompt("Adjacency Rule")])),field("stand2_id",intty,props([sworst("WWWWWWWWW"),prompt("2nd Stand")])),field("stand2_filter_exp",strty(slen(2000)),props([prompt("Adjacency Rule")])),field("id",intty,none)],props([partition(0)])).
table_descr("stand_filter_expression",[field("id",intty,none),field("name",strty(slen(30)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Name")])),field("airport",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport")])),field("filter_expression",strty(slen(20000)),props([prompt("Flight Filter Expression")]))],props([partition(0)])).
table_descr("stand_local_filter",[field("resource_set_id",intty,none),field("name",strty(slen(40)),props([prompt("Name")])),field("field_value_list",strty(slen(10000)),props([prompt("Filter")]))],props([partition(0)])).
table_descr("status_information_reason",[field("text",strty(slen(10)),props([sworst("WWWWWWWWWW"),upper,prompt("Reason")])),field("comment",strty(slen(80)),props([prompt("Comment")]))],props([partition(0)])).
table_descr("t_user",[field("id",intty,none),field("name",strty(slen(40)),props([upper,prompt("User Name")])),field("usergroup",intty,props([prompt("User Group")])),field("password1",strty(slen(80)),props([prompt("Password")])),field("password2",strty(slen(80)),props([prompt("Retype Password")])),field("comment",strty(slen(80)),props([prompt("Comment")])),field("active_directory_login",boolty,props([prompt("Windows login (Y/N)")]))],props([partition(0)])).
table_descr("t_values",[field("no_of_ops",intty,props([prompt("No of Ops")])),field("t_value",realty,props([prompt("T Value")]))],props([partition(0)])).
table_descr("tactical_availability",[field("airport",strty(slen(3)),none),field("season",strty(slen(3)),none),field("arr_dep",strty(slen(1)),none),field("date_time",minutety,none),field("limit",intty,none)],props([partition(0)])).
table_descr("tactical_availability_array",[field("airport",strty(slen(3)),none),field("season",strty(slen(3)),none),field("array",binty,none)],props([partition(0)])).
table_descr("telex_addresses",[field("telex_address_id",intty,none),field("address",strty(slen(50)),props([prompt("Address")])),field("address_group",strty(slen(25)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),upper,prompt("Group")])),field("comment",strty(slen(40)),props([sworst("WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW"),prompt("Comment")]))],props([partition(0)])).
table_descr("temp_actual_flight",[field("id",intty,props([prompt("ID")])),field("airport",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport")])),field("season",strty(slen(3)),props([sworst("WWW"),upper,prompt("Season code")])),field("carrier",strty(slen(3)),props([sworst("ARF"),upper,prompt("Ope")])),field("flightnumber",strty(slen(4)),props([sworst("8888"),upper,prompt("Flight No.")])),field("suffix",strty(slen(1)),props([sworst("a"),upper,prompt("Suffix")])),field("scheduledate",strty(slen(8)),props([upper,prompt("Sched. Date")])),field("scheduletime",strty(slen(4)),props([prompt("Sched. Time")])),field("actualblockdate",strty(slen(8)),props([upper,prompt("Block Date")])),field("actualblocktime",strty(slen(4)),props([prompt("Block Time")])),field("movementtype",strty(slen(1)),props([sworst("A"),upper,prompt("Arr/Dep")])),field("aircrafttype",strty(slen(4)),props([sworst("ARF"),upper,prompt("A/C")])),field("movementtime",strty(slen(4)),props([prompt("Mov. Time")])),field("delaycodes",strty(slen(20)),props([upper,prompt("Delay Codes")])),field("loaded",boolty,props([prompt("Loaded Y/N")])),field("registration",strty(slen(12)),props([upper,prompt("Registration")]))],props([partition(0)])).
table_descr("towing",[field("airport",strty(slen(3)),props([sworst("WWW"),upper,prompt("Airport")])),field("ac_type_group",intty,props([prompt("A/C Type Group")])),field("operator",strty(slen(3)),props([sworst("WWWW"),prompt("Operator")])),field("tow_out_after",intty,props([prompt("Tow Out After")])),field("tow_in_before",intty,props([prompt("Tow In Before")])),field("min_break",intty,props([prompt("Min. Break")])),field("comment",strty(slen(80)),props([prompt("Comment")])),field("ac_type",strty(slen(3)),props([prompt("Aircraft Type")])),field("terminal",strty(slen(30)),props([prompt("Terminal")]))],props([partition(0)])).
table_descr("user_group",[field("id",intty,none),field("name",strty(slen(40)),props([upper,prompt("Name")])),field("comment",strty(slen(80)),props([prompt("Comment")])),field("access_right_data",strty(slen(10000)),props([prompt("Access Rights")]))],props([partition(0)])).
table_descr("waitlist_priority",[field("service_type",strty(slen(1)),props([prompt("Service type")])),field("airport",strty(slen(3)),props([sworst("WWW"),prompt("Airport")])),field("priority",intty,props([sworst("000"),prompt("Priority")]))],props([partition(0)])).
table_descr("sequence",[field("no",intty,none)],props([partition(0)])).
table_descr("old_sequence",[field("no",intty,none)],props([partition(0)])).
table_descr("meta_table",[field("table_name",strty(slen(30)),none),field("Description",strty(slen(200)),none),field("prompt",strty(slen(30)),none),field("in_cache",boolty,none),field("details_table",strty(slen(30)),none),field("val_from",strty(slen(14)),none),field("val_to",strty(slen(14)),none),field("scope",strty(slen(40)),none)],props([partition(0)])).
table_descr("meta_inter_field_constraint",[field("table_name",strty(slen(30)),none),field("inter_field_constraint",strty(slen(200)),none),field("comment",strty(slen(200)),none),field("val_from",strty(slen(14)),none),field("val_to",strty(slen(14)),none)],props([partition(0)])).
table_descr("meta_field",[field("field_id",intty,none),field("table_name",strty(slen(30)),none),field("field_name",strty(slen(30)),none),field("description",strty(slen(200)),none),field("primary_key",boolty,none),field("alt_key",boolty,none),field("alt_key_no",intty,none),field("type",strty(slen(10)),none),field("length",intty,none),field("default_value",strty(slen(30)),none),field("null_allowed",boolty,none),field("visible",boolty,none),field("outdated",boolty,none),field("val_from",strty(slen(14)),none),field("val_to",strty(slen(14)),none),field("virtual_copy",strty(slen(30)),none),field("virtual_custom",strty(slen(30)),none),field("initial_value",strty(slen(60)),none)],props([partition(0)])).
table_descr("meta_field_presentation",[field("field_id",intty,none),field("lookup_ref_field",intty,none),field("lookup_field",intty,none),field("lookup_alt_field",intty,none),field("prompt",strty(slen(20)),none),field("prompt2",strty(slen(20)),none),field("ctl_type",strty(slen(20)),none),field("format_str",strty(slen(80)),none),field("upper",boolty,none),field("worst_str",strty(slen(30)),none),field("mandatory",boolty,none),field("editable",boolty,none),field("val_from",strty(slen(14)),none),field("val_to",strty(slen(14)),none)],props([partition(0)])).
table_descr("meta_field_constraint",[field("field_id",intty,none),field("value_constraint",strty(slen(100)),none),field("comment",strty(slen(200)),none),field("val_from",strty(slen(14)),none),field("val_to",strty(slen(14)),none)],props([partition(0)])).
table_descr("meta_dialogue_layout",[field("field_id",intty,none),field("row_no",intty,none),field("col_no",intty,none),field("visit_order",intty,none),field("val_from",strty(slen(14)),none),field("val_to",strty(slen(14)),none)],props([partition(0)])).
table_descr("meta_index",[field("index_id",intty,none),field("index_name",strty(slen(50)),none),field("table_name",strty(slen(30)),none),field("description",strty(slen(200)),none),field("primary_index",boolty,none),field("val_from",strty(slen(14)),none),field("val_to",strty(slen(14)),none),field("prolog_index",boolty,none)],props([partition(0)])).
table_descr("meta_index_field",[field("index_id",intty,none),field("field_id",intty,none),field("field_order",intty,none),field("val_from",strty(slen(14)),none),field("val_to",strty(slen(14)),none)],props([partition(0)])).
table_descr("meta_foreign_key",[field("field_id",intty,none),field("foreign_field_id",intty,none),field("key_number",intty,none),field("val_from",strty(slen(14)),none),field("val_to",strty(slen(14)),none)],props([partition(0)])).
table_descr("meta_database_version",[field("time_stamp",strty(slen(13)),none)],props([partition(0)])).
index_descr("actual_night_count_ix","actual_night_count",[field("airport"),field("season"),field("operator"),field("constraint_id")],props([partition(0)])).
index_descr("additional_si_text_ix","additional_si_text",[field("airport"),field("season")],props([partition(0)])).
index_descr("agent_response_ix","agent_response",[field("request_id"),field("request_response_id")],props([partition(0)])).
index_descr("aircraft_type_ix1","aircraft_type",[field("aircraft_type"),field("icao_aircraft_type")],props([partition(0)])).
index_descr("aircraft_type_expanded_ix","aircraft_type_expanded",[field("id"),field("aircraft_type")],props([partition(0)])).
index_descr("AIRCRAFT_TYPE_GROUP_IX1","aircraft_type_group",[field("aircraft_type_group"),field("aircraft_type")],props([partition(0)])).
index_descr("AIRCRAFT_TYPE_GROUP_IX2","aircraft_type_group",[field("aircraft_type"),field("airport")],props([partition(0)])).
index_descr("AIRCRAFT_TYPE_GROUP_IX3","aircraft_type_group",[field("airport"),field("aircraft_type")],props([partition(0)])).
index_descr("aircraft_type_group_name_ix1","aircraft_type_group_name",[field("id")],props([partition(0)])).
index_descr("aircraft_type_group_name_ix2","aircraft_type_group_name",[field("name")],props([partition(0)])).
index_descr("airport_ix1","airport",[field("airport_id")],props([partition(0)])).
index_descr("airport_ix2","airport",[field("IATA_code"),field("ICAO_code")],props([partition(0)])).
index_descr("airport_setting_ix","airport_setting",[field("setting"),field("airport")],props([partition(0)])).
index_descr("archive_ix1","archive",[field("archive_id")],props([partition(0)])).
index_descr("archive_date_ix","archive",[field("date"),field("archive_id")],props([partition(0)])).
index_descr("archiveMsgIdIndex","archive",[field("msg_id"),field("archive_id")],props([partition(0)])).
index_descr("arr_dep_constraint_id_ix","arr_dep_constraint",[field("arr_dep_constraint_id")],props([partition(0)])).
index_descr("arr_dep_constraint_name_ix","arr_dep_constraint",[field("name")],props([partition(0)])).
index_descr("audit_log_ix","audit_log",[field("id")],props([partition(0)])).
index_descr("audit_kind_ix1","audit_kind",[field("id")],props([partition(0)])).
index_descr("audit_kind_ix2","audit_kind",[field("kind")],props([partition(0)])).
index_descr("aux_actype_or_group_ix","aux_actype_or_group",[field("linking_type")],props([partition(0)])).
index_descr("aux_no_yes_onlyooh_ix","aux_no_yes_onlyooh",[field("no_yes_onlyooh")],props([partition(0)])).
index_descr("aux_singleday_adhoc_seasonal_ix","aux_singleday_adhoc_seasonal",[field("singleday_adhoc_seasonal")],props([partition(0)])).
index_descr("base_table_update_ix","base_table_update",[field("table_name")],props([partition(0)])).
index_descr("baseline_automation_parameter_ix","baseline_automation_parameter",[field("airport"),field("season"),field("apply_to_amp")],props([partition(0)])).
index_descr("catagories_ix1","catagories",[field("cat_id")],props([partition(0)])).
index_descr("catagories_ix2","catagories",[field("category")],props([partition(0)])).
index_descr("cats_ix1","cats",[field("cat_id"),field("contact_id")],props([partition(0)])).
index_descr("cats_ix2","cats",[field("contact_id"),field("cat_id")],props([partition(0)])).
index_descr("id_CHECKIN_ADV_CONSTRAINT_ix","checkin_adv_constraint",[field("constraint_id")],props([partition(0)])).
index_descr("resource_id_CHECKIN_ADV_CONSTRAINT_ix","checkin_adv_constraint",[field("resource_id"),field("constraint_id")],props([partition(0)])).
index_descr("checkin_adv_constraint_details_constraint_id_ix","checkin_adv_constraint_details",[field("constraint_id"),field("from_date"),field("from_time"),field("doop")],props([partition(0)])).
index_descr("id_CHECKIN_ADV_CONSTRAINT_NEW_ix","checkin_adv_constraint_new",[field("constraint_id")],props([partition(0)])).
index_descr("resource_id_CHECKIN_ADV_CONSTRAINT_NEW_ix","checkin_adv_constraint_new",[field("resource_id"),field("constraint_id")],props([partition(0)])).
index_descr("checkin_client_id_ix","checkin_client",[field("zone_id"),field("checkin_client_id")],props([partition(0)])).
index_descr("CHECKIN_COMMON_id_ix","checkin_common",[field("checkin_client_id"),field("from_date"),field("doop"),field("from_time")],props([partition(0)])).
index_descr("checkin_constraint_id_ix","checkin_constraint",[field("constraint_id")],props([partition(0)])).
index_descr("checkin_constraint_resource_ix","checkin_constraint",[field("resource_id")],props([partition(0)])).
index_descr("checkin_constraint_details_constraint_id_ix","checkin_constraint_details",[field("constraint_id"),field("from_date"),field("from_time"),field("doop")],props([partition(0)])).
index_descr("checkin_counters_minimum_ix","checkin_counters_minimum",[field("airport"),field("operator"),field("valid_from_date")],props([partition(0)])).
index_descr("checkin_counters_maximum_ix","checkin_counters_maximum",[field("airport"),field("operator"),field("valid_from_date")],props([partition(0)])).
index_descr("CHECKIN_DEDICATED_id_ix","checkin_dedicated",[field("checkin_client_id"),field("from_date"),field("doop"),field("from_time")],props([partition(0)])).
index_descr("checkin_desks_profile_ix","checkin_desks_profile",[field("id")],props([partition(0)])).
index_descr("checkin_desks_profile_name_ix","checkin_desks_profile",[field("name")],props([partition(0)])).
index_descr("checkin_desks_profile_period_ix","checkin_desks_profile_period",[field("checkin_desks_profile_id"),field("time_slot_before_dep")],props([partition(0)])).
index_descr("CHECKIN_FLIGHT_id_ix","checkin_flight",[field("checkin_flight_id")],props([partition(0)])).
index_descr("checkin_flight_period_ix","checkin_flight_period",[field("checkin_flight_id"),field("time_slot_before_dep")],props([partition(0)])).
index_descr("checkin_airport_ix","checkin_ope_use",[field("id")],props([partition(0)])).
index_descr("CHECKIN_REPORTING_PROFILE_ix","checkin_reporting_profile",[field("id")],props([partition(0)])).
index_descr("CHECKIN_REPORTING_PROFILE_NAME_ix","checkin_reporting_profile",[field("name")],props([partition(0)])).
index_descr("checkin_reporting_profile_period_ix","checkin_reporting_profile_period",[field("checkin_reporting_profile_id"),field("time_slot_before_dep")],props([partition(0)])).
index_descr("checkin_type_ix","checkin_type",[field("type")],props([partition(0)])).
index_descr("zone_id_ix","checkin_zone",[field("zone_id")],props([partition(0)])).
index_descr("zone_constraint_id_ix","checkin_zone",[field("constraint_id"),field("zone_id")],props([partition(0)])).
index_descr("checkin_zone_details_zone_id_ix","checkin_zone_details",[field("zone_id"),field("from_date"),field("from_time"),field("doop")],props([partition(0)])).
index_descr("client_request_ix","client_request",[field("request_id")],props([partition(0)])).
index_descr("client_request_ix2","client_request",[field("agent_id"),field("request_id")],props([partition(0)])).
index_descr("COLOR_SETUP_ix1","color_setup",[field("color_setup_id")],props([partition(0)])).
index_descr("cph_actype_conversion_ix","cph_actype_conversion",[field("actype"),field("cph_actype")],props([partition(0)])).
index_descr("cph_flight_conversion_ix","cph_flight_conversion",[field("operator"),field("service_no"),field("cph_operator"),field("cph_service_no")],props([partition(0)])).
index_descr("cph_operator_conversion_ix","cph_operator_conversion",[field("operator"),field("from_service_no")],props([partition(0)])).
index_descr("constraint_array_id_ix","constraint_array",[field("resource_set_id"),field("branch_id"),field("array_id"),field("use_taxi_time")],props([partition(0)])).
index_descr("constraint_array_branch_ix","constraint_array",[field("branch_id"),field("resource_set_id"),field("array_id"),field("use_taxi_time")],props([partition(0)])).
index_descr("contact_ix1","contact",[field("contact_id")],props([partition(0)])).
index_descr("contact_airport_ix1","contact_airport",[field("contact_group"),field("airport")],props([partition(0)])).
index_descr("contact_airport_ix2","contact_airport",[field("airport"),field("contact_group")],props([partition(0)])).
index_descr("contact_group_ix1","contact_group",[field("id")],props([partition(0)])).
index_descr("contact_group_ix2","contact_group",[field("name")],props([partition(0)])).
index_descr("contact_operator_IX1","contact_operator",[field("contact_group"),field("operator"),field("airport"),field("service_no_from")],props([partition(0)])).
index_descr("contact_operator_IX2","contact_operator",[field("operator"),field("contact_group"),field("airport"),field("service_no_from")],props([partition(0)])).
index_descr("contact_operator_group_group_ix","contact_operator_group",[field("contact_operator_group"),field("contact_operator")],props([partition(0)])).
index_descr("contact_operator_group_operator_ix","contact_operator_group",[field("contact_operator"),field("contact_operator_group")],props([partition(0)])).
index_descr("contact_operator_group_name_id_ix","contact_operator_group_name",[field("id")],props([partition(0)])).
index_descr("contact_operator_group_name_name_ix","contact_operator_group_name",[field("name")],props([partition(0)])).
index_descr("coordinated_airport_ix1","coordinated_airport",[field("airport_id")],props([partition(0)])).
index_descr("coordinated_airport_ix2","coordinated_airport",[field("IATA_code")],props([partition(0)])).
index_descr("copy_telex_address_ix","copy_telex_address",[field("address"),field("airport"),field("copy_address")],props([partition(0)])).
index_descr("country_ix1","country",[field("country_id")],props([partition(0)])).
index_descr("country_ix2","country",[field("country")],props([partition(0)])).
index_descr("country_group_group_ix","country_group",[field("country_group"),field("country_id")],props([partition(0)])).
index_descr("database_version_ix","database_version",[field("time_stamp")],props([partition(0)])).
index_descr("daylight_saving_time_period_ix","daylight_saving_time_period",[field("airport"),field("from_date_time")],props([partition(0)])).
index_descr("db_ini_ix1","db_ini",[field("user_name"),field("id")],props([partition(0)])).
index_descr("db_ini_user_section_item_ix","db_ini",[field("user_name"),field("section"),field("item")],props([partition(0)])).
index_descr("disable_message_parameter_ix","disable_message_parameter",[field("airport"),field("from_date_time")],props([partition(0)])).
index_descr("dubai_terminal_code_ix","dubai_terminal_code",[field("terminal_name")],props([partition(0)])).
index_descr("eschedule_fcsu_fragment_ix","eschedule_fcsu_fragment",[field("replicate_id"),field("flight_id"),field("arr_dep_mode"),field("start_date")],props([partition(0)])).
index_descr("eschedule_fcsu_fragment_ix2","eschedule_fcsu_fragment",[field("replicate_id"),field("airport"),field("season"),field("flight_id"),field("arr_dep_mode"),field("start_date")],props([partition(0)])).
index_descr("favorite_view_ix","favorite_view",[field("user_id"),field("tablename"),field("viewname")],props([partition(0)])).
index_descr("filter_expression_ix1","filter_expression",[field("filter_expression_id")],props([partition(0)])).
index_descr("filter_expression_ix2","filter_expression",[field("filter_expression_name"),field("filter_expression_id")],props([partition(0)])).
index_descr("filter_valuelist_ix1","filter_valuelist",[field("id")],props([partition(0)])).
index_descr("filter_valuelist_ix2","filter_valuelist",[field("name"),field("id")],props([partition(0)])).
index_descr("flight_ope_arr_dep_ix","flight",[field("branch_id"),field("operator_arrival_departure"),field("service_no_arrival_departure"),field("flight_id")],props([partition(0)])).
index_descr("flight_ope_dep_ix","flight",[field("branch_id"),field("operator_departure"),field("service_no_departure"),field("flight_id")],props([partition(0)])).
index_descr("flight_ope_arr_ix","flight",[field("branch_id"),field("operator_arrival"),field("service_no_arrival"),field("flight_id")],props([partition(0)])).
index_descr("flight_time_arr_ix","flight",[field("branch_id"),field("cleared_time_arrival"),field("flight_id")],props([partition(0)])).
index_descr("flight_time_dep_ix","flight",[field("branch_id"),field("cleared_time_departure"),field("flight_id")],props([partition(0)])).
index_descr("ix_branch","flight",[field("branch_id"),field("flight_id")],props([partition(0)])).
index_descr("flight_slotholder_ope_dep_ix","flight",[field("branch_id"),field("slot_holder_dep"),field("slot_holder_service_no_dep"),field("flight_id")],props([partition(0)])).
index_descr("flight_slotholder_ope_arr_ix","flight",[field("branch_id"),field("slot_holder_arr"),field("slot_holder_service_no_arr"),field("flight_id")],props([partition(0)])).
index_descr("flight_ad_ix","flight_ad",[field("flight_ad")],props([partition(0)])).
index_descr("flight_adt_ix","flight_adt",[field("flight_adt")],props([partition(0)])).
index_descr("flight_aircraft_ix","flight_aircraft",[field("branch_id"),field("arr_dep_mode"),field("operator"),field("service_no"),field("start_date")],props([partition(0)])).
index_descr("flight_branch_ix1","flight_branch",[field("branch_id")],props([partition(0)])).
index_descr("flight_branch_ix5","flight_branch",[field("IATA_code"),field("season_code"),field("user_id"),field("name")],props([partition(0)])).
index_descr("flight_branch_ix6","flight_branch",[field("IATA_code"),field("season_code"),field("branch_kind"),field("branch_id")],props([partition(0)])).
index_descr("flight_branch_kind_ix1","flight_branch_kind",[field("id")],props([partition(0)])).
index_descr("flight_count_ix","flight_count",[field("airport"),field("season"),field("resource_set_id"),field("branch_id")],props([partition(0)])).
index_descr("flight_count_ix2","flight_count",[field("branch_id"),field("resource_set_id")],props([partition(0)])).
index_descr("flight_delete_branch_flight_id_ix","flight_delete",[field("branch_id"),field("flight_id")],props([partition(0)])).
index_descr("flight_delete_branch_id_id_ix","flight_delete",[field("branch_id"),field("id")],props([partition(0)])).
index_descr("FLIGHT_LINK_ix","flight_link",[field("airport"),field("season"),field("operator_arrival"),field("service_no_arrival"),field("start_date"),field("doop"),field("branch_id")],props([partition(0)])).
index_descr("FLIGHT_LINK_ix2","flight_link",[field("airport"),field("season"),field("operator_departure"),field("service_no_departure"),field("start_date"),field("doop"),field("branch_id"),field("turnaround_days")],props([partition(0)])).
index_descr("FLIGHT_LINK_ix3","flight_link",[field("airport"),field("season"),field("branch_id"),field("operator_departure"),field("service_no_departure"),field("start_date"),field("doop"),field("turnaround_days")],props([partition(0)])).
index_descr("flight_mother_flight_id_ix","flight_mother",[field("branch_id"),field("flight_id"),field("mother_flight_id")],props([partition(0)])).
index_descr("flight_resource_set_flight_id_ix","flight_resource_set",[field("flight_id"),field("resource_set_id")],props([partition(0)])).
index_descr("flight_resource_set_resource_set_ix","flight_resource_set",[field("resource_set_id"),field("flight_id")],props([partition(0)])).
index_descr("flight_routing_ix","flight_routing",[field("branch_id"),field("arr_dep_mode"),field("operator"),field("service_no"),field("start_date")],props([partition(0)])).
index_descr("flight_trans_ix","flight_trans",[field("from_id")],props([partition(0)])).
index_descr("flight_codeshare_ix","flight_codeshare",[field("airport"),field("season"),field("operator"),field("service_no"),field("codeshare_operator"),field("codeshare_service_no"),field("arr_dep_mode"),field("date_from"),field("doop")],props([partition(0)])).
index_descr("flight_marketing_ix","flight_marketing",[field("airport"),field("season"),field("marketing_operator"),field("marketing_service_no"),field("operating_operator"),field("operating_service_no"),field("start_date"),field("end_date"),field("doop")],props([partition(0)])).
index_descr("flight_marketing_ix2","flight_marketing",[field("airport"),field("season"),field("operating_operator"),field("operating_service_no"),field("start_date"),field("end_date"),field("doop"),field("marketing_operator"),field("marketing_service_no")],props([partition(0)])).
index_descr("full_amp_active_ix","full_amp_active",[field("airport_group_name")],props([partition(0)])).
index_descr("full_amp_filter_ix","full_amp_filter",[field("name")],props([partition(0)])).
index_descr("gaba_service_no_ix","gaba_service_no",[field("airport"),field("season")],props([partition(0)])).
index_descr("gantt_carrier_colour_ix","gantt_carrier_colour",[field("operator"),field("airport")],props([partition(0)])).
index_descr("gantt_view_ix","gantt_view",[field("id")],props([partition(0)])).
index_descr("gantt_view_ix2","gantt_view",[field("view_name"),field("user_id"),field("airport"),field("season"),field("branch_id"),field("resource_id")],props([partition(0)])).
index_descr("gantt_view_ix3","gantt_view",[field("resource_id"),field("view_name"),field("user_id"),field("airport"),field("season"),field("branch_id")],props([partition(0)])).
index_descr("gate_adv_array_ix","gate_adv_array",[field("constraint_id"),field("aircraft_type_group")],props([partition(0)])).
index_descr("gate_adv_constraint_id_ix","gate_adv_constraint",[field("constraint_id")],props([partition(0)])).
index_descr("gate_adv_constraint_resource_ix","gate_adv_constraint",[field("resource_id"),field("constraint_id")],props([partition(0)])).
index_descr("gate_adv_pool_id_ix","gate_adv_pool",[field("pool_id")],props([partition(0)])).
index_descr("gate_adv_pool_constraint_ix","gate_adv_pool",[field("constraint_id"),field("pool_id")],props([partition(0)])).
index_descr("gate_adv_pool_details_constraint_id_ix","gate_adv_pool_details",[field("pool_id"),field("from_date"),field("from_time"),field("doop")],props([partition(0)])).
index_descr("gate_array_ix","gate_array",[field("resource_id"),field("aircraft_type_group")],props([partition(0)])).
index_descr("gate_constraint_id_ix","gate_constraint",[field("constraint_id")],props([partition(0)])).
index_descr("gate_constraint_resource_ix","gate_constraint",[field("resource_id"),field("constraint_id")],props([partition(0)])).
index_descr("gate_constraint_details_constraint_id_ix","gate_constraint_details",[field("constraint_id"),field("from_date"),field("from_time"),field("doop")],props([partition(0)])).
index_descr("handling_agent_ix1","handling_agent",[field("operator"),field("airport"),field("contact_id"),field("service_no_from")],props([partition(0)])).
index_descr("handling_agent_ix2","handling_agent",[field("airport"),field("operator"),field("contact_id"),field("service_no_from")],props([partition(0)])).
index_descr("header_footer_ix1","header_footer",[field("id")],props([partition(0)])).
index_descr("header_footer_ix2","header_footer",[field("name"),field("user_id")],props([partition(0)])).
index_descr("hist_status_code_ix","hist_status_code",[field("hist_status_code")],props([partition(0)])).
index_descr("hist_status_code_group_ix","hist_status_code_group",[field("id")],props([partition(0)])).
index_descr("holiday_ix1","holiday",[field("date"),field("airport")],props([partition(0)])).
index_descr("ICAO_AIRCRAFT_SIZE_ix1","icao_aircraft_size",[field("icao_aircraft_size")],props([partition(0)])).
index_descr("keycats_ix1","keycats",[field("keycat")],props([partition(0)])).
index_descr("load_factor_resource_id_ix","load_factor",[field("resource_id"),field("allocation_order"),field("from_date"),field("from_time"),field("doop")],props([partition(0)])).
index_descr("locations_ix1","locations",[field("location")],props([partition(0)])).
index_descr("LOW_PRIORITY_ix","low_priority",[field("airport"),field("season"),field("operator"),field("from_time")],props([partition(0)])).
index_descr("max_ground_time_ix","max_ground_time",[field("airport"),field("operator"),field("aircraft_type"),field("service_type"),field("valid_from")],props([partition(0)])).
index_descr("message_ix1","message",[field("msg_id")],props([partition(0)])).
index_descr("message_alert_ix1","message_alert",[field("id")],props([partition(0)])).
index_descr("message_configuration_ix1","message_configuration",[field("message_config_id")],props([partition(0)])).
index_descr("min_ground_time_ix","min_ground_time",[field("aircraft_type"),field("airport"),field("operator"),field("service_type"),field("valid_from")],props([partition(0)])).
index_descr("no_autoreply_reason_ix1","no_autoreply_reason",[field("id")],props([partition(0)])).
index_descr("id_noise_quota_constraint_ix","noise_quota_constraint",[field("constraint_id")],props([partition(0)])).
index_descr("resource_id_noise_quota_constraint_ix","noise_quota_constraint",[field("resource_id"),field("constraint_id")],props([partition(0)])).
index_descr("noise_quota_constraint_details_constraint_id_ix","noise_quota_constraint_details",[field("constraint_id"),field("operator")],props([partition(0)])).
index_descr("NOISE_QUOTA_PERIOD_KIND_ix1","noise_quota_period_kind",[field("id")],props([partition(0)])).
index_descr("note_ix1","note",[field("note_id")],props([partition(0)])).
index_descr("offer_id_ix","offer",[field("offer_id")],props([partition(0)])).
index_descr("office_ix1","office",[field("id")],props([partition(0)])).
index_descr("office_details_ix1","office_details",[field("id"),field("airport")],props([partition(0)])).
index_descr("online_account_ix1","online_account",[field("account_id")],props([partition(0)])).
index_descr("online_account_ix2","online_account",[field("account_name")],props([partition(0)])).
index_descr("online_account_local_ix1","online_account_local",[field("account_name")],props([partition(0)])).
index_descr("online_airport_season_ix1","online_airport_season",[field("airport_code"),field("season_code")],props([partition(0)])).
index_descr("online_season_ix1","online_season",[field("season_code")],props([partition(0)])).
index_descr("online_slot_monitoring_result_primary_ix","online_slot_monitoring_result",[field("airport"),field("season"),field("flight_operator"),field("flight_service_no"),field("arrival_departure"),field("start_date"),field("weekday")],props([partition(0)])).
index_descr("online_slot_monitoring_result_flightno_ix","online_slot_monitoring_result",[field("flight_operator"),field("flight_service_no"),field("arrival_departure"),field("season"),field("airport"),field("start_date"),field("weekday")],props([partition(0)])).
index_descr("ooh_redirect_message_address_ix1","ooh_redirect_message_address",[field("id")],props([partition(0)])).
index_descr("operator_ix1","operator",[field("IATA_code"),field("id")],props([partition(0)])).
index_descr("operator_expanded_ix1","operator_expanded",[field("operator"),field("id")],props([partition(0)])).
index_descr("operator_group_group_ix","operator_group",[field("operator_group"),field("operator")],props([partition(0)])).
index_descr("operator_group_operator_ix","operator_group",[field("operator"),field("operator_group")],props([partition(0)])).
index_descr("operator_group_name_id_ix","operator_group_name",[field("id")],props([partition(0)])).
index_descr("operator_group_name_name_ix","operator_group_name",[field("name"),field("airport"),field("valid_from_season")],props([partition(0)])).
index_descr("system_params_id_ix","params",[field("system_params_id")],props([partition(0)])).
index_descr("parking_adv_array_ix","parking_adv_array",[field("constraint_id"),field("aircraft_type_group")],props([partition(0)])).
index_descr("parking_adv_constraint_id_ix","parking_adv_constraint",[field("constraint_id")],props([partition(0)])).
index_descr("parking_adv_constraint_resource_ix","parking_adv_constraint",[field("resource_id"),field("constraint_id")],props([partition(0)])).
index_descr("parking_adv_pool_details_ix","parking_adv_pool_details",[field("pool_id"),field("from_date"),field("from_time"),field("doop")],props([partition(0)])).
index_descr("parking_adv_pool_id_ix","parking_adv_pool",[field("pool_id")],props([partition(0)])).
index_descr("parking_adv_pool_constraint_ix","parking_adv_pool",[field("constraint_id"),field("pool_id")],props([partition(0)])).
index_descr("parking_adv_pool_name_ix","parking_adv_pool",[field("constraint_id"),field("name")],props([partition(0)])).
index_descr("parking_allocation_ix","parking_allocation",[field("airport"),field("season"),field("branch_id"),field("resource_set_id"),field("constraint_id"),field("bay_number")],props([partition(0)])).
index_descr("parking_allocation_ix2","parking_allocation",[field("constraint_id"),field("airport"),field("season"),field("branch_id"),field("resource_set_id"),field("bay_number")],props([partition(0)])).
index_descr("PARKING_TEMPLATE_ix","parking_template",[field("id")],props([partition(0)])).
index_descr("PARKING_TEMPLATE_ix2","parking_template",[field("branch_id"),field("resource_set_id"),field("constraint_id"),field("name")],props([partition(0)])).
index_descr("PARKING_TEMPLATE_MEMBER_ix","parking_template_member",[field("template_id"),field("pool_id"),field("bay_number")],props([partition(0)])).
index_descr("parking_array_ix","parking_array",[field("resource_id"),field("aircraft_type_group")],props([partition(0)])).
index_descr("parking_constraint_id_ix","parking_constraint",[field("constraint_id")],props([partition(0)])).
index_descr("parking_constraint_resource_ix","parking_constraint",[field("resource_id"),field("constraint_id")],props([partition(0)])).
index_descr("parking_constraint_details_constraint_id_ix","parking_constraint_details",[field("constraint_id"),field("from_date"),field("from_time"),field("doop")],props([partition(0)])).
index_descr("parking_count_ix","parking_count",[field("resource_id"),field("aircraft_type_group"),field("from_date"),field("time"),field("doop")],props([partition(0)])).
index_descr("parking_links_operator_group_ix","parking_links_operator_group",[field("parking_links_operator_group"),field("operator"),field("valid_from_season")],props([partition(0)])).
index_descr("parking_links_operator_group_expanded_ix","parking_links_operator_group_expanded",[field("operator"),field("season")],props([partition(0)])).
index_descr("parking_links_operator_group_name_id_ix","parking_links_operator_group_name",[field("id")],props([partition(0)])).
index_descr("parking_links_operator_group_name_name_ix","parking_links_operator_group_name",[field("name")],props([partition(0)])).
index_descr("id_paxflow_constraint_ix","paxflow_constraint",[field("constraint_id")],props([partition(0)])).
index_descr("resource_id_paxflow_constraint_ix","paxflow_constraint",[field("resource_id"),field("constraint_id")],props([partition(0)])).
index_descr("paxflow_constraint_details_constraint_id_ix","paxflow_constraint_details",[field("constraint_id"),field("a_d_t"),field("from_date"),field("from_time"),field("doop")],props([partition(0)])).
index_descr("permitted_message_mixed_operator_pair_ix","permitted_message_mixed_operator_pair",[field("operator1"),field("operator2")],props([partition(0)])).
index_descr("permitted_shl_code_ix","permitted_shl_code",[field("code")],props([partition(0)])).
index_descr("view_ix1","pro_view",[field("view_id")],props([partition(0)])).
index_descr("view_ix2","pro_view",[field("user_id"),field("tablename"),field("viewname"),field("report_flag")],props([partition(0)])).
index_descr("current_view_ix1","pro_view_current",[field("user_id"),field("tablename")],props([partition(0)])).
index_descr("user_table_view_ix","pro_view_current",[field("user_id"),field("tablename"),field("viewname")],props([partition(0)])).
index_descr("view_state_ix1","pro_view_state",[field("user_id"),field("workspace"),field("workpane_id"),field("viewtype"),field("viewname")],props([partition(0)])).
index_descr("qc_points_aircraft_type_ix1","qc_points",[field("aircraft_type"),field("operator"),field("airport"),field("acreg")],props([partition(0)])).
index_descr("quota_operator_ix","quota_operator",[field("quota_constraint_id"),field("operator")],props([partition(0)])).
index_descr("reason_code_ix","reason_code",[field("reason_code")],props([partition(0)])).
index_descr("reason_code_group_ix","reason_code_group",[field("id")],props([partition(0)])).
index_descr("register_ix1","register",[field("register_id")],props([partition(0)])).
index_descr("RES_SET_PARKING_TYPE_ix1","res_set_parking_type",[field("id")],props([partition(0)])).
index_descr("resource_ix1","resource",[field("resource_id")],props([partition(0)])).
index_descr("resource_ix2","resource",[field("resource_set_id"),field("resource_id")],props([partition(0)])).
index_descr("resource_set_ix1","resource_set",[field("resource_set_id")],props([partition(0)])).
index_descr("resource_set_ix2","resource_set",[field("resource_set_name"),field("airport"),field("season")],props([partition(0)])).
index_descr("resource_set_ix3","resource_set",[field("airport"),field("season"),field("resource_set_id")],props([partition(0)])).
index_descr("resource_set_ix4","resource_set",[field("active"),field("airport"),field("season"),field("resource_set_id")],props([partition(0)])).
index_descr("resource_set_ix5","resource_set",[field("type"),field("airport"),field("season"),field("resource_set_id")],props([partition(0)])).
index_descr("RESOURCE_SET_KIND_ix1","resource_set_kind",[field("id")],props([partition(0)])).
index_descr("RESULT_OFF_SLOT_TYPE_ix","result_off_slot_type",[field("type")],props([partition(0)])).
index_descr("id_runway_admix_constraint_ix","runway_admix_constraint",[field("constraint_id")],props([partition(0)])).
index_descr("resource_id_runway_admix_constraint_ix","runway_admix_constraint",[field("resource_id"),field("constraint_id")],props([partition(0)])).
index_descr("runway_admix_constraint_details_constraint_id_ix","runway_admix_constraint_details",[field("constraint_id"),field("arr_limit"),field("dep_limit"),field("tot_limit")],props([partition(0)])).
index_descr("runway_buffer_details_constraint_id_ix","runway_buffer_details",[field("constraint_id"),field("a_d_t"),field("from_date"),field("from_time"),field("doop")],props([partition(0)])).
index_descr("id_runway_constraint_ix","runway_constraint",[field("constraint_id")],props([partition(0)])).
index_descr("resource_id_runway_constraint_ix","runway_constraint",[field("resource_id"),field("constraint_id")],props([partition(0)])).
index_descr("runway_constraint_details_constraint_id_ix","runway_constraint_details",[field("constraint_id"),field("a_d_t"),field("from_date"),field("from_time"),field("doop")],props([partition(0)])).
index_descr("runway_factor_constraint_id_ix","runway_factor",[field("constraint_id"),field("allocation_order")],props([partition(0)])).
index_descr("id_runway_FACTOR_constraint_ix","runway_factor_constraint",[field("constraint_id")],props([partition(0)])).
index_descr("resource_id_runway_FACTOR_constraint_ix","runway_factor_constraint",[field("resource_id"),field("constraint_id")],props([partition(0)])).
index_descr("runway_factor_constraint_details_constraint_id_ix","runway_factor_constraint_details",[field("constraint_id"),field("a_d_t"),field("from_date"),field("from_time"),field("doop")],props([partition(0)])).
index_descr("SA_SEMAPHORE_ix","sa_semaphore",[field("name")],props([partition(0)])).
index_descr("sam_request_id_ix","sam_request_id",[field("id")],props([partition(0)])).
index_descr("season_ix1","season",[field("season_code")],props([partition(0)])).
index_descr("send_address_ix1","send_address",[field("send_address_id")],props([partition(0)])).
index_descr("send_group_ix1","send_group",[field("send_group_id")],props([partition(0)])).
index_descr("service_type_ix1","service_type",[field("service_type")],props([partition(0)])).
index_descr("setting_ix","setting",[field("section_key")],props([partition(0)])).
index_descr("setting2_ix","setting2",[field("id")],props([partition(0)])).
index_descr("SETTING_CATEGORY_ix","setting_category",[field("id")],props([partition(0)])).
index_descr("SETTING_DETAILS_ACTIVE_STRING_ix","setting_details_active_string",[field("setting"),field("airport")],props([partition(0)])).
index_descr("SETTING_DETAILS_FILTER_EMAIL_ix","setting_details_filter_email",[field("setting"),field("airport"),field("filter"),field("email")],props([partition(0)])).
index_descr("SETTING_DETAILS_INTEGER_ix","setting_details_integer",[field("setting"),field("airport")],props([partition(0)])).
index_descr("SETTING_DETAILS_MULTI_INTEGER_ix","setting_details_multi_integer",[field("setting"),field("airport"),field("integer_value")],props([partition(0)])).
index_descr("SETTING_DETAILS_MULTI_STRING_ix","setting_details_multi_string",[field("setting"),field("airport"),field("string_value")],props([partition(0)])).
index_descr("SETTING_DETAILS_SEASON_ix","setting_details_season",[field("setting"),field("airport"),field("season")],props([partition(0)])).
index_descr("SETTING_DETAILS_SEASON_ACTYPE_ix","setting_details_season_actype",[field("setting"),field("airport"),field("season")],props([partition(0)])).
index_descr("SETTING_DETAILS_SEASON_ACTIVE_INTEGER_ix","setting_details_season_active_integer",[field("setting"),field("airport"),field("season")],props([partition(0)])).
index_descr("SETTING_DETAILS_SEASON_INTEGER_ix","setting_details_season_integer",[field("setting"),field("airport"),field("season")],props([partition(0)])).
index_descr("SETTING_DETAILS_SEASON_MULTI_STRING_ix","setting_details_season_multi_string",[field("setting"),field("airport"),field("season"),field("string_value")],props([partition(0)])).
index_descr("SETTING_DETAILS_SEASON_SERVICETYPE_INTEGER_IX","setting_details_season_servicetype_integer",[field("setting"),field("airport"),field("season"),field("servicetype")],props([partition(0)])).
index_descr("SETTING_DETAILS_SEASON_STRING_ix","setting_details_season_string",[field("setting"),field("airport"),field("season")],props([partition(0)])).
index_descr("SETTING_DETAILS_SEASON_7_ix","setting_details_season_7",[field("setting"),field("airport"),field("season")],props([partition(0)])).
index_descr("SETTING_DETAILS_SEASON_11_ix","setting_details_season_11",[field("setting"),field("airport"),field("season")],props([partition(0)])).
index_descr("SETTING_DETAILS_STRING_ix","setting_details_string",[field("setting"),field("airport")],props([partition(0)])).
index_descr("SETTING_DETAILS_TWO_INTEGERS_ix","setting_details_two_integers",[field("setting"),field("airport")],props([partition(0)])).
index_descr("SETTING_DETAILS_TYPE_ix","setting_details_type",[field("id")],props([partition(0)])).
index_descr("setting_type_ix","setting_type",[field("type_id")],props([partition(0)])).
index_descr("shl_parameters_id_ix","shl_params",[field("shl_params_id")],props([partition(0)])).
index_descr("slot_link_sequence_air_sea_ix","slot_link_sequence",[field("airport"),field("season")],props([partition(0)])).
index_descr("slot_monitoring_airport_ix","slot_monitoring",[field("airport"),field("season")],props([partition(0)])).
index_descr("slot_monitoring_season_ix","slot_monitoring",[field("season"),field("airport")],props([partition(0)])).
index_descr("slot_monitoring_air_sea_lose_ix","slot_monitoring",[field("airport"),field("season"),field("use_it_lose_it")],props([partition(0)])).
index_descr("slot_monitoring_air_sea_branch_kind_ix","slot_monitoring",[field("airport"),field("season"),field("branch_kind")],props([partition(0)])).
index_descr("slot_monitoring_actual_primary_ix","slot_monitoring_actual",[field("id")],props([partition(0)])).
index_descr("slot_monitoring_actual_season_ix","slot_monitoring_actual",[field("season"),field("airport"),field("operator"),field("service_no"),field("arrival_departure"),field("date_sched"),field("time_sched"),field("duplicate_no"),field("id")],props([partition(0)])).
index_descr("slot_monitoring_actual_flightno_ix","slot_monitoring_actual",[field("operator"),field("service_no"),field("season"),field("airport"),field("arrival_departure"),field("date_sched"),field("time_sched"),field("duplicate_no"),field("id")],props([partition(0)])).
index_descr("slot_monitoring_actual_air_sea_date_ix","slot_monitoring_actual",[field("airport"),field("season"),field("date_sched"),field("id")],props([partition(0)])).
index_descr("slot_monitoring_actual_air_sea_actualdate_ix","slot_monitoring_actual",[field("airport"),field("season"),field("date_actual"),field("id")],props([partition(0)])).
index_descr("slot_monitoring_actual_filter_ix1","slot_monitoring_actual_filter",[field("slot_monitoring_actual_filter_id")],props([partition(0)])).
index_descr("slot_monitoring_actual_filter_ix2","slot_monitoring_actual_filter",[field("slot_monitoring_actual_filter_name"),field("slot_monitoring_actual_filter_id")],props([partition(0)])).
index_descr("slot_monitoring_coord_type_ix","slot_monitoring_coord_type",[field("coord_type")],props([partition(0)])).
index_descr("slot_monitoring_flight_primary_ix","slot_monitoring_flight",[field("airport"),field("season"),field("flight_operator_coord_actual"),field("flight_service_no_coord_actual"),field("arrival_departure"),field("date_coord_actual"),field("time_coord_actual"),field("record_type")],props([partition(0)])).
index_descr("slot_monitoring_flight_season_ix","slot_monitoring_flight",[field("season"),field("airport"),field("flight_operator_coord_actual"),field("flight_service_no_coord_actual"),field("arrival_departure"),field("date_coord_actual"),field("time_coord_actual"),field("record_type")],props([partition(0)])).
index_descr("slot_monitoring_flight_flightno_ix","slot_monitoring_flight",[field("flight_operator_coord_actual"),field("flight_service_no_coord_actual"),field("season"),field("airport"),field("arrival_departure"),field("date_coord_actual"),field("time_coord_actual"),field("record_type")],props([partition(0)])).
index_descr("slot_monitoring_flight_date_ix","slot_monitoring_flight",[field("airport"),field("season"),field("date_coord_actual"),field("arrival_departure"),field("time_coord_actual"),field("flight_operator_coord_actual"),field("flight_service_no_coord_actual"),field("record_type")],props([partition(0)])).
index_descr("slot_monitoring_flight_manual_match_ix","slot_monitoring_flight",[field("airport"),field("season"),field("record_type"),field("match_status"),field("session_number"),field("date_coord_actual"),field("arrival_departure"),field("time_coord_actual"),field("flight_operator_coord_actual"),field("flight_service_no_coord_actual")],props([partition(0)])).
index_descr("slot_monitoring_flight_filter_ix1","slot_monitoring_flight_filter",[field("slot_monitoring_flight_filter_id")],props([partition(0)])).
index_descr("slot_monitoring_flight_filter_ix2","slot_monitoring_flight_filter",[field("slot_monitoring_flight_filter_name"),field("slot_monitoring_flight_filter_id")],props([partition(0)])).
index_descr("slot_monitoring_result_primary_ix","slot_monitoring_result",[field("airport"),field("season"),field("flight_operator"),field("flight_service_no"),field("arrival_departure"),field("start_date"),field("weekday")],props([partition(0)])).
index_descr("slot_monitoring_result_flightno_ix","slot_monitoring_result",[field("flight_operator"),field("flight_service_no"),field("arrival_departure"),field("season"),field("airport"),field("start_date"),field("weekday")],props([partition(0)])).
index_descr("slot_monitoring_result_filter_ix1","slot_monitoring_result_filter",[field("slot_monitoring_result_filter_id")],props([partition(0)])).
index_descr("slot_monitoring_result_filter_ix2","slot_monitoring_result_filter",[field("slot_monitoring_result_filter_name"),field("slot_monitoring_result_filter_id")],props([partition(0)])).
index_descr("slot_monitoring_type_ix","slot_monitoring_type",[field("record_type")],props([partition(0)])).
index_descr("slot_mon_cancellation_primary_ix","slot_mon_cancellation",[field("airport"),field("season"),field("flight_operator"),field("flight_service_no"),field("arrival_departure"),field("date_coord")],props([partition(0)])).
index_descr("slot_mon_cancellation_filter_ix1","slot_mon_cancellation_filter",[field("slot_mon_cancellation_filter_id")],props([partition(0)])).
index_descr("slot_mon_cancellation_filter_ix2","slot_mon_cancellation_filter",[field("slot_mon_cancellation_filter_name"),field("slot_mon_cancellation_filter_id")],props([partition(0)])).
index_descr("slot_mon_taxi_time_airport_ix","slot_mon_taxi_time",[field("airport"),field("season")],props([partition(0)])).
index_descr("slot_mon_taxi_time_season_ix","slot_mon_taxi_time",[field("season"),field("airport")],props([partition(0)])).
index_descr("slot_swap_air_sea_id_ix","slot_swap",[field("airport"),field("season"),field("slot_swap_id"),field("operator_arrival_departure"),field("service_no_arrival_departure"),field("start_date"),field("doop")],props([partition(0)])).
index_descr("slot_swap_ope_arr_dep_ix","slot_swap",[field("operator_arrival_departure"),field("service_no_arrival_departure"),field("airport"),field("season"),field("slot_swap_id"),field("start_date"),field("doop")],props([partition(0)])).
index_descr("slot_swap_time_arr_ix","slot_swap",[field("cleared_time_arrival"),field("airport"),field("season"),field("slot_swap_id"),field("operator_arrival_departure"),field("service_no_arrival_departure"),field("start_date"),field("doop")],props([partition(0)])).
index_descr("slot_swap_time_dep_ix","slot_swap",[field("cleared_time_departure"),field("airport"),field("season"),field("slot_swap_id"),field("operator_arrival_departure"),field("service_no_arrival_departure"),field("start_date"),field("doop")],props([partition(0)])).
index_descr("slot_swap_id_ix","slot_swap",[field("slot_swap_id"),field("airport"),field("season"),field("operator_arrival_departure"),field("service_no_arrival_departure"),field("start_date"),field("doop")],props([partition(0)])).
index_descr("slot_swap_id_air_sea_ix","slot_swap_id",[field("airport"),field("season")],props([partition(0)])).
index_descr("special_ops_code_ix","special_ops_code",[field("special_ops_code")],props([partition(0)])).
index_descr("ssim_action_code_coord_ix1","ssim_action_code_coord",[field("name")],props([partition(0)])).
index_descr("ssim_action_code_operator_ix1","ssim_action_code_operator",[field("name")],props([partition(0)])).
index_descr("stand_ix","stand",[field("id")],props([partition(0)])).
index_descr("stand_constraint_ix","stand",[field("constraint_id"),field("id")],props([partition(0)])).
index_descr("stand_adv_ix","stand_adv",[field("id")],props([partition(0)])).
index_descr("stand_adv_pool_ix","stand_adv",[field("pool_id"),field("id")],props([partition(0)])).
index_descr("stand_adjacency_ix1","stand_adjacency",[field("id")],props([partition(0)])).
index_descr("stand_adjacency_ix2","stand_adjacency",[field("id"),field("constraint_id"),field("stand1_id"),field("stand2_id")],props([partition(0)])).
index_descr("stand_filter_expression_ix1","stand_filter_expression",[field("id")],props([partition(0)])).
index_descr("stand_filter_expression_ix2","stand_filter_expression",[field("name"),field("airport"),field("id")],props([partition(0)])).
index_descr("stand_local_filter_ix","stand_local_filter",[field("resource_set_id"),field("name")],props([partition(0)])).
index_descr("status_information_reason_ix","status_information_reason",[field("text")],props([partition(0)])).
index_descr("user_ix1","t_user",[field("id")],props([partition(0)])).
index_descr("user_ix2","t_user",[field("name")],props([partition(0)])).
index_descr("t_values_ix","t_values",[field("no_of_ops")],props([partition(0)])).
index_descr("tactical_availability_ix","tactical_availability",[field("airport"),field("season"),field("arr_dep"),field("date_time"),field("limit")],props([partition(0)])).
index_descr("tactical_availability_array_ix","tactical_availability_array",[field("airport"),field("season")],props([partition(0)])).
index_descr("telex_addresses_ix1","telex_addresses",[field("telex_address_id")],props([partition(0)])).
index_descr("temp_actual_flight_ix1","temp_actual_flight",[field("id")],props([partition(0)])).
index_descr("temp_actual_flight_air_sea_ix","temp_actual_flight",[field("airport"),field("season"),field("scheduledate"),field("id")],props([partition(0)])).
index_descr("towing_ix1","towing",[field("airport"),field("ac_type_group"),field("operator"),field("ac_type"),field("terminal")],props([partition(0)])).
index_descr("user_group_ix1","user_group",[field("id")],props([partition(0)])).
index_descr("user_group_ix2","user_group",[field("name")],props([partition(0)])).
index_descr("waitlist_priority_ix1","waitlist_priority",[field("service_type"),field("airport")],props([partition(0)])).
index_descr("sequence_ix1","sequence",[field("no")],props([partition(0)])).
index_descr("old_sequence_ix1","old_sequence",[field("no")],props([partition(0)])).
index_descr("table_ix1","meta_table",[field("table_name")],props([partition(0)])).
index_descr("inter_field_constraint_ix1","meta_inter_field_constraint",[field("table_name")],props([partition(0)])).
index_descr("field_ix1","meta_field",[field("field_id")],props([partition(0)])).
index_descr("field_ix2","meta_field",[field("table_name"),field("field_name")],props([partition(0)])).
index_descr("field_presentation_ix1","meta_field_presentation",[field("field_id")],props([partition(0)])).
index_descr("field_constraint_ix1","meta_field_constraint",[field("field_id")],props([partition(0)])).
index_descr("dialogue_layout_ix1","meta_dialogue_layout",[field("field_id")],props([partition(0)])).
index_descr("index_ix1","meta_index",[field("index_id")],props([partition(0)])).
index_descr("index_ix2","meta_index",[field("table_name")],props([partition(0)])).
index_descr("index_field_ix1","meta_index_field",[field("index_id"),field("field_order")],props([partition(0)])).
index_descr("foreign_key_ix1","meta_foreign_key",[field("field_id")],props([partition(0)])).
index_descr("meta_database_version_ix1","meta_database_version",[field("time_stamp")],props([partition(0)])).
