[dbo].[R00158B]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	21
Created	2:55:11 PM Friday, November 21, 2003
Last Modified	2:55:11 PM Friday, November 21, 2003

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

2:55:11 PM Friday, November 21, 2003

Last Modified

2:55:11 PM Friday, November 21, 2003

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key R00158B_pk: UNITID\DOMAINID\IDX$	UNITID	int	4
$Cluster Primary Key R00158B_pk: UNITID\DOMAINID\IDX$	DOMAINID	int	4
	AREA	varchar(64)	64
	TYPE	int	4
	NAME	varchar(64)	64
	LRUNDATE	int	4
	PLATFORM	int	4
$Cluster Primary Key R00158B_pk: UNITID\DOMAINID\IDX$	IDX	int	4	(0)
	T08Syste	varchar(127)	127
	T09Syste	varchar(127)	127
	D0ASyste	float	8
	T0BProce	varchar(127)	127
	L0CProce	int	4
	L0DStora	int	4
	D0EStora	float	8
	T0FOpera	varchar(127)	127
	T10Opera	varchar(127)	127
	D11Syste	float	8
	T12Opera	varchar(127)	127

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Cluster Primary Key R00158B_pk: UNITID\DOMAINID\IDX$

UNITID

int

$Cluster Primary Key R00158B_pk: UNITID\DOMAINID\IDX$

DOMAINID

int

AREA

varchar(64)

TYPE

int

NAME

varchar(64)

LRUNDATE

int

PLATFORM

int

$Cluster Primary Key R00158B_pk: UNITID\DOMAINID\IDX$

IDX

int

(0)

T08Syste

varchar(127)

127

T09Syste

varchar(127)

127

D0ASyste

float

T0BProce

varchar(127)

127

L0CProce

int

L0DStora

int

D0EStora

float

T0FOpera

varchar(127)

127

T10Opera

varchar(127)

127

D11Syste

float

T12Opera

varchar(127)

127

	Name	Columns	Unique
$Cluster Primary Key R00158B_pk: UNITID\DOMAINID\IDX$	R00158B_pk	UNITID, DOMAINID, IDX

Name

Columns

Unique

$Cluster Primary Key R00158B_pk: UNITID\DOMAINID\IDX$

R00158B_pk

UNITID, DOMAINID, IDX

SQL Script

CREATE TABLE [dbo].[R00158B]
(
[UNITID] [int] NOT NULL,
[DOMAINID] [int] NOT NULL,
[AREA] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TYPE] [int] NULL,
[NAME] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LRUNDATE] [int] NULL,
[PLATFORM] [int] NULL,
[IDX] [int] NOT NULL CONSTRAINT [DF__R00158B__IDX__37F05C60] DEFAULT (0),
[T08Syste] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[T09Syste] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[D0ASyste] [float] NULL,
[T0BProce] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[L0CProce] [int] NULL,
[L0DStora] [int] NULL,
[D0EStora] [float] NULL,
[T0FOpera] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[T10Opera] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[D11Syste] [float] NULL,
[T12Opera] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[R00158B] ADD CONSTRAINT [R00158B_pk] PRIMARY KEY CLUSTERED ([UNITID], [DOMAINID], [IDX]) ON [PRIMARY]
GO