YTrip
Tables (7)
CoursePlaces (각 일차별 장소 정보)
- place_id (Key) — Primary key — NOT NULL
- course_id (Key2) — Foreign key → TravelCourse.course_id — NOT NULL
- user_id (Key22) — Foreign key → TravelCourse.user_id — NOT NULL
- place_name (Field)
- posx (Field2)
- posy (Field3)
- day_num (Field7) — 몇 번째 날인지
- order (Field4) — 해당 일차 방문 순서
- mainImg (Field5)
- content (Field6)
Review (리뷰)
- review_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
- video_id (Key3) — Foreign key → video.video_id — NOT NULL
- content (Field)
- score (Field2)
- created_at (Field3)
- updated_at (Field4)
TravelCourse (사용자가 생성한 코스)
- course_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
- course_name (Field)
- created_at (Field2)
- updated_at (Field3)
User (사용자)
- user_id (Key) — Primary key — NOT NULL
- nickname (Field)
- email (Field2)
- password (Field3)
- refresh Token (Field4)
- created_at (Field5)
- updated_at (Field6)
UserSavedVideos (마이플레이스 등록 영상)
- saved_video_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
- video_id (Key3) — Foreign key → video.video_id — NOT NULL
- saved_at (Field)
video (유튜브)
- video_id (Key) — Primary key — NOT NULL
- title (Field)
- content (Field2)
- video_url (Field3)
- tag (Field5)
- youtuber (Field6)
- saved_count (Field4)
video_course (영상에서 나온 경로)
- video_Course_id (Key) — Primary key — NOT NULL
- video_id (Key2) — Foreign key → video.video_id — NOT NULL
- index (Field)
- place_name (Field2)
- posx (Field3)
- posy (Field4)