Tables [aiowner].[ai_hwdef_mac_kpi_s]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count202
Created11:24:57 PM Monday, January 10, 2011
Last Modified11:24:57 PM Monday, January 10, 2011
Columns
NameData TypeMax Length (Bytes)Allow Nulls
source_set_priorityint4
No
source_domuuid_charvarchar(36)36
Yes
source_hwuuid_charvarchar(36)36
Yes
source_domain_idint4
Yes
source_unit_idint4
Yes
domuuiduniqueidentifier16
Yes
hwuuiduniqueidentifier16
Yes
hwmacnvarchar(128)256
Yes
SQL Script
CREATE TABLE [aiowner].[ai_hwdef_mac_kpi_s]
(
[source_set_priority] [int] NOT NULL,
[source_domuuid_char] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[source_hwuuid_char] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[source_domain_id] [int] NULL,
[source_unit_id] [int] NULL,
[domuuid] [uniqueidentifier] NULL,
[hwuuid] [uniqueidentifier] NULL,
[hwmac] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
Uses