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