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_idR
authenticateduserlookup.authenticateduser_id fk_authenticateduserlookup_authenticateduser_idR
confirmemaildata.authenticateduser_id fk_confirmemaildata_authenticateduser_idR
datasetlock.user_id fk_datasetlock_user_idR
datasetversionuser.authenticateduser_id fk_datasetversionuser_authenticateduser_idR
dvobject.creator_id fk_dvobject_creator_idR
dvobject.releaseuser_id fk_dvobject_releaseuser_idR
explicitgroup_authenticateduser.containedauthenticatedusers_id explicitgroup_authenticateduser_containedauthenticatedusers_idR
fileaccessrequests.authenticated_user_id fk_fileaccessrequests_authenticated_user_idR
guestbookresponse.authenticateduser_id fk_guestbookresponse_authenticateduser_idR
oauth2tokendata.user_id fk_oauth2tokendata_user_idR
savedsearch.creator_id fk_savedsearch_creator_idR
userbannermessage.user_id fk_userbannermessage_user_idR
usernotification.requestor_id fk_usernotification_requestor_idR
usernotification.user_id fk_usernotification_user_idR
workflowcomment.authenticateduser_id fk_workflowcomment_authenticateduser_idR
affiliation varchar 255 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

Relationships