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

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

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: