Tables [ca_itrm].[geni_1291572735_13]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count0
Created2:24:52 AM Monday, July 11, 2011
Last Modified2:24:52 AM Monday, July 11, 2011
Columns
NameData TypeMax Length (Bytes)Allow Nulls
object_uuidbinary(16)16
No
item_parent_idint4
No
item_name_idint4
No
item_root_idint4
Yes
item_root_name_idint4
Yes
item_parent_name_idint4
Yes
item_indexint4
Yes
item_typeint4
Yes
item_formatint4
Yes
item_value_textnvarchar(384)768
Yes
item_previous_value_textnvarchar(384)768
Yes
item_value_longint4
Yes
item_previous_value_longint4
Yes
item_value_doublefloat8
Yes
item_previous_value_doublefloat8
Yes
item_dateint4
Yes
item_lockint4
Yes
domain_uuidbinary(16)16
Yes
auto_rep_versiontimestamp8
Yes
object_typeint4
Yes
tenant_idbinary(16)16
Yes
SQL Script
CREATE TABLE [ca_itrm].[geni_1291572735_13]
(
[object_uuid] [binary] (16) NOT NULL,
[item_parent_id] [int] NOT NULL,
[item_name_id] [int] NOT NULL,
[item_root_id] [int] NULL,
[item_root_name_id] [int] NULL,
[item_parent_name_id] [int] NULL,
[item_index] [int] NULL,
[item_type] [int] NULL,
[item_format] [int] NULL,
[item_value_text] [nvarchar] (384) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[item_previous_value_text] [nvarchar] (384) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[item_value_long] [int] NULL,
[item_previous_value_long] [int] NULL,
[item_value_double] [float] NULL,
[item_previous_value_double] [float] NULL,
[item_date] [int] NULL,
[item_lock] [int] NULL,
[domain_uuid] [binary] (16) NULL,
[auto_rep_version] [timestamp] NULL,
[object_type] [int] NULL,
[tenant_id] [binary] (16) NULL
) ON [PRIMARY]

GO
Uses