[cohesion].[QLTRIGGERS]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	11:18:10 AM Friday, April 20, 2007
Last Modified	11:18:10 AM Friday, April 20, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

11:18:10 AM Friday, April 20, 2007

Last Modified

11:18:10 AM Friday, April 20, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK__QLTRIGGERS__3B40CD36: TRIGGER_NAME\TRIGGER_GROUP$	TRIGGER_NAME	varchar(90)	90
$Cluster Primary Key PK__QLTRIGGERS__3B40CD36: TRIGGER_NAME\TRIGGER_GROUP$	TRIGGER_GROUP	varchar(90)	90
$Foreign Keys FK__QLTRIGGERS__3C34F16F: [cohesion].[QLJOB_DETAILS].JOB_NAME\JOB_GROUP$	JOB_NAME	varchar(90)	90
$Foreign Keys FK__QLTRIGGERS__3C34F16F: [cohesion].[QLJOB_DETAILS].JOB_NAME\JOB_GROUP$	JOB_GROUP	varchar(90)	90
	IS_VOLATILE	varchar(1)	1
	DESCRIPTION	varchar(255)	255
	NEXT_FIRE_TIME	bigint	8
	PREV_FIRE_TIME	bigint	8
	TRIGGER_STATE	varchar(40)	40
	TRIGGER_TYPE	varchar(40)	40
	START_TIME	bigint	8
	END_TIME	bigint	8
	CALENDAR_NAME	varchar(90)	90
	MISFIRE_INSTR	smallint	2

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK__QLTRIGGERS__3B40CD36: TRIGGER_NAME\TRIGGER_GROUP$

TRIGGER_NAME

varchar(90)

$Cluster Primary Key PK__QLTRIGGERS__3B40CD36: TRIGGER_NAME\TRIGGER_GROUP$

TRIGGER_GROUP

varchar(90)

$Foreign Keys FK__QLTRIGGERS__3C34F16F: [cohesion].[QLJOB_DETAILS].JOB_NAME\JOB_GROUP$

JOB_NAME

varchar(90)

$Foreign Keys FK__QLTRIGGERS__3C34F16F: [cohesion].[QLJOB_DETAILS].JOB_NAME\JOB_GROUP$

JOB_GROUP

varchar(90)

IS_VOLATILE

varchar(1)

DESCRIPTION

varchar(255)

255

NEXT_FIRE_TIME

bigint

PREV_FIRE_TIME

bigint

TRIGGER_STATE

varchar(40)

TRIGGER_TYPE

varchar(40)

START_TIME

bigint

END_TIME

bigint

CALENDAR_NAME

varchar(90)

MISFIRE_INSTR

smallint

	Name	Columns
$Cluster Primary Key PK__QLTRIGGERS__3B40CD36: TRIGGER_NAME\TRIGGER_GROUP$	PK__QLTRIGGERS__3B40CD36	TRIGGER_NAME, TRIGGER_GROUP
	XIE1QLTRIGGERS	NEXT_FIRE_TIME
	XIE2QLTRIGGERS	TRIGGER_STATE
	XIE3QLTRIGGERS	IS_VOLATILE

Name

Columns

Unique

$Cluster Primary Key PK__QLTRIGGERS__3B40CD36: TRIGGER_NAME\TRIGGER_GROUP$

PK__QLTRIGGERS__3B40CD36

TRIGGER_NAME, TRIGGER_GROUP

XIE1QLTRIGGERS

NEXT_FIRE_TIME

XIE2QLTRIGGERS

TRIGGER_STATE

XIE3QLTRIGGERS

IS_VOLATILE

Name	Columns
FK__QLTRIGGERS__3C34F16F	JOB_NAME->[cohesion].[QLJOB_DETAILS].[JOB_NAME] JOB_GROUP->[cohesion].[QLJOB_DETAILS].[JOB_GROUP]

Name

Columns

FK__QLTRIGGERS__3C34F16F

JOB_NAME->[cohesion].[QLJOB_DETAILS].[JOB_NAME]
JOB_GROUP->[cohesion].[QLJOB_DETAILS].[JOB_GROUP]

SQL Script

CREATE TABLE [cohesion].[QLTRIGGERS]
(
[TRIGGER_NAME] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TRIGGER_GROUP] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[JOB_NAME] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[JOB_GROUP] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IS_VOLATILE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DESCRIPTION] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NEXT_FIRE_TIME] [bigint] NULL,
[PREV_FIRE_TIME] [bigint] NULL,
[TRIGGER_STATE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TRIGGER_TYPE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[START_TIME] [bigint] NULL,
[END_TIME] [bigint] NULL,
[CALENDAR_NAME] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MISFIRE_INSTR] [smallint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[QLTRIGGERS] ADD CONSTRAINT [PK__QLTRIGGERS__3B40CD36] PRIMARY KEY CLUSTERED ([TRIGGER_NAME], [TRIGGER_GROUP]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE3QLTRIGGERS] ON [cohesion].[QLTRIGGERS] ([IS_VOLATILE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1QLTRIGGERS] ON [cohesion].[QLTRIGGERS] ([NEXT_FIRE_TIME]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE2QLTRIGGERS] ON [cohesion].[QLTRIGGERS] ([TRIGGER_STATE]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[QLTRIGGERS] ADD CONSTRAINT [FK__QLTRIGGERS__3C34F16F] FOREIGN KEY ([JOB_NAME], [JOB_GROUP]) REFERENCES [cohesion].[QLJOB_DETAILS] ([JOB_NAME], [JOB_GROUP])
GO