claim_coverage

Provides information about member coverage for a specific plan during service dates

Primary Key:

• claim_id
• member_coverage_id
• claim_coverage_date_from
• claim_coverage_date_through

Foreign Keys:

• claim_id => claim.claim_id
• member_coverage_id => member_coverage.member_coverage_id
• plan_chosen_by => login.login_id
• plan_id_chosen => plan.plan_id

Indexes:

• claim_coverage_claim_id_idx - claim_id
• claim_coverage_member_coverage_id_idx - member_coverage_id
• claim_coverage_plan_chosen_by_idx - plan_chosen_by
• claim_coverage_plan_id_chosen_idx - plan_id_chosen

Column	Data Type	Nullable	Indexed	Description
claim_id	bigint	No	Yes	-
claim_coverage_date_from	date	No	Yes	-
claim_coverage_date_through	date	No	Yes	-
member_coverage_id	bigint	No	Yes	-
plan_id_chosen	bigint	Yes	Yes	-
plan_chosen_by	bigint	Yes	Yes	-
plan_chosen_at	date	Yes	No	-