
[dbo].[SelfServeSessions]
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