Xtress

Tables (7)

path_diff

  • id — BIGINT — Primary key
  • pathes_id1 — BIGINT — Foreign key → pathes.id
  • pathes_id2 — BIGINT — Foreign key → pathes.id
  • before_diff — geometry(Point, 4326)
  • after_diff — geometry(Point, 4326)
  • path1_coords — geometry(LineString, 4326)
  • path2_coords — geometry(LineString, 4326)
  • diff_time — INT
  • diff_stress — DOUBLE
  • selected_path — INT
  • selected_at — TIMESTAMPTZ

pathes

  • id — BIGINT — Primary key
  • routes_id — BIGINT — Foreign key → routes.id
  • name — VARCHAR — NOT NULL
  • distance — INT
  • duration — INT — NOT NULL
  • coords — geometry(LineString, 4326)
  • avg_score — DOUBLE
  • is_main — BOOLEAN
  • created_at — TIMESTAMPTZ

routes

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.id
  • kakao_request_id — VARCHAR
  • origin_coord — geometry(Point, 4326)
  • destination_coord — geometry(Point, 4326)
  • is_main — BOOLEAN
  • created_at — TIMESTAMPTZ

stress_polygon (CopyOfwaypoints)

  • id — BIGINT — Primary key
  • score — DOUBLE
  • coords — geometry(Polygon, 4326)
  • description — VARCHAR

user_places

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.id
  • name — VARCHAR
  • address — VARCHAR
  • coord — geometry(Point, 4326)
  • is_active — BOOLEAN

users

  • id — BIGINT — Primary key
  • nickname — VARCHAR
  • motion_sick — BOOLEAN
  • acrophobia — BOOLEAN
  • created_at — TIMESTAMPTZ
  • coord — geometry(Point, 4326)

waypoints

  • id — BIGINT — Primary key
  • routes_id — BIGINT — Foreign key → routes.id
  • name — VARCHAR
  • coord — geometry(Point, 4326)