search

KHAcademyProject2020 / Spring-Project-Trip2Reap

국내 여행 사이트
Apache License 2.0
0 stars 0 forks source link

[김기쁨] 여행코스 샘플데이터 #14

Open joyeeek opened 3 years ago

joyeeek commented 3 years ago

insert into board values(SEQ_BO_NO.NEXTVAL,2,'우리가족 안산투어',null,'jaewook',0,null,'N',to_date('20/11/24','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course20.jpg','1608267310626course20.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'가족','당일치기','0,0,0,0','바다향기수목원,안산갈대습지,화랑유원지,안산식물원','126.64652831596153,126.83974811260443,126.814341858481,126.861072239892','37.22502218198028,37.273715528519375,37.3265944170577,37.3137485130475','28.7');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'군포철쭉축제',null,'suzy',0,null,'N',to_date('20/11/25','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course19.jpg','1608267140882course19.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'가족','기쁨,수진,은강,규호','0,0,0,0,0','반월호수,갈치저수지,산본로데오거리,수리산도립공원,관모봉','126.889994467378,126.906839602418,126.932006714896,126.904724830135,126.918460126985','37.3214809676705,37.3335620513881,37.3592981746466,37.3569114463487,37.3771083028725','10.6');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'보성으로 네식구 떠나자',null,'ain',0,null,'N',to_date('20/11/26','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course18.jpg','1608266954380course18.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'가족','우리가족 여행가요~!','0,0,0,0','보성녹차밭,율포해수욕장,제암산자연휴양림,보성비봉공룡공원','127.077901795169,127.0890226008729,126.985020821103,127.194732884858','34.7159597989524,34.67002979882495,34.69962468832,34.7086537462092','34.5');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'전주 가족여행',null,'joy',0,null,'N',to_date('20/11/28','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course17.jpg','1608266603488course17.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'가족','맛집탐방','0,0,0,0,0','전주한옥마을,경기전,전주동물원,자만벽화마을,PNB풍년제과 본점','127.152557091072,127.149729902972,127.144388934126,127.157184713186,127.147190523108','35.8148243087693,35.8153866450026,35.8552035317834,35.8137981198856,35.8184288311183','10.4');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'영남 알프스 여행기',null,'kmk',0,null,'N',to_date('20/11/27','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course16.jpg','1608266449127course16.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'가족','영남 알프스 여행','0,0,0,0,0','영남알프스,영남알프스 국제클라이밍장,영남알프스골프파크,영남알프스둘레길 1코스,배내통하우스','129.067605227914,129.0665975813536,129.09454268994008,129.095530464707,129.022544992979','35.5563262302399,35.556206544045544,35.54151009944064,35.5329486433176,35.5667327754678','11.7');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'통영 [동피랑 마을]',null,'soo',0,null,'N',to_date('20/11/29','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course15.jpg','1608265994053course15.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'커플','통영여행','0,0,0,0','통영케이블카,동피랑벽화마을,스카이라인루지 통영,욕지도','128.426207930721,128.427625013602,128.424146493077,128.252369035815','34.8267877405814,34.845305652074,34.824374746341,34.6363687135464','30.5');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'양평축제 놀러가자',null,'TRIP',0,null,'N',to_date('20/12/01','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course13.jpg','1608265355518course13.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'커플','두물머리 꼭 가기','0,0,0,0,0','두물머리,두물머리연핫도그,테라로사 서종점,피아노폭포,용문산','127.315829778049,127.31682011581383,127.35528536911004,127.347685844373,127.548829154789','37.5328127891601,37.53477340977065,37.624698025453625,37.6303509014602,37.5621537276043','30.9');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'1주년 여행🎈',null,'psj',0,null,'N',to_date('20/11/30','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course14.jpg','1608265713929course14.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'커플','1주년 맞이 여행','0,0,0,0,0','동대문디자인플라자,종로빈대떡 광화문점,광화문광장,테라로사 광화문점,남산서울타워','127.009911013917,126.975286676158,126.97691639601517,126.979551097421,126.988217046052','37.5671843130818,37.5715429606809,37.572602860810186,37.5747188824776,37.551279740966','6.3');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'하윤이의 캠핑여행기💗',null,'cjy',0,null,'N',to_date('20/12/02','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course12.jpg','1608260459305course12.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'액티비티','저의 캠핑 코스입니다. 많이 공유해주세요','0,0,0,0','한탄강관광지 오토캠핑장,재인폭포,임진강 주상절리,고대산자연휴양림','127.058964350023,127.143318624342,127.015419614536,127.1507057687593','38.008306196531,38.0773343830953,38.0186301814307,38.21125391423866','48.2');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'평택으로 출발~!!',null,'chy',0,null,'N',to_date('20/12/03','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course11.jpg','1608259949896course11.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'액티비티','당일치기','0,0,0,0','소풍정원,내리문화공원,안정리 로데오거리,평택시자연테마식물원','127.018944017367,127.030979024796,127.045130140765,126.980825865869','37.0108064598313,36.9749263901673,36.9602413409793,37.0143927231357','14.5');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'대구 즐기기 코스',null,'jcs',0,null,'N',to_date('20/12/04','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course10.jpg','1608258685108course10.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'나홀로','대구 곱창먹기','0,0,0,0','디아크문화관,구공탄막창 형님본점,이월드,금봉산','128.468070231095,128.555695179858,128.56658131032162,128.56003650365062','35.8388524710476,35.8687098071514,35.85322716591636,35.84889670042911','11.4');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'정동진 해돋이여행🌞',null,'lsy',0,null,'N',to_date('20/12/05','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course9.jpg','1608257570516course9.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'커플','2020-12-24~','0,0,0,0,0','정동진역,정동진 레일바이크,정동진초당순두부,정동진해변,썬크루즈리조트엔호텔','129.03268957371495,129.03261781868983,129.032054481167,129.036259739972,129.043942880667','37.691430132528666,37.691459295666476,37.6905897957039,37.6891659795686,37.6834586643041','1.4');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'수원화성 탐방하기',null,'kyy',0,null,'N',to_date('20/12/06','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course8.jpg','1608256544634course8.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'나홀로','2020-12-22~','0,0,0,0','팔달공원 효원의종,수원화성 화홍문,장안공원 화서문,팔달문','127.01038283238,127.01762609024438,127.009693533728,127.016742011481','37.279456840377,37.28754551327953,37.2855803622032,37.2775675320808','2.9');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'부산으로 떠나요!',null,'mdj',0,null,'N',to_date('20/12/08','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course4.jpg','1607937458015course4.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'가족','크리스마스에는 부산으로~!','0,0,0,0,0','마린시티,해운대가야밀면,해운대해수욕장,비비비당,해운대달맞이공원','129.116248485217,129.166334485854,129.159854668484,129.1850134393127,129.17893035431','35.172125477434,35.1688354703383,35.1585232170784,35.162550535259946,35.1560728255183','9.1');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'제주 남부 여행',null,'lys',0,null,'N',to_date('20/12/09','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course2.jpg','1607934467823course2.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'커플','제주도 여행','0,0,0,0','함덕해수욕장,카페더콘테나,교래흑돼지 본점,산굼부리,비자림','126.669238934013,126.67895539907079,126.6750575197852,126.693840600964,126.80998754971','33.5430615661113,33.49808308071445,33.42372662293438,33.4325741154168,33.4904083697986','28');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'가평 수상레저 즐기기',null,'jkd',0,null,'N',to_date('20/12/10','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course5.jpg','1607937714736course5.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'액티비티','가평에서 즐길 수 있는 액티비티입니다.','0,0,0,0,0','가평빠지 바이킹수상레저,봉화산,구곡폭포,남이섬,스윙카페','127.54063465265088,127.611155351119,127.609196555667,127.525209237483,127.52677494487004','37.75654910133039,37.7809662687697,37.7940221581331,37.7916335528514,37.7943672578702','16');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'제주 서부로 떠나자~!!',null,'kkh',0,null,'N',to_date('20/12/11','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course1.jpg','1607934324177course1.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'나홀로','당일치기','0,0,0,0,0','하이엔드제주,골목카페옥수,9.81파크,아르떼뮤지엄,새별오름','126.30917383944714,126.379977434507,126.36666400048769,126.34500847325,126.357711941768','33.46359065428745,33.4397509795262,33.39028982281912,33.3966977646567,33.3661936453469','18.4');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'북촌한옥마을',null,'psj',0,null,'N',to_date('20/12/12','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course3.jpg','1607936714070course3.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'우정','당일치기','0,0,0,0,0','북촌한옥마을,카페노티드 안국,소금집델리 안국,창덕궁,종묘','126.983384576672,126.986039353435,126.98623370380619,126.99164485515004,126.994212979827','37.5829185302128,37.5774624552685,37.57944556614759,37.58187064743792,37.5761080433804','2');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'경주여행 레고🚴‍♀️',null,'kjh',0,null,'N',to_date('20/12/13','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course6.jpg','1607968572615course6.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'나홀로','경주 혼여갑니다!','0,0,0,0,0','첨성대,함양집 경주보문점,동국대학교 경주캠퍼스,포석정,신경주역','129.219020190172,129.262183765744,129.19450495505598,129.213092771083,129.13899826575','35.8347180469201,35.8520273426589,35.862538617367974,35.8071183926353,35.7983754706903','23.7');

insert into board values(SEQ_BO_NO.NEXTVAL,2,'★별보러가자★',null,'kyw',0,null,'N',to_date('20/12/14','RR/MM/DD')); Insert into IMG_FILE values (SEQ_FILE_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'course7.jpg','1607969035089course7.JPG',1,'null','N'); insert into course values(SEQ_CO_NO.NEXTVAL,SEQ_BO_NO.CURRVAL,'가족','천문대에서 꼭 별을 감상해야지~!','0,0,0,0','영양반딧불이천문대,석보갈비,선바위관광지,커피베이 경북영양점','129.26945106775,129.101560844106,129.081086315202,129.11071218641237','36.8304157868791,36.5563906091168,36.6087837193124,36.66347869486301','46.4');

COMMIT;