Tables [dbo].[asset_detection_profile]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count0
Created11:07:58 AM Wednesday, March 07, 2007
Last Modified11:09:57 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKasset_detection_profile: asset_detection_profile_rec_idasset_detection_profile_rec_idbinary(16)16
No
status_changed_bynvarchar(64)128
Yes
auto_statustinyint1
Yes
inventory_profile_idbinary(16)16
No
risk_ratingdecimal(3,1)5
Yes
asset_vulnerability_rec_idbinary(16)16
No
status_change_dateint4
No
Foreign Keys $asset_r00001b6d00000000: [dbo].[asset_detection_profile_status].asset_detect_profile_status_idasset_detect_profile_status_idbinary(16)16
No
creation_usernvarchar(64)128
Yes
creation_dateint4
Yes
last_update_usernvarchar(64)128
Yes
last_update_dateint4
Yes
version_numberint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKasset_detection_profile: asset_detection_profile_rec_idXPKasset_detection_profileasset_detection_profile_rec_id
Yes
Foreign Keys Foreign Keys
NameColumns
$asset_r00001b6d00000000asset_detect_profile_status_id->[dbo].[asset_detection_profile_status].[asset_detect_profile_status_id]
SQL Script
CREATE TABLE [dbo].[asset_detection_profile]
(
[asset_detection_profile_rec_id] [binary] (16) NOT NULL,
[status_changed_by] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[auto_status] [tinyint] NULL,
[inventory_profile_id] [binary] (16) NOT NULL,
[risk_rating] [decimal] (3, 1) NULL,
[asset_vulnerability_rec_id] [binary] (16) NOT NULL,
[status_change_date] [int] NOT NULL,
[asset_detect_profile_status_id] [binary] (16) NOT NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[asset_detection_profile] ADD CONSTRAINT [XPKasset_detection_profile] PRIMARY KEY CLUSTERED ([asset_detection_profile_rec_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[asset_detection_profile] ADD CONSTRAINT [$asset_r00001b6d00000000] FOREIGN KEY ([asset_detect_profile_status_id]) REFERENCES [dbo].[asset_detection_profile_status] ([asset_detect_profile_status_id])
GO
Uses
Used By