user

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id text 2147483647 null
api_token.user_id api_token_user_id_fkeyR
dashboard.user_id dashboard_user_id_fkeyC
dcpr_error_report.csi_reviewer dcpr_error_report_csi_reviewer_fkeyR
dcpr_error_report.owner_user dcpr_error_report_owner_user_fkeyR
dcpr_error_report_notification.user_id dcpr_error_report_notification_user_id_fkeyR
dcpr_geospatial_request.csi_reviewer dcpr_geospatial_request_csi_reviewer_fkeyR
dcpr_geospatial_request.nsif_reviewer dcpr_geospatial_request_nsif_reviewer_fkeyR
dcpr_geospatial_request.owner_user dcpr_geospatial_request_owner_user_fkeyR
dcpr_geospatial_request_notification.user_id dcpr_geospatial_request_notification_user_id_fkeyR
dcpr_request.csi_moderator dcpr_request_csi_moderator_fkeyR
dcpr_request.nsif_reviewer dcpr_request_nsif_reviewer_fkeyR
dcpr_request.owner_user dcpr_request_owner_user_fkeyR
dcpr_request_notification.user_id dcpr_request_notification_user_id_fkeyR
error_report.nsif_reviewer error_report_nsif_reviewer_fkeyR
error_report.owner_user error_report_owner_user_fkeyR
error_report_notification.user_id error_report_notification_user_id_fkeyR
package_member.user_id package_member_user_id_fkeyR
rating.user_id rating_user_id_fkeyR
reporting_tool.owner_user reporting_tool_owner_user_fkeyR
saved_searches.owner_user saved_searches_owner_user_fkeyR
user_extra_fields.user_id user_extra_fields_user_id_fkeyR
user_following_dataset.follower_id user_following_dataset_follower_id_fkeyC
user_following_group.follower_id user_following_group_user_id_fkeyC
user_following_user.follower_id user_following_user_follower_id_fkeyC
user_following_user.object_id user_following_user_object_id_fkeyC
name text 2147483647 null
apikey text 2147483647 √ null
created timestamp 29,6 √ null
about text 2147483647 √ null
password text 2147483647 √ null
fullname text 2147483647 √ null
email text 2147483647 √ null
reset_key text 2147483647 √ null
sysadmin bool 1 √ false
activity_streams_email_notifications bool 1 √ false
state text 2147483647 'active'::text
plugin_extras jsonb 2147483647 √ null
image_url text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
user_pkey Primary key Asc id
idx_user_id Performance Asc id
idx_user_name Performance Asc name
idx_user_name_index Performance
user_name_key Must be unique Asc name

Relationships

Close relationships within degrees of separation