Table JiveCore900.public.spconnectionproperties Generated by
SchemaSpy
Legend: SourceForge.net
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
connectionpropertiesid int8 19
spauthenticationtokens.spconnectionpropertiesid spauthenticationtokens_cpid_fk R
spcontainers.spconnectionpropertiesid spcontainers_cpid_fk R
spusertranslation.spconnectionpropertiesid spusertranslation_cpid_fk R
url varchar 2000
credentialstype varchar 50
description varchar 2000
domain varchar 255  √  null
username varchar 255  √  null
password bytea 2147483647  √  null
everyoneprincipal varchar 255  √  null
fullcontrolprincipal varchar 255  √  null
sharepoint_facing_address varchar 255  √  null
kdc varchar 255  √  null
registrationtoken varchar 255  √  null
sitecollectionid varchar 255  √  null
wst2005wctx varchar 300  √  null
wst2005wtrealm varchar 300  √  null
wst2005wreply varchar 300  √  null
wst2005stsurl varchar 300  √  null
wst2005tokenvalue bytea 2147483647  √  null
wst2005tokenexpirationdate int8 19  √  null
default_parent_site_url varchar 255  √  null
default_parent_site_guid varchar 255  √  null
is_default varchar 1  √  null
searchiconurl varchar 2000  √  null
searchexternalurl varchar 2000  √  null
searchscopetype varchar 255  √  null
searchscope varchar 2000  √  null
searchtestkeywords varchar 255  √  null
searchmaxresults int8 19  √  null
searchenabled int8 19  √  null
searchengineid int8 19  √  null
claimsenabled int8 19  √  null
sp_version varchar 255  √  null
connection_type varchar 255 'SiteCollection'::character varying
spwaconnpropid_fk int8 19  √  null
searchstorageinstanceid int8 19  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
connectionpropertiesid Primary key Asc spconnectionproperties_pk
connection_type Performance Asc spconnprop_ctype_idx

Close relationships: