Your task is to provide answers based solely on SQL queries from our PostgreSQL database. To assist you, the user will provide the database schema. Follow these guidelines when responding to queries:
1. Incorporate the Provided Database Schema: Below, the user will input the schema of their database. Carefully analyze this schema to understand the structure, relationships, and constraints of the database. This schema will be essential in formulating accurate and relevant SQL queries or explanations.
User-Provided Database Schema:
--
-- PostgreSQL database dump
--
-- Dumped from database version 15.1
-- Dumped by pg_dump version 15.1
-- Started on 2024-05-23 14:48:20 +03
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
--
-- TOC entry 7 (class 2615 OID 19620)
-- Name: river; Type: SCHEMA; Schema: -; Owner: -
--
CREATE SCHEMA river;
SET default_table_access_method = heap;
--
-- TOC entry 216 (class 1259 OID 19621)
-- Name: air_traffic; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.air_traffic (
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
"time" timestamp(6) without time zone,
calibrated_altitude character varying(255),
call_sign character varying(255),
carrier character varying(255),
direction character varying(255),
extra_info character varying(255),
gps_altitude character varying(255),
ground_speed character varying(255),
indicated_air_speed character varying(255),
latitude character varying(255),
longitude character varying(255),
reg_id character varying(255),
temperature character varying(255),
true_air_speed character varying(255),
type character varying(255),
vertical_speed character varying(255),
wind character varying(255)
);
--
-- TOC entry 217 (class 1259 OID 19626)
-- Name: air_traffic_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.air_traffic_aud (
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
"time" timestamp(6) without time zone,
calibrated_altitude character varying(255),
call_sign character varying(255),
carrier character varying(255),
direction character varying(255),
extra_info character varying(255),
gps_altitude character varying(255),
ground_speed character varying(255),
indicated_air_speed character varying(255),
latitude character varying(255),
longitude character varying(255),
reg_id character varying(255),
temperature character varying(255),
true_air_speed character varying(255),
type character varying(255),
vertical_speed character varying(255),
wind character varying(255)
);
--
-- TOC entry 218 (class 1259 OID 19631)
-- Name: air_traffic_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.air_traffic_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 219 (class 1259 OID 19632)
-- Name: aircraft; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.aircraft (
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
number_of_seats bigint,
ac_type character varying(255),
contract character varying(255),
customized_type character varying(255),
extra_info character varying(255),
name_of_aircraft character varying(255),
owner character varying(255),
reg_id character varying(255),
registrar character varying(255),
subtype character varying(255)
);
--
-- TOC entry 220 (class 1259 OID 19637)
-- Name: aircraft_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.aircraft_aud (
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
number_of_seats bigint,
ac_type character varying(255),
contract character varying(255),
customized_type character varying(255),
extra_info character varying(255),
name_of_aircraft character varying(255),
owner character varying(255),
reg_id character varying(255),
registrar character varying(255),
subtype character varying(255)
);
--
-- TOC entry 221 (class 1259 OID 19642)
-- Name: aircraft_flight_duty; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.aircraft_flight_duty (
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
extra_info character varying(255),
leg_id character varying(255) NOT NULL,
reg_id character varying(255),
rot_id character varying(255)
);
--
-- TOC entry 222 (class 1259 OID 19647)
-- Name: aircraft_flight_duty_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.aircraft_flight_duty_aud (
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
extra_info character varying(255),
leg_id character varying(255),
reg_id character varying(255),
rot_id character varying(255)
);
--
-- TOC entry 223 (class 1259 OID 19652)
-- Name: aircraft_flight_duty_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.aircraft_flight_duty_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 224 (class 1259 OID 19653)
-- Name: aircraft_ground_duty; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.aircraft_ground_duty (
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone,
end_time timestamp(6) without time zone,
id bigint NOT NULL,
start_time timestamp(6) without time zone,
code character varying(255),
extra_info character varying(255),
reg_id character varying(255) NOT NULL,
rot_id character varying(255),
station character varying(255),
status character varying(255),
leg_id character varying(50)
);
--
-- TOC entry 225 (class 1259 OID 19658)
-- Name: aircraft_ground_duty_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.aircraft_ground_duty_aud (
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
updated_at timestamp(6) without time zone,
end_time timestamp(6) without time zone,
id bigint NOT NULL,
start_time timestamp(6) without time zone,
code character varying(255),
extra_info character varying(255),
reg_id character varying(255),
rot_id character varying(255),
station character varying(255),
status character varying(255),
leg_id character varying(50)
);
--
-- TOC entry 226 (class 1259 OID 19663)
-- Name: aircraft_ground_duty_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.aircraft_ground_duty_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 227 (class 1259 OID 19664)
-- Name: aircraft_rotation; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.aircraft_rotation (
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone,
end_time timestamp(6) without time zone,
id bigint NOT NULL,
start_time timestamp(6) without time zone,
ac_type character varying(255),
extra_info character varying(255),
reg_id character varying(255),
rotation_id character varying(255),
subtype character varying(255)
);
--
-- TOC entry 228 (class 1259 OID 19669)
-- Name: aircraft_rotation_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.aircraft_rotation_aud (
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
updated_at timestamp(6) without time zone,
end_time timestamp(6) without time zone,
id bigint NOT NULL,
start_time timestamp(6) without time zone,
ac_type character varying(255),
extra_info character varying(255),
reg_id character varying(255),
rotation_id character varying(255),
subtype character varying(255)
);
--
-- TOC entry 229 (class 1259 OID 19674)
-- Name: aircraft_rotation_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.aircraft_rotation_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 230 (class 1259 OID 19675)
-- Name: aircraft_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.aircraft_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 231 (class 1259 OID 19676)
-- Name: alternative_airport; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.alternative_airport (
distance real,
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
priority bigint,
arrival_airport character varying(255),
extra_info character varying(255),
iata character varying(255) NOT NULL
);
--
-- TOC entry 232 (class 1259 OID 19681)
-- Name: alternative_airport_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.alternative_airport_aud (
rev integer NOT NULL,
revtype smallint,
distance real,
created_at timestamp(6) without time zone,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
priority bigint,
arrival_airport character varying(255),
extra_info character varying(255),
iata character varying(255)
);
--
-- TOC entry 233 (class 1259 OID 19686)
-- Name: alternative_airport_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.alternative_airport_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 234 (class 1259 OID 19687)
-- Name: baggage_info; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.baggage_info (
id bigint NOT NULL,
created_at timestamp without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp without time zone,
baggage_id character varying(255),
inbound_leg_id character varying(255),
is_excess integer,
outbound_leg_id character varying(255),
pnr character varying(255),
status character varying(255),
weight real,
flight_leg_id character varying(255),
reason character varying(255),
carrier character varying(255),
flight_number character varying(255),
udor date
);
--
-- TOC entry 235 (class 1259 OID 19692)
-- Name: baggage_info_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.baggage_info_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp without time zone,
extra_info character varying(255),
updated_at timestamp without time zone,
baggage_id character varying(255),
inbound_leg_id character varying(255),
is_excess integer,
outbound_leg_id character varying(255),
pnr character varying(255),
status character varying(255),
weight real,
flight_leg_id character varying(255),
reason character varying(255),
carrier character varying(255),
flight_number character varying(255),
udor date
);
--
-- TOC entry 236 (class 1259 OID 19697)
-- Name: baggage_info_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.baggage_info_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 237 (class 1259 OID 19698)
-- Name: baggage_statistics; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.baggage_statistics (
id bigint NOT NULL,
created_at timestamp without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp without time zone,
flight_leg_id character varying(255),
number_of_excess_baggage real,
number_of_total_baggage real,
reg_id character varying(255),
total_excess_baggage_weight real,
aircraft_type character varying(255),
total_baggage_weight real,
actual_total_cargo_weight real,
carrier character varying(255),
flight_number character varying(255),
udor date,
updated_from character varying(255),
booked_total_cargo_weight real
);
--
-- TOC entry 238 (class 1259 OID 19703)
-- Name: baggage_statistics_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.baggage_statistics_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp without time zone,
extra_info character varying(255),
updated_at timestamp without time zone,
flight_leg_id character varying(255),
number_of_excess_baggage real,
number_of_total_baggage real,
reg_id character varying(255),
total_excess_baggage_weight real,
aircraft_type character varying(255),
total_baggage_weight real,
actual_total_cargo_weight real,
carrier character varying(255),
flight_number character varying(255),
udor date,
updated_from character varying(255),
booked_total_cargo_weight real
);
--
-- TOC entry 239 (class 1259 OID 19708)
-- Name: baggage_statistics_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.baggage_statistics_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 240 (class 1259 OID 19709)
-- Name: baggage_status_mail; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.baggage_status_mail (
id bigint NOT NULL,
created_at timestamp without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp without time zone,
mail_id character varying(255),
content_type character varying(255)
);
--
-- TOC entry 241 (class 1259 OID 19714)
-- Name: baggage_status_mail_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.baggage_status_mail_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp without time zone,
extra_info character varying(255),
updated_at timestamp without time zone,
mail_id character varying(255),
content_type character varying(255)
);
--
-- TOC entry 242 (class 1259 OID 19719)
-- Name: baggage_status_mail_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.baggage_status_mail_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 243 (class 1259 OID 19720)
-- Name: crew_accommodation; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_accommodation (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
hotel_address character varying(255),
hotel_email character varying(255),
hotel_id character varying(255),
hotel_name character varying(255),
hotel_phone character varying(255)
);
--
-- TOC entry 244 (class 1259 OID 19725)
-- Name: crew_accommodation_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_accommodation_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
hotel_address character varying(255),
hotel_email character varying(255),
hotel_id character varying(255),
hotel_name character varying(255),
hotel_phone character varying(255)
);
--
-- TOC entry 245 (class 1259 OID 19730)
-- Name: crew_accommodation_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_accommodation_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 246 (class 1259 OID 19731)
-- Name: crew_activity; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_activity (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
code character varying(255),
crew_info_id character varying(255) NOT NULL,
duty_id character varying(255),
end_date timestamp(6) without time zone,
"position" character varying(255),
roster_id character varying(255),
start_date timestamp(6) without time zone,
status character varying(255),
trip_id character varying(255),
source_key character varying(255),
start_date_local timestamp without time zone,
end_date_local timestamp without time zone,
station character varying(255)
);
--
-- TOC entry 247 (class 1259 OID 19736)
-- Name: crew_activity_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_activity_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
code character varying(255),
crew_info_id character varying(255),
duty_id character varying(255),
end_date timestamp(6) without time zone,
"position" character varying(255),
roster_id character varying(255),
start_date timestamp(6) without time zone,
status character varying(255),
trip_id character varying(255),
source_key character varying(255),
start_date_local timestamp without time zone,
end_date_local timestamp without time zone,
station character varying(255)
);
--
-- TOC entry 248 (class 1259 OID 19741)
-- Name: crew_activity_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_activity_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 249 (class 1259 OID 19742)
-- Name: crew_base; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_base (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
base character varying(255),
crew_info_id character varying(255) NOT NULL,
end_date timestamp(6) without time zone,
start_date timestamp(6) without time zone,
temp boolean
);
--
-- TOC entry 250 (class 1259 OID 19747)
-- Name: crew_base_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_base_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
base character varying(255),
crew_info_id character varying(255),
end_date timestamp(6) without time zone,
start_date timestamp(6) without time zone,
temp boolean
);
--
-- TOC entry 251 (class 1259 OID 19752)
-- Name: crew_base_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_base_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 252 (class 1259 OID 19753)
-- Name: crew_bid; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_bid (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
bid_id character varying(255) NOT NULL,
crew_info_id character varying(255) NOT NULL,
end_date timestamp(6) without time zone,
period character varying(255),
points real,
priority integer,
start_date timestamp(6) without time zone,
sub_type character varying(255),
type character varying(255),
value character varying(255)
);
--
-- TOC entry 253 (class 1259 OID 19758)
-- Name: crew_bid_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_bid_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
bid_id character varying(255),
crew_info_id character varying(255),
end_date timestamp(6) without time zone,
period character varying(255),
points real,
priority integer,
start_date timestamp(6) without time zone,
sub_type character varying(255),
type character varying(255),
value character varying(255)
);
--
-- TOC entry 254 (class 1259 OID 19763)
-- Name: crew_bid_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_bid_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 255 (class 1259 OID 19764)
-- Name: crew_communication; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_communication (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255) NOT NULL,
end_date timestamp(6) without time zone,
priority integer,
start_date timestamp(6) without time zone,
sub_type character varying(255),
type character varying(255),
value character varying(255)
);
--
-- TOC entry 256 (class 1259 OID 19769)
-- Name: crew_communication_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_communication_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255),
end_date timestamp(6) without time zone,
priority integer,
start_date timestamp(6) without time zone,
sub_type character varying(255),
type character varying(255),
value character varying(255)
);
--
-- TOC entry 257 (class 1259 OID 19774)
-- Name: crew_communication_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_communication_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 258 (class 1259 OID 19775)
-- Name: crew_document; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_document (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255) NOT NULL,
doc_no character varying(255),
end_date timestamp(6) without time zone,
issued_at timestamp(6) without time zone,
issuer character varying(255),
ref_doc_no character varying(255),
start_date timestamp(6) without time zone,
sub_type character varying(255),
type character varying(255)
);
--
-- TOC entry 259 (class 1259 OID 19780)
-- Name: crew_document_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_document_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255),
doc_no character varying(255),
end_date timestamp(6) without time zone,
issued_at timestamp(6) without time zone,
issuer character varying(255),
ref_doc_no character varying(255),
start_date timestamp(6) without time zone,
sub_type character varying(255),
type character varying(255)
);
--
-- TOC entry 260 (class 1259 OID 19785)
-- Name: crew_document_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_document_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 261 (class 1259 OID 19786)
-- Name: crew_duties; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_duties (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255) NOT NULL,
duty_id character varying(255),
end_date timestamp(6) without time zone,
number_of_activities integer,
number_of_landings integer,
roster_id character varying(255),
start_date timestamp(6) without time zone,
status character varying(255),
total_block_time character varying(255),
total_duty_time character varying(255),
trip_id character varying(255),
source_key character varying(255),
training_start_date timestamp(6) without time zone,
training_end_date timestamp(6) without time zone,
training_position character varying(255)
);
--
-- TOC entry 262 (class 1259 OID 19791)
-- Name: crew_duties_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_duties_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255),
duty_id character varying(255),
end_date timestamp(6) without time zone,
number_of_activities integer,
number_of_landings integer,
roster_id character varying(255),
start_date timestamp(6) without time zone,
status character varying(255),
total_block_time character varying(255),
total_duty_time character varying(255),
trip_id character varying(255),
source_key character varying(255),
training_start_date timestamp(6) without time zone,
training_end_date timestamp(6) without time zone,
training_position character varying(255)
);
--
-- TOC entry 263 (class 1259 OID 19796)
-- Name: crew_duties_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_duties_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 264 (class 1259 OID 19797)
-- Name: crew_employment; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_employment (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
carrier character varying(255),
company character varying(255),
contract_sub_type character varying(255),
contract_type character varying(255),
crew_info_id character varying(255) NOT NULL,
end_date timestamp(6) without time zone,
start_date timestamp(6) without time zone,
type character varying(255)
);
--
-- TOC entry 265 (class 1259 OID 19802)
-- Name: crew_employment_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_employment_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
carrier character varying(255),
company character varying(255),
contract_sub_type character varying(255),
contract_type character varying(255),
crew_info_id character varying(255),
end_date timestamp(6) without time zone,
start_date timestamp(6) without time zone,
type character varying(255)
);
--
-- TOC entry 266 (class 1259 OID 19807)
-- Name: crew_employment_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_employment_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 267 (class 1259 OID 19808)
-- Name: crew_flight; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_flight (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255) NOT NULL,
duty_id character varying(255),
leg_id character varying(255),
"position" character varying(255),
roster_id character varying(255),
status character varying(255),
trip_id character varying(255),
duty_type character varying(255),
source_key character varying(255)
);
--
-- TOC entry 268 (class 1259 OID 19813)
-- Name: crew_flight_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_flight_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255),
duty_id character varying(255),
leg_id character varying(255),
"position" character varying(255),
roster_id character varying(255),
status character varying(255),
trip_id character varying(255),
duty_type character varying(255),
source_key character varying(255)
);
--
-- TOC entry 269 (class 1259 OID 19818)
-- Name: crew_flight_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_flight_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 374 (class 1259 OID 1966193)
-- Name: crew_flight_transport; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_flight_transport (
udor date,
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone,
arrival_date timestamp(6) without time zone,
departure_date timestamp(6) without time zone,
id bigint NOT NULL,
arrival_airport character varying(255),
carrier character varying(255),
crew_info_id character varying(255) NOT NULL,
departure_airport character varying(255),
duty_id character varying(255),
extra_info character varying(255),
leg_id character varying(255),
roster_id character varying(255) NOT NULL,
source_key character varying(255) NOT NULL,
status character varying(255),
suffix character varying(50),
flight_number character varying(50),
trip_id character varying(255)
);
--
-- TOC entry 375 (class 1259 OID 1966202)
-- Name: crew_flight_transport_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_flight_transport_aud (
rev integer NOT NULL,
revtype smallint,
udor date,
created_at timestamp(6) without time zone,
updated_at timestamp(6) without time zone,
arrival_date timestamp(6) without time zone,
departure_date timestamp(6) without time zone,
id bigint NOT NULL,
arrival_airport character varying(255),
carrier character varying(255),
crew_info_id character varying(255),
departure_airport character varying(255),
duty_id character varying(255),
extra_info character varying(255),
leg_id character varying(255),
roster_id character varying(255),
source_key character varying(255),
status character varying(255),
suffix character varying(50),
flight_number character varying(50),
trip_id character varying(255)
);
--
-- TOC entry 373 (class 1259 OID 1966192)
-- Name: crew_flight_transport_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_flight_transport_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 270 (class 1259 OID 19819)
-- Name: crew_ground_activity; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_ground_activity (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
code character varying(255),
crew_info_id character varying(255) NOT NULL,
end_date timestamp(6) without time zone,
"position" character varying(255),
roster_id character varying(255),
start_date timestamp(6) without time zone,
station character varying(255),
status character varying(255),
source_key character varying(255),
trip_id character varying(255),
duty_id character varying(255),
code_description character varying(255)
);
--
-- TOC entry 271 (class 1259 OID 19824)
-- Name: crew_ground_activity_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_ground_activity_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
code character varying(255),
crew_info_id character varying(255),
end_date timestamp(6) without time zone,
"position" character varying(255),
roster_id character varying(255),
start_date timestamp(6) without time zone,
station character varying(255),
status character varying(255),
source_key character varying(255),
trip_id character varying(255),
duty_id character varying(255),
code_description character varying(255)
);
--
-- TOC entry 272 (class 1259 OID 19829)
-- Name: crew_ground_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_ground_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 273 (class 1259 OID 19830)
-- Name: crew_ground_transport; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_ground_transport (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255) NOT NULL,
destination character varying(255),
end_date timestamp(6) without time zone,
leg_id character varying(255),
pickup character varying(255),
start_date timestamp(6) without time zone,
status character varying(255),
type character varying(255),
begin_date date,
source_key character varying(255),
roster_id character varying(255),
trip_id character varying(255),
duty_id character varying(255)
);
--
-- TOC entry 274 (class 1259 OID 19835)
-- Name: crew_ground_transport_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_ground_transport_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255),
destination character varying(255),
end_date timestamp(6) without time zone,
leg_id character varying(255),
pickup character varying(255),
start_date timestamp(6) without time zone,
status character varying(255),
type character varying(255),
begin_date date,
source_key character varying(255),
roster_id character varying(255),
trip_id character varying(255),
duty_id character varying(255)
);
--
-- TOC entry 275 (class 1259 OID 19840)
-- Name: crew_ground_transport_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_ground_transport_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 276 (class 1259 OID 19841)
-- Name: crew_info; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_info (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
birth_city character varying(255),
birth_country character varying(255),
birth_day date,
blood_type character varying(255),
category character varying(255),
citizenship_id character varying(255),
crew_id character varying(255) NOT NULL,
crew_info_id character varying(255),
employment_date date,
first_flight_date date,
forenames character varying(255),
id_card_no character varying(255),
leave_date date,
leave_reason character varying(255),
maiden_name character varying(255),
marital_status character varying(255),
marriage_date date,
nationality character varying(255),
period character varying(255),
preferred_name character varying(255),
secondary_id character varying(255),
sex character varying(255),
surname character varying(255),
title character varying(255)
);
--
-- TOC entry 277 (class 1259 OID 19846)
-- Name: crew_info_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_info_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
birth_city character varying(255),
birth_country character varying(255),
birth_day date,
blood_type character varying(255),
category character varying(255),
citizenship_id character varying(255),
crew_id character varying(255),
crew_info_id character varying(255),
employment_date date,
first_flight_date date,
forenames character varying(255),
id_card_no character varying(255),
leave_date date,
leave_reason character varying(255),
maiden_name character varying(255),
marital_status character varying(255),
marriage_date date,
nationality character varying(255),
period character varying(255),
preferred_name character varying(255),
secondary_id character varying(255),
sex character varying(255),
surname character varying(255),
title character varying(255)
);
--
-- TOC entry 278 (class 1259 OID 19851)
-- Name: crew_layover; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_layover (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
arrival_flight_leg_id character varying(255),
crew_info_id character varying(255) NOT NULL,
departure_flight_leg_id character varying(255),
distance_from_station character varying(255),
durations_from_station character varying(255),
end_date timestamp(6) without time zone,
hotel_id character varying(255),
start_date timestamp(6) without time zone,
status character varying(255),
source_key character varying(255),
roster_id character varying(255)
);
--
-- TOC entry 279 (class 1259 OID 19856)
-- Name: crew_layover_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_layover_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
arrival_flight_leg_id character varying(255),
crew_info_id character varying(255),
departure_flight_leg_id character varying(255),
distance_from_station character varying(255),
durations_from_station character varying(255),
end_date timestamp(6) without time zone,
hotel_id character varying(255),
start_date timestamp(6) without time zone,
status character varying(255),
source_key character varying(255),
roster_id character varying(255)
);
--
-- TOC entry 280 (class 1259 OID 19861)
-- Name: crew_layover_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_layover_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 399 (class 1259 OID 2108185)
-- Name: crew_notification_alert; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_notification_alert (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
alert_date timestamp(6) without time zone,
crew_info_id character varying(255) NOT NULL,
end_date timestamp(6) without time zone,
source_key character varying(255),
start_date timestamp(6) without time zone,
status character varying(255),
type character varying(255)
);
--
-- TOC entry 400 (class 1259 OID 2108192)
-- Name: crew_notification_alert_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_notification_alert_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
alert_date timestamp(6) without time zone,
crew_info_id character varying(255),
end_date timestamp(6) without time zone,
source_key character varying(255),
start_date timestamp(6) without time zone,
status character varying(255),
type character varying(255)
);
--
-- TOC entry 401 (class 1259 OID 2108201)
-- Name: crew_notification_alert_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_notification_alert_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 281 (class 1259 OID 19862)
-- Name: crew_pair_trip; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_pair_trip (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255) NOT NULL,
end_date timestamp(6) without time zone,
number_of_duties integer,
roster_id character varying(255),
start_date timestamp(6) without time zone,
status character varying(255),
total_block_time character varying(255),
total_duty_time character varying(255),
total_rest_time character varying(255),
trip_id character varying(255) NOT NULL,
number_of_activities integer,
number_of_landings integer,
source_key character varying(255)
);
--
-- TOC entry 282 (class 1259 OID 19867)
-- Name: crew_pair_trip_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_pair_trip_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255),
end_date timestamp(6) without time zone,
number_of_duties integer,
roster_id character varying(255),
start_date timestamp(6) without time zone,
status character varying(255),
total_block_time character varying(255),
total_duty_time character varying(255),
total_rest_time character varying(255),
trip_id character varying(255),
number_of_activities integer,
number_of_landings integer,
source_key character varying(255)
);
--
-- TOC entry 283 (class 1259 OID 19872)
-- Name: crew_pair_trip_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_pair_trip_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 284 (class 1259 OID 19873)
-- Name: crew_qualification; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_qualification (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
aircraft_type character varying(255),
category character varying(255),
crew_info_id character varying(255) NOT NULL,
end_date timestamp(6) without time zone,
level character varying(255),
start_date timestamp(6) without time zone,
sub_type character varying(255),
type character varying(255),
source_key character varying(255),
cat character varying(255)
);
--
-- TOC entry 285 (class 1259 OID 19878)
-- Name: crew_qualification_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_qualification_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
aircraft_type character varying(255),
category character varying(255),
crew_info_id character varying(255),
end_date timestamp(6) without time zone,
level character varying(255),
start_date timestamp(6) without time zone,
sub_type character varying(255),
type character varying(255),
source_key character varying(255),
cat character varying(255)
);
--
-- TOC entry 286 (class 1259 OID 19883)
-- Name: crew_qualification_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_qualification_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 287 (class 1259 OID 19884)
-- Name: crew_roster; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_roster (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255) NOT NULL,
roster_id character varying(255)
);
--
-- TOC entry 288 (class 1259 OID 19889)
-- Name: crew_roster_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_roster_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255),
roster_id character varying(255)
);
--
-- TOC entry 396 (class 1259 OID 2108163)
-- Name: crew_roster_notice; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_roster_notice (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255) NOT NULL,
date date,
notice character varying(2048),
source_key character varying(255),
status character varying(255),
type character varying(255)
);
--
-- TOC entry 397 (class 1259 OID 2108170)
-- Name: crew_roster_notice_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_roster_notice_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255),
date date,
notice character varying(2048),
source_key character varying(255),
status character varying(255),
type character varying(255)
);
--
-- TOC entry 398 (class 1259 OID 2108179)
-- Name: crew_roster_notice_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_roster_notice_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 289 (class 1259 OID 19894)
-- Name: crew_roster_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_roster_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 290 (class 1259 OID 19895)
-- Name: crew_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 393 (class 1259 OID 2056766)
-- Name: crew_simulator_flight; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_simulator_flight (
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone,
enddate timestamp(6) without time zone,
id bigint NOT NULL,
startdate timestamp(6) without time zone,
code character varying(255),
crew_info_id character varying(255) NOT NULL,
duty_id character varying(255),
extra_info character varying(255),
"position" character varying(255),
roster_id character varying(255) NOT NULL,
source_key character varying(255),
station character varying(255),
status character varying(255),
trip_id character varying(255)
);
--
-- TOC entry 394 (class 1259 OID 2056773)
-- Name: crew_simulator_flight_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_simulator_flight_aud (
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
updated_at timestamp(6) without time zone,
enddate timestamp(6) without time zone,
id bigint NOT NULL,
startdate timestamp(6) without time zone,
code character varying(255),
crew_info_id character varying(255),
duty_id character varying(255),
extra_info character varying(255),
"position" character varying(255),
roster_id character varying(255),
source_key character varying(255),
station character varying(255),
status character varying(255),
trip_id character varying(255)
);
--
-- TOC entry 392 (class 1259 OID 2056765)
-- Name: crew_simulator_flight_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_simulator_flight_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 291 (class 1259 OID 19896)
-- Name: crew_statistic; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_statistic (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255) NOT NULL,
end_date timestamp(6) without time zone,
mean real,
median real,
period character varying(255),
start_date timestamp(6) without time zone,
sub_type character varying(255),
type character varying(255),
value real,
rank character varying(255),
mode real
);
--
-- TOC entry 292 (class 1259 OID 19901)
-- Name: crew_statistic_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.crew_statistic_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
crew_info_id character varying(255),
end_date timestamp(6) without time zone,
mean real,
median real,
period character varying(255),
start_date timestamp(6) without time zone,
sub_type character varying(255),
type character varying(255),
value real,
rank character varying(255),
mode real
);
--
-- TOC entry 293 (class 1259 OID 19906)
-- Name: crew_statistic_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.crew_statistic_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 294 (class 1259 OID 19907)
-- Name: databasechangelog_crew; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.databasechangelog_crew (
id character varying(255) NOT NULL,
author character varying(255) NOT NULL,
filename character varying(255) NOT NULL,
dateexecuted timestamp without time zone NOT NULL,
orderexecuted integer NOT NULL,
exectype character varying(10) NOT NULL,
md5sum character varying(35),
description character varying(255),
comments character varying(255),
tag character varying(255),
liquibase character varying(20),
contexts character varying(255),
labels character varying(255),
deployment_id character varying(10)
);
--
-- TOC entry 372 (class 1259 OID 1949725)
-- Name: databasechangelog_event_manager; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.databasechangelog_event_manager (
id character varying(255) NOT NULL,
author character varying(255) NOT NULL,
filename character varying(255) NOT NULL,
dateexecuted timestamp without time zone NOT NULL,
orderexecuted integer NOT NULL,
exectype character varying(10) NOT NULL,
md5sum character varying(35),
description character varying(255),
comments character varying(255),
tag character varying(255),
liquibase character varying(20),
contexts character varying(255),
labels character varying(255),
deployment_id character varying(10)
);
--
-- TOC entry 295 (class 1259 OID 19912)
-- Name: databasechangelog_flight; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.databasechangelog_flight (
id character varying(255) NOT NULL,
author character varying(255) NOT NULL,
filename character varying(255) NOT NULL,
dateexecuted timestamp without time zone NOT NULL,
orderexecuted integer NOT NULL,
exectype character varying(10) NOT NULL,
md5sum character varying(35),
description character varying(255),
comments character varying(255),
tag character varying(255),
liquibase character varying(20),
contexts character varying(255),
labels character varying(255),
deployment_id character varying(10)
);
--
-- TOC entry 296 (class 1259 OID 19917)
-- Name: databasechangelog_ground; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.databasechangelog_ground (
id character varying(255) NOT NULL,
author character varying(255) NOT NULL,
filename character varying(255) NOT NULL,
dateexecuted timestamp without time zone NOT NULL,
orderexecuted integer NOT NULL,
exectype character varying(10) NOT NULL,
md5sum character varying(35),
description character varying(255),
comments character varying(255),
tag character varying(255),
liquibase character varying(20),
contexts character varying(255),
labels character varying(255),
deployment_id character varying(10)
);
--
-- TOC entry 403 (class 1259 OID 2123997)
-- Name: databasechangelog_smart; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.databasechangelog_smart (
id character varying(255) NOT NULL,
author character varying(255) NOT NULL,
filename character varying(255) NOT NULL,
dateexecuted timestamp without time zone NOT NULL,
orderexecuted integer NOT NULL,
exectype character varying(10) NOT NULL,
md5sum character varying(35),
description character varying(255),
comments character varying(255),
tag character varying(255),
liquibase character varying(20),
contexts character varying(255),
labels character varying(255),
deployment_id character varying(10)
);
--
-- TOC entry 364 (class 1259 OID 360461)
-- Name: databasechangelog_thunder; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.databasechangelog_thunder (
id character varying(255) NOT NULL,
author character varying(255) NOT NULL,
filename character varying(255) NOT NULL,
dateexecuted timestamp without time zone NOT NULL,
orderexecuted integer NOT NULL,
exectype character varying(10) NOT NULL,
md5sum character varying(35),
description character varying(255),
comments character varying(255),
tag character varying(255),
liquibase character varying(20),
contexts character varying(255),
labels character varying(255),
deployment_id character varying(10)
);
--
-- TOC entry 297 (class 1259 OID 19922)
-- Name: databasechangeloglock_crew; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.databasechangeloglock_crew (
id integer NOT NULL,
locked boolean NOT NULL,
lockgranted timestamp without time zone,
lockedby character varying(255)
);
--
-- TOC entry 371 (class 1259 OID 1949720)
-- Name: databasechangeloglock_event_manager; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.databasechangeloglock_event_manager (
id integer NOT NULL,
locked boolean NOT NULL,
lockgranted timestamp without time zone,
lockedby character varying(255)
);
--
-- TOC entry 298 (class 1259 OID 19925)
-- Name: databasechangeloglock_flight; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.databasechangeloglock_flight (
id integer NOT NULL,
locked boolean NOT NULL,
lockgranted timestamp without time zone,
lockedby character varying(255)
);
--
-- TOC entry 299 (class 1259 OID 19928)
-- Name: databasechangeloglock_ground; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.databasechangeloglock_ground (
id integer NOT NULL,
locked boolean NOT NULL,
lockgranted timestamp without time zone,
lockedby character varying(255)
);
--
-- TOC entry 402 (class 1259 OID 2123992)
-- Name: databasechangeloglock_smart; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.databasechangeloglock_smart (
id integer NOT NULL,
locked boolean NOT NULL,
lockgranted timestamp without time zone,
lockedby character varying(255)
);
--
-- TOC entry 363 (class 1259 OID 360456)
-- Name: databasechangeloglock_thunder; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.databasechangeloglock_thunder (
id integer NOT NULL,
locked boolean NOT NULL,
lockgranted timestamp without time zone,
lockedby character varying(255)
);
--
-- TOC entry 300 (class 1259 OID 19931)
-- Name: flight_crew; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.flight_crew (
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
crew_id character varying(255) NOT NULL,
crew_name character varying(255),
crew_position character varying(255),
duty_type character varying(255),
extra_info character varying(255),
leg_id character varying(255) NOT NULL
);
--
-- TOC entry 301 (class 1259 OID 19936)
-- Name: flight_crew_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.flight_crew_aud (
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
crew_id character varying(255),
crew_name character varying(255),
crew_position character varying(255),
duty_type character varying(255),
extra_info character varying(255),
leg_id character varying(255)
);
--
-- TOC entry 302 (class 1259 OID 19941)
-- Name: flight_crew_need_vector; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.flight_crew_need_vector (
number_of_crew integer,
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
duty_type character varying(255),
extra_info character varying(255),
leg_id character varying(255) NOT NULL,
"position" character varying(255)
);
--
-- TOC entry 303 (class 1259 OID 19946)
-- Name: flight_crew_need_vector_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.flight_crew_need_vector_aud (
rev integer NOT NULL,
revtype smallint,
number_of_crew integer,
created_at timestamp(6) without time zone,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
duty_type character varying(255),
extra_info character varying(255),
leg_id character varying(255),
"position" character varying(255)
);
--
-- TOC entry 304 (class 1259 OID 19951)
-- Name: flight_crew_need_vector_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.flight_crew_need_vector_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 305 (class 1259 OID 19952)
-- Name: flight_crew_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.flight_crew_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 306 (class 1259 OID 19953)
-- Name: flight_delay; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.flight_delay (
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone,
actual_duration bigint,
estimated_duration bigint,
id bigint NOT NULL,
last_update timestamp(6) without time zone,
updated_arrival_time timestamp(6) without time zone,
updated_departure_time timestamp(6) without time zone,
delay_code character varying(255),
extra_info character varying(255),
leg_id character varying(255) NOT NULL,
reason_of_delay character varying(255),
reason_order character varying(255),
sub_delay_code character varying(255),
status character varying(50)
);
--
-- TOC entry 307 (class 1259 OID 19958)
-- Name: flight_delay_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.flight_delay_aud (
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
updated_at timestamp(6) without time zone,
actual_duration bigint,
estimated_duration bigint,
id bigint NOT NULL,
last_update timestamp(6) without time zone,
updated_arrival_time timestamp(6) without time zone,
updated_departure_time timestamp(6) without time zone,
delay_code character varying(255),
extra_info character varying(255),
leg_id character varying(255),
reason_of_delay character varying(255),
reason_order character varying(255),
sub_delay_code character varying(255),
status character varying(50)
);
--
-- TOC entry 308 (class 1259 OID 19963)
-- Name: flight_delay_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.flight_delay_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 406 (class 1259 OID 2124057)
-- Name: flight_disruption; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.flight_disruption (
category32b double precision,
category_16f double precision,
category_19a double precision,
category_19b double precision,
category_32a double precision,
category_32d double precision,
category_32x double precision,
category_41a double precision,
category_43c double precision,
category_46c double precision,
category_81a double precision,
category_81b double precision,
category_83m double precision,
category_85f double precision,
category_89c double precision,
category_91b double precision,
category_93a double precision,
category_93b double precision,
category_95a double precision,
category_96c double precision,
category_96j double precision,
category_99b double precision,
category_99d double precision,
category_other double precision,
delay_minute double precision,
on_time double precision,
inference_category character varying(255),
inference_value double precision,
udor date,
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
scheduled_landing_time timestamp(6) without time zone,
scheduled_takeoff_time timestamp(6) without time zone,
arrival_airport character varying(255),
carrier character varying(255),
departure_airport character varying(255),
flight_number character varying(255),
leg_id character varying(255),
suffix character varying(255)
);
--
-- TOC entry 407 (class 1259 OID 2124064)
-- Name: flight_disruption_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.flight_disruption_aud (
rev integer NOT NULL,
revtype smallint,
category32b double precision,
category_16f double precision,
category_19a double precision,
category_19b double precision,
category_32a double precision,
category_32d double precision,
category_32x double precision,
category_41a double precision,
category_43c double precision,
category_46c double precision,
category_81a double precision,
category_81b double precision,
category_83m double precision,
category_85f double precision,
category_89c double precision,
category_91b double precision,
category_93a double precision,
category_93b double precision,
category_95a double precision,
category_96c double precision,
category_96j double precision,
category_99b double precision,
category_99d double precision,
category_other double precision,
delay_minute double precision,
on_time double precision,
inference_category character varying(255),
inference_value double precision,
udor date,
created_at timestamp(6) without time zone,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
scheduled_landing_time timestamp(6) without time zone,
scheduled_takeoff_time timestamp(6) without time zone,
arrival_airport character varying(255),
carrier character varying(255),
departure_airport character varying(255),
flight_number character varying(255),
leg_id character varying(255),
suffix character varying(255)
);
--
-- TOC entry 404 (class 1259 OID 2124055)
-- Name: flight_disruption_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.flight_disruption_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 309 (class 1259 OID 19964)
-- Name: flight_leg; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.flight_leg (
udor date,
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone,
actual_delay_duration bigint,
actual_in_block_time timestamp(6) without time zone,
actual_landing_time timestamp(6) without time zone,
actual_off_block_time timestamp(6) without time zone,
actual_take_off_time timestamp(6) without time zone,
ctot timestamp(6) without time zone,
estimated_delay_duration bigint,
estimated_in_block_time timestamp(6) without time zone,
estimated_landing_time timestamp(6) without time zone,
estimated_off_block_time timestamp(6) without time zone,
estimated_take_off_time timestamp(6) without time zone,
id bigint NOT NULL,
scheduled_in_block_time timestamp(6) without time zone,
scheduled_landing_time timestamp(6) without time zone,
scheduled_off_block_time timestamp(6) without time zone,
scheduled_take_off_time timestamp(6) without time zone,
ac_reg_no character varying(255),
aircraft_subtype character varying(255),
aircraft_type character varying(255),
arr_stand character varying(255),
arrival_airport character varying(255),
arrival_gate character varying(255),
call_code character varying(255),
carrier character varying(255),
dep_stand character varying(255),
departure_airport character varying(255),
departure_gate character varying(255),
extra_info character varying(255),
flight_number character varying(255),
leg_id character varying(255),
open_for_checkin character varying(255),
rescheduled_arrival_airport character varying(255),
rescheduled_departure_airport character varying(255),
service_type character varying(255),
status_code character varying(255),
suffix character varying(255),
boarding_start_date timestamp(6) without time zone,
estimated_enroute_time bigint,
traffic character varying(50),
CONSTRAINT flight_leg_status_code_check CHECK (((status_code)::text = ANY (ARRAY[('SKD'::character varying)::text, ('NEW'::character varying)::text, ('EQT'::character varying)::text, ('RRT'::character varying)::text, ('TIM'::character varying)::text, ('ISK'::character varying)::text, ('DEL'::character varying)::text, ('ON'::character varying)::text, ('OUT'::character varying)::text, ('RTR'::character varying)::text, ('NXI'::character varying)::text, ('ETD'::character varying)::text, ('DEP'::character varying)::text, ('DIV'::character varying)::text, ('ARR'::character varying)::text, ('CNL'::character varying)::text, ('INC'::character varying)::text])))
);
--
-- TOC entry 310 (class 1259 OID 19970)
-- Name: flight_leg_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.flight_leg_aud (
rev integer NOT NULL,
revtype smallint,
udor date,
created_at timestamp(6) without time zone,
updated_at timestamp(6) without time zone,
actual_delay_duration bigint,
actual_in_block_time timestamp(6) without time zone,
actual_landing_time timestamp(6) without time zone,
actual_off_block_time timestamp(6) without time zone,
actual_take_off_time timestamp(6) without time zone,
ctot timestamp(6) without time zone,
estimated_delay_duration bigint,
estimated_in_block_time timestamp(6) without time zone,
estimated_landing_time timestamp(6) without time zone,
estimated_off_block_time timestamp(6) without time zone,
estimated_take_off_time timestamp(6) without time zone,
id bigint NOT NULL,
scheduled_in_block_time timestamp(6) without time zone,
scheduled_landing_time timestamp(6) without time zone,
scheduled_off_block_time timestamp(6) without time zone,
scheduled_take_off_time timestamp(6) without time zone,
ac_reg_no character varying(255),
aircraft_subtype character varying(255),
aircraft_type character varying(255),
arr_stand character varying(255),
arrival_airport character varying(255),
arrival_gate character varying(255),
call_code character varying(255),
carrier character varying(255),
dep_stand character varying(255),
departure_airport character varying(255),
departure_gate character varying(255),
extra_info character varying(255),
flight_number character varying(255),
leg_id character varying(255),
open_for_checkin character varying(255),
rescheduled_arrival_airport character varying(255),
rescheduled_departure_airport character varying(255),
service_type character varying(255),
status_code character varying(255),
suffix character varying(255),
boarding_start_date timestamp(6) without time zone,
estimated_enroute_time bigint,
traffic character varying(50),
CONSTRAINT flight_leg_aud_status_code_check CHECK (((status_code)::text = ANY (ARRAY[('SKD'::character varying)::text, ('NEW'::character varying)::text, ('EQT'::character varying)::text, ('RRT'::character varying)::text, ('TIM'::character varying)::text, ('ISK'::character varying)::text, ('DEL'::character varying)::text, ('ON'::character varying)::text, ('OUT'::character varying)::text, ('RTR'::character varying)::text, ('NXI'::character varying)::text, ('ETD'::character varying)::text, ('DEP'::character varying)::text, ('DIV'::character varying)::text, ('ARR'::character varying)::text, ('CNL'::character varying)::text, ('INC'::character varying)::text])))
);
--
-- TOC entry 311 (class 1259 OID 19976)
-- Name: flight_leg_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.flight_leg_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 312 (class 1259 OID 19977)
-- Name: flight_leg_times; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.flight_leg_times (
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone,
date_time timestamp(6) without time zone,
id bigint NOT NULL,
extra_info character varying(255),
leg_id character varying(255) NOT NULL,
source character varying(255),
status character varying(255),
type character varying(255)
);
--
-- TOC entry 313 (class 1259 OID 19982)
-- Name: flight_leg_times_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.flight_leg_times_aud (
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
updated_at timestamp(6) without time zone,
date_time timestamp(6) without time zone,
id bigint NOT NULL,
extra_info character varying(255),
leg_id character varying(255),
source character varying(255),
status character varying(255),
type character varying(255)
);
--
-- TOC entry 314 (class 1259 OID 19987)
-- Name: flight_leg_times_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.flight_leg_times_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 377 (class 1259 OID 2015245)
-- Name: flyway_event_manager_history; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.flyway_event_manager_history (
installed_rank integer NOT NULL,
version character varying(50),
description character varying(200) NOT NULL,
type character varying(20) NOT NULL,
script character varying(1000) NOT NULL,
checksum integer,
installed_by character varying(100) NOT NULL,
installed_on timestamp without time zone DEFAULT now() NOT NULL,
execution_time integer NOT NULL,
success boolean NOT NULL
);
--
-- TOC entry 315 (class 1259 OID 19988)
-- Name: ground_traffic; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.ground_traffic (
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
"time" timestamp(6) without time zone,
carrier character varying(255),
extra_info character varying(255),
latitude character varying(255),
longitude character varying(255),
pos_marker character varying(255),
reg_id character varying(255),
type character varying(255)
);
--
-- TOC entry 316 (class 1259 OID 19993)
-- Name: ground_traffic_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.ground_traffic_aud (
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
"time" timestamp(6) without time zone,
carrier character varying(255),
extra_info character varying(255),
latitude character varying(255),
longitude character varying(255),
pos_marker character varying(255),
reg_id character varying(255),
type character varying(255)
);
--
-- TOC entry 317 (class 1259 OID 19998)
-- Name: ground_traffic_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.ground_traffic_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 376 (class 1259 OID 2007058)
-- Name: hibernate_sequence; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.hibernate_sequence
START WITH 1
INCREMENT BY 50
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 370 (class 1259 OID 1893018)
-- Name: orders; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.orders (
orderid integer NOT NULL,
customer character varying(255),
price numeric(10,2)
);
--
-- TOC entry 318 (class 1259 OID 20000)
-- Name: pax_boarding_summary; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.pax_boarding_summary (
id bigint NOT NULL,
created_at timestamp without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp without time zone,
flight_leg_id character varying(255),
number_of_pax bigint,
pax_status character varying(255),
pax_type character varying(255)
);
--
-- TOC entry 319 (class 1259 OID 20005)
-- Name: pax_boarding_summary_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.pax_boarding_summary_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp without time zone,
extra_info character varying(255),
updated_at timestamp without time zone,
flight_leg_id character varying(255),
number_of_pax bigint,
pax_status character varying(255),
pax_type character varying(255)
);
--
-- TOC entry 320 (class 1259 OID 20010)
-- Name: pax_boarding_summary_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.pax_boarding_summary_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 321 (class 1259 OID 20011)
-- Name: pax_fare_basis_summary; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.pax_fare_basis_summary (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
fare_basis character varying(255),
flight_leg_id character varying(255),
number_of_codes bigint
);
--
-- TOC entry 322 (class 1259 OID 20016)
-- Name: pax_fare_basis_summary_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.pax_fare_basis_summary_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
fare_basis character varying(255),
flight_leg_id character varying(255),
number_of_codes bigint
);
--
-- TOC entry 323 (class 1259 OID 20021)
-- Name: pax_fare_basis_summary_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.pax_fare_basis_summary_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 324 (class 1259 OID 20022)
-- Name: pax_info; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.pax_info (
id bigint NOT NULL,
created_at timestamp without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp without time zone,
arrival_airport character varying(255),
arrival_time timestamp without time zone,
carrier character varying(255),
departure_airport character varying(255),
departure_time timestamp without time zone,
flight_number character varying(255),
forenames character varying(255),
passenger_card character varying(255),
passenger_card_type character varying(255),
passenger_reference_id character varying(255),
pnr character varying(255),
seat_number character varying(255),
suffix character varying(255),
surname character varying(255),
udor date,
gender character varying(255),
checked_in character varying(255),
cabin_class character varying(255),
infant character varying(255),
unaccompanied_minor character varying(255),
flight_leg_id character varying(255),
in_bound_arrival_airport character varying(255),
in_bound_carrier character varying(255),
in_bound_departure_airport character varying(255),
in_bound_flight_number character varying(255),
in_bound_transfer_pax character varying(1),
out_bound_arrival_airport character varying(255),
out_bound_carrier character varying(255),
out_bound_departure_airport character varying(255),
out_bound_flight_number character varying(255),
out_bound_transfer_pax character varying(1),
fare_basis character varying(255)
);
--
-- TOC entry 325 (class 1259 OID 20027)
-- Name: pax_info_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.pax_info_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp without time zone,
extra_info character varying(255),
updated_at timestamp without time zone,
arrival_airport character varying(255),
arrival_time timestamp without time zone,
carrier character varying(255),
departure_airport character varying(255),
departure_time timestamp without time zone,
flight_number character varying(255),
forenames character varying(255),
passenger_card character varying(255),
passenger_card_type character varying(255),
passenger_reference_id character varying(255),
pnr character varying(255),
seat_number character varying(255),
suffix character varying(255),
surname character varying(255),
udor date,
gender character varying(255),
checked_in character varying(255),
cabin_class character varying(255),
infant character varying(255),
unaccompanied_minor character varying(255),
flight_leg_id character varying(255),
in_bound_arrival_airport character varying(255),
in_bound_carrier character varying(255),
in_bound_departure_airport character varying(255),
in_bound_flight_number character varying(255),
in_bound_transfer_pax character varying(1),
out_bound_arrival_airport character varying(255),
out_bound_carrier character varying(255),
out_bound_departure_airport character varying(255),
out_bound_flight_number character varying(255),
out_bound_transfer_pax character varying(1),
fare_basis character varying(255)
);
--
-- TOC entry 326 (class 1259 OID 20032)
-- Name: pax_info_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.pax_info_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 327 (class 1259 OID 20033)
-- Name: pax_ssr_info; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.pax_ssr_info (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
passenger_reference_id character varying(255),
pnr character varying(255),
ssr_code character varying(255),
sub_ssr_code character varying(255),
flight_leg_id character varying(255)
);
--
-- TOC entry 328 (class 1259 OID 20038)
-- Name: pax_ssr_info_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.pax_ssr_info_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
passenger_reference_id character varying(255),
pnr character varying(255),
ssr_code character varying(255),
sub_ssr_code character varying(255),
flight_leg_id character varying(255)
);
--
-- TOC entry 329 (class 1259 OID 20043)
-- Name: pax_ssr_info_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.pax_ssr_info_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 330 (class 1259 OID 20044)
-- Name: pax_ssr_summary; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.pax_ssr_summary (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
flight_leg_id character varying(255),
numberofrequest bigint,
ssr_code character varying(255)
);
--
-- TOC entry 331 (class 1259 OID 20049)
-- Name: pax_ssr_summary_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.pax_ssr_summary_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
flight_leg_id character varying(255),
numberofrequest bigint,
ssr_code character varying(255)
);
--
-- TOC entry 332 (class 1259 OID 20054)
-- Name: pax_ssr_summary_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.pax_ssr_summary_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 333 (class 1259 OID 20055)
-- Name: pax_summary; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.pax_summary (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
arrival_airport character varying(255),
arrival_time timestamp(6) without time zone,
booked_pax bigint,
carrier character varying(255),
checked_pax bigint,
departure_airport character varying(255),
departure_time timestamp(6) without time zone,
flight_number character varying(255),
inbound_transfers bigint,
outbound_transfers bigint,
predicted_pax bigint,
suffix character varying(255),
udor date,
flight_leg_id character varying(255),
no_show_pax bigint,
number_of_booked_child_passengers bigint,
number_of_booked_female_passengers bigint,
number_of_booked_infant_passengers bigint,
number_of_booked_male_passengers bigint,
number_of_checked_child_passengers bigint,
number_of_checked_female_passengers bigint,
number_of_checked_infant_passengers bigint,
number_of_checked_male_passengers bigint,
total_boarded_pax bigint,
updated_from character varying(255)
);
--
-- TOC entry 334 (class 1259 OID 20060)
-- Name: pax_summary_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.pax_summary_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
arrival_airport character varying(255),
arrival_time timestamp(6) without time zone,
booked_pax bigint,
carrier character varying(255),
checked_pax bigint,
departure_airport character varying(255),
departure_time timestamp(6) without time zone,
flight_number character varying(255),
inbound_transfers bigint,
outbound_transfers bigint,
predicted_pax bigint,
suffix character varying(255),
udor date,
flight_leg_id character varying(255),
no_show_pax bigint,
number_of_booked_child_passengers bigint,
number_of_booked_female_passengers bigint,
number_of_booked_infant_passengers bigint,
number_of_booked_male_passengers bigint,
number_of_checked_child_passengers bigint,
number_of_checked_female_passengers bigint,
number_of_checked_infant_passengers bigint,
number_of_checked_male_passengers bigint,
total_boarded_pax bigint,
updated_from character varying(255)
);
--
-- TOC entry 335 (class 1259 OID 20065)
-- Name: pax_summary_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.pax_summary_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 385 (class 1259 OID 2015315)
-- Name: qrtz_blob_triggers; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.qrtz_blob_triggers (
sched_name character varying(120) NOT NULL,
trigger_name character varying(200) NOT NULL,
trigger_group character varying(200) NOT NULL,
blob_data bytea
);
--
-- TOC entry 386 (class 1259 OID 2015327)
-- Name: qrtz_calendars; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.qrtz_calendars (
sched_name character varying(120) NOT NULL,
calendar_name character varying(200) NOT NULL,
calendar bytea NOT NULL
);
--
-- TOC entry 383 (class 1259 OID 2015291)
-- Name: qrtz_cron_triggers; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.qrtz_cron_triggers (
sched_name character varying(120) NOT NULL,
trigger_name character varying(200) NOT NULL,
trigger_group character varying(200) NOT NULL,
cron_expression character varying(120) NOT NULL,
time_zone_id character varying(80)
);
--
-- TOC entry 388 (class 1259 OID 2015339)
-- Name: qrtz_fired_triggers; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.qrtz_fired_triggers (
sched_name character varying(120) NOT NULL,
entry_id character varying(95) NOT NULL,
trigger_name character varying(200) NOT NULL,
trigger_group character varying(200) NOT NULL,
instance_name character varying(200) NOT NULL,
fired_time bigint NOT NULL,
sched_time bigint NOT NULL,
priority integer NOT NULL,
state character varying(16) NOT NULL,
job_name character varying(200),
job_group character varying(200),
is_nonconcurrent boolean,
requests_recovery boolean
);
--
-- TOC entry 380 (class 1259 OID 2015260)
-- Name: qrtz_job_details; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.qrtz_job_details (
sched_name character varying(120) NOT NULL,
job_name character varying(200) NOT NULL,
job_group character varying(200) NOT NULL,
description character varying(250),
job_class_name character varying(250) NOT NULL,
is_durable boolean NOT NULL,
is_nonconcurrent boolean NOT NULL,
is_update_data boolean NOT NULL,
requests_recovery boolean NOT NULL,
job_data bytea
);
--
-- TOC entry 390 (class 1259 OID 2015351)
-- Name: qrtz_locks; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.qrtz_locks (
sched_name character varying(120) NOT NULL,
lock_name character varying(40) NOT NULL
);
--
-- TOC entry 387 (class 1259 OID 2015334)
-- Name: qrtz_paused_trigger_grps; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.qrtz_paused_trigger_grps (
sched_name character varying(120) NOT NULL,
trigger_group character varying(200) NOT NULL
);
--
-- TOC entry 389 (class 1259 OID 2015346)
-- Name: qrtz_scheduler_state; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.qrtz_scheduler_state (
sched_name character varying(120) NOT NULL,
instance_name character varying(200) NOT NULL,
last_checkin_time bigint NOT NULL,
checkin_interval bigint NOT NULL
);
--
-- TOC entry 382 (class 1259 OID 2015279)
-- Name: qrtz_simple_triggers; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.qrtz_simple_triggers (
sched_name character varying(120) NOT NULL,
trigger_name character varying(200) NOT NULL,
trigger_group character varying(200) NOT NULL,
repeat_count bigint NOT NULL,
repeat_interval bigint NOT NULL,
times_triggered bigint NOT NULL
);
--
-- TOC entry 384 (class 1259 OID 2015303)
-- Name: qrtz_simprop_triggers; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.qrtz_simprop_triggers (
sched_name character varying(120) NOT NULL,
trigger_name character varying(200) NOT NULL,
trigger_group character varying(200) NOT NULL,
str_prop_1 character varying(512),
str_prop_2 character varying(512),
str_prop_3 character varying(512),
int_prop_1 integer,
int_prop_2 integer,
long_prop_1 bigint,
long_prop_2 bigint,
dec_prop_1 numeric(13,4),
dec_prop_2 numeric(13,4),
bool_prop_1 boolean,
bool_prop_2 boolean
);
--
-- TOC entry 381 (class 1259 OID 2015267)
-- Name: qrtz_triggers; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.qrtz_triggers (
sched_name character varying(120) NOT NULL,
trigger_name character varying(200) NOT NULL,
trigger_group character varying(200) NOT NULL,
job_name character varying(200) NOT NULL,
job_group character varying(200) NOT NULL,
description character varying(250),
next_fire_time bigint,
prev_fire_time bigint,
priority integer,
trigger_state character varying(16) NOT NULL,
trigger_type character varying(8) NOT NULL,
start_time bigint NOT NULL,
end_time bigint,
calendar_name character varying(200),
misfire_instr smallint,
job_data bytea
);
--
-- TOC entry 336 (class 1259 OID 20115)
-- Name: revinfo_crew; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.revinfo_crew (
rev integer NOT NULL,
revstamp bigint NOT NULL
);
--
-- TOC entry 337 (class 1259 OID 20118)
-- Name: revinfo_crew_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.revinfo_crew_seq
START WITH 1
INCREMENT BY 50
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 338 (class 1259 OID 20119)
-- Name: revinfo_flight; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.revinfo_flight (
rev integer NOT NULL,
revstamp bigint NOT NULL
);
--
-- TOC entry 339 (class 1259 OID 20122)
-- Name: revinfo_flight_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.revinfo_flight_seq
START WITH 1
INCREMENT BY 50
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 340 (class 1259 OID 20123)
-- Name: revinfo_ground; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.revinfo_ground (
rev integer NOT NULL,
revstamp bigint NOT NULL
);
--
-- TOC entry 341 (class 1259 OID 20126)
-- Name: revinfo_ground_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.revinfo_ground_seq
START WITH 1
INCREMENT BY 50
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 408 (class 1259 OID 2124071)
-- Name: revinfo_smart; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.revinfo_smart (
rev integer NOT NULL,
revstamp bigint NOT NULL
);
--
-- TOC entry 405 (class 1259 OID 2124056)
-- Name: revinfo_smart_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.revinfo_smart_seq
START WITH 1
INCREMENT BY 50
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 367 (class 1259 OID 360468)
-- Name: revinfo_thunder; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.revinfo_thunder (
rev integer NOT NULL,
revstamp bigint NOT NULL
);
--
-- TOC entry 365 (class 1259 OID 360466)
-- Name: revinfo_thunder_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.revinfo_thunder_seq
START WITH 1
INCREMENT BY 50
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 342 (class 1259 OID 20127)
-- Name: roster; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.roster (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
period_end timestamp(6) without time zone,
period_start timestamp(6) without time zone,
publish_date timestamp(6) without time zone,
roster_id character varying(255),
status character varying(255),
total_expected_fatigue real
);
--
-- TOC entry 343 (class 1259 OID 20132)
-- Name: roster_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.roster_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
period_end timestamp(6) without time zone,
period_start timestamp(6) without time zone,
publish_date timestamp(6) without time zone,
roster_id character varying(255),
status character varying(255),
total_expected_fatigue real
);
--
-- TOC entry 344 (class 1259 OID 20137)
-- Name: roster_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.roster_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 345 (class 1259 OID 20138)
-- Name: station; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.station (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
address character varying(255),
city character varying(255),
country character varying(255),
email character varying(255),
fax character varying(255),
icao character varying(255),
latitude character varying(255),
longitude character varying(255),
phone character varying(255),
region character varying(255),
station_id character varying(255),
station_name character varying(255),
telex character varying(255),
timezone character varying(255)
);
--
-- TOC entry 346 (class 1259 OID 20143)
-- Name: station_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.station_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
address character varying(255),
city character varying(255),
country character varying(255),
email character varying(255),
fax character varying(255),
icao character varying(255),
latitude character varying(255),
longitude character varying(255),
phone character varying(255),
region character varying(255),
station_id character varying(255),
station_name character varying(255),
telex character varying(255),
timezone character varying(255)
);
--
-- TOC entry 347 (class 1259 OID 20148)
-- Name: station_contact; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.station_contact (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
manager character varying(255),
manager_email character varying(255),
manager_phone character varying(255),
station_id character varying(255)
);
--
-- TOC entry 348 (class 1259 OID 20153)
-- Name: station_contact_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.station_contact_aud (
id bigint NOT NULL,
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
manager character varying(255),
manager_email character varying(255),
manager_phone character varying(255),
station_id character varying(255)
);
--
-- TOC entry 349 (class 1259 OID 20158)
-- Name: station_contact_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.station_contact_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 350 (class 1259 OID 20159)
-- Name: station_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.station_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 395 (class 1259 OID 2106297)
-- Name: station_with_weather; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.station_with_weather (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
address character varying(255),
city character varying(255),
country character varying(255),
email character varying(255),
fax character varying(255),
icao character varying(255),
latitude character varying(255),
longitude character varying(255),
phone character varying(255),
region character varying(255),
station_id character varying(255),
station_name character varying(255),
telex character varying(255),
timezone character varying(255)
);
--
-- TOC entry 379 (class 1259 OID 2015255)
-- Name: tasks; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.tasks (
id bigint NOT NULL,
createdat timestamp without time zone
);
--
-- TOC entry 378 (class 1259 OID 2015254)
-- Name: tasks_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.tasks_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 368 (class 1259 OID 360473)
-- Name: test; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.test (
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
number_of_seats bigint,
ac_type character varying(255),
contract character varying(255),
customized_type character varying(255),
extra_info character varying(255),
name_of_aircraft character varying(255),
owner character varying(255),
reg_id character varying(255),
registrar character varying(255),
subtype character varying(255)
);
--
-- TOC entry 369 (class 1259 OID 360480)
-- Name: test_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.test_aud (
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
number_of_seats bigint,
ac_type character varying(255),
contract character varying(255),
customized_type character varying(255),
extra_info character varying(255),
name_of_aircraft character varying(255),
owner character varying(255),
reg_id character varying(255),
registrar character varying(255),
subtype character varying(255)
);
--
-- TOC entry 366 (class 1259 OID 360467)
-- Name: test_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.test_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 351 (class 1259 OID 20163)
-- Name: timezones; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.timezones (
created_at timestamp(6) without time zone NOT NULL,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
end_long character varying(255),
exception character varying(255),
extra_info character varying(255),
start_long character varying(255),
timezone_id character varying(255)
);
--
-- TOC entry 352 (class 1259 OID 20168)
-- Name: timezones_aud; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.timezones_aud (
rev integer NOT NULL,
revtype smallint,
created_at timestamp(6) without time zone,
updated_at timestamp(6) without time zone,
id bigint NOT NULL,
end_long character varying(255),
exception character varying(255),
extra_info character varying(255),
start_long character varying(255),
timezone_id character varying(255)
);
--
-- TOC entry 353 (class 1259 OID 20173)
-- Name: timezones_seq; Type: SEQUENCE; Schema: river; Owner: -
--
CREATE SEQUENCE river.timezones_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- TOC entry 354 (class 1259 OID 20174)
-- Name: tows; Type: TABLE; Schema: river; Owner: -
--
CREATE TABLE river.tows (
id bigint NOT NULL,
created_at timestamp(6) without time zone NOT NULL,
extra_info character varying(255),
updated_at timestamp(6) without time zone,
end_lat character varying(255),
end_long character varying(255),
end_time timestamp(6) without time zone,
ramp_id character varying(255),
reg_id character varying(255),
start_lat character varying(255),
start_long character varying(255),
start_time timestamp(6) without time zone,
stations_id bigint,
status character varying(255),
tow_id character