Tables [dbo].[al_link_norm_manufacturer]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count91
Created10:33:06 PM Thursday, February 10, 2011
Last Modified10:33:06 PM Thursday, February 10, 2011
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_al_link_norm_manufacturer: uuidIndexes idx_al_link_norm_manufacturer8: uuiduuidbinary(16)16
No
collected_valuenvarchar(255)510
No
content_uuidbinary(16)16
No
creation_usernvarchar(64)128
Yes
creation_dateint4
Yes
last_update_usernvarchar(64)128
Yes
last_update_dateint4
Yes
version_numberint4
Yes
('0 ')
actionint4
Yes
('0 ')
processint4
Yes
('0 ')
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_al_link_norm_manufacturer: uuidPK_al_link_norm_manufactureruuid
Yes
idx_al_link_norm_manufacturer8uuid
Yes
SQL Script
CREATE TABLE [dbo].[al_link_norm_manufacturer]
(
[uuid] [binary] (16) NOT NULL,
[collected_value] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[content_uuid] [binary] (16) NOT NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__AL_LNK_NRM_MAN_VERS] DEFAULT ('0 '),
[action] [int] NULL CONSTRAINT [DF__AL_LNK_NRM_MAN_ACT] DEFAULT ('0 '),
[process] [int] NULL CONSTRAINT [DF__AL_LNK_NRM_MAN_PROC] DEFAULT ('0 ')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[al_link_norm_manufacturer] ADD CONSTRAINT [PK_al_link_norm_manufacturer] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [idx_al_link_norm_manufacturer8] ON [dbo].[al_link_norm_manufacturer] ([uuid]) ON [PRIMARY]
GO
Uses
Used By