[dbo].[si_arg_own_asset

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	12:31:17 PM Sunday, December 05, 2010
Last Modified	12:31:17 PM Sunday, December 05, 2010

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_si_arg_own_asset_prop: own_asset_uuid\data_source$	own_asset_uuid	binary(16)	16
$Cluster Primary Key PK_si_arg_own_asset_prop: own_asset_uuid\data_source$	data_source	nvarchar(128)	256
	own_asset_name	nvarchar(100)	200
	own_asset_tag	nvarchar(64)	128
	own_alias	nvarchar(30)	60
	own_serial_number	nvarchar(64)	128
	own_host_name	nvarchar(255)	510
	own_model_name	nvarchar(100)	200
	own_resource_family	nvarchar(100)	200
	own_manufacturer	nvarchar(100)	200
	own_class	nvarchar(100)	200
	own_subclass	nvarchar(100)	200
	own_location_name	nvarchar(100)	200
	own_department	nvarchar(100)	200
	own_cost_center	nvarchar(100)	200
	dis_asset_uuid	binary(16)	16
	dis_host_name	nvarchar(255)	510
	dis_serial_number	nvarchar(64)	128
	dis_asset_tag	nvarchar(64)	128
	dis_sys_model	nvarchar(384)	768
	dis_sys_type	nvarchar(384)	768
	dis_sys_vendor	nvarchar(384)	768

	Name	Columns	Unique
$Cluster Primary Key PK_si_arg_own_asset_prop: own_asset_uuid\data_source$	PK_si_arg_own_asset_prop	own_asset_uuid, data_source

Type	Action	Owning Principal
Grant	Delete	aiadmin
Grant	Insert	aiadmin
Grant	Select	aiadmin
Grant	Update	aiadmin
Grant	Select	aipublic

SQL Script

CREATE TABLE [dbo].[si_arg_own_asset_prop]
(
[own_asset_uuid] [binary] (16) NOT NULL,
[data_source] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[own_asset_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[own_asset_tag] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[own_alias] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[own_serial_number] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[own_host_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[own_model_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[own_resource_family] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[own_manufacturer] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[own_class] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[own_subclass] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[own_location_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[own_department] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[own_cost_center] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dis_asset_uuid] [binary] (16) NULL,
[dis_host_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dis_serial_number] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dis_asset_tag] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dis_sys_model] [nvarchar] (384) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dis_sys_type] [nvarchar] (384) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dis_sys_vendor] [nvarchar] (384) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[si_arg_own_asset_prop] ADD CONSTRAINT [PK_si_arg_own_asset_prop] PRIMARY KEY CLUSTERED ([own_asset_uuid], [data_source]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[si_arg_own_asset_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[si_arg_own_asset_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[si_arg_own_asset_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[si_arg_own_asset_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_arg_own_asset_prop] TO [aipublic]
GO