Tables [dbo].[RALLHW]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count67
Created5:49:53 PM Monday, May 17, 2004
Last Modified5:49:53 PM Monday, May 17, 2004
Columns
NameData TypeMax Length (Bytes)Allow Nulls
UNITIDint4
No
DOMAINIDint4
No
AREAvarchar(64)64
Yes
TYPEint4
Yes
NAMEvarchar(64)64
Yes
LRUNDATEint4
Yes
PLATFORMint4
Yes
IDXint4
No
T08Operavarchar(127)127
Yes
T09Operavarchar(127)127
Yes
T0ASystevarchar(127)127
Yes
T0BSystevarchar(127)127
Yes
T0CSystevarchar(127)127
Yes
T0DRelatvarchar(64)64
Yes
D0ESystefloat8
Yes
T0FProcevarchar(127)127
Yes
L10Proceint4
Yes
T11Fixedvarchar(127)127
Yes
T12Fixedvarchar(127)127
Yes
T13Fixedvarchar(127)127
Yes
T14CDRomvarchar(127)127
Yes
T15CDRomvarchar(127)127
Yes
T16TCPIPvarchar(127)127
Yes
T17TCPIPvarchar(127)127
Yes
T18Displvarchar(127)127
Yes
T19Displvarchar(127)127
Yes
SQL Script
CREATE TABLE [dbo].[RALLHW]
(
[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,
[T08Opera] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[T09Opera] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[T0ASyste] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[T0BSyste] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[T0CSyste] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[T0DRelat] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[D0ESyste] [float] NULL,
[T0FProce] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[L10Proce] [int] NULL,
[T11Fixed] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[T12Fixed] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[T13Fixed] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[T14CDRom] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[T15CDRom] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[T16TCPIP] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[T17TCPIP] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[T18Displ] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[T19Displ] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
Uses