[dbo].[MilepostHistory]

(local) > SupportBridge > Tables > dbo.MilepostHistory

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)	Allow Nulls
$Cluster Primary Key pk_milephistory: sessionID\milepost$	sessionID	int	4
$Cluster Primary Key pk_milephistory: sessionID\milepost$	milepost	int	4

Indexes

	Name	Columns	Unique
$Cluster Primary Key pk_milephistory: sessionID\milepost$	pk_milephistory	sessionID, milepost

Foreign Keys

Name	Columns
fk_milephist_session	sessionID->[dbo].[Mileposts].[sessionID]

SQL Script

CREATE TABLE [dbo].[MilepostHistory]
(
[sessionID] [int] NOT NULL,
[milepost] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MilepostHistory] ADD CONSTRAINT [pk_milephistory] PRIMARY KEY CLUSTERED ([sessionID], [milepost]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MilepostHistory] ADD CONSTRAINT [fk_milephist_session] FOREIGN KEY ([sessionID]) REFERENCES [dbo].[Mileposts] ([sessionID])
GO

Uses

[dbo].[Mileposts]
dbo