[dbo].[UserSessionChoice]

(local) > SupportBridge > Tables > dbo.UserSessionChoice

Properties
Columns
Foreign Keys
SQL Script
Uses

Property	Value
Heap
Row Count	0
Created	12:44:46 PM Thursday, October 04, 2007
Last Modified	12:44:46 PM Thursday, October 04, 2007

Columns

	Name	Data Type	Max Length (Bytes)	Allow Nulls	Default
	sessionID	int	4		((1))
	choice	int	4		((0))

Foreign Keys

Name	Columns
fk_USChoice	sessionID->[dbo].[UserSessions].[sessionID]

SQL Script

CREATE TABLE [dbo].[UserSessionChoice]
(
[sessionID] [int] NOT NULL CONSTRAINT [DF__UserSessi__sessi__7EC1CEDB] DEFAULT ((1)),
[choice] [int] NULL CONSTRAINT [DF__UserSessi__choic__7FB5F314] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserSessionChoice] ADD CONSTRAINT [fk_USChoice] FOREIGN KEY ([sessionID]) REFERENCES [dbo].[UserSessions] ([sessionID])
GO

Uses

[dbo].[UserSessions]
dbo