-- Tables

-- Alters

ALTER TABLE [AKUZ].[T_CDA_SECTION_PREGNANCY_CHILDBIRTH] ADD [AddressLiving] uniqueidentifier NULL
GO

ALTER TABLE [AKUZ].[T_CDA_SECTION_PREGNANCY_CHILDBIRTH] ADD [AddressRegistry] uniqueidentifier NULL
GO

ALTER TABLE [AKUZ].[T_CDA_SECTION_PREGNANCY_CHILDBIRTH] ADD CONSTRAINT [FK_T_PATIENT_ADDRESS_T_CDA_SECTION_PREGNANCY_CHILDBIRTH_AddressLiving]
FOREIGN KEY([AddressLiving]) REFERENCES [AKUZ].[T_PATIENT_ADDRESS] ([AddressID])
GO

ALTER TABLE [AKUZ].[T_CDA_SECTION_PREGNANCY_CHILDBIRTH] ADD CONSTRAINT [FK_T_PATIENT_ADDRESS_T_CDA_SECTION_PREGNANCY_CHILDBIRTH_AddressRegistry]
FOREIGN KEY([AddressRegistry]) REFERENCES [AKUZ].[T_PATIENT_ADDRESS] ([AddressID])
GO

ALTER TABLE [AKUZ].[T_CDA_SECTION_PREGNANCY_CHILDBIRTH] ALTER COLUMN [region_living] uniqueidentifier NULL
GO
ALTER TABLE [AKUZ].[T_CDA_SECTION_PREGNANCY_CHILDBIRTH] ALTER COLUMN [address_living] uniqueidentifier NULL
GO
ALTER TABLE [AKUZ].[T_CDA_SECTION_PREGNANCY_CHILDBIRTH] ALTER COLUMN [region_registry] uniqueidentifier NULL
GO
ALTER TABLE [AKUZ].[T_CDA_SECTION_PREGNANCY_CHILDBIRTH] ALTER COLUMN [address_registry] uniqueidentifier NULL
GO