Приказ на детали

Посетител или Reviewer може да гледа детали за избраниот бизнис.

Актери

• Посетител
• Reviewer

Реализација

Чекор 1 : Системот го прикажува избраниот бизнис.

Најди детали за бизнисот

select 
        b.business_id,
        b.business_name,
        (
        select
                avg(r.review_stars)
        from
                review r
        where
                r.business_id = b.business_id 
) as business_avg_stars,
        c.category_name,
        a.address_city,
        b.business_hours,
        b.business_descr,
        b.business_phone        
from
        business b
join category c on
        b.category_id = c.category_id
join address a on
        b.business_id = a.business_id
where
        b.business_id = 4

Најди ги сите сервиси за бизнисот

select s.service_name from business_service bs
join service s on
        bs.service_id = s.service_id
where business_id = 4 

Најди ги сите ревјуа за бизнисот

select
        r.reviewer_name,
        r.reviewer_verified,
        review.review_title,
        review.review_text,
        review.review_stars
from
        review
join reviewer r 
on
        review.reviewer_id = r.reviewer_id
where
        review.business_id = 4;