기말

테이블 (7)

course_likes

  • course_like_id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • course_id — BIGINT — 외래 키 → courses.course_id — NOT NULL
  • liked_date — TIMESTAMP — NOT NULL

courses

  • course_id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.user_id
  • record_id — BIGINT — 외래 키 → records.record_id
  • name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(1000)
  • shape — VARCHAR(100) — NOT NULL
  • region — VARCHAR(255) — NOT NULL
  • distance — DOUBLE — NOT NULL
  • likes — INTEGER — NOT NULL
  • run_count — INTEGER — NOT NULL
  • gps_data — TEXT — NOT NULL
  • start_point — geometry(Point, 4326) — NOT NULL
  • caution — VARCHAR(255)
  • is_official — BOOLEAN — NOT NULL

join_request

  • request_id — BIGSERIAL
  • room_id — BIGINT — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • requested_at — DATE — NOT NULL

records

  • record_id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • course_id — BIGINT — 외래 키 → courses.course_id
  • crew_id — BIGINT
  • name — VARCHAR(300)
  • start_time — TIMESTAMP — NOT NULL
  • average_pace — INTEGER — NOT NULL
  • average_heart_rate — INTEGER
  • distance — DOUBLE — NOT NULL
  • elapsed_time — INTEGER — NOT NULL
  • running_shoes — VARCHAR(50)
  • calories — INTEGER — NOT NULL
  • start_point — geometry(Point, 4326) — NOT NULL
  • gps_data — TEXT — NOT NULL
  • region — VARCHAR(255) — NOT NULL
  • segment_paces — TEXT

room_member

  • id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • room_id — BIGINT — NOT NULL
  • role — VARCHAR(255) — NOT NULL
  • joined_date — DATE — NOT NULL

running_shoe

  • shoe_id — BIGSERIAL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • shoe_name — VARCHAR(50) — NOT NULL
  • brand — VARCHAR(50) — NOT NULL
  • total_distance — DOUBLE — NOT NULL
  • goal_distance — DOUBLE — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

users

  • user_id — BIGSERIAL
  • user_name — VARCHAR(20) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • level — VARCHAR(20)
  • level_tested — BOOLEAN — NOT NULL
  • last_logout_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL