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