Tables [dbo].[UserSessionChoice]
Properties
PropertyValue
HeapYes
Row Count0
Created12:44:46 PM Thursday, October 04, 2007
Last Modified12:44:46 PM Thursday, October 04, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Foreign Keys fk_USChoice: [dbo].[UserSessions].sessionIDsessionIDint4
No
((1))
choiceint4
Yes
((0))
Foreign Keys Foreign Keys
NameColumns
fk_USChoicesessionID->[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