jiveexpertisetag

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
expertisetagid int8 19 null
tagid int8 19 null
jivetag.tagid jetag_fk_tagidR
targetuserid int8 19 null
jiveuser.userid jetag_fk_tuseridR
originuserid int8 19 null
jiveuser.userid jetag_fk_ouseridR
approved int2 5 0
creationdate int8 19 null

Indexes

Constraint Name Type Sort Column(s)
jetag_pk Primary key Asc expertisetagid
jetag_appridx Performance Asc approved
jetag_originidx Performance Asc originuserid
jetag_tagidx Performance Asc tagid
jetag_targetidx Performance Asc targetuserid
jvetag_tagtargetorigin_idx Must be unique Asc/Asc/Asc tagid + targetuserid + originuserid

Relationships

Close relationships within degrees of separation