[dbo].[ScriptExecutionLog]

(local) > SupportBridge > Tables > dbo.ScriptExecutionLog

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Row Count	44
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)	Identity	Default
scriptInstanceID	int	4	1 - 1
scriptID	int	4
selfServeSessionID	int	4
userID	int	4
executedEpoch	decimal(13,0)	9
surveyShown	int	4		((0))

Indexes

	Name	Columns	Unique
	pk_scriptexec	scriptInstanceID

SQL Script

CREATE TABLE [dbo].[ScriptExecutionLog]
(
[scriptInstanceID] [int] NOT NULL IDENTITY(1, 1),
[scriptID] [int] NOT NULL,
[selfServeSessionID] [int] NOT NULL,
[userID] [int] NOT NULL,
[executedEpoch] [decimal] (13, 0) NOT NULL,
[surveyShown] [int] NULL CONSTRAINT [DF__ScriptExe__surve__0C1BC9F9] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ScriptExecutionLog] ADD CONSTRAINT [pk_scriptexec] PRIMARY KEY CLUSTERED ([scriptInstanceID]) ON [PRIMARY]
GO

Uses