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