jeju
테이블 (5)
관광 (tour)
- tour_id (_ID) — BIGINT — NOT NULL
- items__alltag (태그) — VARCHAR(255)
- items__contentsid (컨텐츠_ID) — VARCHAR(255)
- items__contentscd__value (컨텐츠_분류_코드) — VARCHAR(255)
- items__contentscd__label (컨텐츠_분류_명칭) — VARCHAR(255)
- items__contentscd__refId (컨텐츠_분류_참조ID) — VARCHAR(255)
- items__title (이름) — VARCHAR(255)
- items__region1cd__value (지역_코드) — VARCHAR(255)
- items__region1cd__label (지역_명칭) — VARCHAR(255)
- items__region1cd__refId (지역_참조ID) — VARCHAR(255)
- items__region2cd__value (세부지역_코드) — BIGINT
- items__region2cd__label (세부지역_명칭) — VARCHAR(255)
- items__region2cd__refId (세부지역_참조ID) — VARCHAR(255)
- items__address (주소) — VARCHAR(255)
- items__roadaddress (도로명주소) — VARCHAR(255)
- items__tag (특징_태그) — VARCHAR(255)
- items__introduction (소개) — VARCHAR(512)
- items__latitude (위도) — DOUBLE
- items__longitude (경도) — DOUBLE
- items__postcode (우편번호) — VARCHAR(255)
- items__phoneno (전화번호) — VARCHAR(255)
- items__repPhoto (대표사진) — VARCHAR(255)
- items__repPhoto__descseo (대표사진_설명) — VARCHAR(255)
- items__repPhoto__photoid__photoid (사진_ID) — VARCHAR(255)
- items__repPhoto__photoid__imgpath (이미지_경로) — VARCHAR(255)
- items__repPhoto__photoid__thumbnailpath (썸네일_경로) — VARCHAR(255)
쇼핑 (shopping)
- shop_id (_ID) — BIGINT — NOT NULL
- items__alltag (태그) — VARCHAR(255)
- items__contentsid (컨텐츠_ID) — VARCHAR(255)
- items__contentscd__value (컨텐츠_분류_코드) — VARCHAR(255)
- items__contentscd__label (컨텐츠_분류_명칭) — VARCHAR(255)
- items__contentscd__refId (컨텐츠_분류_참조ID) — VARCHAR(255)
- items__title (이름) — VARCHAR(255)
- items__region1cd__value (지역_코드) — VARCHAR(255)
- items__region1cd__label (지역_명칭) — VARCHAR(255)
- items__region1cd__refId (지역_참조ID) — VARCHAR(255)
- items__region2cd__value (세부지역_코드) — BIGINT
- items__region2cd__label (세부지역_명칭) — VARCHAR(255)
- items__region2cd__refId (세부지역_참조ID) — VARCHAR(255)
- items__address (주소) — VARCHAR(255)
- items__roadaddress (도로명주소) — VARCHAR(255)
- items__tag (특징_태그) — VARCHAR(255)
- items__introduction (소개) — VARCHAR(512)
- items__latitude (위도) — DOUBLE
- items__longitude (경도) — DOUBLE
- items__postcode (우편번호) — VARCHAR(255)
- items__phoneno (전화번호) — VARCHAR(255)
- items__repPhoto (대표사진) — VARCHAR(255)
- items__repPhoto__descseo (대표사진_설명) — VARCHAR(255)
- items__repPhoto__photoid__photoid (사진_ID) — VARCHAR(255)
- items__repPhoto__photoid__imgpath (이미지_경로) — VARCHAR(255)
- items__repPhoto__photoid__thumbnailpath (썸네일_경로) — VARCHAR(255)
숙소 (accommodation)
- accom_id (_ID) — BIGINT — NOT NULL
- items__alltag (태그) — VARCHAR(255)
- items__contentsid (컨텐츠_ID) — VARCHAR(255)
- items__contentscd__value (컨텐츠_분류_코드) — VARCHAR(255)
- items__contentscd__label (컨텐츠_분류_명칭) — VARCHAR(255)
- items__contentscd__refId (컨텐츠_분류_참조ID) — VARCHAR(255)
- items__title (이름) — VARCHAR(255)
- items__region1cd__value (지역_코드) — VARCHAR(255)
- items__region1cd__label (지역_명칭) — VARCHAR(255)
- items__region1cd__refId (지역_참조ID) — VARCHAR(255)
- items__region2cd__value (세부지역_코드) — BIGINT
- items__region2cd__label (세부지역_명칭) — VARCHAR(255)
- items__region2cd__refId (세부지역_참조ID) — VARCHAR(255)
- items__address (주소) — VARCHAR(255)
- items__roadaddress (도로명주소) — VARCHAR(255)
- items__tag (특징_태그) — VARCHAR(255)
- items__introduction (소개) — VARCHAR(512)
- items__latitude (위도) — DOUBLE
- items__longitude (경도) — DOUBLE
- items__postcode (우편번호) — VARCHAR(255)
- items__phoneno (전화번호) — VARCHAR(255)
- items__repPhoto (대표사진) — VARCHAR(255)
- items__repPhoto__descseo (대표사진_설명) — VARCHAR(255)
- items__repPhoto__photoid__photoid (사진_ID) — VARCHAR(255)
- items__repPhoto__photoid__imgpath (이미지_경로) — VARCHAR(255)
- items__repPhoto__photoid__thumbnailpath (썸네일_경로) — VARCHAR(255)
음식점 (restaruant)
- res_id (_ID) — BIGINT — NOT NULL
- items__alltag (태그) — VARCHAR(255)
- items__contentsid (컨텐츠_ID) — VARCHAR(255)
- items__contentscd__value (컨텐츠_분류_코드) — VARCHAR(255)
- items__contentscd__label (컨텐츠_분류_명칭) — VARCHAR(255)
- items__contentscd__refId (컨텐츠_분류_참조ID) — VARCHAR(255)
- items__title (이름) — VARCHAR(255)
- items__region1cd__value (지역_코드) — VARCHAR(255)
- items__region1cd__label (지역_명칭) — VARCHAR(255)
- items__region1cd__refId (지역_참조ID) — VARCHAR(255)
- items__region2cd__value (세부지역_코드) — BIGINT
- items__region2cd__label (세부지역_명칭) — VARCHAR(255)
- items__region2cd__refId (세부지역_참조ID) — VARCHAR(255)
- items__address (주소) — VARCHAR(255)
- items__roadaddress (도로명주소) — VARCHAR(255)
- items__tag (특징_태그) — VARCHAR(255)
- items__introduction (소개) — VARCHAR(512)
- items__latitude (위도) — DOUBLE
- items__longitude (경도) — DOUBLE
- items__postcode (우편번호) — VARCHAR(255)
- items__phoneno (전화번호) — VARCHAR(255)
- items__repPhoto (대표사진) — VARCHAR(255)
- items__repPhoto__descseo (대표사진_설명) — VARCHAR(255)
- items__repPhoto__photoid__photoid (사진_ID) — VARCHAR(255)
- items__repPhoto__photoid__imgpath (이미지_경로) — VARCHAR(255)
- items__repPhoto__photoid__thumbnailpath (썸네일_경로) — VARCHAR(255)
축제 (festival)
- fes_id (_ID) — BIGINT — NOT NULL
- items__alltag (태그) — VARCHAR(255)
- items__contentsid (컨텐츠_ID) — VARCHAR(255)
- items__contentscd__value (컨텐츠_분류_코드) — VARCHAR(255)
- items__contentscd__label (컨텐츠_분류_명칭) — VARCHAR(255)
- items__contentscd__refId (컨텐츠_분류_참조ID) — VARCHAR(255)
- items__title (이름) — VARCHAR(255)
- items__region1cd__value (지역_코드) — VARCHAR(255)
- items__region1cd__label (지역_명칭) — VARCHAR(255)
- items__region1cd__refId (지역_참조ID) — VARCHAR(255)
- items__region2cd__value (세부지역_코드) — BIGINT
- items__region2cd__label (세부지역_명칭) — VARCHAR(255)
- items__region2cd__refId (세부지역_참조ID) — VARCHAR(255)
- items__address (주소) — VARCHAR(255)
- items__roadaddress (도로명주소) — VARCHAR(255)
- items__tag (특징_태그) — VARCHAR(255)
- items__introduction (소개) — VARCHAR(512)
- items__latitude (위도) — DOUBLE
- items__longitude (경도) — DOUBLE
- items__postcode (우편번호) — VARCHAR(255)
- items__phoneno (전화번호) — VARCHAR(255)
- items__repPhoto (대표사진) — VARCHAR(255)
- items__repPhoto__descseo (대표사진_설명) — VARCHAR(255)
- items__repPhoto__photoid__photoid (사진_ID) — VARCHAR(255)
- items__repPhoto__photoid__imgpath (이미지_경로) — VARCHAR(255)
- items__repPhoto__photoid__thumbnailpath (썸네일_경로) — VARCHAR(255)