Tables [dbo].[arg_link_model_note]
Properties
PropertyValue
Row Count0
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_model_note: model_uuid\note_idForeign Keys LITNOJOIN01: [dbo].[ca_model_def].model_uuidmodel_uuidbinary(16)16
No
last_update_dateint4
Yes
version_numberint4
Yes
('0  ')
Foreign Keys FK_ARG_LINK_MODEL_NOTE_TENANT: [dbo].[ca_tenant].tenanttenantbinary(16)16
Yes
Cluster Primary Key xpkarg_link_model_note: model_uuid\note_idForeign Keys LITNOJOIN02: [dbo].[al_notes].note_idnote_idbigint8
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key xpkarg_link_model_note: model_uuid\note_idxpkarg_link_model_notemodel_uuid, note_id
Yes
Foreign Keys Foreign Keys
NameColumns
FK_ARG_LINK_MODEL_NOTE_TENANTtenant->[dbo].[ca_tenant].[id]
LITNOJOIN01model_uuid->[dbo].[ca_model_def].[model_uuid]
LITNOJOIN02note_id->[dbo].[al_notes].[note_id]
SQL Script
CREATE TABLE [dbo].[arg_link_model_note]
(
[model_uuid] [binary] (16) NOT NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__ARG_LINK___VERSI__42CCE065] DEFAULT ('0  '),
[tenant] [binary] (16) NULL,
[note_id] [bigint] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[arg_link_model_note] ADD CONSTRAINT [xpkarg_link_model_note] PRIMARY KEY CLUSTERED ([model_uuid], [note_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_link_model_note] ADD CONSTRAINT [FK_ARG_LINK_MODEL_NOTE_TENANT] FOREIGN KEY ([tenant]) REFERENCES [dbo].[ca_tenant] ([id])
GO
ALTER TABLE [dbo].[arg_link_model_note] ADD CONSTRAINT [LITNOJOIN01] FOREIGN KEY ([model_uuid]) REFERENCES [dbo].[ca_model_def] ([model_uuid])
GO
ALTER TABLE [dbo].[arg_link_model_note] ADD CONSTRAINT [LITNOJOIN02] FOREIGN KEY ([note_id]) REFERENCES [dbo].[al_notes] ([note_id])
GO
Uses