CREATE TABLE [dbo].[Vocabolario] (
    [Lingua]     NVARCHAR (3)   NOT NULL,
    [Lemma]      NVARCHAR (50)  NOT NULL,
    [Traduzione] NVARCHAR (500) NOT NULL,
    CONSTRAINT [PK_Vocabolario] PRIMARY KEY CLUSTERED ([Lingua] ASC, [Lemma] ASC),
    CONSTRAINT [FK_Vocabolario_Lingue] FOREIGN KEY ([Lingua]) REFERENCES [dbo].[Lingue] ([Lingua]) ON UPDATE CASCADE
);


GO
CREATE NONCLUSTERED INDEX [I_lemma]
    ON [dbo].[Vocabolario]([Lemma] ASC);

