Table end_product_establishments

Columns

	id		bigserial
	benefit_type_code		varchar
	claim_date		date
	claimant_participant_id		varchar
	code		varchar
	committed_at		timestamp
	created_at		timestamp
	development_item_reference_id		varchar
	doc_reference_id		varchar
	established_at		timestamp
	last_synced_at		timestamp
	limited_poa_access		bool
	limited_poa_code		varchar
	modifier		varchar
	payee_code		varchar
	reference_id		varchar
	source_id		int8
	source_type		varchar
	station		varchar
	synced_status		varchar
	updated_at		timestamp
	user_id		int4
	veteran_file_number		varchar

Associations

depends on
users	n:1	on	end_product_establishments.user_id=users.id
has dependent
board_grant_effectuations	1:n	on	board_grant_effectuations.end_product_establishment_id=end_product_establishments.id
end_product_code_updates	1:n	on	end_product_code_updates.end_product_establishment_id=end_product_establishments.id
end_product_updates	1:n	on	end_product_updates.end_product_establishment_id=end_product_establishments.id
priority_end_product_sync_queue	1:n	on	priority_end_product_sync_queue.end_product_establishment_id=end_product_establishments.id
request_issues	1:n	on	request_issues.end_product_establishment_id=end_product_establishments.id
is associated with
decision_documents	1:n	on	end_product_establishments.source_id=decision_documents.id AND end_product_establishments.source_type='DecisionDocument'
higher_level_reviews	1:n	on	end_product_establishments.source_id=higher_level_reviews.id AND end_product_establishments.source_type='HigherLevelReview'
ramp_elections	n:m	on	end_product_establishments.source_id=ramp_elections.id AND end_product_establishments.source_type='RampElection'
ramp_refilings	n:m	on	end_product_establishments.source_id=ramp_refilings.id AND end_product_establishments.source_type='RampRefiling'
supplemental_claims	1:n	on	end_product_establishments.source_id=supplemental_claims.id AND end_product_establishments.source_type='SupplementalClaim'

Closure

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