[dbo].[HealingSession]

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

Property

Value

Row Count

Created

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

Last Modified

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

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

Default

SHSessionID

int

1 - 1

sessionID

int

userID

int

startEpoch

decimal(18,0)

endEpoch

decimal(18,0)

LastUpdateEpoch

decimal(18,0)

((0))

escalationTargetQueue

int

((-1))

	Name	Columns	Unique
	PK__HealingSession__3DB3258D	SHSessionID

Name

Columns

Unique

PK__HealingSession__3DB3258D

SHSessionID

Name	Columns
FK__HealingSe__sessi__3EA749C6	sessionID->[dbo].[UserSessions].[sessionID]
FK__HealingSe__userI__3F9B6DFF	userID->[dbo].[SelfHealingUser].[userID]

Name

Columns

FK__HealingSe__sessi__3EA749C6

sessionID->[dbo].[UserSessions].[sessionID]

FK__HealingSe__userI__3F9B6DFF

userID->[dbo].[SelfHealingUser].[userID]

SQL Script

CREATE TABLE [dbo].[HealingSession]
(
[SHSessionID] [int] NOT NULL IDENTITY(1, 1),
[sessionID] [int] NULL,
[userID] [int] NULL,
[startEpoch] [decimal] (18, 0) NULL,
[endEpoch] [decimal] (18, 0) NULL,
[LastUpdateEpoch] [decimal] (18, 0) NULL CONSTRAINT [DF__HealingSe__LastU__408F9238] DEFAULT ((0)),
[escalationTargetQueue] [int] NULL CONSTRAINT [DF__HealingSe__escal__4183B671] DEFAULT ((-1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HealingSession] ADD CONSTRAINT [PK__HealingSession__3DB3258D] PRIMARY KEY CLUSTERED ([SHSessionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HealingSession] ADD CONSTRAINT [FK__HealingSe__sessi__3EA749C6] FOREIGN KEY ([sessionID]) REFERENCES [dbo].[UserSessions] ([sessionID])
GO
ALTER TABLE [dbo].[HealingSession] ADD CONSTRAINT [FK__HealingSe__userI__3F9B6DFF] FOREIGN KEY ([userID]) REFERENCES [dbo].[SelfHealingUser] ([userID])
GO