moped_users

4 rows


Description

Standardized list of city of Austin employees

Columns

Column Type Size Nulls Auto Default Children Parents Comments
first_name text 2147483647 null
last_name text 2147483647 null
title text 2147483647 null
user_id serial 10 √ nextval('moped_users_user_id_seq'::regclass)
feature_drawn_lines.created_by_user_id fk_feature_drawn_lines_created_byR
feature_drawn_lines.updated_by_user_id fk_feature_drawn_lines_updated_byR
feature_drawn_points.created_by_user_id fk_feature_drawn_points_created_byR
feature_drawn_points.updated_by_user_id fk_feature_drawn_points_updated_byR
feature_intersections.created_by_user_id fk_feature_intersections_created_byR
feature_intersections.updated_by_user_id fk_feature_intersections_updated_byR
feature_school_beacons.created_by_user_id fk_feature_school_beacons_created_byR
feature_school_beacons.updated_by_user_id fk_feature_school_beacons_updated_byR
feature_signals.created_by_user_id fk_feature_signals_created_byR
feature_signals.updated_by_user_id fk_feature_signals_updated_byR
feature_street_segments.created_by_user_id fk_feature_street_segments_created_byR
feature_street_segments.updated_by_user_id fk_feature_street_segments_updated_byR
moped_activity_log.updated_by_user_id moped_activity_log_updated_by_user_id_fkeyN
moped_proj_component_tags.created_by_user_id project_component_tags_created_by_fkeyR
moped_proj_component_tags.updated_by_user_id project_component_tags_updated_by_fkeyR
moped_proj_component_work_types.created_by_user_id project_component_work_types_created_by_fkeyR
moped_proj_component_work_types.updated_by_user_id project_component_work_types_updated_by_fkeyR
moped_proj_components_subcomponents.created_by_user_id project_component_subcomponent_created_by_fkeyR
moped_proj_components_subcomponents.updated_by_user_id project_component_subcomponent_updated_by_fkeyR
moped_proj_funding.created_by_user_id created_by_user_fkeyR
moped_proj_funding.updated_by_user_id updated_by_user_fkeyR
moped_proj_notes.created_by_user_id moped_proj_notes_added_by_user_id_fkeyN
moped_proj_partners.created_by_user_id moped_proj_partners_created_by_fkeyR
moped_proj_partners.updated_by_user_id moped_proj_partners_updated_by_fkeyR
moped_proj_personnel.created_by_user_id project_personnel_created_by_fkeyR
moped_proj_personnel.updated_by_user_id project_personnel_updated_by_fkeyR
moped_proj_personnel.user_id moped_proj_personnel_user_id_fkeyR
moped_proj_personnel_roles.created_by_user_id project_personnel_roles_created_by_fkeyR
moped_proj_personnel_roles.updated_by_user_id project_personnel_roles_updated_by_fkeyR
moped_proj_phases.created_by_user_id created_by_user_fkeyR
moped_proj_phases.updated_by_user_id updated_by_user_fkeyR
moped_proj_tags.created_by_user_id project_tags_created_by_fkeyR
moped_proj_tags.updated_by_user_id project_tags_updated_by_fkeyR
moped_proj_work_activity.created_by_user_id created_by_user_fkeyN
moped_proj_work_activity.updated_by_user_id updated_by_user_fkeyN
moped_project.added_by moped_project_added_by_fkeyN
moped_project.updated_by_user_id updated_by_user_fkeyR
moped_project_files.created_by_user_id moped_project_files_created_by_fkeyR
moped_project_files.updated_by_user_id updated_by_user_fkeyR
moped_project_types.created_by_user_id project_types_created_by_fkeyR
moped_project_types.updated_by_user_id project_types_updated_by_fkeyR
moped_user_events.user_id moped_user_events_user_id_fkeyC
workgroup_id int4 10 √ null
moped_workgroup.workgroup_id moped_users_workgroup_id_fkeyR
cognito_user_id uuid 2147483647 √ null
date_added timestamptz 35,6 √ clock_timestamp()
is_coa_staff bool 1 false
email citext 2147483647 null
roles jsonb 2147483647 √ null
picture text 2147483647 √ null
is_deleted bool 1 false

Indicates soft deletion
is_user_group_member bool 1 false

Tracks if the user is a member of the Moped User Group, aka the MUG.
note text 2147483647 √ null

A place to add any notes about this user, e.g. why they were deactivated.
last_seen_date timestamptz 35,6 √ null

Tracks the last time a user loaded the Moped app in their browser. This value is set by the set_last_seen_date function. This value is not 100% reliable because it is updated by an API call that can be blocked by the client.

Indexes

Constraint Name Type Sort Column(s)
moped_users_pkey Primary key Asc user_id
moped_users_cognito_user_id_key Must be unique Asc cognito_user_id
moped_users_email_key Must be unique Asc email
moped_users_unique_email_idx Must be unique Asc email
moped_users_user_id_key Must be unique Asc user_id

Relationships

Close relationships within degrees of separation