Database Structure

AdvantShop.NET database contains 80 tables and over 300 procedures all of which provide flexible functioning of web stores on ASP.NET platform.

Tables are grouped to schemes due to their functions.
Scheme examples: [Catalog], [Customers], [Order], [Settings], [CMS] ...


Tables

[Catalog].[Catalog]	[CMS].[PagePart]	[SEO].[Link]
[Catalog].[Category]	[Customers].[Contact]	[SEO].[ProductMetaInfo]
[Catalog].[Currency]	[Customers].[Country]	[SEO].[Settings]
[Catalog].[CustomOptionInputTypes]	[Customers].[Customer]	[Settings].[AuthorizeLog]
[Catalog].[CustomOptions]	[Customers].[CustomerGroup]	[Settings].[AuxCategory]
[Catalog].[DiscussionText]	[Customers].[GeoIP]	[Settings].[AuxGroup]
[Catalog].[DiscussionThreads]	[Customers].[Region]	[Settings].[AuxGroupLink]
[Catalog].[FakeBestSellers]	[dbo].[MessageLog]	[Settings].[AuxPage]
[Catalog].[FlagProduct]	[dbo].[RecentlyViewsData]	[Settings].[AuxTemplates]
[Catalog].[ImportLog]	[dbo].[Subscribe]	[Settings].[EFHistory]
[Catalog].[LocationMap]	[dbo].[SubscribeDeactivReason]	[Settings].[EFSelectedProducts]
[Catalog].[Offer]	[Order].[Notifications]	[Settings].[Language]
[Catalog].[OffersList]	[Order].[Order]	[Settings].[MailFormat]
[Catalog].[OfferType]	[Order].[OrderCustomOptions]	[Settings].[MailFormatType]
[Catalog].[OptionPriceTypes]	[Order].[OrderedCart]	[Settings].[News]
[Catalog].[Options]	[Order].[OrderPriceDiscount]	[Settings].[NewsCategory]
[Catalog].[PanoramPhoto]	[Order].[OrderStatus]	[Settings].[PdaPage]
[Catalog].[Product]	[Order].[PaymentDetails]	[Settings].[PdaTemplates]
[Catalog].[ProductDiscussion]	[Order].[PaymentModule]	[Settings].[Ranges]
[Catalog].[ProductPhoto]	[Order].[PaymentModuleSetting]	[Settings].[Settings]
[Catalog].[ProductProperty]	[Order].[PaymentType]	[Settings].[SMSModule]
[Catalog].[Property]	[Order].[ShippingMethod]	[Settings].[WapPage]
[Catalog].[Ratio]	[Order].[ShippingModule]	[Settings].[WapTemplates]
[Catalog].[RelatedProducts]	[Order].[ShippingModuleSetting]	[Voice].[Answer]
[Catalog].[RepairDescription]	[Order].[ShoppingCartItem]	[Voice].[VoiceTheme]
[Catalog].[Shop]	[Order].[TempOrder]
[Catalog].[SpecialOffer]	[SEO].[CategoryLinks]

Database Part Schemes

Catalog-Related Table Structure

Order-Related Table Structure

Download Example

AdvantShop.NET 2.3.0 Demo Database (*.bak file)

2 077 KB

Download

SQL Query Examples (MS SQL 2005/2008)

Create Table [ProductPhoto] CREATE TABLE [ProductPhoto]( [ProductPhotoID] [int] IDENTITY(1,1) NOT NULL, [ProductID] [nvarchar](50) COLLATE Cyrillic_General_CI_AS NOT NULL, [Path] [nvarchar](255) COLLATE Cyrillic_General_CI_AS NOT NULL, [ModifiedDate] [datetime] NOT NULL, [Description] [nvarchar](255) COLLATE Cyrillic_General_CI_AS NULL, [PhotoSortOrder] [int] NULL, [Main] [bit] NOT NULL, CONSTRAINT [PK_ProductPhoto] PRIMARY KEY CLUSTERED ( [ProductPhotoID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] Create Stored Procedure [sp_AddOption] CREATE PROCEDURE [sp_AddOption] @CustomOptionsId int, @Title nvarchar(255), @PriceBC money, @PriceType int, @SortOrder int AS BEGIN INSERT INTO [Catalog].[Options] ([CustomOptionsId], [Title], [PriceBC], [PriceType], [SortOrder]) VALUES (@CustomOptionsId, @Title, @PriceBC, @PriceType, @SortOrder) END Create View [view_GetCurrency] CREATE VIEW [Catalog].[view_GetCurrency] AS SELECT TOP (100) PERCENT [CurrencyIso3], [Name] FROM Catalog.Currency ORDER BY Name GO EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]Begin DesignProperties = Begin PaneConfigurations = Begin PaneConfiguration = 0 NumPanes = 4 Configuration = "(H (1[40] 4[20] 2[20] 3) )" End Begin PaneConfiguration = 1 NumPanes = 3 Configuration = "(H (1 [50] 4 [25] 3))" End ...

Any question? Ask now!

Top