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