authenticateduser

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('authenticateduser_id_seq'::regclass)
apitoken.authenticateduser_id fk_apitoken_authenticateduser_id R
authenticateduserlookup.authenticateduser_id fk_authenticateduserlookup_authenticateduser_id R
confirmemaildata.authenticateduser_id fk_confirmemaildata_authenticateduser_id R
datasetlock.user_id fk_datasetlock_user_id R
datasetversionuser.authenticateduser_id fk_datasetversionuser_authenticateduser_id R
dvobject.creator_id fk_dvobject_creator_id R
dvobject.releaseuser_id fk_dvobject_releaseuser_id R
explicitgroup_authenticateduser.containedauthenticatedusers_id explicitgroup_authenticateduser_containedauthenticatedusers_id R
fileaccessrequests.authenticated_user_id fk_fileaccessrequests_authenticated_user_id R
globustaskinprogress.user_id fk_globustaskinprogress_user_id R
guestbookresponse.authenticateduser_id fk_guestbookresponse_authenticateduser_id R
oauth2tokendata.user_id fk_oauth2tokendata_user_id R
savedsearch.creator_id fk_savedsearch_creator_id R
userbannermessage.user_id fk_userbannermessage_user_id R
usernotification.requestor_id fk_usernotification_requestor_id R
usernotification.user_id fk_usernotification_user_id R
workflowcomment.authenticateduser_id fk_workflowcomment_authenticateduser_id R
affiliation varchar 255 √ null
authenticatedorcid varchar 45 √ null
createdtime timestamp 29,6 null
deactivated bool 1 null
deactivatedtime timestamp 29,6 √ null
email varchar 255 null
emailconfirmed timestamp 29,6 √ null
firstname varchar 255 √ null
lastapiusetime timestamp 29,6 √ null
lastlogintime timestamp 29,6 √ null
lastname varchar 255 √ null
mutedemails text 2147483647 √ null
mutednotifications text 2147483647 √ null
position varchar 255 √ null
ratelimittier int4 10 null
superuser bool 1 √ null
useridentifier varchar 255 null

Indexes

Constraint Name Type Sort Column(s)
authenticateduser_pkey Primary key Asc id
authenticateduser_email_key Must be unique Asc email
authenticateduser_useridentifier_key Must be unique Asc useridentifier
index_authenticateduser_lower_email Must be unique
index_authenticateduser_lower_useridentifier Must be unique
orcid_unique Must be unique Asc authenticatedorcid

Relationships

Close relationships within degrees of separation