기말

테이블 (12)

course_likes

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

courses

  • course_id — BIGINT
  • 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 — VARCHAR(255) — NOT NULL
  • caution — VARCHAR(255)
  • is_official — BOOLEAN — NOT NULL
  • grade_by_official — DOUBLE — NOT NULL
  • grade_by_user — DOUBLE — NOT NULL

join_request

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

records

  • record_id — BIGINT
  • 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
  • gps_data — TEXT — NOT NULL
  • start_point — VARCHAR(255) — NOT NULL
  • region — VARCHAR(255) — NOT NULL
  • segment_paces — TEXT

room

  • room_id — BIGINT
  • course_id — BIGINT — 외래 키 → courses.course_id
  • invite_code — VARCHAR(6) — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • pace — INTEGER — NOT NULL
  • schedule_days — VARCHAR(50) — NOT NULL
  • max_participants — INTEGER — NOT NULL
  • join_type — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • created_at — DATE — NOT NULL

room_member

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

room_notice

  • notice_id — BIGINT
  • room_id — BIGINT — 외래 키 → room.room_id — NOT NULL
  • author_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • text — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

room_vote

  • vote_id — BIGINT
  • room_id — BIGINT — 외래 키 → room.room_id — NOT NULL
  • author_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • question — VARCHAR(200) — NOT NULL
  • is_closed — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

running_shoe

  • shoe_id — BIGINT
  • 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 — BIGINT
  • 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

vote_option

  • option_id — BIGINT
  • vote_id — BIGINT — 외래 키 → room_vote.vote_id — NOT NULL
  • option_text — VARCHAR(100) — NOT NULL

vote_result

  • result_id — BIGINT
  • vote_id — BIGINT — 외래 키 → room_vote.vote_id — NOT NULL
  • option_id — BIGINT — 외래 키 → vote_option.option_id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • voted_at — TIMESTAMP — NOT NULL