Back to Table list

Table users

Columns

  id
      serial



  created_at
      timestamp



  css_id
      varchar



  efolder_documents_fetched_at
      timestamp



  email
      varchar



  full_name
      varchar



  last_login_at
      timestamp



  roles
      _varchar



  selected_regional_office
      varchar



  station_id
      varchar



  status
      varchar



  status_updated_at
      timestamp



  updated_at
      timestamp



Associations

has dependent

  advance_on_docket_motions
  1:n
 on 
advance_on_docket_motions.user_id=users.id

  annotations
  1:n
 on 
annotations.user_id=users.id

  appeal_states
  1:n
 on 
appeal_states.updated_by_id=users.id

  appeal_states
  1:n
 on 
appeal_states.created_by_id=users.id

  appeal_views
  1:n
 on 
appeal_views.user_id=users.id

  appellant_substitutions
  1:n
 on 
appellant_substitutions.created_by_id=users.id

  attorney_case_reviews
  1:n
 on 
attorney_case_reviews.reviewing_judge_id=users.id

  attorney_case_reviews
  1:n
 on 
attorney_case_reviews.attorney_id=users.id

  cavc_dashboard_dispositions
  1:n
 on 
cavc_dashboard_dispositions.created_by_id=users.id

  cavc_dashboard_dispositions
  1:n
 on 
cavc_dashboard_dispositions.updated_by_id=users.id

  cavc_dashboard_issues
  1:n
 on 
cavc_dashboard_issues.created_by_id=users.id

  cavc_dashboard_issues
  1:n
 on 
cavc_dashboard_issues.updated_by_id=users.id

  cavc_dashboards
  1:n
 on 
cavc_dashboards.created_by_id=users.id

  cavc_dashboards
  1:n
 on 
cavc_dashboards.updated_by_id=users.id

  cavc_dispositions_to_reasons
  1:n
 on 
cavc_dispositions_to_reasons.created_by_id=users.id

  cavc_dispositions_to_reasons
  1:n
 on 
cavc_dispositions_to_reasons.updated_by_id=users.id

  cavc_reasons_to_bases
  1:n
 on 
cavc_reasons_to_bases.created_by_id=users.id

  cavc_reasons_to_bases
  1:n
 on 
cavc_reasons_to_bases.updated_by_id=users.id

  cavc_remands
  1:n
 on 
cavc_remands.updated_by_id=users.id

  cavc_remands
  1:n
 on 
cavc_remands.created_by_id=users.id

  cavc_remands_appellant_substitutions
  1:n
 on 
cavc_remands_appellant_substitutions.created_by_id=users.id

  cavc_remands_appellant_substitutions
  1:n
 on 
cavc_remands_appellant_substitutions.updated_by_id=users.id

  certifications
  1:n
 on 
certifications.user_id=users.id

  claims_folder_searches
  1:n
 on 
claims_folder_searches.user_id=users.id

  conference_links
  1:n
 on 
conference_links.created_by_id=users.id

  conference_links
  1:n
 on 
conference_links.updated_by_id=users.id

  dispatch_tasks
  1:n
 on 
dispatch_tasks.user_id=users.id

  distributions
  1:n
 on 
distributions.judge_id=users.id

  document_views
  1:n
 on 
document_views.user_id=users.id

  end_product_establishments
  1:n
 on 
end_product_establishments.user_id=users.id

  end_product_updates
  1:n
 on 
end_product_updates.user_id=users.id

  hearing_days
  1:n
 on 
hearing_days.updated_by_id=users.id

  hearing_days
  1:n
 on 
hearing_days.judge_id=users.id

  hearing_days
  1:n
 on 
hearing_days.created_by_id=users.id

  hearing_views
  1:n
 on 
hearing_views.user_id=users.id

  hearings
  1:n
 on 
hearings.judge_id=users.id

  hearings
  1:n
 on 
hearings.created_by_id=users.id

  hearings
  1:n
 on 
hearings.updated_by_id=users.id

  intakes
  1:n
 on 
intakes.user_id=users.id

  job_notes
  1:n
 on 
job_notes.user_id=users.id

  judge_case_reviews
  1:n
 on 
judge_case_reviews.judge_id=users.id

  judge_case_reviews
  1:n
 on 
judge_case_reviews.attorney_id=users.id

  legacy_hearings
  1:n
 on 
legacy_hearings.updated_by_id=users.id

  legacy_hearings
  1:n
 on 
legacy_hearings.user_id=users.id

  legacy_hearings
  1:n
 on 
legacy_hearings.created_by_id=users.id

  membership_requests
  1:n
 on 
membership_requests.requestor_id=users.id

  membership_requests
  1:n
 on 
membership_requests.decider_id=users.id

  messages
  1:n
 on 
messages.user_id=users.id

  metrics
  1:n
 on 
metrics.user_id=users.id

  nod_date_updates
  1:n
 on 
nod_date_updates.user_id=users.id

  organizations_users
  1:n
 on 
organizations_users.user_id=users.id

  ramp_election_rollbacks
  1:n
 on 
ramp_election_rollbacks.user_id=users.id

  request_issues_updates
  1:n
 on 
request_issues_updates.user_id=users.id

  schedule_periods
  1:n
 on 
schedule_periods.user_id=users.id

  sent_hearing_email_events
  1:n
 on 
sent_hearing_email_events.sent_by_id=users.id

  split_correlation_tables
  1:n
 on 
split_correlation_tables.updated_by_id=users.id

  split_correlation_tables
  1:n
 on 
split_correlation_tables.created_by_id=users.id

  system_admin_events
  1:n
 on 
system_admin_events.user_id=users.id

  tasks
  1:n
 on 
tasks.assigned_by_id=users.id

  tasks
  1:n
 on 
tasks.cancelled_by_id=users.id

  unrecognized_appellants
  1:n
 on 
unrecognized_appellants.created_by_id=users.id

  user_quotas
  1:n
 on 
user_quotas.user_id=users.id

  vbms_communication_packages
  1:n
 on 
vbms_communication_packages.created_by_id=users.id

  vbms_communication_packages
  1:n
 on 
vbms_communication_packages.updated_by_id=users.id

  vbms_distribution_destinations
  1:n
 on 
vbms_distribution_destinations.updated_by_id=users.id

  vbms_distribution_destinations
  1:n
 on 
vbms_distribution_destinations.created_by_id=users.id

  vbms_distributions
  1:n
 on 
vbms_distributions.updated_by_id=users.id

  vbms_distributions
  1:n
 on 
vbms_distributions.created_by_id=users.id

  virtual_hearings
  1:n
 on 
virtual_hearings.created_by_id=users.id

  virtual_hearings
  1:n
 on 
virtual_hearings.updated_by_id=users.id

 
is associated with


  tasks
  n:1
 on 
tasks.assigned_to_id=users.id AND tasks.assigned_to_type='User'

Closure

  distance 0

 
users

  distance 1

 
advance_on_docket_motions, annotations, appeal_states, appeal_views, appellant_substitutions, attorney_case_reviews, cavc_dashboard_dispositions, cavc_dashboard_issues, cavc_dashboards, cavc_dispositions_to_reasons, cavc_reasons_to_bases, cavc_remands, cavc_remands_appellant_substitutions, certifications, claims_folder_searches, conference_links, dispatch_tasks, distributions, document_views, end_product_establishments, end_product_updates, hearing_days, hearing_views, hearings, intakes, job_notes, judge_case_reviews, legacy_hearings, membership_requests, messages, metrics, nod_date_updates, organizations_users, ramp_election_rollbacks, request_issues_updates, schedule_periods, sent_hearing_email_events, split_correlation_tables, system_admin_events, tasks, unrecognized_appellants, user_quotas, vbms_communication_packages, vbms_distribution_destinations, vbms_distributions, virtual_hearings

  distance 2

 
allocations, appeals, board_grant_effectuations, cavc_decision_reasons, cavc_selection_bases, certification_cancellations, claim_establishments, claimants, decision_documents, distributed_cases, docket_switches, end_product_code_updates, hearing_appeal_stream_snapshots, hearing_email_recipients, hearing_issue_notes, hearing_locations, hearing_task_associations, higher_level_reviews, legacy_appeals, non_availabilities, organizations, people, post_decision_motions, priority_end_product_sync_queue, ramp_elections, ramp_refilings, request_issues, sent_hearing_admin_email_events, supplemental_claims, task_timers, team_quotas, transcriptions, unrecognized_party_details, vbms_uploaded_documents, veterans, virtual_hearing_establishments

  distance 3

 
appeal_series, available_hearing_locations, batch_processes, caseflow_stuck_records, decision_issues, ihp_drafts, legacy_issue_optins, legacy_issues, ramp_closed_appeals, ramp_issues, record_synced_by_jobs, request_decision_issues, special_issue_lists, vso_configs, work_modes, worksheet_issues

  distance 4

 
remand_reasons