[dbo].[ScriptAcquiredData]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	12:44:47 PM Thursday, October 04, 2007
Last Modified	12:44:47 PM Thursday, October 04, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

12:44:47 PM Thursday, October 04, 2007

Last Modified

12:44:47 PM Thursday, October 04, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key pk_scriptacquireddata: divisionID\userID\sessionID\scriptID\scriptInstanceID\triggerID\triggerInstanceID$	divisionID	int	4
$Cluster Primary Key pk_scriptacquireddata: divisionID\userID\sessionID\scriptID\scriptInstanceID\triggerID\triggerInstanceID$	userID	int	4
$Cluster Primary Key pk_scriptacquireddata: divisionID\userID\sessionID\scriptID\scriptInstanceID\triggerID\triggerInstanceID$	sessionID	int	4
$Cluster Primary Key pk_scriptacquireddata: divisionID\userID\sessionID\scriptID\scriptInstanceID\triggerID\triggerInstanceID$	scriptID	int	4
$Cluster Primary Key pk_scriptacquireddata: divisionID\userID\sessionID\scriptID\scriptInstanceID\triggerID\triggerInstanceID$	scriptInstanceID	int	4
$Cluster Primary Key pk_scriptacquireddata: divisionID\userID\sessionID\scriptID\scriptInstanceID\triggerID\triggerInstanceID$	triggerID	int	4
$Cluster Primary Key pk_scriptacquireddata: divisionID\userID\sessionID\scriptID\scriptInstanceID\triggerID\triggerInstanceID$	triggerInstanceID	int	4
	epoch	decimal(18,0)	9
	acquiredData	ntext	max

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_scriptacquireddata: divisionID\userID\sessionID\scriptID\scriptInstanceID\triggerID\triggerInstanceID$

divisionID

int

$Cluster Primary Key pk_scriptacquireddata: divisionID\userID\sessionID\scriptID\scriptInstanceID\triggerID\triggerInstanceID$

userID

int

$Cluster Primary Key pk_scriptacquireddata: divisionID\userID\sessionID\scriptID\scriptInstanceID\triggerID\triggerInstanceID$

sessionID

int

$Cluster Primary Key pk_scriptacquireddata: divisionID\userID\sessionID\scriptID\scriptInstanceID\triggerID\triggerInstanceID$

scriptID

int

$Cluster Primary Key pk_scriptacquireddata: divisionID\userID\sessionID\scriptID\scriptInstanceID\triggerID\triggerInstanceID$

scriptInstanceID

int

$Cluster Primary Key pk_scriptacquireddata: divisionID\userID\sessionID\scriptID\scriptInstanceID\triggerID\triggerInstanceID$

triggerID

int

$Cluster Primary Key pk_scriptacquireddata: divisionID\userID\sessionID\scriptID\scriptInstanceID\triggerID\triggerInstanceID$

triggerInstanceID

int

epoch

decimal(18,0)

acquiredData

ntext

max

	Name	Columns	Unique
$Cluster Primary Key pk_scriptacquireddata: divisionID\userID\sessionID\scriptID\scriptInstanceID\triggerID\triggerInstanceID$	pk_scriptacquireddata	divisionID, userID, sessionID, scriptID, scriptInstanceID, triggerID, triggerInstanceID

Name

Columns

Unique

$Cluster Primary Key pk_scriptacquireddata: divisionID\userID\sessionID\scriptID\scriptInstanceID\triggerID\triggerInstanceID$

pk_scriptacquireddata

divisionID, userID, sessionID, scriptID, scriptInstanceID, triggerID, triggerInstanceID

Name	Columns
fk_ScriptAcquiredData_division	divisionID->[dbo].[Divisions].[divisionID]
fk_ScriptAcquiredData_user	userID->[dbo].[Users].[userID]

Name

Columns

fk_ScriptAcquiredData_division

divisionID->[dbo].[Divisions].[divisionID]

fk_ScriptAcquiredData_user

userID->[dbo].[Users].[userID]

SQL Script

CREATE TABLE [dbo].[ScriptAcquiredData]
(
[divisionID] [int] NOT NULL,
[userID] [int] NOT NULL,
[sessionID] [int] NOT NULL,
[scriptID] [int] NOT NULL,
[scriptInstanceID] [int] NOT NULL,
[triggerID] [int] NOT NULL,
[triggerInstanceID] [int] NOT NULL,
[epoch] [decimal] (18, 0) NOT NULL,
[acquiredData] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[ScriptAcquiredData] ADD CONSTRAINT [pk_scriptacquireddata] PRIMARY KEY CLUSTERED ([divisionID], [userID], [sessionID], [scriptID], [scriptInstanceID], [triggerID], [triggerInstanceID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ScriptAcquiredData] ADD CONSTRAINT [fk_ScriptAcquiredData_division] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO
ALTER TABLE [dbo].[ScriptAcquiredData] ADD CONSTRAINT [fk_ScriptAcquiredData_user] FOREIGN KEY ([userID]) REFERENCES [dbo].[Users] ([userID])
GO