Tables [dbo].[ScriptExecutionLog]
Properties
PropertyValue
Row Count44
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_scriptexec: scriptInstanceIDscriptInstanceIDint4
No
1 - 1
scriptIDint4
No
selfServeSessionIDint4
No
userIDint4
No
executedEpochdecimal(13,0)9
No
surveyShownint4
Yes
((0))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key pk_scriptexec: scriptInstanceIDpk_scriptexecscriptInstanceID
Yes
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