Tables [aiowner].[ai_hwdef_prop_hwsys_s]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count141
Created9:12:27 AM Thursday, November 06, 2008
Last Modified9:12:27 AM Thursday, November 06, 2008
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
hwtypenvarchar(128)256
Yes
hwmfgrnvarchar(128)256
Yes
hwmodelnvarchar(128)256
Yes
hwmemreal4
Yes
hwproccountint4
Yes
SQL Script
CREATE TABLE [aiowner].[ai_hwdef_prop_hwsys_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,
[hwtype] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwmfgr] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwmodel] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[hwmem] [real] NULL,
[hwproccount] [int] NULL
) ON [PRIMARY]
GO
Uses