eperson

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
eperson_id int4 10 √ null
email varchar 64 √ null
password varchar 128 √ null
can_log_in bool 1 √ null
require_certificate bool 1 √ null
self_registered bool 1 √ null
last_active timestamp 29,6 √ null
sub_frequency int4 10 √ null
netid varchar 64 √ null
salt varchar 32 √ null
digest_algorithm varchar 16 √ null
uuid uuid 2147483647 gen_random_uuid()
cwf_claimtask.owner_id cwf_claimtask_owner_id_fkey R
cwf_in_progress_user.user_id cwf_in_progress_user_user_id_fkey R
cwf_pooltask.eperson_id cwf_pooltask_eperson_id_fkey R
cwf_workflowitemrole.eperson_id cwf_workflowitemrole_eperson_id_fkey R
epersongroup2eperson.eperson_id epersongroup2eperson_eperson_id_fkey R
item.submitter_id item_submitter_id_fkey R
orcid_token.eperson_id orcid_token_eperson_id_fkey R
process.user_id process_eperson N
qaevent_processed.eperson_uuid eperson_uuid_fkey R
resourcepolicy.eperson_id resourcepolicy_eperson_id_fkey R
subscription.eperson_id subscription_eperson_id_fkey R
versionitem.eperson_id versionitem_eperson_id_fkey R
dspaceobject.uuid eperson_uuid_fkey R
session_salt varchar 32 √ null

Indexes

Constraint Name Type Sort Column(s)
eperson_pkey Primary key Asc uuid
eperson_email_idx Performance Asc email
eperson_email_key Must be unique Asc email
eperson_id_idx Performance Asc eperson_id
eperson_id_unique Must be unique Asc uuid
eperson_netid_key Must be unique Asc netid
eperson_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation