[최은강] 2020.12.18 마이페이지 호텔 뷰

[loveAlakazam]

1. 마이페이지 내가 예약한 호텔 뷰 - MY_HOTEL

CREATE OR REPLACE VIEW MY_HOTEL
AS
SELECT R.RESERVE_NO, BO_NO, B.BO_TITLE, R.ROOM_NO, R.RESERVE_PRICE, R.RESERVE_TOTAL_PERSON_CNT,
        R.CHECK_IN_DATE, R.CHECK_OUT_DATE, I.CHANGE_NAME, R.MEMBER_ID
FROM HOTEL_RESERVATION R
JOIN IMG_FILE I USING(BO_NO)
JOIN BOARD B USING(BO_NO)
WHERE I.FILE_LEVEL=1 AND R.CHECK_IN_DATE>SYSDATE AND R.REFUND_CHECK='N';

commit;