Tables [dbo].[wtframerelay_pvc_endpoint]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count0
Created11:07:52 AM Wednesday, March 07, 2007
Last Modified11:09:18 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKwtframerelay_pvc_endpoint: uuiduuidbinary(16)16
No
cirint4
Yes
containerhostvarchar(100)100
Yes
hostnamevarchar(100)100
Yes
dlciint4
Yes
incongestionthreshint4
Yes
outcongestionthreshint4
Yes
utilizationthresholdint4
Yes
ifdescriptionvarchar(100)100
Yes
ifindexint4
Yes
iftypeint4
Yes
interface_novarchar(100)100
Yes
network_address_hexbinary(4)4
Yes
pvclinkidvarchar(100)100
Yes
remote_ip_address_hexbinary(4)4
Yes
frlink_uuidbinary(16)16
Yes
frlink_flagint4
Yes
dlcmiint4
Yes
ifaliasvarchar(100)100
Yes
ref_wvidvarchar(255)255
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKwtframerelay_pvc_endpoint: uuidXPKwtframerelay_pvc_endpointuuid
Yes
SQL Script
CREATE TABLE [dbo].[wtframerelay_pvc_endpoint]
(
[uuid] [binary] (16) NOT NULL,
[cir] [int] NULL,
[containerhost] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[hostname] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dlci] [int] NULL,
[incongestionthresh] [int] NULL,
[outcongestionthresh] [int] NULL,
[utilizationthreshold] [int] NULL,
[ifdescription] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ifindex] [int] NULL,
[iftype] [int] NULL,
[interface_no] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[network_address_hex] [binary] (4) NULL,
[pvclinkid] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[remote_ip_address_hex] [binary] (4) NULL,
[frlink_uuid] [binary] (16) NULL,
[frlink_flag] [int] NULL,
[dlcmi] [int] NULL,
[ifalias] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ref_wvid] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wtframerelay_pvc_endpoint] ADD CONSTRAINT [XPKwtframerelay_pvc_endpoint] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO
Uses
Used By