기말
테이블 (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