Table contour.perspective 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  √ 
perspective.stereotypeId FKC653A3C1E06C7A2
perspective_role.perspectiveId FK4FA2049999AAFC2C
perspective_view.perspectiveId FK4FA3BEC899AAFC2C
perspectiveconfig.perspectiveId FKAB47207E99AAFC2C
createdBy int 11  √  null
createdDate datetime 19  √  null
modifiedBy int 11  √  null
modifiedDate datetime 19  √  null
active char 1  √  null
canOverride char 1  √  null
description longtext 2147483647  √  null
headerConfig varchar 255  √  null
icon varchar 255  √  null
name varchar 255  √  null
navConfig varchar 255  √  null
refId int 11  √  null
scope int 11  √  null
viewConfig varchar 255  √  null
xtype varchar 255  √  null
perspectiveTypeId int 11
perspectivetype.id FKC653A3CAA82B7C0
stereotypeId int 11  √  null
perspective.id FKC653A3C1E06C7A2

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
stereotypeId Performance Asc FKC653A3C1E06C7A2
perspectiveTypeId Performance Asc FKC653A3CAA82B7C0

Close relationships  within of separation: