RunBoo
Tables (16)
badge
- badge_id (Key) — BIGSERIAL — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- icon_url — VARCHAR(255)
- difficulty — VARCHAR(10) — NOT NULL
challenge
- challenge_id (Key) — BIGSERIAL — Primary key — NOT NULL
- badge_id (Key2) — BIGSERIAL — Foreign key → badge.badge_id — NOT NULL
- badge_id — BIGINT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
- difficulty — VARCHAR(10) — NOT NULL
- target_type — VARCHAR(20) — NOT NULL
- target_value — INTEGER
- start_at — TIMESTAMPTZ
- end_at — TIMESTAMPTZ
course
- course_id (Key) — BIGSERIAL — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- address — VARCHAR(255)
- length_km — DECIMAL(5,2) — NOT NULL
- latitude — DECIMAL(9,6) — NOT NULL
- longitude — DECIMAL(9,6) — NOT NULL
- category — VARCHAR(10) — NOT NULL
ghost_profile
- ghost_profile_id (Key) — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- run_record_id — BIGINT — NOT NULL
- type — VARCHAR(20)
- target_distance_km — DECIMAL(10,2)
- avg_pace — INTEGER
- created_at — TIMESTAMPTZ
- user_id (user_id2) — BIGSERIAL — Foreign key → users.user_id — NOT NULL
- record_id (Key2) — BIGSERIAL — Foreign key → run_records.record_id — NOT NULL
grass
- grass_id (Key) — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- date — DATE — NOT NULL
- total_distance_km — DECIMAL(10,2)
- category — VARCHAR(10)
- user_id (user_id2) — BIGSERIAL — Foreign key → users.user_id — NOT NULL
notification
- notification_id — BIGSERIAL — Primary key — NOT NULL
- title — VARCHAR(100)
- body — VARCHAR(100)
- type — VARCHAR(20)
- is_read — BOOLEAN
- created_at — TIMESTAMPTZ
- deleted_at — TIMESTAMPTZ
- user_id — BIGSERIAL — Foreign key → users.user_id — NOT NULL
run_gps_point
- id — BIGSERIAL — Primary key
- record_id — BIGINT — NOT NULL
- seq — INTEGER
- latitude — DECIMAL(10,7)
- longitude — DECIMAL(10,7)
- recorded_at — TIMESTAMPTZ
- record_id (Key) — BIGSERIAL — Foreign key → run_records.record_id — NOT NULL
run_records
- record_id (Key) — BIGSERIAL — Primary key — NOT NULL
- mode — VARCHAR(10)
- distance_m — DECIMAL(10,2)
- duration_sec — INTEGER
- avg_pace — INTEGER
- calories — INTEGER
- started_at — TIMESTAMPTZ
- ended_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ
- route_polyline — TEXT
- user_id (user_id2) — BIGSERIAL — Foreign key → users.user_id — NOT NULL
social_account
- social_id (Key) — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- provider — VARCHAR(20)
- provider_user_id — VARCHAR(255)
- connected_at — TIMESTAMPTZ
- user_id (user_id2) — BIGSERIAL — Foreign key → users.user_id — NOT NULL
tier
- tier_id — BIGSERIAL — Primary key
- name — VARCHAR(50) — NOT NULL
- CRYSTAL_SNEAKER — ))
- display_name — VARCHAR(50) — NOT NULL
- distance_type — VARCHAR(10) — NOT NULL
- min_pace_sec_per_km — INTEGER — NOT NULL
- max_pace_sec_per_km — INTEGER — NOT NULL
tier_result
- tier_result_id — BIGSERIAL — Primary key
- record_id (Key) — BIGSERIAL — Foreign key → run_records.record_id — NOT NULL
- tier_id (tier_id2) — BIGSERIAL — Foreign key → tier.tier_id
- record_id — BIGINT — NOT NULL
- tier_id — BIGINT — NOT NULL
- distance_type — VARCHAR(10)
- evaluated_at — TIMESTAMPTZ
user_badge
- user_badge_id (Key) — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- badge_id — BIGINT — NOT NULL
- earned_at — TIMESTAMPTZ
- user_id (user_id2) — BIGSERIAL — Foreign key → users.user_id — NOT NULL
- badge_id (Key2) — BIGSERIAL — Foreign key → badge.badge_id — NOT NULL
user_challenge
- user_challenge_id — BIGSERIAL — Primary key — NOT NULL
- user_id (user_id3) — BIGSERIAL — Foreign key → users.user_id — NOT NULL
- challenge_id (Key) — BIGSERIAL — Foreign key → challenge.challenge_id — NOT NULL
- badge_id (Key2) — BIGSERIAL — Foreign key → challenge.badge_id — NOT NULL
- user_id — BIGINT — NOT NULL
- challenge_id — BIGINT — NOT NULL
- badge_id — BIGINT — NOT NULL
- progress_value — INTEGER
- status — VARCHAR(20)
- started_at — TIMESTAMPTZ
- completed_at — TIMESTAMPTZ
user_saved_course
- id (Key) — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- course_id — BIGINT — NOT NULL
- saved_at — TIMESTAMPTZ
- user_id (user_id2) — BIGSERIAL — Foreign key → users.user_id — NOT NULL
- course_id (Key2) — BIGSERIAL — Foreign key → course.course_id — NOT NULL
user_setting
- user_id (Key) — BIGINT — Primary key — NOT NULL
- user_id — BIGSERIAL — Foreign key → users.user_id — NOT NULL
- push_enabled — BOOLEAN
- voice_guide_enabled — BOOLEAN
- voice_type — VARCHAR(10)
- theme_mode — VARCHAR(10)
- font_size — VARCHAR(10)
- location_permission — VARCHAR(10)
users
- user_id — BIGSERIAL — Primary key — NOT NULL
- email — VARCHAR(255)
- password — VARCHAR(255)
- nickname — VARCHAR(30) — NOT NULL
- profile_image_url — VARCHAR(255)
- created_at — TIMESTAMPTZ
- state — VARCHAR(20) — NOT NULL
- deleted_at — TIMESTAMPTZ