Control_DB_Railway/SQL_Scripts/dbo.Stations.sql

CREATE TABLE [dbo].[Stations] (
    [stationID]          INT           IDENTITY (1, 1) NOT NULL,
    [typeStationID]      INT           NOT NULL,
    [nameStation]        NVARCHAR (40) NOT NULL,
    [image]              IMAGE         NULL,
    [overheadTransition] BIT           NOT NULL,
    [location]           NVARCHAR (50) NOT NULL,
    CONSTRAINT [PK_Stations] PRIMARY KEY CLUSTERED ([stationID] ASC),
    CONSTRAINT [FK_Stations] FOREIGN KEY ([typeStationID]) REFERENCES [dbo].[TypeStation] ([typeStationID]) ON DELETE CASCADE ON UPDATE CASCADE
);