claim_member_phones_view

Materialized: true

Definition

 SELECT claim_member.claim_member_id,
    'unknown'::text AS phone_type,
    phone.phone_number
   FROM ((claims.claim_member
     JOIN claims.subscriber_or_patient ON ((subscriber_or_patient.subscriber_or_patient_id = COALESCE(claim_member.patient_subscriber_or_patient_id, claim_member.member_subscriber_or_patient_id))))
     JOIN claims.phone ON ((phone.phone_id = subscriber_or_patient.phone_number_id)));

Indexes:

• claim_member_phones_view_claim_member_id_phone_number_idx (Unique) - claim_member_id, phone_number
• claim_member_phones_view_claim_member_id_phone_type_idx (Unique) - claim_member_id, phone_type
• claim_member_phones_view_phone_number_idx - phone_number

Column	Data Type	Indexed
claim_member_id	bigint	No
phone_type	text	No
phone_number	text	No