-- Tables

-- Alters

ALTER TABLE [AKUZ].[T_MEDICAL_EPISODE] ADD [Result] int NULL
GO

ALTER TABLE [AKUZ].[T_MEDICAL_EPISODE] ADD [Outcome] int NULL
GO

ALTER TABLE [AKUZ].[T_MEDICAL_EPISODE] ADD CONSTRAINT [FK_T_V009_RESULT_T_MEDICAL_EPISODE_Result]
FOREIGN KEY([Result]) REFERENCES [AKUZ].[T_V009_RESULT] ([IDRMP])
GO

ALTER TABLE [AKUZ].[T_MEDICAL_EPISODE] ADD CONSTRAINT [FK_T_V012_OUTCOME_T_MEDICAL_EPISODE_Outcome]
FOREIGN KEY([Outcome]) REFERENCES [AKUZ].[T_V012_OUTCOME] ([IDIZ])
GO

