[dbo].[vuln_management_backup

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:08:08 AM Wednesday, March 07, 2007
Last Modified	11:09:59 AM Wednesday, March 07, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Row Count

Created

11:08:08 AM Wednesday, March 07, 2007

Last Modified

11:09:59 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
unit_id	binary(16)	16
backup_file_url	nvarchar(255)	510
backup_location_password	nvarchar(30)	60
backup_location_user_name	nvarchar(85)	170
is_active	tinyint	1
creation_user	nvarchar(64)	128
creation_date	int	4
last_update_user	nvarchar(64)	128
last_update_date	int	4
version_number	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

unit_id

binary(16)

backup_file_url

nvarchar(255)

510

backup_location_password

nvarchar(30)

backup_location_user_name

nvarchar(85)

170

is_active

tinyint

creation_user

nvarchar(64)

128

creation_date

int

last_update_user

nvarchar(64)

128

last_update_date

int

version_number

int

	Name	Columns	Unique
	XPKvuln_management_backup_config	unit_id

Name

Columns

Unique

XPKvuln_management_backup_config

unit_id

Name	Columns
$vuln__r00001b2300000000	unit_id->[dbo].[vuln_management_configuration].[unit_id]

Name

Columns

$vuln__r00001b2300000000

unit_id->[dbo].[vuln_management_configuration].[unit_id]

SQL Script

CREATE TABLE [dbo].[vuln_management_backup_config]
(
[unit_id] [binary] (16) NOT NULL,
[backup_file_url] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[backup_location_password] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[backup_location_user_name] [nvarchar] (85) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[is_active] [tinyint] 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].[vuln_management_backup_config] ADD CONSTRAINT [XPKvuln_management_backup_config] PRIMARY KEY CLUSTERED ([unit_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[vuln_management_backup_config] ADD CONSTRAINT [$vuln__r00001b2300000000] FOREIGN KEY ([unit_id]) REFERENCES [dbo].[vuln_management_configuration] ([unit_id])
GO