-- Tables

-- Alters

delete from [AKUZ].[T_PROCEDURE_JOURNAL_NOTE]

ALTER TABLE [AKUZ].[T_PROCEDURE_JOURNAL_NOTE] DROP CONSTRAINT [FK_T_RESEARCH_T_PROCEDURE_JOURNAL_NOTE_Research]
GO

ALTER TABLE [AKUZ].[T_PROCEDURE_JOURNAL_NOTE] DROP COLUMN [Research]
GO

ALTER TABLE [AKUZ].[T_PROCEDURE_JOURNAL_NOTE] ADD [Procedure] uniqueidentifier NOT NULL CONSTRAINT [df_Procedure] DEFAULT '00000000-0000-0000-0000-000000000000' WITH VALUES
GO
ALTER TABLE [AKUZ].[T_PROCEDURE_JOURNAL_NOTE] DROP CONSTRAINT [df_Procedure]
GO

ALTER TABLE [AKUZ].[T_PROCEDURE_JOURNAL_NOTE] ADD CONSTRAINT [FK_T_MEDICAL_SERVICE_T_PROCEDURE_JOURNAL_NOTE_Procedure]
FOREIGN KEY([Procedure]) REFERENCES [AKUZ].[T_MEDICAL_SERVICE] ([MedicalServiceID])
GO
