SwimEarth

Tables (5)

routes

  • id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • stage_no — SMALLINT — NOT NULL
  • distance_km — NUMERIC(10, 2) — NOT NULL
  • previous_route_id — BIGINT — Foreign key → routes.id
  • display_order — SMALLINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

swim_records

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • record_date — DATE — NOT NULL
  • distance_m — INTEGER — NOT NULL
  • pool_length_m — SMALLINT
  • lap_count — INTEGER
  • stroke — VARCHAR(20)
  • duration_sec — INTEGER
  • memo — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

user_routes

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • route_id — BIGINT — Foreign key → routes.id — NOT NULL
  • distance_snapshot_m — BIGINT — NOT NULL
  • started_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ

users

  • id — BIGSERIAL — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

waypoints

  • id — BIGSERIAL — Primary key — NOT NULL
  • route_id — BIGINT — Foreign key → routes.id — NOT NULL
  • sequence_no — SMALLINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • cumulative_km — NUMERIC(10, 2) — NOT NULL