Tables [dbo].[si_arg_swprod_tot_prop]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count0
Created12:31:17 PM Sunday, December 05, 2010
Last Modified12:31:17 PM Sunday, December 05, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
sw_def_uuidbinary(16)16
No
data_sourcenvarchar(128)256
No
model_uuidbinary(16)16
Yes
company_uuidbinary(16)16
Yes
company_namenvarchar(100)200
Yes
model_namenvarchar(100)200
Yes
software_productnvarchar(255)510
Yes
license_typenvarchar(100)200
No
owned_countint4
Yes
discovered_countint4
Yes
varianceint4
Yes
Permissions
TypeActionOwning Principal
GrantDeleteaiadmin
GrantInsertaiadmin
GrantSelectaiadmin
GrantUpdateaiadmin
GrantSelectaipublic
SQL Script
CREATE TABLE [dbo].[si_arg_swprod_tot_prop]
(
[sw_def_uuid] [binary] (16) NOT NULL,
[data_source] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[model_uuid] [binary] (16) NULL,
[company_uuid] [binary] (16) NULL,
[company_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[model_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[software_product] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[license_type] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[owned_count] [int] NULL,
[discovered_count] [int] NULL,
[variance] [int] NULL
) ON [PRIMARY]

GO
GRANT SELECT ON  [dbo].[si_arg_swprod_tot_prop] TO [aiadmin]
GRANT INSERT ON  [dbo].[si_arg_swprod_tot_prop] TO [aiadmin]
GRANT DELETE ON  [dbo].[si_arg_swprod_tot_prop] TO [aiadmin]
GRANT UPDATE ON  [dbo].[si_arg_swprod_tot_prop] TO [aiadmin]
GRANT SELECT ON  [dbo].[si_arg_swprod_tot_prop] TO [aipublic]
GO
Uses