RunCode

Tables (6)

Archiving (Untitled)

  • Key (archiving_id) — Primary key — NOT NULL
  • Field (date) — datetime
  • (content)
  • Field (thumbnail) — String
  • Field (distance)
  • Field (calorie) — Float
  • (average) — Float
  • Field (time) — String
  • Field (altitude) — Float
  • Field — Long
  • Field2
  • Key (user_id) — Foreign key → User.Key — NOT NULL
  • Id (course_id) — Foreign key → Course.Id — NOT NULL

Course

  • Id (course_id) — Primary key — NOT NULL
  • Field (title) — String
  • Field2 (content) — String
  • Field3 (address) — String
  • Field (distance)
  • Field2 (thumbnail) — String
  • Field (average) — Float
  • Field2 (review_cnt) — Long
  • Field3
  • Key (user_id) — Foreign key → User.Key — NOT NULL
  • Key (location_Id) — Foreign key → Location.Key — NOT NULL

Location

  • Key (location_Id) — Primary key — NOT NULL
  • Field (title) — String
  • Field2 (longitude) — Float
  • Field3 (latitude) — String
  • Field

Review (Untitled3)

  • Key (review_id) — Primary key — NOT NULL
  • Field (title) — String
  • Field (rating) — Long
  • Field (date) — Datetime
  • Field (content) — String
  • Field (thumnail) — String
  • Field
  • Key (user_id) — Foreign key → User.Key — NOT NULL
  • Id (course_id) — Foreign key → Course.Id — NOT NULL

Scrap (Untitled2)

  • Key (srap_id) — Primary key — NOT NULL
  • Field
  • Key (user_id) — Foreign key → User.Key — NOT NULL
  • Id (course_id) — Foreign key → Course.Id — NOT NULL

User

  • Key (user_id) — Primary key — NOT NULL
  • Field (name) — String
  • Field (profileImg) — String
  • Field (nickname) — String
  • Field (type)