Tables [dbo].[SelfServeSessions]
Properties
PropertyValue
Row Count37
Created12:44:46 PM Thursday, October 04, 2007
Last Modified12:44:46 PM Thursday, October 04, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key pk_selfservs: selfSessionIDselfSessionIDint4
No
1 - 1
sessionIDint4
Yes
userIDint4
No
divisionIDint4
No
queueIDint4
Yes
Foreign Keys fk_SSSCat: [dbo].[CustomCategories].categoryIDcategoryIDint4
Yes
createdEpochdecimal(18,0)9
Yes
lastScriptEpochdecimal(18,0)9
Yes
scriptCountint4
No
((0))
endEpochdecimal(18,0)9
Yes
Timezoneint4
Yes
Foreign Keys FK__SelfServe__local__084B3915: [dbo].[Localizations].localizationIDlocalizationIDint4
Yes
((-1))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key pk_selfservs: selfSessionIDpk_selfservsselfSessionID
Yes
Foreign Keys Foreign Keys
NameColumns
FK__SelfServe__local__084B3915localizationID->[dbo].[Localizations].[localizationID]
fk_SSSCatcategoryID->[dbo].[CustomCategories].[categoryID]
SQL Script
CREATE TABLE [dbo].[SelfServeSessions]
(
[selfSessionID] [int] NOT NULL IDENTITY(1, 1),
[sessionID] [int] NULL,
[userID] [int] NOT NULL,
[divisionID] [int] NOT NULL,
[queueID] [int] NULL,
[categoryID] [int] NULL,
[createdEpoch] [decimal] (18, 0) NULL,
[lastScriptEpoch] [decimal] (18, 0) NULL,
[scriptCount] [int] NOT NULL CONSTRAINT [DF__SelfServe__scrip__0662F0A3] DEFAULT ((0)),
[endEpoch] [decimal] (18, 0) NULL,
[Timezone] [int] NULL,
[localizationID] [int] NULL CONSTRAINT [DF__SelfServe__local__075714DC] DEFAULT ((-1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SelfServeSessions] ADD CONSTRAINT [pk_selfservs] PRIMARY KEY CLUSTERED ([selfSessionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SelfServeSessions] ADD CONSTRAINT [FK__SelfServe__local__084B3915] FOREIGN KEY ([localizationID]) REFERENCES [dbo].[Localizations] ([localizationID])
GO
ALTER TABLE [dbo].[SelfServeSessions] ADD CONSTRAINT [fk_SSSCat] FOREIGN KEY ([categoryID]) REFERENCES [dbo].[CustomCategories] ([categoryID])
GO
Uses