get_subscription_details(p_user_id integer, p_streamer_id integer)


Description

Retrieves detailed subscription information including both usernames for a specific user-streamer relationship.

Parameters

Name Type Mode
p_user_id integer IN
p_streamer_id integer IN
user_id integer TABLE
streamer_id integer TABLE
subscribed_since timestamp without time zone TABLE
streamer_username citext TABLE
user_username citext TABLE

Definition