eperson

0 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()
epersongroup2eperson.eperson_id epersongroup2eperson_eperson_id_fkey R
item.submitter_id item_submitter_id_fkey R
resourcepolicy.eperson_id resourcepolicy_eperson_id_fkey R
subscription.eperson_id subscription_eperson_id_fkey R
tasklistitem.eperson_id tasklistitem_eperson_id_fkey R
versionitem.eperson_id versionitem_eperson_id_fkey R
workflowitem.owner workflowitem_owner_fkey R
dspaceobject.uuid eperson_uuid_fkey R

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_idx Performance Asc netid
eperson_uuid_key Must be unique Asc uuid

Relationships

Close relationships within degrees of separation