Tables [dbo].[arg_link_company_keyword]
Properties
PropertyValue
Row Count0
Created10:33:13 PM Thursday, February 10, 2011
Last Modified10:34:29 PM Thursday, February 10, 2011
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key xpkarg_link_company_keyword: company_uuid\kwkdidForeign Keys LCOKWJOIN01: [dbo].[ca_company].company_uuidcompany_uuidbinary(16)16
No
Cluster Primary Key xpkarg_link_company_keyword: company_uuid\kwkdidForeign Keys LCOKWJOIN02: [dbo].[arg_keydef].kwkdidkwkdidbigint8
No
last_update_dateint4
Yes
version_numberint4
Yes
('0  ')
Indexes Indexes
NameColumnsUnique
Cluster Primary Key xpkarg_link_company_keyword: company_uuid\kwkdidxpkarg_link_company_keywordcompany_uuid, kwkdid
Yes
Foreign Keys Foreign Keys
NameColumns
LCOKWJOIN01company_uuid->[dbo].[ca_company].[company_uuid]
LCOKWJOIN02kwkdid->[dbo].[arg_keydef].[kdid]
SQL Script
CREATE TABLE [dbo].[arg_link_company_keyword]
(
[company_uuid] [binary] (16) NOT NULL,
[kwkdid] [bigint] NOT NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__ARG_LINK___VERSI__74794A92] DEFAULT ('0  ')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_link_company_keyword] ADD CONSTRAINT [xpkarg_link_company_keyword] PRIMARY KEY CLUSTERED ([company_uuid], [kwkdid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_link_company_keyword] ADD CONSTRAINT [LCOKWJOIN01] FOREIGN KEY ([company_uuid]) REFERENCES [dbo].[ca_company] ([company_uuid])
GO
ALTER TABLE [dbo].[arg_link_company_keyword] ADD CONSTRAINT [LCOKWJOIN02] FOREIGN KEY ([kwkdid]) REFERENCES [dbo].[arg_keydef] ([kdid])
GO
Uses