Prodect /ProdectExtraTabsDetails/ProdectOptionDetails/ProductsSpecificationsDetails

USE [Ecommerce]
GO

/****** Object:  Table [dbo].[ProductsSpecificationsDetails]    Script Date: 4/12/2019 9:10:17 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ProductsSpecificationsDetails](
	[Specificationsdetailsid] [int] NOT NULL,
	[Specificationsid] [varchar](50) NULL,
	[SpecificationsTax] [varchar](500) NULL,
	[Prodectid] [nvarchar](50) NULL,
 CONSTRAINT [PK_ProductsAttributeDetails] PRIMARY KEY CLUSTERED 
(
	[Specificationsdetailsid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


++++++++++++++++++++++++++++++++




USE [Ecommerce]
GO

/****** Object:  Table [dbo].[ProdectOptionDetails]    Script Date: 4/12/2019 9:14:07 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ProdectOptionDetails](
	[ProdectOptionid] [int] IDENTITY(1,1) NOT NULL,
	[Prodectid] [int] NULL,
	[Optionsid] [int] NULL,
	[Optionname] [nvarchar](150) NULL,
	[Image] [nvarchar](50) NULL,
	[URL] [nvarchar](50) NULL,
 CONSTRAINT [PK_ProdectOptionDetails] PRIMARY KEY CLUSTERED 
(
	[ProdectOptionid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO


++++++++++++++


USE [Ecommerce]
GO

/****** Object:  Table [dbo].[ProdectImageDetails]    Script Date: 4/12/2019 9:14:29 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ProdectImageDetails](
	[ProdectImageid] [int] IDENTITY(1,1) NOT NULL,
	[Prodectid] [int] NULL,
	[Image] [varchar](50) NULL,
	[SortOrder] [int] NULL,
 CONSTRAINT [PK_ProdectImageDetails] PRIMARY KEY CLUSTERED 
(
	[ProdectImageid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


+++++++



USE [Ecommerce]
GO

/****** Object:  Table [dbo].[ProdectExtraTabsDetails]    Script Date: 4/12/2019 9:14:42 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ProdectExtraTabsDetails](
	[ProdectExtraTabsid] [int] IDENTITY(1,1) NOT NULL,
	[ExtraTabsid] [int] NULL,
	[TabContent] [varchar](8000) NULL,
	[Prodectid] [int]] NULL,
 CONSTRAINT [PK_ProdectExtraTabsDetails] PRIMARY KEY CLUSTERED 
(
	[ProdectExtraTabsid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO