civicrm_openid - civicrm Database

Columns

Related columns Constraint Comments

Search:

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.

Showing 1 to 6 of 6 entries

Indexes

Search:

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

Showing 1 to 4 of 4 entries

Relationships

Close relationships within degrees of separation

One
Two degrees