[dbo].[PortalComponents]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	2
Created	12:44:45 PM Thursday, October 04, 2007
Last Modified	12:44:45 PM Thursday, October 04, 2007

Name	Data Type	Max Length (Bytes)	Identity	Default
componentID	int	4	1 - 1
divisionID	int	4
name	nvarchar(50)	100
URL	nvarchar(255)	510
beforeLogin	int	4		((1))
afterLogin	int	4		((1))
beforeProbDef	int	4		((1))
afterProbDef	int	4		((1))
displayColumn	int	4
displayIndex	int	4

	Name	Columns	Unique
	pk_portalcomps	componentID

Name	Columns
fk_portalcomps_div	divisionID->[dbo].[Divisions].[divisionID]

SQL Script

CREATE TABLE [dbo].[PortalComponents]
(
[componentID] [int] NOT NULL IDENTITY(1, 1),
[divisionID] [int] NOT NULL,
[name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[URL] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[beforeLogin] [int] NULL CONSTRAINT [DF__PortalCom__befor__1EA48E88] DEFAULT ((1)),
[afterLogin] [int] NULL CONSTRAINT [DF__PortalCom__after__1F98B2C1] DEFAULT ((1)),
[beforeProbDef] [int] NULL CONSTRAINT [DF__PortalCom__befor__208CD6FA] DEFAULT ((1)),
[afterProbDef] [int] NULL CONSTRAINT [DF__PortalCom__after__2180FB33] DEFAULT ((1)),
[displayColumn] [int] NULL,
[displayIndex] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PortalComponents] ADD CONSTRAINT [pk_portalcomps] PRIMARY KEY CLUSTERED ([componentID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PortalComponents] ADD CONSTRAINT [fk_portalcomps_div] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO