Tables [dbo].[usm_form_attributes_schema]
Properties
PropertyValue
Row Count225
Created11:19:32 AM Monday, December 13, 2010
Last Modified11:19:32 AM Monday, December 13, 2010
Columns
NameData TypeCollationMax Length (Bytes)Allow NullsDefault
Cluster Primary Key XPK1usm_form_attributes_schema: form_entity_type\attr_nameIndexes usm_form_attr_schema_idx_1: form_entity_typeform_entity_typeint4
No
Cluster Primary Key XPK1usm_form_attributes_schema: form_entity_type\attr_nameattr_namevarchar(256)SQL_Latin1_General_CP1_CI_AS256
No
attr_default_valuenvarchar(2000)SQL_Latin1_General_CP1_CS_AS4000
Yes
is_requiredint4
No
is_localizableint4
No
('0')
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPK1usm_form_attributes_schema: form_entity_type\attr_nameXPK1usm_form_attributes_schemaform_entity_type, attr_name
Yes
usm_form_attr_schema_idx_1form_entity_type
SQL Script
CREATE TABLE [dbo].[usm_form_attributes_schema]
(
[form_entity_type] [int] NOT NULL,
[attr_name] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[attr_default_value] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[is_required] [int] NOT NULL,
[is_localizable] [int] NOT NULL CONSTRAINT [DF__usm_form___is_lo__11BBCDCD] DEFAULT ('0')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[usm_form_attributes_schema] ADD CONSTRAINT [XPK1usm_form_attributes_schema] PRIMARY KEY CLUSTERED ([form_entity_type], [attr_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_form_attr_schema_idx_1] ON [dbo].[usm_form_attributes_schema] ([form_entity_type]) ON [PRIMARY]
GO
Uses