---

CREATE TABLE Stops (
    id_stops INT PRIMARY KEY,
    stop_name VARCHAR(100),
    address VARCHAR(100),
    nearby VARCHAR(100)
    -- убираем id_route отсюда!
);

CREATE TABLE Route (
    id_route INT PRIMARY KEY,
    route_number VARCHAR(20),
    time TIME,
    start_route INT,  -- FK на Stops
    end_route INT,    -- FK на Stops
    ticket_price DECIMAL(10, 2),
    activity BIT,
    FOREIGN KEY (start_route) REFERENCES Stops(id_stops),
    FOREIGN KEY (end_route) REFERENCES Stops(id_stops)
);