favoritMap

Tables (5)

Mycollection (컬렉션)

  • Key (c_id) — Primary key — NOT NULL
  • Field (name)
  • Field2 (color)
  • Field (createDt)
  • Field2 (is_share)
  • Key (user_id) — Foreign key → user.Key — NOT NULL

collection_place (컬렉션에 포함된 장소)

  • Key (id) — Primary key — NOT NULL
  • Key (c_id) — Foreign key → Mycollection.Key — NOT NULL
  • Key (place_id) — Foreign key → place.Key — NOT NULL
  • Field (create_date)

place (장소)

  • Key (place_id) — Primary key — NOT NULL
  • Field (name)
  • Field2 (lng)
  • Field3 (lat)
  • Field (country)

place_submissions (장소제보)

  • Key (id) — Primary key — NOT NULL
  • Field (name)
  • Field2 (desc)
  • Field (lat)
  • Field2 (lng)
  • Key (user_id) — Foreign key → user.Key — NOT NULL
  • Field (is_approved)
  • Field2 (status)
  • Field (approve_date)
  • Field (create_date)

user (유저테이블)

  • Key (user_id) — Primary key — NOT NULL
  • Field (email)
  • Field2 (password)
  • Field3 (nickname)