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)