[dbo].[wtepcomsmpnodegroup]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:07:51 AM Wednesday, March 07, 2007
Last Modified	11:09:18 AM Wednesday, March 07, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Row Count

Created

11:07:51 AM Wednesday, March 07, 2007

Last Modified

11:09:18 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
uuid	binary(16)	16
type	int	4
queryclass	varchar(40)	40
queryproperty	varchar(40)	40
join_name1	varchar(200)	200
join_name2	varchar(200)	200
join_type	int	4
ip_query	varchar(255)	255
et_platform	varchar(40)	40
et_product	varchar(200)	200

Name

Data Type

Max Length (Bytes)

Allow Nulls

uuid

binary(16)

type

int

queryclass

varchar(40)

queryproperty

varchar(40)

join_name1

varchar(200)

200

join_name2

varchar(200)

200

join_type

int

ip_query

varchar(255)

255

et_platform

varchar(40)

et_product

varchar(200)

200

	Name	Columns	Unique
	XPKwtepcomsmpnodegroup	uuid

Name

Columns

Unique

XPKwtepcomsmpnodegroup

uuid

SQL Script

CREATE TABLE [dbo].[wtepcomsmpnodegroup]
(
[uuid] [binary] (16) NOT NULL,
[type] [int] NULL,
[queryclass] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[queryproperty] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[join_name1] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[join_name2] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[join_type] [int] NULL,
[ip_query] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[et_platform] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[et_product] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wtepcomsmpnodegroup] ADD CONSTRAINT [XPKwtepcomsmpnodegroup] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO