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)