[dbo].[SessionLoginFields]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

129

Created

12:44:46 PM Thursday, October 04, 2007

Last Modified

12:44:46 PM Thursday, October 04, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key pk_sessionloginflds: sessionID\fieldID$	sessionID	int	4
$Cluster Primary Key pk_sessionloginflds: sessionID\fieldID$	fieldID	int	4
	value	nvarchar(500)	1000

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_sessionloginflds: sessionID\fieldID$

sessionID

int

$Cluster Primary Key pk_sessionloginflds: sessionID\fieldID$

fieldID

int

value

nvarchar(500)

1000

	Name	Columns	Unique
$Cluster Primary Key pk_sessionloginflds: sessionID\fieldID$	pk_sessionloginflds	sessionID, fieldID

Name

Columns

Unique

$Cluster Primary Key pk_sessionloginflds: sessionID\fieldID$

pk_sessionloginflds

sessionID, fieldID

Name	Columns
fk_sessionloginflds_field	fieldID->[dbo].[Fields].[fieldID]
fk_sessionloginflds_session	sessionID->[dbo].[UserSessions].[sessionID]

Name

Columns

fk_sessionloginflds_field

fieldID->[dbo].[Fields].[fieldID]

fk_sessionloginflds_session

sessionID->[dbo].[UserSessions].[sessionID]

SQL Script

CREATE TABLE [dbo].[SessionLoginFields]
(
[sessionID] [int] NOT NULL,
[fieldID] [int] NOT NULL,
[value] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SessionLoginFields] ADD CONSTRAINT [pk_sessionloginflds] PRIMARY KEY CLUSTERED ([sessionID], [fieldID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SessionLoginFields] ADD CONSTRAINT [fk_sessionloginflds_field] FOREIGN KEY ([fieldID]) REFERENCES [dbo].[Fields] ([fieldID])
GO
ALTER TABLE [dbo].[SessionLoginFields] ADD CONSTRAINT [fk_sessionloginflds_session] FOREIGN KEY ([sessionID]) REFERENCES [dbo].[UserSessions] ([sessionID])
GO