jiveuserrel

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
relationshipid int8 19 null
jiveusrrellistmap.relationshipid jvurlstlm_fk_relidR
userid int8 19 null
jiveuser.userid jvusrrel_fk_usridR
relateduserid int8 19 null
jiveuser.userid jvusrrel_fk_rlusidR
relnshiptypeid int4 10 2
state varchar 20 'pending_approval'::character varying
creationdate int8 19 null
retirementdate int8 19 √ 0
graphid int8 19 null
jiveuserrelgraph.graphid jvusrrel_fk_rlgridR
workflowid int8 19 √ null
modificationdate int8 19 null

Indexes

Constraint Name Type Sort Column(s)
jiveusrrel_pk Primary key Asc relationshipid
jvusrrel_fk_rlgrid Performance Asc graphid
jvusrrel_relid_idx Performance Asc relateduserid
jvusrrel_uk2_idx Must be unique Asc/Asc/Asc/Asc/Asc userid + relateduserid + relnshiptypeid + state + retirementdate
jvusrrel_uk_idx Performance Asc/Asc/Asc userid + relateduserid + graphid

Relationships

Close relationships within degrees of separation