Table JiveCore900.public.jiveproject Generated by
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 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
displayname varchar 255  √  null

Table contained 6 rows at Fri Jan 13 13:20 PST 2017

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

Close relationships: