 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
 GO
 ALTER TABLE [Archive].[tblRelatedValuesArchive]  WITH CHECK ADD  CONSTRAINT [FK_tblRelatedValuesArchive_tblLURosterGen1Assignment] FOREIGN KEY([RosterAssignmentID])
-REFERENCES [Metadata].[tblroster_assignment_79_gen1] ([ID])
+REFERENCES [Metadata].[tblroster_assignment_gen1] ([ID])
 ON UPDATE CASCADE
 ON DELETE CASCADE
 GO

GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Metadata].[tblVariable_79](
	[VariableCode] [char](8) NOT NULL,
	[Item] [smallint] NOT NULL,
	[Generation] [tinyint] NOT NULL,

GO
ALTER TABLE [Archive].[tblRelatedValuesArchive] CHECK CONSTRAINT [FK_tblRelatedValuesArchive_tblLUTristate]
GO
ALTER TABLE [Metadata].[tblroster_assignment_gen1]  WITH CHECK ADD  CONSTRAINT [FK_tblLURosterGen1Assignment_tblLURosterGen1] FOREIGN KEY([ResponseLower])
REFERENCES [Enum].[tblLURosterGen1] ([ID])
GO
ALTER TABLE [Metadata].[tblroster_assignment_gen1] CHECK CONSTRAINT [FK_tblLURosterGen1Assignment_tblLURosterGen1]
GO
ALTER TABLE [Metadata].[tblroster_assignment_gen1]  WITH CHECK ADD  CONSTRAINT [FK_tblLURosterGen1Assignment_tblLURosterGen11] FOREIGN KEY([ResponseUpper])
REFERENCES [Enum].[tblLURosterGen1] ([ID])
GO
ALTER TABLE [Metadata].[tblroster_assignment_gen1] CHECK CONSTRAINT [FK_tblLURosterGen1Assignment_tblLURosterGen11]
GO
ALTER TABLE [Metadata].[tblroster_assignment_gen1]  WITH CHECK ADD  CONSTRAINT [FK_tblLURosterGen1Assignment_tblLUTristate] FOREIGN KEY([SameGeneration])
REFERENCES [Enum].[tblLUTristate] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Metadata].[tblroster_assignment_gen1] CHECK CONSTRAINT [FK_tblLURosterGen1Assignment_tblLUTristate]
GO
ALTER TABLE [Metadata].[tblroster_assignment_gen1]  WITH CHECK ADD  CONSTRAINT [FK_tblLURosterGen1Assignment_tblLUTristate1] FOREIGN KEY([ShareBiodad])
REFERENCES [Enum].[tblLUTristate] ([ID])
GO
ALTER TABLE [Metadata].[tblroster_assignment_gen1] CHECK CONSTRAINT [FK_tblLURosterGen1Assignment_tblLUTristate1]
GO
ALTER TABLE [Metadata].[tblroster_assignment_gen1]  WITH CHECK ADD  CONSTRAINT [FK_tblLURosterGen1Assignment_tblLUTristate2] FOREIGN KEY([ShareBiomom])
REFERENCES [Enum].[tblLUTristate] ([ID])
GO
ALTER TABLE [Metadata].[tblroster_assignment_gen1] CHECK CONSTRAINT [FK_tblLURosterGen1Assignment_tblLUTristate2]
GO
ALTER TABLE [Metadata].[tblroster_assignment_gen1]  WITH CHECK ADD  CONSTRAINT [FK_tblLURosterGen1Assignment_tblLUTristate3] FOREIGN KEY([ShareBiograndparent])
REFERENCES [Enum].[tblLUTristate] ([ID])
GO
ALTER TABLE [Metadata].[tblroster_assignment_gen1] CHECK CONSTRAINT [FK_tblLURosterGen1Assignment_tblLUTristate3]
GO
ALTER TABLE [Metadata].[tblVariable]  WITH CHECK ADD  CONSTRAINT [FK_tblVariable_79_tblItem_79] FOREIGN KEY([Item])
REFERENCES [Metadata].[tblItem] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Metadata].[tblVariable] CHECK CONSTRAINT [FK_tblVariable_79_tblItem_79]
GO
ALTER TABLE [Metadata].[tblVariable]  WITH CHECK ADD  CONSTRAINT [FK_tblVariable_79_tblLUExtractSource] FOREIGN KEY([ExtractSource])
REFERENCES [Enum].[tblLUExtractSource] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [Metadata].[tblVariable] CHECK CONSTRAINT [FK_tblVariable_79_tblLUExtractSource]
GO
ALTER TABLE [Process].[tblBabyDaddy]  WITH CHECK ADD  CONSTRAINT [FK_tblBabyDaddy_tblLUYesNoGen_BiodadInHH] FOREIGN KEY([BiodadInHH])
REFERENCES [Enum].[tblLUYesNo] ([ID])
