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 10  √ 
document_attachment.attachmentId FKFEB8AEC756B0D1E8
report.attachmentId FKC84C553456B0D1E8
report.previewAttachmentId FKC84C55347CDA49B0
userbase.avatarId FK_USER_AVATAR
createdBy int 10  √  null
createdDate datetime 19  √  null
modifiedBy int 10  √  null
modifiedDate datetime 19  √  null
attachmentTypeId int 10  √  null
description longtext 2147483647  √  null
fileName varchar 255  √  null
fileSize int 10  √  null
mimeType longtext 2147483647  √  null
system char 1  √  null
organizationId int 10  √  null
organization.id FK8AF75923B2808048
projectId int 10  √  null
project.id FK8AF7592362A5139B

Table contained 33 rows at Wed Jan 18 17:22 PST 2012

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

Close relationships  within of separation: