Table contour.report
Reports

 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  √ 
report_criterion.reportId FKC53D6D56166CC54A
report_reportformat.reportId FK5EEEBF56166CC54A
reportcriteria.reportId FK767C093166CC54A
System generated unique ID
createdBy int 11  √  null
createdDate datetime 19  √  null
modifiedBy int 11  √  null
modifiedDate datetime 19  √  null
contextSensitive char 1  √  null
description longtext 2147483647  √  null Admin entered description of report
display varchar 255  √  null Display name of report
excelStartDataTest varchar 255  √  null
name varchar 255  √  null Internal name of report (Duplicate)
refId int 11  √  null
reportClass varchar 1024  √  null
scope int 11  √  null
showJamaFields char 1  √  null
sortItems char 1  √  null
system char 1  √  null
visible char 1  √  null Flag to indicate the report is visible to users
attachmentId int 11  √  null
attachment.id FKC84C553456B0D1E8
ID of report file
previewAttachmentId int 11  √  null
attachment.id FKC84C55347CDA49B0
reportTypeId int 11  √  null
reporttype.id FKC84C5534F0DEC1DE
reportParams longtext 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
attachmentId Performance Asc FKC84C553456B0D1E8
previewAttachmentId Performance Asc FKC84C55347CDA49B0
reportTypeId Performance Asc FKC84C5534F0DEC1DE

Close relationships  within of separation: