-- Tables

-- Alters

ALTER TABLE [AKUZ].[T_MOVEMENTS_DIVISION_CARD] ADD [PatientDivisionLocation] uniqueidentifier
GO
update [AKUZ].[T_MOVEMENTS_DIVISION_CARD] set PatientDivisionLocation = Division

ALTER TABLE [AKUZ].[T_MOVEMENTS_DIVISION_CARD] ADD CONSTRAINT [FK_T_DIVISION_T_MOVEMENTS_DIVISION_CARD_PatientDivisionLocation]
FOREIGN KEY([PatientDivisionLocation]) REFERENCES [AKUZ].[T_DIVISION] ([DivisionID])
GO

