[dbo].[DisclaimerHistory]

(local) > SupportBridge > Tables > dbo.DisclaimerHistory

Properties
Columns
Indexes
Foreign Keys
SQL Script
Uses

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

Columns

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key pk_dischistory: sessionID\disclaimerID$	sessionID	int	4
$Cluster Primary Key pk_dischistory: sessionID\disclaimerID$	disclaimerID	int	4
	response	int	4	((0))

Indexes

	Name	Columns	Unique
$Cluster Primary Key pk_dischistory: sessionID\disclaimerID$	pk_dischistory	sessionID, disclaimerID

Foreign Keys

Name	Columns
fk_dischist_session	sessionID->[dbo].[UserSessions].[sessionID]

SQL Script

CREATE TABLE [dbo].[DisclaimerHistory]
(
[sessionID] [int] NOT NULL,
[disclaimerID] [int] NOT NULL,
[response] [int] NULL CONSTRAINT [DF__Disclaime__respo__4CC05EF3] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DisclaimerHistory] ADD CONSTRAINT [pk_dischistory] PRIMARY KEY CLUSTERED ([sessionID], [disclaimerID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DisclaimerHistory] ADD CONSTRAINT [fk_dischist_session] FOREIGN KEY ([sessionID]) REFERENCES [dbo].[UserSessions] ([sessionID])
GO

Uses

[dbo].[UserSessions]
dbo