Table JiveCore700.public.jiveproject 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
projectid int8 19
jivepcheckpoint.projectid jivepcp_fk R
jiveprojectprop.projectid jpjtp_wsid_fk R
jiveprojectstatus.projectid jvpjtstat_pjtid_fk R
parentobjecttype int4 10
parentobjectid int8 19
name varchar 255
jiveproperty.name Implied Constraint R
description varchar 1000  √  null
userid int8 19
jiveuser.userid Implied Constraint R
creationdate int8 19
modificationdate int8 19
startdate int8 19
duedate int8 19  √  null
status int4 10
lateststatusid int8 19  √  null
duedatenull int4 10

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
projectid Primary key Asc jivepjt_pk
duedate + duedatenull Performance Asc/Asc jivepjt_ddn_idx

Close relationships: