jiveinvite

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
invitationid int8 19 null
jiveinviteprop.invitationid jvinvprop_invid_fkR
inviterid int8 19 √ null
jiveuser.userid jvinvt_fk_invtridR
userid int8 19 √ null
jiveuser.userid jvinvt_fk_usridR
email varchar 254 √ null
objecttype int4 10 null
objectid int8 19 null
sentdate int8 19 √ null
revokerid int8 19 √ null
revokedate int8 19 √ null
state int4 10 null
creationdate int8 19 null
modificationdate int8 19 null

Indexes

Constraint Name Type Sort Column(s)
jiveinvite_pk Primary key Asc invitationid
jiveinvite_email_idx Performance Asc email
jiveinvite_object_idx Performance Asc/Asc objectid + objecttype
jiveinvite_uid_idx Performance Asc userid
jvinvt_fk_invtrid Performance Asc inviterid

Relationships

Close relationships within degrees of separation