create table #package
 (
 id int PRIMARY KEY IDENTITY(1,1),
 ZfeatureId INT NULL,
 AcceptedValueID INT NULL,
 PackageID INT NULL,
 ValueName NVARCHAR(2000) default ''
 )
indexes i have 
on package table
     create nonclustered index IDX_PackageID on #package(PackageID) include (ZfeatureId,AcceptedValueID , ValueName)
     create index acceptedvaluesidpackage_idx on #package(AcceptedValueID)

package attributes table

    ALTER TABLE [Parts].[Nop_PackageAttribute] ADD  CONSTRAINT [PK_Nop_PackageAttribute] PRIMARY KEY CLUSTERED 
    (
    	[PackageAttributeID] 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 [Customer]
    GO
    CREATE NONCLUSTERED INDEX [_dta_index_Nop_PackageAttribute_8_578153155__K2_K1_K3_4] ON [Parts].[Nop_PackageAttribute]
    (
    	[PackageID] ASC,
    	[PackageAttributeID] ASC,
    	[Key] ASC
    )
    INCLUDE ( 	[Value]) 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 [Customer]

    CREATE NONCLUSTERED INDEX [IDX_Key] ON [Parts].[Nop_PackageAttribute]
    (
    	[Key] 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 [Customer]

    
    CREATE NONCLUSTERED INDEX [IDX_PakageID] ON [Parts].[Nop_PackageAttribute]
    (
    	[PackageID] 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 [Customer]
    GO
    CREATE NONCLUSTERED INDEX [IX_Nop_PackageAttribute_Key] ON [Parts].[Nop_PackageAttribute]
    (
    	[Key] ASC
    )
    INCLUDE ( 	[PackageID],
    	[Value]) 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 [Customer]


    CREATE TABLE [Parts].[Nop_PackageAttribute](
    	[PackageAttributeID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
    	[PackageID] [int] NOT NULL,
    	[Key] [int] NOT NULL,
    	[Value] [nvarchar](max) NOT NULL,
    	[CreatedDate] [datetime] NULL,
    	[CreatedBy] [int] NULL,
    	[ModifiedDate] [datetime] NULL,
    	[ModifiedBy] [int] NULL,
    	[DeletedDate] [datetime] NULL,
    	[DeletedBy] [int] NULL,
     CONSTRAINT [PK_Nop_PackageAttribute] PRIMARY KEY CLUSTERED 
    (
    	[PackageAttributeID] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Customer]
    ) ON [Customer] TEXTIMAGE_ON [PRIMARY]

nop_acceptedvaluesoption table

    ALTER TABLE [dbo].[Nop_AcceptedValuesOption] ADD  CONSTRAINT [PK_Nop_AcceptedValuesOption] PRIMARY KEY CLUSTERED 
    (
    	[AcceptedValuesOptionID] 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 [Customer]
    GO
    
    CREATE NONCLUSTERED COLUMNSTORE INDEX [_dta_index_Nop_AcceptedValuesOption_5_1669580986__col__] ON [dbo].[Nop_AcceptedValuesOption]
    (
    	[AcceptedValuesOptionID],
    	[AcceptedValuesID],
    	[Name],
    	[DisplayOrder],
    	[Description],
    	[CreatedDate],
    	[CreatedBy],
    	[ModifiedDate],
    	[ModifiedBy],
    	[DeletedDate],
    	[DeletedBy],
    	[Is_Split],
    	[AcceptedValuesOption_Value],
    	[AcceptedValuesOption_Unit]
    )WITH (DROP_EXISTING = OFF) ON [Customer]
    
    CREATE NONCLUSTERED INDEX [_dta_index_Nop_AcceptedValuesOption_8_1074154922__K1_3] ON [dbo].[Nop_AcceptedValuesOption]
    (
    	[AcceptedValuesOptionID] ASC
    )
    INCLUDE ( 	[Name]) 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 [Customer]
    GO
    CREATE NONCLUSTERED INDEX [_dta_index_Nop_AcceptedValuesOption_8_1074154922__K2_K4_1_3] ON [dbo].[Nop_AcceptedValuesOption]
    (
    	[AcceptedValuesID] ASC,
    	[DisplayOrder] ASC
    )
    INCLUDE ( 	[AcceptedValuesOptionID],
    	[Name]) 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 [Customer]
    GO
    CREATE NONCLUSTERED INDEX [NonClusteredIndex-20160824-070515] ON [dbo].[Nop_AcceptedValuesOption]
    (
    	[AcceptedValuesID] 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 [Customer]
    GO
    CREATE NONCLUSTERED INDEX [NonClusteredIndex-20160829-015901] ON [dbo].[Nop_AcceptedValuesOption]
    (
    	[Name] 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 [Customer]
    GO
    
    CREATE TABLE [dbo].[Nop_AcceptedValuesOption](
    	[AcceptedValuesOptionID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
    	[AcceptedValuesID] [int] NOT NULL,
    	[Name] [nvarchar](500) NOT NULL,
    	[DisplayOrder] [int] NOT NULL,
    	[Description] [varchar](250) NULL,
    	[CreatedDate] [datetime] NULL,
    	[CreatedBy] [int] NULL,
    	[ModifiedDate] [datetime] NULL,
    	[ModifiedBy] [int] NULL,
    	[DeletedDate] [datetime] NULL,
    	[DeletedBy] [int] NULL,
    	[Is_Split] [int] NULL,
    	[AcceptedValuesOption_Value] [float] NULL,
    	[AcceptedValuesOption_Unit] [nvarchar](20) NULL,
    	[IsDeleted] [bit] NULL,
     CONSTRAINT [PK_Nop_AcceptedValuesOption] PRIMARY KEY CLUSTERED 
    (
    	[AcceptedValuesOptionID] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Customer]
    ) ON [Customer]
    
    GO
    
    SET ANSI_PADDING ON
    GO
    
    ALTER TABLE [dbo].[Nop_AcceptedValuesOption] ADD  CONSTRAINT [DF_IsDeleted]  DEFAULT ((0)) FOR [IsDeleted]
    GO
    
    ALTER TABLE [dbo].[Nop_AcceptedValuesOption] CHECK CONSTRAINT [FK_Nop_AcceptedValuesOption_Nop_AcceptedValues]
    GO