Table contour.attachment
File attachment information

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int 11  √ 
document_attachment.attachmentId FKFEB8AEC756B0D1E8
report.attachmentId FKC84C553456B0D1E8
report.previewAttachmentId FKC84C55347CDA49B0
userbase.avatarId FK_USER_AVATAR
createdBy int 11  √  null
createdDate datetime 19  √  null
modifiedBy int 11  √  null
modifiedDate datetime 19  √  null
attachmentTypeId int 11  √  null
description longtext 2147483647  √  null
fileName varchar 255  √  null
fileSize int 11  √  null
mimeType longtext 2147483647  √  null
system char 1  √  null
organizationId int 11  √  null
organization.id FK8AF75923B2808048
projectId int 11  √  null
project.id FK8AF7592343370F26

Table contained 33 rows at Mon Jun 14 17:03 PDT 2010

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
projectId Performance Asc FK8AF7592343370F26
organizationId Performance Asc FK8AF75923B2808048

Close relationships  within of separation: