I want to create the admin panel of website. I need to create dynamic menus and sub menus, and also dynamic pages.
I have these tables:
- Menu
- News
- Articles
- Gallery
- ContentPage (for creating content pages same about us etc.)
- PageLinks(for adding link of other websites)
and other tables.
I don't know how can I manage my DB to create dynamic menus with link menu items to dynamic pages, news and articles.
This is menu table :
CREATE TABLE [dbo].[Menu](
[Id] [tinyint] IDENTITY(1,1) NOT NULL,
[ParentId] [tinyint] NULL,
[Id_AllPages] [int] NULL,
[MenuTitle] [nvarchar](50) NULL,
[Description] [nvarchar](50) NULL,
[Position] [tinyint] NULL,
[IsActive] [bit] NULL,
[CreateDate] [datetime] NULL,
[Language] [char](1) NULL,
CONSTRAINT [PK_Menu] PRIMARY KEY CLUSTERED
How can I save link of dynamic page for menu items?
I don't need c# code at this time, I just need helping about DB structure for dynamic menus and pages.
Thanks