Table: Attachment
Associates attachments to an item.
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
row_KEYintNOT NULLWhich row in the table indicated by [table_information_KEY].
table_information_KEYintNOT NULLWhich table is the row indicated by row_KEY in.
attachment_content_KEYintNOT NULLWhat is the content of the associated attachment.
attachment_namenvarchar (260)NOT NULLThe name of a particular attachment. This is usually the file name of the source file.
attachment_commentnvarchar (-1)NOT NULL
Primary key
NameColumnsDescription
PK_Attachment$row_KEY$table_information_KEY$attachment_content_KEYrow_KEY, table_information_KEY, attachment_content_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Attachment$attachment_content_KEYattachment_content_KEYIndex supports foreign key FK_Attachment__Attachment_Content__attachment_content_KEY
IX_Attachment$table_information_KEYtable_information_KEYIndex supports foreign key FK_Attachment__Table_Information__table_information_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Attachment__Attachment_Content__attachment_content_KEYattachment_content_KEYAttachment_Content
FK_Attachment__Table_Information__table_information_KEYtable_information_KEYTable_Information

Schema diagram