Table JiveCore900.public.jivecnxtconnection 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
connectionid int8 19
alias varchar 255
appinstanceid int8 19
creationdate int8 19
enabled int2 5
modificationdate int8 19
serviceid int8 19
jivecnxtendpoint.endpointid jvcx_fk_endpoint R
userid int8 19
jiveuser.userid Implied Constraint R

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

Column(s) Type Sort Constraint Name
connectionid Primary key Asc jvcnxtcx_pk
appinstanceid + alias Must be unique Asc/Asc jvcnxtcx_ix_ai
serviceid Performance Asc jvcnxtcx_ix_svc
userid Performance Asc jvcnxtcx_ix_user

Close relationships  within of separation: