CREATE TABLE [dbo].[al_navigation_def]
(
[navigation_id] [int] NOT NULL,
[position] [int] NOT NULL,
[page_id] [int] NULL,
[url] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[navigation_type_id] [int] NOT NULL,
[parent_nav_id] [int] NULL,
[resource_string] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[parent_class] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[target] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[for_new_flag] [int] NOT NULL CONSTRAINT [DF__AL_NAVIGA__FOR_N__396371BC] DEFAULT ('0 '),
[context_dependent_flag] [int] NOT NULL CONSTRAINT [DF__AL_NAVIGA__CONTE__3A5795F5] DEFAULT ('0 '),
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__AL_NAVIGA__VERSI__3B4BBA2E] DEFAULT ('0               '),
[related_attribute] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[formlet_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[class_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[menu_display_text] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[admin_flag] [int] NULL CONSTRAINT [DF__AL_NAVIGA__ADMIN__3C3FDE67] DEFAULT ('0'),
[config_id] [int] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[al_navigation_def] ADD CONSTRAINT [pk_al_navigation_def] PRIMARY KEY CLUSTERED ([navigation_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_navigation_def] ADD CONSTRAINT [AL_NAVIGATION_DEF_FK01] FOREIGN KEY ([page_id]) REFERENCES [dbo].[al_page_def] ([page_id])
GO
ALTER TABLE [dbo].[al_navigation_def] ADD CONSTRAINT [AL_NAVIGATION_DEF_FK02] FOREIGN KEY ([navigation_type_id]) REFERENCES [dbo].[al_navigation_type] ([id])
GO
ALTER TABLE [dbo].[al_navigation_def] ADD CONSTRAINT [AL_NAVIGATION_DEF_FK03] FOREIGN KEY ([parent_nav_id]) REFERENCES [dbo].[al_navigation_def] ([navigation_id])
GO
ALTER TABLE [dbo].[al_navigation_def] ADD CONSTRAINT [AL_NAVIGATION_DEF_FK04] FOREIGN KEY ([admin_flag]) REFERENCES [dbo].[arg_sl_admin_flag] ([id])
GO