yi0nYfk8

1if not exists (select * from dbo.sysobjects 
2               where id = object_id(N'[dbo].[HistoricoClinico]') )
3BEGIN
4    CREATE TABLE HistoricoClinico (
5        IdHistoricoClinico int NOT NULL
6            CHECK (IdHistoricoClinico >= 1),
7        IdUtente int 
8            CONSTRAINT nn_IdUtente NOT NULL,
9
10        CONSTRAINT PK_IdHistoricoClinico PRIMARY KEY (IdHistoricoClinico),
11
12        CONSTRAINT FK_IdUtente FOREIGN KEY (IdUtente)
13            REFERENCES Utente(IdUtente)
14            ON UPDATE CASCADE
15
16    ); 
17END
18	
19if not exists (select * from dbo.sysobjects 
20               where id = object_id(N'[dbo].[Acede]') )
21
22BEGIN
23CREATE TABLE Acede(
24    IdColaborador int 
25        CONSTRAINT nn_IdColaborador NOT NULL,
26    IdHistoricoClinico int 
27        CONSTRAINT nn_IdHistoricoClinico NOT NULL,
28
29    CONSTRAINT PK_Acede
30        PRIMARY KEY (IdColaborador, IdHistoricoClinico),
31
32    CONSTRAINT FK_Acede_IdColaborador FOREIGN KEY(IdColaborador)
33        REFERENCES Colaborador(IdColaborador)
34        ON UPDATE CASCADE,
35
36    CONSTRAINT FK_Acede_IdHistoricoClinico FOREIGN KEY(IdHistoricoClinico)
37        REFERENCES HistoricoClinico(IdHistoricoClinico)
38        ON UPDATE CASCADE
39);
40END