member_seen_phones_view

Materialized: true

Definition

 SELECT member_seen.member_seen_id,
    'unknown'::text AS phone_type,
    phone.phone_number
   FROM (claims.member_seen
     JOIN claims.phone ON ((phone.phone_id = member_seen.phone_number_id)));

Indexes:

• member_seen_phones_view_member_seen_id_phone_number_idx (Unique) - member_seen_id, phone_number
• member_seen_phones_view_member_seen_id_phone_type_idx (Unique) - member_seen_id, phone_type

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