CREATE DOMAIN identify
 AS INTEGER;

CREATE DOMAIN name_custom
 AS VARCHAR(30);

-- CREATE DOMAIN date_a
-- AS DATE
-- CHECK (date_d > date_a);
--
-- CREATE DOMAIN date_d
-- AS DATE
-- CHECK (date_d > date_a);

CREATE TABLE Stations(
	ID_station SERIAL NOT NULL,
	Name_station name_custom NOT NULL
);

CREATE TABLE Stops(
	ID_train identify NOT NULL,
	ID_stop SERIAL NOT NULL,
	ID_station identify NOT NULL,
	date_arrive name_custom NULL, --Время прибытия
	date_departure name_custom NULL,  --Время отправления
	day_from_departure identify NULL,
	transit BOOLEAN,
	order identify NOT NULL
);

-- CREATE TABLE Routes(
-- 	ID_route SERIAL NOT NULL,
-- 	Region  name_custom NOT NULL,
-- 	City    name_custom NOT NULL
-- );

CREATE TABLE Flights(
	ID_flight SERIAL NOT NULL,
	ID_train identify NOT NULL,
	date_start date NOT NULL,
);

CREATE TABLE Tickets (
	ID_ticket SERIAL NOT NULL,
	ID_place identify NOT NULL,
-- 	ID_route identify NOT NULL,
	ID_station identify NOT NULL,
	Stat_ID_station identify NOT NULL,
	date_arrival DATE NOT NULL, -- Генерирует приложение
	date_dispatch DATE NOT NULL, -- Генерирует приложение
	passport_number INTEGER NOT NULL,
	full_name VARCHAR(80) NOT NULL
);

CREATE TABLE Places(
	ID_carriage identify NOT NULL,
	place identify NULL,
	ID_place SERIAL NOT NULL
);

CREATE TABLE Carriages(
	ID_train identify NOT NULL,
	carriage identify NULL,
	ID_carriage SERIAL NOT NULL
);

CREATE TABLE Trains(
	ID_train SERIAL NOT NULL,
	train_number identify NULL
);