Tables [dbo].[arg_link_legaldoc_attachment]
Properties
PropertyValue
Row Count3
Created10:33:13 PM Thursday, February 10, 2011
Last Modified10:34:30 PM Thursday, February 10, 2011
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key xpkarg_link_legaldoc_attachmt: legaldoc_uuid\file_idForeign Keys LLEAMJOIN01: [dbo].[arg_legaldoc].legaldoc_uuidlegaldoc_uuidbinary(16)16
No
Cluster Primary Key xpkarg_link_legaldoc_attachmt: legaldoc_uuid\file_idForeign Keys LLEAMJOIN02: [dbo].[al_file_storage].file_idfile_idbigint8
No
last_update_dateint4
Yes
version_numberint4
Yes
('0  ')
Foreign Keys FK_LINK_LEGALDOC_ATTACH_TENANT: [dbo].[ca_tenant].tenanttenantbinary(16)16
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key xpkarg_link_legaldoc_attachmt: legaldoc_uuid\file_idxpkarg_link_legaldoc_attachmtlegaldoc_uuid, file_id
Yes
Foreign Keys Foreign Keys
NameColumns
FK_LINK_LEGALDOC_ATTACH_TENANTtenant->[dbo].[ca_tenant].[id]
LLEAMJOIN01legaldoc_uuid->[dbo].[arg_legaldoc].[legaldoc_uuid]
LLEAMJOIN02file_id->[dbo].[al_file_storage].[file_id]
SQL Script
CREATE TABLE [dbo].[arg_link_legaldoc_attachment]
(
[legaldoc_uuid] [binary] (16) NOT NULL,
[file_id] [bigint] NOT NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__ARG_LINK___VERSI__22401542] DEFAULT ('0  '),
[tenant] [binary] (16) NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_link_legaldoc_attachment] ADD CONSTRAINT [xpkarg_link_legaldoc_attachmt] PRIMARY KEY CLUSTERED ([legaldoc_uuid], [file_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_link_legaldoc_attachment] ADD CONSTRAINT [FK_LINK_LEGALDOC_ATTACH_TENANT] FOREIGN KEY ([tenant]) REFERENCES [dbo].[ca_tenant] ([id])
GO
ALTER TABLE [dbo].[arg_link_legaldoc_attachment] ADD CONSTRAINT [LLEAMJOIN01] FOREIGN KEY ([legaldoc_uuid]) REFERENCES [dbo].[arg_legaldoc] ([legaldoc_uuid])
GO
ALTER TABLE [dbo].[arg_link_legaldoc_attachment] ADD CONSTRAINT [LLEAMJOIN02] FOREIGN KEY ([file_id]) REFERENCES [dbo].[al_file_storage] ([file_id])
GO
Uses