Tables [dbo].[UserSessionBrowser]
(local) > SupportBridge > Tables > dbo.UserSessionBrowser
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
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 Nulls
Cluster Primary Key pk_usersessionbrowser: sessionIDForeign Keys fk_usersessionbrowser_sessionid: [dbo].[UserSessions].sessionIDsessionIDint4
No
userAgentnvarchar(500)1000
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key pk_usersessionbrowser: sessionIDpk_usersessionbrowsersessionID
Yes
Foreign Keys Foreign Keys
NameColumns
fk_usersessionbrowser_sessionidsessionID->[dbo].[UserSessions].[sessionID]
SQL Script
CREATE TABLE [dbo].[UserSessionBrowser]
(
[sessionID] [int] NOT NULL,
[userAgent] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserSessionBrowser] ADD CONSTRAINT [pk_usersessionbrowser] PRIMARY KEY CLUSTERED ([sessionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserSessionBrowser] ADD CONSTRAINT [fk_usersessionbrowser_sessionid] FOREIGN KEY ([sessionID]) REFERENCES [dbo].[UserSessions] ([sessionID])
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved