Tables [dbo].[ai_baseline_attribute_info]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count30
Created12:42:10 PM Sunday, December 05, 2010
Last Modified12:42:10 PM Sunday, December 05, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
attribute_uuiduniqueidentifier16
No
column_namenvarchar(256)512
No
attribute_typeint4
Yes
attribute_formatint4
Yes
attribute_value_textnvarchar(384)768
Yes
attribute_value_longint4
Yes
attribute_value_doublefloat8
Yes
Permissions
TypeActionOwning Principal
GrantDeleteaiadmin
GrantInsertaiadmin
GrantSelectaiadmin
GrantUpdateaiadmin
GrantSelectaipublic
SQL Script
CREATE TABLE [dbo].[ai_baseline_attribute_info]
(
[attribute_uuid] [uniqueidentifier] NOT NULL,
[column_name] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[attribute_type] [int] NULL,
[attribute_format] [int] NULL,
[attribute_value_text] [nvarchar] (384) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[attribute_value_long] [int] NULL,
[attribute_value_double] [float] NULL
) ON [PRIMARY]

GO
GRANT SELECT ON  [dbo].[ai_baseline_attribute_info] TO [aiadmin]
GRANT INSERT ON  [dbo].[ai_baseline_attribute_info] TO [aiadmin]
GRANT DELETE ON  [dbo].[ai_baseline_attribute_info] TO [aiadmin]
GRANT UPDATE ON  [dbo].[ai_baseline_attribute_info] TO [aiadmin]
GRANT SELECT ON  [dbo].[ai_baseline_attribute_info] TO [aipublic]
GO
Uses
Used By