timtravler

Tables (8)

answers

  • answer_id — INT
  • user_id — CHAR(36) — NOT NULL
  • question_id — INT — NOT NULL
  • response — TEXT
  • answered_at — DATETIME
  • updated_at — DATETIME

photos

  • image_id — INT
  • user_id — CHAR(36) — NOT NULL
  • route_id — INT — NOT NULL
  • spot_id — INT — NOT NULL
  • image_url — TEXT — NOT NULL
  • is_used — BOOLEAN
  • used_at — DATETIME

questions

  • question_id — INT
  • content — VARCHAR(255) — NOT NULL
  • type — VARCHAR(20)

route_spots

  • route_spot_id — INT
  • route_id — INT — NOT NULL
  • spot_id — INT — NOT NULL
  • order_number — INT — NOT NULL
  • created_at — DATETIME

routes

  • route_id — INT
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT

spots

  • spot_id — INT
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT — NOT NULL
  • lat — DOUBLE — NOT NULL
  • long — DOUBLE — NOT NULL
  • era — VARCHAR(50)

user_route_spots

  • user_route_spot_id — INT
  • user_id — CHAR(36) — NOT NULL
  • route_id — INT — NOT NULL
  • spot_id — INT — NOT NULL
  • order_number — INT — NOT NULL
  • created_at — DATETIME
  • unlocked_at — DATETIME

users

  • id — CHAR(36)
  • nickname — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • email — VARCHAR(100) — NOT NULL
  • age — VARCHAR(20)
  • gender — VARCHAR(10)
  • created_at — DATETIME
  • updated_at — DATETIME