ALTER TABLE [AKUZ].[T_APGAR_ASSESSMENT_OF_NEWBORN] ALTER COLUMN [NewbornDevelopmentHistory] uniqueidentifier NULL
GO

ALTER TABLE [AKUZ].[T_APGAR_ASSESSMENT_OF_NEWBORN] ADD [ChildRegistration] uniqueidentifier NULL
GO
ALTER TABLE [AKUZ].[T_APGAR_ASSESSMENT_OF_NEWBORN] ADD CONSTRAINT [FK_T_CHILD_REGISTRATION_T_APGAR_ASSESSMENT_OF_NEWBORN_ChildRegistration]
FOREIGN KEY([ChildRegistration]) REFERENCES [AKUZ].[T_CHILD_REGISTRATION] ([MovementID])
GO

--
ALTER TABLE [AKUZ].[T_CHILD_REGISTRATION] ADD [Caesarean] bit NOT NULL CONSTRAINT [df_Caesarean] DEFAULT 0 WITH VALUES
GO
ALTER TABLE [AKUZ].[T_CHILD_REGISTRATION] DROP CONSTRAINT [df_Caesarean]
GO

ALTER TABLE [AKUZ].[T_CHILD_REGISTRATION] ADD [Post] int NULL
GO
ALTER TABLE [AKUZ].[T_CHILD_REGISTRATION] ADD CONSTRAINT [FK_T_POST_T_CHILD_REGISTRATION_Post]
FOREIGN KEY([Post]) REFERENCES [AKUZ].[T_POST] ([ResourceID])
GO