[ca_itrm].[health_mdb

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	0
Created	9:45:46 AM Monday, November 30, 2009
Last Modified	9:45:46 AM Monday, November 30, 2009

Name	Data Type	Max Length (Bytes)	Default
label	nvarchar(255)	510	('')
object_uuid	binary(16)	16
object_type	int	4	((0))
primary_key_string	nvarchar(255)	510	('')
key_count	int	4	((0))
primary_table	int	4	((0))
agent_table	int	4	((0))
group_member	int	4	((0))
inv_root_map	int	4	((0))
inv_general_item	int	4	((0))
inv_general_tree	int	4	((0))
signaturesoftware	int	4	((0))
heuristicsoftware	int	4	((0))

SQL Script

CREATE TABLE [ca_itrm].[health_mdb_chk]
(
[label] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__health_md__label__4D2C3BBF] DEFAULT (''),
[object_uuid] [binary] (16) NOT NULL,
[object_type] [int] NULL CONSTRAINT [DF__health_md__objec__4E205FF8] DEFAULT ((0)),
[primary_key_string] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__health_md__prima__4F148431] DEFAULT (''),
[key_count] [int] NULL CONSTRAINT [DF__health_md__key_c__5008A86A] DEFAULT ((0)),
[primary_table] [int] NULL CONSTRAINT [DF__health_md__prima__50FCCCA3] DEFAULT ((0)),
[agent_table] [int] NULL CONSTRAINT [DF__health_md__agent__51F0F0DC] DEFAULT ((0)),
[group_member] [int] NULL CONSTRAINT [DF__health_md__group__52E51515] DEFAULT ((0)),
[inv_root_map] [int] NULL CONSTRAINT [DF__health_md__inv_r__53D9394E] DEFAULT ((0)),
[inv_general_item] [int] NULL CONSTRAINT [DF__health_md__inv_g__54CD5D87] DEFAULT ((0)),
[inv_general_tree] [int] NULL CONSTRAINT [DF__health_md__inv_g__55C181C0] DEFAULT ((0)),
[signaturesoftware] [int] NULL CONSTRAINT [DF__health_md__signa__56B5A5F9] DEFAULT ((0)),
[heuristicsoftware] [int] NULL CONSTRAINT [DF__health_md__heuri__57A9CA32] DEFAULT ((0))
) ON [PRIMARY]
GO