USE [FSLibrary]
GO

SET ANSI_PADDING ON
GO

/****** Object:  Index [ClusteredIndex-20200513-145800]    Script Date: 6/23/2020 4:18:59 PM ******/
CREATE CLUSTERED INDEX [ClusteredIndex-20200513-145800] ON [dbo].[tbl_PRD_AllergenInfo]
(
	[ownerType] ASC,
	[ownerId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

/****** Object:  Index [NonClusteredIndex-20200513-150118]    Script Date: 6/23/2020 4:19:32 PM ******/
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20200513-150118] ON [dbo].[tbl_PRD_AllergenInfo]
(
	[ownerType] ASC,
	[ownerId] ASC,
	[linkType] ASC
)
INCLUDE([linkId],[allergenId]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO


CREATE UNIQUE NONCLUSTERED INDEX [NonClusteredIndex-20200513-152337] ON [dbo].[tbl_PRD_AllergenInfo]
(
	[ownerType] ASC,
	[ownerId] ASC,
	[linkType] ASC,
	[linkId] ASC,
	[allergenId] ASC
)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


/****** Object:  Index [PK_tbl_PRD_AllergenInfo]    Script Date: 6/23/2020 4:19:57 PM ******/
ALTER TABLE [dbo].[tbl_PRD_AllergenInfo] ADD  CONSTRAINT [PK_tbl_PRD_AllergenInfo] PRIMARY KEY NONCLUSTERED 
(
	[allergenInfoId] ASC,
	[ownerType] ASC,
	[ownerId] ASC,
	[linkType] ASC,
	[linkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO