[dbo].[MonitorParams]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK__MonitorParams__60FC61CA: monitorID\paramID$	monitorID	int	4
$Cluster Primary Key PK__MonitorParams__60FC61CA: monitorID\paramID$	paramID	int	4
	paramName	nvarchar(100)	200
	paramDescription	nvarchar(2000)	4000
	paramType	int	4
	enumID	int	4
	paramDirection	int	4
	paramRequired	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK__MonitorParams__60FC61CA: monitorID\paramID$

monitorID

int

$Cluster Primary Key PK__MonitorParams__60FC61CA: monitorID\paramID$

paramID

int

paramName

nvarchar(100)

200

paramDescription

nvarchar(2000)

4000

paramType

int

enumID

int

paramDirection

int

paramRequired

int

	Name	Columns	Unique
$Cluster Primary Key PK__MonitorParams__60FC61CA: monitorID\paramID$	PK__MonitorParams__60FC61CA	monitorID, paramID

Name

Columns

Unique

$Cluster Primary Key PK__MonitorParams__60FC61CA: monitorID\paramID$

PK__MonitorParams__60FC61CA

monitorID, paramID

Name	Columns
FK__MonitorPa__enumI__62E4AA3C	enumID->[dbo].[MonitorEnums].[enumID]
FK__MonitorPa__monit__61F08603	monitorID->[dbo].[Monitors].[monitorID]

Name

Columns

FK__MonitorPa__enumI__62E4AA3C

enumID->[dbo].[MonitorEnums].[enumID]

FK__MonitorPa__monit__61F08603

monitorID->[dbo].[Monitors].[monitorID]

SQL Script

CREATE TABLE [dbo].[MonitorParams]
(
[monitorID] [int] NOT NULL,
[paramID] [int] NOT NULL,
[paramName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[paramDescription] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[paramType] [int] NULL,
[enumID] [int] NULL,
[paramDirection] [int] NOT NULL,
[paramRequired] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MonitorParams] ADD CONSTRAINT [PK__MonitorParams__60FC61CA] PRIMARY KEY CLUSTERED ([monitorID], [paramID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MonitorParams] ADD CONSTRAINT [FK__MonitorPa__enumI__62E4AA3C] FOREIGN KEY ([enumID]) REFERENCES [dbo].[MonitorEnums] ([enumID])
GO
ALTER TABLE [dbo].[MonitorParams] ADD CONSTRAINT [FK__MonitorPa__monit__61F08603] FOREIGN KEY ([monitorID]) REFERENCES [dbo].[Monitors] ([monitorID])
GO