Control_DB_Railway/SQL_Scripts/dbo.Stations_Roads.sql

CREATE TABLE [dbo].[Stations_Roads] (
    [stationID] INT NOT NULL,
    [roadID]    INT NOT NULL,
    CONSTRAINT [PKcomp_Stations_Roads] PRIMARY KEY CLUSTERED ([stationID] ASC, [roadID] ASC),
    CONSTRAINT [FK2_Stations_Roads] FOREIGN KEY ([roadID]) REFERENCES [dbo].[Roads] ([roadID]) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT [FK1_Stations_Roads] FOREIGN KEY ([stationID]) REFERENCES [dbo].[Stations] ([stationID]) ON DELETE CASCADE ON UPDATE CASCADE
);