Table legacy_appeals

Columns

	id		bigserial
	appeal_series_id		int8
	changed_hearing_request_type		varchar
	closest_regional_office		varchar
	contaminated_water_at_camp_lejeune		bool
	created_at		timestamp
	dic_death_or_accrued_benefits_united_states		bool
	dispatched_to_station		varchar
	education_gi_bill_dependents_educational_assistance_scholars		bool
	foreign_claim_compensation_claims_dual_claims_appeals		bool
	foreign_pension_dic_all_other_foreign_countries		bool
	foreign_pension_dic_mexico_central_and_south_america_caribb		bool
	hearing_including_travel_board_video_conference		bool
	home_loan_guaranty		bool
	incarcerated_veterans		bool
	insurance		bool
	issues_pulled		bool
	manlincon_compliance		bool
	mustard_gas		bool
	national_cemetery_administration		bool
	nonrating_issue		bool
	original_hearing_request_type		varchar
	pension_united_states		bool
	private_attorney_or_agent		bool
	radiation		bool
	rice_compliance		bool
	spina_bifida		bool
	updated_at		timestamp
	us_territory_claim_american_samoa_guam_northern_mariana_isla		bool
	us_territory_claim_philippines		bool
	us_territory_claim_puerto_rico_and_virgin_islands		bool
	vacols_id		varchar
	vamc		bool
	vbms_id		varchar
	vocational_rehab		bool
	waiver_of_overpayment		bool

Associations

depends on
appeal_series	n:1	on	legacy_appeals.appeal_series_id=appeal_series.id
has dependent
dispatch_tasks	1:n	on	dispatch_tasks.appeal_id=legacy_appeals.id
hearing_appeal_stream_snapshots	1:n	on	hearing_appeal_stream_snapshots.appeal_id=legacy_appeals.id
legacy_hearings	1:n	on	legacy_hearings.appeal_id=legacy_appeals.id
worksheet_issues	1:n	on	worksheet_issues.appeal_id=legacy_appeals.id
is associated with
advance_on_docket_motions	n:m	on	advance_on_docket_motions.appeal_id=legacy_appeals.id AND advance_on_docket_motions.appeal_type='LegacyAppeal'
appeal_states	1:1	on	appeal_states.appeal_id=legacy_appeals.id AND appeal_states.appeal_type='LegacyAppeal'
appeal_views	n:1	on	appeal_views.appeal_id=legacy_appeals.id AND appeal_views.appeal_type='LegacyAppeal'
attorney_case_reviews	n:1	on	attorney_case_reviews.appeal_id=legacy_appeals.id AND attorney_case_reviews.appeal_type='LegacyAppeal'
available_hearing_locations	n:1	on	available_hearing_locations.appeal_id=legacy_appeals.id AND available_hearing_locations.appeal_type='LegacyAppeal'
claims_folder_searches	n:1	on	claims_folder_searches.appeal_id=legacy_appeals.id AND claims_folder_searches.appeal_type='LegacyAppeal'
decision_documents	n:1	on	decision_documents.appeal_id=legacy_appeals.id AND decision_documents.appeal_type='LegacyAppeal'
hearing_email_recipients	n:m	on	hearing_email_recipients.appeal_id=legacy_appeals.id AND hearing_email_recipients.appeal_type='LegacyAppeal'
ihp_drafts	n:m	on	ihp_drafts.appeal_id=legacy_appeals.id AND ihp_drafts.appeal_type='LegacyAppeal'
judge_case_reviews	n:1	on	judge_case_reviews.appeal_id=legacy_appeals.id AND judge_case_reviews.appeal_type='LegacyAppeal'
record_synced_by_jobs	1:1	on	record_synced_by_jobs.record_id=legacy_appeals.id AND record_synced_by_jobs.record_type='LegacyAppeal'
special_issue_lists	1:1	on	special_issue_lists.appeal_id=legacy_appeals.id AND special_issue_lists.appeal_type='LegacyAppeal'
tasks	n:1	on	tasks.appeal_id=legacy_appeals.id AND tasks.appeal_type='LegacyAppeal'
vbms_uploaded_documents	n:1	on	vbms_uploaded_documents.appeal_id=legacy_appeals.id AND vbms_uploaded_documents.appeal_type='LegacyAppeal'
work_modes	1:1	on	work_modes.appeal_id=legacy_appeals.id AND work_modes.appeal_type='LegacyAppeal'

Closure

	distance 0				legacy_appeals
	distance 1				advance_on_docket_motions, appeal_series, appeal_states, appeal_views, attorney_case_reviews, available_hearing_locations, claims_folder_searches, decision_documents, dispatch_tasks, hearing_appeal_stream_snapshots, hearing_email_recipients, ihp_drafts, judge_case_reviews, legacy_hearings, record_synced_by_jobs, special_issue_lists, tasks, vbms_uploaded_documents, work_modes, worksheet_issues
	distance 2				appeals, board_grant_effectuations, claim_establishments, distributed_cases, docket_switches, end_product_establishments, hearing_days, hearing_locations, hearing_task_associations, hearing_views, hearings, organizations, people, post_decision_motions, sent_hearing_email_events, task_timers, users, vbms_communication_packages, virtual_hearings
	distance 3				annotations, appellant_substitutions, cavc_dashboard_dispositions, cavc_dashboard_issues, cavc_dashboards, cavc_dispositions_to_reasons, cavc_reasons_to_bases, cavc_remands, cavc_remands_appellant_substitutions, certifications, claimants, conference_links, decision_issues, distributions, document_views, end_product_code_updates, end_product_updates, hearing_issue_notes, higher_level_reviews, intakes, job_notes, membership_requests, messages, metrics, nod_date_updates, organizations_users, priority_end_product_sync_queue, ramp_election_rollbacks, ramp_elections, ramp_issues, ramp_refilings, request_issues, request_issues_updates, schedule_periods, sent_hearing_admin_email_events, split_correlation_tables, supplemental_claims, system_admin_events, transcriptions, unrecognized_appellants, user_quotas, vbms_distribution_destinations, vbms_distributions, virtual_hearing_establishments, vso_configs
	distance 4				allocations, batch_processes, caseflow_stuck_records, cavc_decision_reasons, cavc_selection_bases, certification_cancellations, legacy_issue_optins, legacy_issues, non_availabilities, ramp_closed_appeals, remand_reasons, request_decision_issues, team_quotas, unrecognized_party_details, veterans