Tables [dbo].[evm_appliance_configuration]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count0
Created11:08:06 AM Wednesday, March 07, 2007
Last Modified11:10:00 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKevm_appliance_configuration: unit_idForeign Keys $evm_a_r00001af200000000: [dbo].[vuln_management_configuration].unit_idunit_idbinary(16)16
No
auto_create_discovered_assetstinyint1
Yes
uses_auto_inventorytinyint1
Yes
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 XPKevm_appliance_configuration: unit_idXPKevm_appliance_configurationunit_id
Yes
Foreign Keys Foreign Keys
NameColumns
$evm_a_r00001af200000000unit_id->[dbo].[vuln_management_configuration].[unit_id]
SQL Script
CREATE TABLE [dbo].[evm_appliance_configuration]
(
[unit_id] [binary] (16) NOT NULL,
[auto_create_discovered_assets] [tinyint] NULL,
[uses_auto_inventory] [tinyint] 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].[evm_appliance_configuration] ADD CONSTRAINT [XPKevm_appliance_configuration] PRIMARY KEY CLUSTERED ([unit_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[evm_appliance_configuration] ADD CONSTRAINT [$evm_a_r00001af200000000] FOREIGN KEY ([unit_id]) REFERENCES [dbo].[vuln_management_configuration] ([unit_id])
GO
Uses
Used By