[dbo].[HealingSessionEventJoin]

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
$Cluster Primary Key PK__HealingSessionEv__436BFEE3: SHSessionID\eventID$	SHSessionID	int	4
$Cluster Primary Key PK__HealingSessionEv__436BFEE3: SHSessionID\eventID$	eventID	decimal(28,0)	13

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK__HealingSessionEv__436BFEE3: SHSessionID\eventID$

SHSessionID

int

$Cluster Primary Key PK__HealingSessionEv__436BFEE3: SHSessionID\eventID$

eventID

decimal(28,0)

	Name	Columns	Unique
$Cluster Primary Key PK__HealingSessionEv__436BFEE3: SHSessionID\eventID$	PK__HealingSessionEv__436BFEE3	SHSessionID, eventID

Name

Columns

Unique

$Cluster Primary Key PK__HealingSessionEv__436BFEE3: SHSessionID\eventID$

PK__HealingSessionEv__436BFEE3

SHSessionID, eventID

Name	Columns
FK__HealingSe__event__45544755	eventID->[dbo].[EventHistory].[eventID]
FK__HealingSe__SHSes__4460231C	SHSessionID->[dbo].[HealingSession].[SHSessionID]

Name

Columns

FK__HealingSe__event__45544755

eventID->[dbo].[EventHistory].[eventID]

FK__HealingSe__SHSes__4460231C

SHSessionID->[dbo].[HealingSession].[SHSessionID]

SQL Script

CREATE TABLE [dbo].[HealingSessionEventJoin]
(
[SHSessionID] [int] NOT NULL,
[eventID] [decimal] (28, 0) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HealingSessionEventJoin] ADD CONSTRAINT [PK__HealingSessionEv__436BFEE3] PRIMARY KEY CLUSTERED ([SHSessionID], [eventID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HealingSessionEventJoin] ADD CONSTRAINT [FK__HealingSe__event__45544755] FOREIGN KEY ([eventID]) REFERENCES [dbo].[EventHistory] ([eventID])
GO
ALTER TABLE [dbo].[HealingSessionEventJoin] ADD CONSTRAINT [FK__HealingSe__SHSes__4460231C] FOREIGN KEY ([SHSessionID]) REFERENCES [dbo].[HealingSession] ([SHSessionID])
GO