Mistero SQL SERVER 2000

USE tempdb;

CREATE TABLE dbo.ais_dia (
dia_dia nvarchar (20) NOT NULL PRIMARY KEY,
dia_des nvarchar (2000) NULL ,
dia_rep_id nvarchar (50) NULL ,
dia_eli bit NULL 
);
GO

CREATE TABLE dbo.ais_paz (
paz_id int NOT NULL PRIMARY KEY,
paz_nom nvarchar (41) NULL ,
paz_cog nvarchar (62) NULL ,
paz_cf nvarchar (16) NULL ,
paz_dna nvarchar (10) NULL ,
paz_sex bit NULL ,
paz_pre nvarchar (2) NULL ,
paz_cre nvarchar (30) NULL 
);
GO

CREATE TABLE dbo.ais_ute (
ute_ute nvarchar (20) NOT NULL PRIMARY KEY,
ute_nom nvarchar (41) NULL ,
ute_cog nvarchar (62) NULL ,
ute_pw nvarchar (20) NULL ,
ute_pro nvarchar (20) NULL ,
ute_gru nvarchar (20) NULL ,
ute_log smalldatetime NULL ,
ute_spw smalldatetime NULL ,
ute_eli bit NULL 
);
GO


CREATE TABLE dbo.ais_sed (
sed_id int NOT NULL ,
sed_paz_id int NULL ,
sed_dat smalldatetime NOT NULL ,
sed_ora smalldatetime NULL ,
sed_mot_id nvarchar (50) NULL ,
sed_dia_id nvarchar (20) NULL ,
sed_ter_id nvarchar (20) NULL ,
sed_rep_id nvarchar (50) NULL ,
sed_tex nvarchar (2000) NULL ,
sed_ute_id nvarchar (20) NULL ,
sed_dcr smalldatetime NULL ,
sed_ucr nvarchar (20) NULL 
);
GO

ALTER TABLE dbo.ais_sed WITH NOCHECK ADD 
CONSTRAINT PK_ais_sed PRIMARY KEY CLUSTERED 
(
sed_id
); 
GO

ALTER TABLE dbo.ais_sed ADD 
CONSTRAINT IX_ais_sed UNIQUE NONCLUSTERED 
(
sed_paz_id,
sed_dat,
sed_rep_id
); 
GO

ALTER TABLE dbo.ais_sed ADD 
CONSTRAINT diagnosi_seduta FOREIGN KEY 
(
sed_dia_id
) REFERENCES dbo.ais_dia (
dia_dia
) ON UPDATE CASCADE ,
CONSTRAINT pazienti_seduta FOREIGN KEY 
(
sed_paz_id
) REFERENCES dbo.ais_paz (
paz_id
),
CONSTRAINT utente_seduta2 FOREIGN KEY 
(
sed_ucr
) REFERENCES dbo.ais_ute (
ute_ute
) ON UPDATE CASCADE 
GO

/* Output:

Command(s) completed successfully.

*/

DROP TABLE dbo.ais_sed, dbo.ais_ute, dbo.ais_paz, dbo.ais_dia;

ALTER TABLE [dbo].[ais_sed] ADD 
...
CONSTRAINT [utente_seduta2] FOREIGN KEY 
(
[sed_ucr]
) REFERENCES [dbo].[ais_ute] (
[ute_ute]
) ON UPDATE CASCADE ,

CONSTRAINT [utente_seduta1] FOREIGN KEY 
(
[sed_ute_id]
) REFERENCES [dbo].[ais_ute] (
[ute_ute]
) ON UPDATE CASCADE ,
...