Samuele E. Locatelli
10 lines
537 B
Transact-SQL
10 lines
537 B
Transact-SQL
CREATE TABLE [dbo].[InterventoOpMtz] (
|
|
[numIntMtz] INT NOT NULL,
|
|
[matrOp] NVARCHAR (10) NOT NULL,
|
|
[durataMinuti] INT NULL,
|
|
CONSTRAINT [PK_InterventoOpMtz] PRIMARY KEY CLUSTERED ([numIntMtz] ASC, [matrOp] ASC),
|
|
CONSTRAINT [FK_InterventoOpMtz_AnagrOperMtz] FOREIGN KEY ([matrOp]) REFERENCES [dbo].[AnagrOperMtz] ([matrOp]) ON UPDATE CASCADE,
|
|
CONSTRAINT [FK_InterventoOpMtz_InterventiMtz] FOREIGN KEY ([numIntMtz]) REFERENCES [dbo].[InterventiMtz] ([numIntMtz]) ON UPDATE CASCADE
|
|
);
|
|
|