[dbo].[UserAddressJoin]

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

Property

Value

Row Count

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key pk_useraddjoin: userID\addrID$	userID	int	4
$Cluster Primary Key pk_useraddjoin: userID\addrID$	addrID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_useraddjoin: userID\addrID$

userID

int

$Cluster Primary Key pk_useraddjoin: userID\addrID$

addrID

int

	Name	Columns	Unique
$Cluster Primary Key pk_useraddjoin: userID\addrID$	pk_useraddjoin	userID, addrID

Name

Columns

Unique

$Cluster Primary Key pk_useraddjoin: userID\addrID$

pk_useraddjoin

userID, addrID

Name	Columns
fk_useraddrjoin_addr	addrID->[dbo].[Addresses].[addrID]
fk_useraddrjoin_users	userID->[dbo].[Users].[userID]

Name

Columns

fk_useraddrjoin_addr

addrID->[dbo].[Addresses].[addrID]

fk_useraddrjoin_users

userID->[dbo].[Users].[userID]

SQL Script

CREATE TABLE [dbo].[UserAddressJoin]
(
[userID] [int] NOT NULL,
[addrID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserAddressJoin] ADD CONSTRAINT [pk_useraddjoin] PRIMARY KEY CLUSTERED ([userID], [addrID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserAddressJoin] ADD CONSTRAINT [fk_useraddrjoin_addr] FOREIGN KEY ([addrID]) REFERENCES [dbo].[Addresses] ([addrID])
GO
ALTER TABLE [dbo].[UserAddressJoin] ADD CONSTRAINT [fk_useraddrjoin_users] FOREIGN KEY ([userID]) REFERENCES [dbo].[Users] ([userID])
GO