authenticateduser

150 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
position varchar 255 √ 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

Close relationships within degrees of separation