[dbo].[wtanointerface]

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

	Name	Data Type	Max Length (Bytes)
	class_name	varchar(40)	40
	uuid	binary(16)	16
$Indexes sanointerface_dx3: device_name\name$	name	varchar(200)	200
$Indexes sanointerface_dx2: device_name\ifindex$ $Indexes sanointerface_dx3: device_name\name$	device_name	varchar(40)	40
$Indexes sanointerface_dx2: device_name\ifindex$	ifindex	int	4
	interface_no	varchar(100)	100
	ifdescr	varchar(40)	40
	address	varchar(30)	30
	bpv_wvid	varchar(255)	255
	parent_uuid	binary(16)	16
	prop_status	tinyint	1
	managed_bits	tinyint	1
	checker	tinyint	1
	status_no	int	4
	status	varchar(255)	255
	nature	varchar(30)	30
	link_id	varchar(100)	100
	link_type	int	4
	anooption	int	4
	atm	tinyint	1
	fro	tinyint	1
	rmo	tinyint	1
	smo	tinyint	1
	ip	tinyint	1
	dsl	tinyint	1
	bgp	tinyint	1
	ospf	tinyint	1
	p1	tinyint	1
	p2	tinyint	1
	p3	tinyint	1
	p4	tinyint	1
	p5	tinyint	1

	Name	Columns	Unique
	XPKwtanointerface	uuid
	sanointerface_dx1	uuid
	sanointerface_dx2	device_name, ifindex
	sanointerface_dx3	device_name, name

SQL Script

CREATE TABLE [dbo].[wtanointerface]
(
[class_name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[uuid] [binary] (16) NOT NULL,
[name] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[device_name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ifindex] [int] NULL,
[interface_no] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ifdescr] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[address] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[bpv_wvid] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[parent_uuid] [binary] (16) NULL,
[prop_status] [tinyint] NULL,
[managed_bits] [tinyint] NULL,
[checker] [tinyint] NULL,
[status_no] [int] NULL,
[status] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[nature] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[link_id] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[link_type] [int] NULL,
[anooption] [int] NULL,
[atm] [tinyint] NULL,
[fro] [tinyint] NULL,
[rmo] [tinyint] NULL,
[smo] [tinyint] NULL,
[ip] [tinyint] NULL,
[dsl] [tinyint] NULL,
[bgp] [tinyint] NULL,
[ospf] [tinyint] NULL,
[p1] [tinyint] NULL,
[p2] [tinyint] NULL,
[p3] [tinyint] NULL,
[p4] [tinyint] NULL,
[p5] [tinyint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wtanointerface] ADD CONSTRAINT [XPKwtanointerface] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [sanointerface_dx2] ON [dbo].[wtanointerface] ([device_name], [ifindex]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [sanointerface_dx3] ON [dbo].[wtanointerface] ([device_name], [name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [sanointerface_dx1] ON [dbo].[wtanointerface] ([uuid]) ON [PRIMARY]
GO