Back to Table list

Table hearing_email_recipients

Columns

  id
      bigserial


  appeal_id
      int8


  appeal_type
      varchar


  created_at
      timestamp


  email_address
      varchar


  email_sent
      bool


  hearing_id
      int8


  hearing_type
      varchar


  timezone
      varchar(50)


  type
      varchar


  updated_at
      timestamp


Associations

has dependent

  sent_hearing_email_events
  1:n
  on 
 sent_hearing_email_events.email_recipient_id=hearing_email_recipients.id

 
is associated with

  appeals
  n:m
  on 
 hearing_email_recipients.appeal_id=appeals.id AND hearing_email_recipients.appeal_type='Appeal'

  hearings
  n:m
  on 
 hearing_email_recipients.hearing_id=hearings.id AND hearing_email_recipients.hearing_type='Hearing'

  legacy_appeals
  n:m
  on 
 hearing_email_recipients.appeal_id=legacy_appeals.id AND hearing_email_recipients.appeal_type='LegacyAppeal'

  legacy_hearings
  n:m
  on 
 hearing_email_recipients.hearing_id=legacy_hearings.id AND hearing_email_recipients.hearing_type='LegacyHearing'

Closure

  distance 0

 
 hearing_email_recipients

  distance 1

 
 appeals, hearings, legacy_appeals, legacy_hearings, sent_hearing_email_events

  distance 2

 
 advance_on_docket_motions, appeal_series, appeal_states, appeal_views, appellant_substitutions, attorney_case_reviews, available_hearing_locations, board_grant_effectuations, cavc_remands, claimants, claims_folder_searches, decision_documents, decision_issues, dispatch_tasks, docket_switches, hearing_appeal_stream_snapshots, hearing_days, hearing_issue_notes, hearing_locations, hearing_task_associations, hearing_views, ihp_drafts, intakes, judge_case_reviews, nod_date_updates, post_decision_motions, ramp_issues, record_synced_by_jobs, request_issues, request_issues_updates, sent_hearing_admin_email_events, special_issue_lists, supplemental_claims, tasks, transcriptions, users, vbms_uploaded_documents, virtual_hearings, work_modes, worksheet_issues

  distance 3

 
 annotations, cavc_dashboard_dispositions, cavc_dashboard_issues, cavc_dashboards, cavc_dispositions_to_reasons, cavc_reasons_to_bases, cavc_remands_appellant_substitutions, certifications, claim_establishments, conference_links, distributed_cases, distributions, document_views, end_product_establishments, end_product_updates, higher_level_reviews, job_notes, legacy_issue_optins, legacy_issues, membership_requests, messages, metrics, organizations, organizations_users, people, ramp_election_rollbacks, ramp_elections, ramp_refilings, remand_reasons, request_decision_issues, schedule_periods, split_correlation_tables, system_admin_events, task_timers, unrecognized_appellants, user_quotas, vbms_communication_packages, vbms_distribution_destinations, vbms_distributions, veterans, virtual_hearing_establishments

  distance 4

 
 allocations, cavc_decision_reasons, cavc_selection_bases, certification_cancellations, end_product_code_updates, non_availabilities, priority_end_product_sync_queue, ramp_closed_appeals, team_quotas, unrecognized_party_details, vso_configs

  distance 5

 
 batch_processes, caseflow_stuck_records