users

1 rows


Description

User identities. A user can be associated with organizations via organization_users.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
application_histories.modified_by application_histories_modified_by_fkeyR
applications.created_by applications_created_by_fkeyR
applications.modified_by applications_modified_by_fkeyR
cohorts.created_by cohorts_created_by_fkeyR
cohorts.modified_by cohorts_modified_by_fkeyR
default_voters.user_id default_voters_user_id_fkeyC
deliverables.created_by deliverables_created_by_fkeyR
deliverables.modified_by deliverables_modified_by_fkeyR
events.created_by events_created_by_fkeyR
events.modified_by events_modified_by_fkeyR
modules.created_by modules_created_by_fkeyR
modules.modified_by modules_modified_by_fkeyR
participant_project_species.created_by participant_project_species_created_by_fkeyR
participant_project_species.modified_by participant_project_species_modified_by_fkeyR
participants.created_by participants_created_by_fkeyR
participants.modified_by participants_modified_by_fkeyR
project_scores.created_by project_scores_created_by_fkeyR
project_scores.modified_by project_scores_modified_by_fkeyR
project_votes.created_by project_votes_created_by_fkeyR
project_votes.modified_by project_votes_modified_by_fkeyR
project_votes.user_id project_votes_user_id_fkeyC
submission_documents.created_by submission_documents_created_by_fkeyR
submissions.created_by submissions_created_by_fkeyR
submissions.modified_by submissions_modified_by_fkeyR
user_internal_interests.created_by user_internal_interests_created_by_fkeyR
user_internal_interests.user_id user_internal_interests_user_id_fkeyR
document_saved_versions.created_by document_saved_versions_created_by_fkey
documents.created_by documents_created_by_fkey
documents.modified_by documents_modified_by_fkey
documents.owned_by documents_owned_by_fkey
variable_manifests.created_by variable_manifests_created_by_fkey
variable_owners.owned_by variable_owners_owned_by_fkeyC
variable_values.created_by variable_values_created_by_fkey
variable_workflow_history.created_by variable_workflow_history_created_by_fkeyR
batch_details_history.created_by batch_details_history_created_by_fkeyR
batch_photos.created_by batch_photos_created_by_fkeyR
batch_photos.deleted_by batch_photos_deleted_by_fkeyR
batch_quantity_history.created_by batch_quantity_history_created_by_fkeyR
batches.created_by batches_created_by_fkeyR
batches.modified_by batches_modified_by_fkeyR
withdrawals.created_by withdrawals_created_by_fkeyR
withdrawals.modified_by withdrawals_modified_by_fkeyR
automations.created_by automations_created_by_fkeyR
automations.modified_by automations_modified_by_fkeyR
device_managers.user_id device_managers_user_id_fkeyR
devices.created_by devices_created_by_fkeyR
devices.modified_by devices_modified_by_fkeyR
facilities.created_by facilities_created_by_fkeyR
facilities.modified_by facilities_modified_by_fkeyR
files.created_by photos_user_id_fkeyR
files.modified_by photos_modified_by_fkeyR
internal_tags.created_by internal_tags_created_by_fkeyR
internal_tags.modified_by internal_tags_modified_by_fkeyR
notifications.user_id notifications_user_id_fkeyR
organization_internal_tags.created_by organization_internal_tags_created_by_fkeyR
organization_users.created_by organization_users_created_by_fkeyR
organization_users.modified_by organization_users_modified_by_fkeyR
organization_users.user_id organization_users_user_id_fkeyR
organizations.created_by organizations_created_by_fkeyR
organizations.modified_by organizations_modified_by_fkeyR
projects.created_by projects_created_by_fkey
projects.modified_by projects_modified_by_fkey
reports.locked_by reports_locked_by_fkeyR
reports.modified_by reports_modified_by_fkeyR
reports.submitted_by reports_submitted_by_fkeyR
species.created_by species_created_by_fkeyR
species.deleted_by species_deleted_by_fkeyR
species.modified_by species_modified_by_fkeyR
sub_locations.created_by storage_locations_created_by_fkeyR
sub_locations.modified_by storage_locations_modified_by_fkeyR
timeseries.created_by timeseries_created_by_fkeyR
timeseries.modified_by timeseries_modified_by_fkeyR
uploads.created_by uploads_created_by_fkeyR
user_global_roles.user_id user_global_roles_user_id_fkeyC
user_preferences.user_id user_preferences_user_id_fkeyR
accession_quantity_history.created_by accession_quantity_history_created_by_fkeyR
accession_state_history.updated_by accession_state_history_updated_by_fkeyR
accessions.created_by accessions_created_by_fkeyR
accessions.modified_by accessions_modified_by_fkeyR
withdrawals.created_by withdrawals_created_by_fkeyR
withdrawals.withdrawn_by withdrawals_withdrawn_by_fkeyR
deliveries.created_by deliveries_created_by_fkeyR
deliveries.modified_by deliveries_modified_by_fkeyR
deliveries.reassigned_by deliveries_reassigned_by_fkeyR
draft_planting_sites.created_by draft_planting_sites_created_by_fkeyR
draft_planting_sites.modified_by draft_planting_sites_modified_by_fkeyR
monitoring_plot_histories.created_by monitoring_plot_histories_created_by_fkeyR
monitoring_plots.created_by monitoring_plots_created_by_fkeyR
monitoring_plots.modified_by monitoring_plots_modified_by_fkeyR
observation_plots.claimed_by observation_plots_claimed_by_fkeyR
observation_plots.completed_by observation_plots_completed_by_fkeyR
observation_plots.created_by observation_plots_created_by_fkeyR
observation_plots.modified_by observation_plots_modified_by_fkeyR
planting_site_histories.created_by planting_site_histories_created_by_fkeyR
planting_sites.created_by planting_sites_created_by_fkeyR
planting_sites.modified_by planting_sites_modified_by_fkeyR
planting_subzones.created_by plots_created_by_fkeyR
planting_subzones.modified_by plots_modified_by_fkeyR
planting_zones.created_by planting_zones_created_by_fkeyR
planting_zones.modified_by planting_zones_modified_by_fkeyR
plantings.created_by plantings_created_by_fkeyR
auth_id text 2147483647 √ null

Unique identifier of the user in the authentication system. Currently, this is a Keycloak user ID.
email text 2147483647 null
first_name text 2147483647 √ null
last_name text 2147483647 √ null
created_time timestamptz 35,6 null
modified_time timestamptz 35,6 null
user_type_id int4 10 null
user_types.id users_user_type_id_fkeyR
last_activity_time timestamptz 35,6 √ null

When the user most recently interacted with the system.
email_notifications_enabled bool 1 false

If true, the user wants to receive notifications via email.
deleted_time timestamptz 35,6 √ null
time_zone text 2147483647 √ null
time_zones.time_zone users_time_zone_fkeyN
locale text 2147483647 √ null
country_code text 2147483647 √ null
countries.code users_country_code_fkeyR
cookies_consented bool 1 √ null
cookies_consented_time timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
users_pkey Primary key Asc id
users_auth_id_key Must be unique Asc auth_id
users_email_key Must be unique Asc email

Check Constraints

Constraint Name Constraint
users_first_name_check ((first_name !~ similar_to_escape(' *'::text)))
users_auth_id_check ((auth_id !~ similar_to_escape(' *'::text)))
users_last_name_check ((last_name !~ similar_to_escape(' *'::text)))

Relationships

Close relationships within degrees of separation