[cohesion].[QTRIGGERS]

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__QTRIGGERS__1EA48E88: TRIGGER_NAME\TRIGGER_GROUP$	TRIGGER_NAME	varchar(90)	90
$Cluster Primary Key PK__QTRIGGERS__1EA48E88: TRIGGER_NAME\TRIGGER_GROUP$	TRIGGER_GROUP	varchar(90)	90
$Foreign Keys FK__QTRIGGERS__1F98B2C1: [cohesion].[QJOB_DETAILS].JOB_NAME\JOB_GROUP$	JOB_NAME	varchar(90)	90
$Foreign Keys FK__QTRIGGERS__1F98B2C1: [cohesion].[QJOB_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__QTRIGGERS__1EA48E88: TRIGGER_NAME\TRIGGER_GROUP$

TRIGGER_NAME

varchar(90)

$Cluster Primary Key PK__QTRIGGERS__1EA48E88: TRIGGER_NAME\TRIGGER_GROUP$

TRIGGER_GROUP

varchar(90)

$Foreign Keys FK__QTRIGGERS__1F98B2C1: [cohesion].[QJOB_DETAILS].JOB_NAME\JOB_GROUP$

JOB_NAME

varchar(90)

$Foreign Keys FK__QTRIGGERS__1F98B2C1: [cohesion].[QJOB_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__QTRIGGERS__1EA48E88: TRIGGER_NAME\TRIGGER_GROUP$	PK__QTRIGGERS__1EA48E88	TRIGGER_NAME, TRIGGER_GROUP
	XIE1QTRIGGERS	NEXT_FIRE_TIME
	XIE2QTRIGGERS	TRIGGER_STATE
	XIE3QTRIGGERS	IS_VOLATILE

Name

Columns

Unique

$Cluster Primary Key PK__QTRIGGERS__1EA48E88: TRIGGER_NAME\TRIGGER_GROUP$

PK__QTRIGGERS__1EA48E88

TRIGGER_NAME, TRIGGER_GROUP

XIE1QTRIGGERS

NEXT_FIRE_TIME

XIE2QTRIGGERS

TRIGGER_STATE

XIE3QTRIGGERS

IS_VOLATILE

Name	Columns
FK__QTRIGGERS__1F98B2C1	JOB_NAME->[cohesion].[QJOB_DETAILS].[JOB_NAME] JOB_GROUP->[cohesion].[QJOB_DETAILS].[JOB_GROUP]

Name

Columns

FK__QTRIGGERS__1F98B2C1

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

SQL Script

CREATE TABLE [cohesion].[QTRIGGERS]
(
[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].[QTRIGGERS] ADD CONSTRAINT [PK__QTRIGGERS__1EA48E88] PRIMARY KEY CLUSTERED ([TRIGGER_NAME], [TRIGGER_GROUP]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE3QTRIGGERS] ON [cohesion].[QTRIGGERS] ([IS_VOLATILE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1QTRIGGERS] ON [cohesion].[QTRIGGERS] ([NEXT_FIRE_TIME]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE2QTRIGGERS] ON [cohesion].[QTRIGGERS] ([TRIGGER_STATE]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[QTRIGGERS] ADD CONSTRAINT [FK__QTRIGGERS__1F98B2C1] FOREIGN KEY ([JOB_NAME], [JOB_GROUP]) REFERENCES [cohesion].[QJOB_DETAILS] ([JOB_NAME], [JOB_GROUP])
GO