Tables [dbo].[UserAlerts]
(local) > SupportBridge > Tables > dbo.UserAlerts
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count0
Created12:44:46 PM Thursday, October 04, 2007
Last Modified12:44:46 PM Thursday, October 04, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
UserIDint4
No
Foreign Keys fk_useralerts_alerttype: [dbo].[AlertTypeDetails].AlertTypeAlertTypeint4
No
Foreign Keys fk_useralerts_alerttrigger: [dbo].[AlertTriggerDetails].AlertTriggerAlertTriggerint4
No
AlertParamsnvarchar(200)400
Yes
Foreign Keys Foreign Keys
NameColumns
fk_useralerts_alerttriggerAlertTrigger->[dbo].[AlertTriggerDetails].[AlertTrigger]
fk_useralerts_alerttypeAlertType->[dbo].[AlertTypeDetails].[AlertType]
SQL Script
CREATE TABLE [dbo].[UserAlerts]
(
[UserID] [int] NOT NULL,
[AlertType] [int] NOT NULL,
[AlertTrigger] [int] NOT NULL,
[AlertParams] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserAlerts] ADD CONSTRAINT [fk_useralerts_alerttrigger] FOREIGN KEY ([AlertTrigger]) REFERENCES [dbo].[AlertTriggerDetails] ([AlertTrigger])
GO
ALTER TABLE [dbo].[UserAlerts] ADD CONSTRAINT [fk_useralerts_alerttype] FOREIGN KEY ([AlertType]) REFERENCES [dbo].[AlertTypeDetails] ([AlertType])
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved