civicrm_openid

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null

Unique OpenID ID

contact_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_openid_contact_idC

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.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_openid_contact_id Performance Asc contact_id
index_location_type Performance Asc location_type_id
UI_openid Must be unique Asc openid

Relationships