query 문 및 이미지 url

-- -----------------------------
-- 1. 테이블 생성
-- -----------------------------

-- Attraction 테이블
CREATE TABLE attraction (
    attractionID INT AUTO_INCREMENT PRIMARY KEY,
    attractionName VARCHAR(255) NOT NULL,
    attractionURL VARCHAR(255) NOT NULL
);

-- EatingHouse 테이블
CREATE TABLE eatingHouse (
    eatingHouseID INT AUTO_INCREMENT PRIMARY KEY,
    eatingHouseName VARCHAR(255) NOT NULL,
    eatingHouseURL VARCHAR(255) NOT NULL
);

-- Menu 테이블 (EatingHouse의 외래키 포함)
CREATE TABLE menu (
    menuID INT AUTO_INCREMENT PRIMARY KEY,
    menuName VARCHAR(255) NOT NULL,
    menuURL VARCHAR(255) NOT NULL,
    menuPrice INT NOT NULL,
    eatingHouseID INT,
    FOREIGN KEY (eatingHouseID) REFERENCES eatingHouse(eatingHouseID) ON DELETE CASCADE
);

-- -----------------------------
-- 2. 데이터 삽입
-- -----------------------------

-- Attraction 데이터 삽입
INSERT INTO attraction (attractionName, attractionURL) VALUES
    ('아트란티스', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=ATL'),
    ('자이로드롭', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=GDR'),
    ('자이로스윙', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=GSW'),
    ('자이로스핀', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=GSP'),
    ('혜성특급', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=COM'),
    ('스페인해적선', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=SPA'),
    ('신밧드의모험', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=SIN'),
    ('회전목마', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=CAR'),
    ('후룸라이드', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=FLO'),
    ('회전바구니', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=TEA'),
    ('드래곤 와일드슈팅', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=DWS'),
    ('플라이벤처', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=FLY'),
    ('후렌치레볼루션', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=FRE'),
    ('범퍼카', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=BUM'),
    ('파라오의 분노', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=PHR'),
    ('풍선비행', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=BAL'),
    ('로티트레인', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=LOT'),
    ('어크로스다크', 'https://adventure.lotteworld.com/kor/enjoy/attrctn/view.do?attrctnId=ACD');

-- EatingHouse 데이터 삽입
INSERT INTO eatingHouse (eatingHouseName, eatingHouseURL) VALUES
    ('크리스탈팰리스 (T.G.I.F)', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=CP_TGIF'),
    ('델키스', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=DELKIS'),
    ('라팔로마 (라라코스트)', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=LP_LARACOAST'),
    ('라인랜드 (퀴즈노스)', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=RL_QUIZNOS'),
    ('스핑크스스낵 (뉴욕핫도그)', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=SS_NYHD'),
    ('비비큐빌리지', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=BBQ_VILLAGE'),
    ('101번지 남산돈까스', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=101_NAMSAN'),
    ('페어리테일 (도미노피자)', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=FT_DOMINO');


-- Menu 데이터 추가 삽입
INSERT INTO menu (menuName, menuURL, menuPrice, eatingHouseID) VALUES
    ('델키스 치킨 샐러드', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=DELKIS', 15000, 2),
    ('델키스 파스타', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=DELKIS', 16000, 2),
    ('델키스 피자', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=DELKIS', 17000, 2),

    ('라팔로마 파스타', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=LP_LARACOAST', 19000, 3),
    ('라팔로마 스테이크', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=LP_LARACOAST', 25000, 3),
    ('라팔로마 리조또', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=LP_LARACOAST', 22000, 3),

    ('라인랜드 샌드위치', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=RL_QUIZNOS', 13000, 4),
    ('라인랜드 피자', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=RL_QUIZNOS', 16000, 4),
    ('라인랜드 샐러드', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=RL_QUIZNOS', 12000, 4),

    ('스핑크스스낵 핫도그', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=SS_NYHD', 9000, 5),
    ('스핑크스스낵 나쵸', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=SS_NYHD', 7000, 5),
    ('스핑크스스낵 감자튀김', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=SS_NYHD', 6000, 5),

    ('비비큐빌리지 바베큐', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=BBQ_VILLAGE', 27000, 6),
    ('비비큐빌리지 그릴드 치킨', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=BBQ_VILLAGE', 22000, 6),
    ('비비큐빌리지 소시지', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=BBQ_VILLAGE', 15000, 6),

    ('101번지 남산돈까스 돈까스', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=101_NAMSAN', 16000, 7),
    ('101번지 남산돈까스 제육볶음', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=101_NAMSAN', 18000, 7),
    ('101번지 남산돈까스 김치찌개', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=101_NAMSAN', 13000, 7),

    ('페어리테일 도미노피자', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=FT_DOMINO', 17000, 8),
    ('페어리테일 치킨윙', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=FT_DOMINO', 15000, 8),
    ('페어리테일 스파게티', 'https://adventure.lotteworld.com/kor/enjoy/restaurant/view.do?categCd=RSTNT_CATEG_2&restId=FT_DOMINO', 19000, 8);