Back to Table list

Table virtual_hearings

Columns

  id
      bigserial



  "alias"
      varchar



  alias_with_host
      varchar



  appellant_email
      varchar



  appellant_email_sent
      bool



  appellant_reminder_sent_at
      timestamp



  appellant_tz
      varchar(50)



  conference_deleted
      bool



  conference_id
      int4



  created_at
      timestamp



  created_by_id
      int8



  guest_hearing_link
      varchar



  guest_pin
      int4



  guest_pin_long
      varchar(11)



  hearing_id
      int8



  hearing_type
      varchar



  host_hearing_link
      varchar



  host_pin
      int4



  host_pin_long
      varchar(8)



  judge_email
      varchar



  judge_email_sent
      bool



  representative_email
      varchar



  representative_email_sent
      bool



  representative_reminder_sent_at
      timestamp



  representative_tz
      varchar(50)



  request_cancelled
      bool



  updated_at
      timestamp



  updated_by_id
      int8



Associations

depends on

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

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

 
has dependent


  virtual_hearing_establishments
  1:n
 on 
virtual_hearing_establishments.virtual_hearing_id=virtual_hearings.id

 
is associated with


  hearings
  1:1
 on 
virtual_hearings.hearing_id=hearings.id AND virtual_hearings.hearing_type='Hearing'

  legacy_hearings
  1:1
 on 
virtual_hearings.hearing_id=legacy_hearings.id AND virtual_hearings.hearing_type='LegacyHearing'

Closure

  distance 0

 
virtual_hearings

  distance 1

 
hearings, legacy_hearings, users, virtual_hearing_establishments

  distance 2

 
advance_on_docket_motions, annotations, appeal_states, appeal_views, appeals, 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_appeal_stream_snapshots, hearing_days, hearing_email_recipients, hearing_issue_notes, hearing_locations, hearing_task_associations, hearing_views, intakes, job_notes, judge_case_reviews, legacy_appeals, 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, transcriptions, unrecognized_appellants, user_quotas, vbms_communication_packages, vbms_distribution_destinations, vbms_distributions

  distance 3

 
allocations, appeal_series, available_hearing_locations, board_grant_effectuations, cavc_decision_reasons, cavc_selection_bases, certification_cancellations, claim_establishments, claimants, decision_documents, decision_issues, distributed_cases, docket_switches, end_product_code_updates, higher_level_reviews, ihp_drafts, non_availabilities, organizations, people, post_decision_motions, priority_end_product_sync_queue, ramp_elections, ramp_issues, ramp_refilings, record_synced_by_jobs, request_issues, sent_hearing_admin_email_events, special_issue_lists, supplemental_claims, task_timers, team_quotas, unrecognized_party_details, vbms_uploaded_documents, veterans, work_modes, worksheet_issues

  distance 4

 
batch_processes, caseflow_stuck_records, legacy_issue_optins, legacy_issues, ramp_closed_appeals, remand_reasons, request_decision_issues, vso_configs