CREATE TABLE [dbo].[Reserva] (
    [idReserva]        INT            IDENTITY (1, 1) NOT NULL,
    [idUtilizador]     NVARCHAR (128) NULL,
    [custoPrevisto]    FLOAT (53)     NULL,
    [idPosto]          INT            NULL,
    [estado]           NCHAR (10)     NULL,
    [dataReserva]      DATETIME       NULL,
    [idIntervaloTempo] INT            NULL,
    PRIMARY KEY CLUSTERED ([idReserva] ASC),
    CONSTRAINT [FK_dbo.Reserva_dbo.IntervaloTempo_idIntervaloTempo] FOREIGN KEY ([idIntervaloTempo]) REFERENCES [dbo].[IntervaloTempo] ([idIntervaloTempo]),
    CONSTRAINT [FK_dbo.Reserva_dbo.AspNetUsers_Id] FOREIGN KEY ([idUtilizador]) REFERENCES [dbo].[AspNetUsers] ([Id]),
    CONSTRAINT [FK_dbo.Reserva_dbo.Posto_idPosto] FOREIGN KEY ([idPosto]) REFERENCES [dbo].[Posto] ([idPosto])
);