[dbo].[CollabResponsesLocalized]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key pk_chatpresetslocal: responseID\localizationID$	responseID	int	4
$Cluster Primary Key pk_chatpresetslocal: responseID\localizationID$	localizationID	int	4
	responseName	nvarchar(256)	512
	responseText	ntext	max
	responseTitle	nvarchar(256)	512

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_chatpresetslocal: responseID\localizationID$

responseID

int

$Cluster Primary Key pk_chatpresetslocal: responseID\localizationID$

localizationID

int

responseName

nvarchar(256)

512

responseText

ntext

max

responseTitle

nvarchar(256)

512

	Name	Columns	Unique
$Cluster Primary Key pk_chatpresetslocal: responseID\localizationID$	pk_chatpresetslocal	responseID, localizationID

Name

Columns

Unique

$Cluster Primary Key pk_chatpresetslocal: responseID\localizationID$

pk_chatpresetslocal

responseID, localizationID

Name	Columns
fk_chatpresetslocal_local	localizationID->[dbo].[Localizations].[localizationID]
fk_chatpresetslocal_preset	responseID->[dbo].[CollabResponses].[responseID]

Name

Columns

fk_chatpresetslocal_local

localizationID->[dbo].[Localizations].[localizationID]

fk_chatpresetslocal_preset

responseID->[dbo].[CollabResponses].[responseID]

SQL Script

CREATE TABLE [dbo].[CollabResponsesLocalized]
(
[responseID] [int] NOT NULL,
[localizationID] [int] NOT NULL,
[responseName] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[responseText] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[responseTitle] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[CollabResponsesLocalized] ADD CONSTRAINT [pk_chatpresetslocal] PRIMARY KEY CLUSTERED ([responseID], [localizationID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CollabResponsesLocalized] ADD CONSTRAINT [fk_chatpresetslocal_local] FOREIGN KEY ([localizationID]) REFERENCES [dbo].[Localizations] ([localizationID])
GO
ALTER TABLE [dbo].[CollabResponsesLocalized] ADD CONSTRAINT [fk_chatpresetslocal_preset] FOREIGN KEY ([responseID]) REFERENCES [dbo].[CollabResponses] ([responseID])
GO