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)