Table d47civi_0z3xa.civicrm_openid 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
id int unsigned 10  √  Unique OpenID ID
contact_id int unsigned 10  √  null
civicrm_contact.id FK_civicrm_openid_contact_id C
FK to Contact ID
location_type_id int unsigned 10  √  null Which Location does this email belong to.
openid varchar 255  √  null the OpenID (or OpenID-style http://username.domain/) unique identifier for this contact mainly used for logging in to CiviCRM
allowed_to_login tinyint 3 0 Whether or not this user is allowed to login
is_primary tinyint 3  √  0 Is this the primary email for this contact and location.

Table contained 0 rows at mer. avr. 13 16:52 EDT 2016

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
contact_id Performance Asc FK_civicrm_openid_contact_id  
location_type_id Performance Asc index_location_type  
openid Must be unique Asc UI_openid This unique column is also nullable

Close relationships  within of separation: