[dbo].[SelfServeEventJoin]

(local) > SupportBridge > Tables > dbo.SelfServeEventJoin

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Row Count	234
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
$Cluster Primary Key pk_SelfServeEventJoin: selfServeSessionID\eventID$	selfServeSessionID	int	4
$Cluster Primary Key pk_SelfServeEventJoin: selfServeSessionID\eventID$	eventID	decimal(28,0)	13

Indexes

	Name	Columns	Unique
$Cluster Primary Key pk_SelfServeEventJoin: selfServeSessionID\eventID$	pk_SelfServeEventJoin	selfServeSessionID, eventID

SQL Script

CREATE TABLE [dbo].[SelfServeEventJoin]
(
[selfServeSessionID] [int] NOT NULL,
[eventID] [decimal] (28, 0) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SelfServeEventJoin] ADD CONSTRAINT [pk_SelfServeEventJoin] PRIMARY KEY CLUSTERED ([selfServeSessionID], [eventID]) ON [PRIMARY]
GO

Uses