FIFTEEN BILLION

테이블 (13)

관광지 상세정보 (tourist_attraction)

  • content_id (Key2) — int — 외래 키 → 콘텐츠.content_id — NOT NULL
  • contenttype_id (Field2) — int
  • chk_credit (Field3) — varchar
  • info_center (Field4) — varchar
  • parking (Field5) — varchar
  • rest_date (Field6) — varchar
  • use_time (Field7) — varchar

도감 등록 (collector)

  • id (Key) — varchar — 기본 키 — NOT NULL
  • verifited_by (Field3) — enum(GPS, Photo)
  • verified_lat (Field4) — float
  • verified_lng (Field5) — float
  • image_url (Field6) — varchar
  • verified_at (Field7) — datetime
  • user_id (Key3) — varchar — 외래 키 → 사용자.user_id — NOT NULL
  • contentid (Key2) — int — 외래 키 → 콘텐츠.content_id — NOT NULL

레포츠 상세정보 (leports)

  • content_id (Key2) — int — 외래 키 → 콘텐츠.content_id — NOT NULL
  • contenttype_id (Field) — int
  • chk_credit (Field3) — varchar
  • info_center (Field5) — varchar
  • parking (Field8) — varchar
  • use_time (Field12) — varchar
  • rest_date (Field10) — varchar

문화시설 상세정보 (culture)

  • content_id (Key2) — int — 외래 키 → 콘텐츠.content_id — NOT NULL
  • contenttype_id (Field) — int
  • chk_credit (Field2) — varchar
  • info_center (Field4) — varchar
  • parking (Field5) — varchar
  • rest_date (Field6) — varchar
  • use_fee (Field7) — varchar
  • use_time (Field8) — varchar

배지 정의 (badge)

  • badge_id (Key) — varchar — 기본 키 — NOT NULL
  • name (Field) — varchar
  • image_url (Field2) — varchar
  • condition (Field3) — JSON
  • description (Field4) — text

사용자 (user)

  • user_id (Key) — varchar — 기본 키 — NOT NULL
  • kakao_id (Field) — bigint
  • nickname (Field2) — varchar
  • profile_image (Field3) — varchar
  • created_at (Field4) — datetime
  • last_login (Field5) — datetime
  • is_active (Field6) — bool

사용자 획득 배지 (user_badge)

  • id (Key) — varchar — 기본 키 — NOT NULL
  • awared_at (Field3) — datetime
  • user_id (Key2) — varchar — 외래 키 → 사용자.user_id — NOT NULL
  • badge_id (Key3) — varchar — 외래 키 → 배지 정의.badge_id — NOT NULL

쇼핑 상세정보 (shopping)

  • content_id (Key2) — int — 외래 키 → 콘텐츠.content_id — NOT NULL
  • contenttype_id (Field) — int
  • chk_credit (Field3) — varchar
  • fair_day (Field4) — varchar
  • info_center (Field5) — varchar
  • open_time (Field7) — varchar
  • parking (Field8) — varchar
  • rest_date (Field9) — varchar
  • sale_item (Field10) — text

여행코스 상세정보 (course)

  • content_id (Key2) — int — 외래 키 → 콘텐츠.content_id — NOT NULL
  • contenttype_id (Field) — int
  • distance (Field2) — varchar
  • take_time (Field4) — varchar

여행코스 상세정보2 (course_detail)

  • subcontent_id (Key) — int — 기본 키 — NOT NULL
  • content_id (Key22) — int — 외래 키 → 여행코스 상세정보.content_id — NOT NULL
  • contenttypeid (Field2) — int
  • subname (Field4) — varchar
  • subdetailoverview (Field5) — varchar
  • subdetail_img (Field) — varchar

음식점 상세정보 (food_store)

  • content_id (Key2) — int — 외래 키 → 콘텐츠.content_id — NOT NULL
  • contenttype_id (Field) — int
  • chk_credit (Field3) — varchar
  • open_time (Field5) — varchar
  • parking (Field7) — varchar
  • rest_date (Field9) — varchar
  • info_center (Field10) — varchar
  • treat_menu (Field11) — text
  • first_menu (Field2) — text

콘텐츠 (content)

  • content_id (Key) — int — 기본 키 — NOT NULL
  • content_typeid (Field3) — int
  • addr1 (Field) — varchar
  • addr2 (Field2) — varchar
  • areacode (Field4) — varchar
  • mapX (Field5) — decimal
  • mapY (Field6) — decimal
  • title (Field8) — varchar
  • IDongRegnCd (Field9) — varchar
  • IDongSignguCd (Field10) — varchar
  • cat1 (Field11) — varchar
  • cat2 (Field12) — varchar
  • cat3 (Field13) — varchar
  • signgucode (Field14) — varchar
  • firstimage2 (Field15) — varchar

행사/공연/축제 상세정보 (festival)

  • content_id (Key2) — int — 외래 키 → 콘텐츠.content_id — NOT NULL
  • contenttype_id (Field1) — int
  • event_startdate (Field2) — date
  • event_enddate (Field3) — date
  • event_place (Field4) — varchar
  • play_time (Field5) — varchar
  • use_fee (Field6) — varchar