CREATE TABLE [dbo].[Delibere] (
    [CodTipoDelibera] NVARCHAR (50) NOT NULL,
    [UDC]             NVARCHAR (50) NOT NULL,
    [DataDelibera]    DATETIME      NOT NULL,
    [CodSoggetto]     NCHAR (17)    NOT NULL,
    CONSTRAINT [PK_Delibere] PRIMARY KEY CLUSTERED ([CodTipoDelibera] ASC, [UDC] ASC),
    CONSTRAINT [FK_Delibere_AnagTipoDelibere] FOREIGN KEY ([CodTipoDelibera]) REFERENCES [dbo].[AnagTipoDelibere] ([CodTipoDelibera]) ON UPDATE CASCADE,
    CONSTRAINT [FK_Delibere_ElencoCartellini] FOREIGN KEY ([UDC]) REFERENCES [dbo].[ElencoCartellini] ([UDC]) ON UPDATE CASCADE
);

