Tables [dbo].[usm_rate_def_ext]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count27
Created11:19:32 AM Monday, December 13, 2010
Last Modified5:02:32 PM Monday, April 25, 2011
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKusm_rate_def_ext: ididbinary(16)16
No
Foreign Keys XFK_usm_rate_def_ext: [dbo].[usm_rate_definition].item_iditem_idint4
Yes
ext_keyvarchar(128)128
Yes
ext_valuenvarchar(512)1024
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKusm_rate_def_ext: idXPKusm_rate_def_extid
Yes
Foreign Keys Foreign Keys
NameUpdateDeleteColumns
XFK_usm_rate_def_extCascadeCascadeitem_id->[dbo].[usm_rate_definition].[item_id]
SQL Script
CREATE TABLE [dbo].[usm_rate_def_ext]
(
[id] [binary] (16) NOT NULL,
[item_id] [int] NULL,
[ext_key] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ext_value] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[usm_rate_def_ext] ADD CONSTRAINT [XPKusm_rate_def_ext] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_rate_def_ext] ADD CONSTRAINT [XFK_usm_rate_def_ext] FOREIGN KEY ([item_id]) REFERENCES [dbo].[usm_rate_definition] ([item_id]) ON DELETE CASCADE ON UPDATE CASCADE
GO
Uses