Tables [ca_itrm].[health_mdb_chk_tmp]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count0
Created10:23:47 AM Friday, July 22, 2011
Last Modified10:23:47 AM Friday, July 22, 2011
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
labelnvarchar(255)510
Yes
('')
object_uuidbinary(16)16
No
object_typeint4
Yes
((0))
primary_key_stringnvarchar(255)510
Yes
('')
key_countint4
Yes
((0))
primary_tableint4
Yes
((0))
agent_tableint4
Yes
((0))
group_memberint4
Yes
((0))
inv_root_mapint4
Yes
((0))
inv_general_itemint4
Yes
((0))
inv_general_treeint4
Yes
((0))
signaturesoftwareint4
Yes
((0))
heuristicsoftwareint4
Yes
((0))
SQL Script
CREATE TABLE [ca_itrm].[health_mdb_chk_tmp]
(
[label] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__health_md__label__296D32DF] DEFAULT (''),
[object_uuid] [binary] (16) NOT NULL,
[object_type] [int] NULL CONSTRAINT [DF__health_md__objec__2A615718] DEFAULT ((0)),
[primary_key_string] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__health_md__prima__2B557B51] DEFAULT (''),
[key_count] [int] NULL CONSTRAINT [DF__health_md__key_c__2C499F8A] DEFAULT ((0)),
[primary_table] [int] NULL CONSTRAINT [DF__health_md__prima__2D3DC3C3] DEFAULT ((0)),
[agent_table] [int] NULL CONSTRAINT [DF__health_md__agent__2E31E7FC] DEFAULT ((0)),
[group_member] [int] NULL CONSTRAINT [DF__health_md__group__2F260C35] DEFAULT ((0)),
[inv_root_map] [int] NULL CONSTRAINT [DF__health_md__inv_r__301A306E] DEFAULT ((0)),
[inv_general_item] [int] NULL CONSTRAINT [DF__health_md__inv_g__310E54A7] DEFAULT ((0)),
[inv_general_tree] [int] NULL CONSTRAINT [DF__health_md__inv_g__320278E0] DEFAULT ((0)),
[signaturesoftware] [int] NULL CONSTRAINT [DF__health_md__signa__32F69D19] DEFAULT ((0)),
[heuristicsoftware] [int] NULL CONSTRAINT [DF__health_md__heuri__33EAC152] DEFAULT ((0))
) ON [PRIMARY]

GO
Uses