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
activities.created_by activities_created_by_fkey R
activities.modified_by activities_modified_by_fkey R
activities.verified_by activities_verified_by_fkey R
application_histories.modified_by application_histories_modified_by_fkey R
applications.created_by applications_created_by_fkey R
applications.modified_by applications_modified_by_fkey R
cohorts.created_by cohorts_created_by_fkey R
cohorts.modified_by cohorts_modified_by_fkey R
default_voters.user_id default_voters_user_id_fkey C
deliverables.created_by deliverables_created_by_fkey R
deliverables.modified_by deliverables_modified_by_fkey R
events.created_by events_created_by_fkey R
events.modified_by events_modified_by_fkey R
modules.created_by modules_created_by_fkey R
modules.modified_by modules_modified_by_fkey R
participant_project_species.created_by participant_project_species_created_by_fkey R
participant_project_species.modified_by participant_project_species_modified_by_fkey R
participants.created_by participants_created_by_fkey R
participants.modified_by participants_modified_by_fkey R
project_overall_scores.created_by project_overall_scores_created_by_fkey R
project_overall_scores.modified_by project_overall_scores_modified_by_fkey R
project_scores.created_by project_scores_created_by_fkey R
project_scores.modified_by project_scores_modified_by_fkey R
project_votes.created_by project_votes_created_by_fkey R
project_votes.modified_by project_votes_modified_by_fkey R
project_votes.user_id project_votes_user_id_fkey C
report_project_metrics.modified_by report_project_metrics_modified_by_fkey R
report_standard_metrics.modified_by report_standard_metrics_modified_by_fkey R
report_system_metrics.modified_by report_system_metrics_modified_by_fkey R
reports.created_by reports_created_by_fkey R
reports.modified_by reports_modified_by_fkey R
reports.submitted_by reports_submitted_by_fkey R
submission_documents.created_by submission_documents_created_by_fkey R
submissions.created_by submissions_created_by_fkey R
submissions.modified_by submissions_modified_by_fkey R
user_internal_interests.created_by user_internal_interests_created_by_fkey R
user_internal_interests.user_id user_internal_interests_user_id_fkey R
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_fkey C
variable_values.created_by variable_values_created_by_fkey
variable_workflow_history.created_by variable_workflow_history_created_by_fkey R
funding_entities.created_by funding_entities_created_by_fkey R
funding_entities.modified_by funding_entities_modified_by_fkey R
funding_entity_users.user_id funding_entity_users_user_id_fkey C
published_activities.published_by published_activities_published_by_fkey R
published_project_details.published_by published_project_details_published_by_fkey R
published_reports.published_by published_reports_published_by_fkey R
batch_details_history.created_by batch_details_history_created_by_fkey R
batch_photos.created_by batch_photos_created_by_fkey R
batch_photos.deleted_by batch_photos_deleted_by_fkey R
batch_quantity_history.created_by batch_quantity_history_created_by_fkey R
batches.created_by batches_created_by_fkey R
batches.modified_by batches_modified_by_fkey R
withdrawals.created_by withdrawals_created_by_fkey R
withdrawals.modified_by withdrawals_modified_by_fkey R
automations.created_by automations_created_by_fkey R
automations.modified_by automations_modified_by_fkey R
chat_memory_conversations.created_by chat_memory_conversations_created_by_fkey R
device_managers.user_id device_managers_user_id_fkey R
devices.created_by devices_created_by_fkey R
devices.modified_by devices_modified_by_fkey R
event_log.created_by event_log_created_by_fkey R
facilities.created_by facilities_created_by_fkey R
facilities.modified_by facilities_modified_by_fkey R
file_access_tokens.created_by file_access_tokens_created_by_fkey R
files.created_by photos_user_id_fkey R
files.modified_by photos_modified_by_fkey R
internal_tags.created_by internal_tags_created_by_fkey R
internal_tags.modified_by internal_tags_modified_by_fkey R
notifications.user_id notifications_user_id_fkey R
organization_internal_tags.created_by organization_internal_tags_created_by_fkey R
organization_users.created_by organization_users_created_by_fkey R
organization_users.modified_by organization_users_modified_by_fkey R
organization_users.user_id organization_users_user_id_fkey R
organizations.created_by organizations_created_by_fkey R
organizations.modified_by organizations_modified_by_fkey R
project_internal_users.created_by project_internal_users_created_by_fkey R
project_internal_users.modified_by project_internal_users_modified_by_fkey R
project_internal_users.user_id project_internal_users_user_id_fkey R
projects.created_by projects_created_by_fkey
projects.modified_by projects_modified_by_fkey
seed_fund_reports.locked_by reports_locked_by_fkey R
seed_fund_reports.modified_by reports_modified_by_fkey R
seed_fund_reports.submitted_by reports_submitted_by_fkey R
species.created_by species_created_by_fkey R
species.deleted_by species_deleted_by_fkey R
species.modified_by species_modified_by_fkey R
sub_locations.created_by storage_locations_created_by_fkey R
sub_locations.modified_by storage_locations_modified_by_fkey R
timeseries.created_by timeseries_created_by_fkey R
timeseries.modified_by timeseries_modified_by_fkey R
uploads.created_by uploads_created_by_fkey R
user_disclaimers.user_id user_disclaimers_user_id_fkey C
user_global_roles.user_id user_global_roles_user_id_fkey C
user_preferences.user_id user_preferences_user_id_fkey R
accession_quantity_history.created_by accession_quantity_history_created_by_fkey R
accession_state_history.updated_by accession_state_history_updated_by_fkey R
accessions.created_by accessions_created_by_fkey R
accessions.modified_by accessions_modified_by_fkey R
withdrawals.created_by withdrawals_created_by_fkey R
withdrawals.withdrawn_by withdrawals_withdrawn_by_fkey R
deliveries.created_by deliveries_created_by_fkey R
deliveries.modified_by deliveries_modified_by_fkey R
deliveries.reassigned_by deliveries_reassigned_by_fkey R
draft_planting_sites.created_by draft_planting_sites_created_by_fkey R
draft_planting_sites.modified_by draft_planting_sites_modified_by_fkey R
monitoring_plot_histories.created_by monitoring_plot_histories_created_by_fkey R
monitoring_plots.created_by monitoring_plots_created_by_fkey R
monitoring_plots.modified_by monitoring_plots_modified_by_fkey R
observation_plots.claimed_by observation_plots_claimed_by_fkey R
observation_plots.completed_by observation_plots_completed_by_fkey R
observation_plots.created_by observation_plots_created_by_fkey R
observation_plots.modified_by observation_plots_modified_by_fkey R
planting_site_histories.created_by planting_site_histories_created_by_fkey R
planting_sites.created_by planting_sites_created_by_fkey R
planting_sites.modified_by planting_sites_modified_by_fkey R
planting_subzones.created_by plots_created_by_fkey R
planting_subzones.modified_by plots_modified_by_fkey R
planting_zone_t0_temp_densities.created_by planting_zone_t0_temp_densities_created_by_fkey R
planting_zone_t0_temp_densities.modified_by planting_zone_t0_temp_densities_modified_by_fkey R
planting_zones.boundary_modified_by planting_zones_boundary_modified_by_fkey R
planting_zones.created_by planting_zones_created_by_fkey R
planting_zones.modified_by planting_zones_modified_by_fkey R
plantings.created_by plantings_created_by_fkey R
plot_t0_densities.created_by plot_t0_densities_created_by_fkey R
plot_t0_densities.modified_by plot_t0_densities_modified_by_fkey R
plot_t0_observations.created_by plot_t0_observations_created_by_fkey R
plot_t0_observations.modified_by plot_t0_observations_modified_by_fkey R
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_fkey R
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_fkey N
locale text 2147483647 √ null
country_code text 2147483647 √ null
countries.code users_country_code_fkey R
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_auth_id_check (auth_id !~ similar_to_escape(' *'::text))
users_first_name_check (first_name !~ similar_to_escape(' *'::text))
users_last_name_check (last_name !~ similar_to_escape(' *'::text))

Relationships

Close relationships within degrees of separation