UTrip

Tables (9)

Comment (댓글)

  • id (Key) — Primary key — NOT NULL
  • user_id (Foreign key) — Foreign key → User.id — NOT NULL
  • video_id (Foreign Key) — Foreign key → Video.id — NOT NULL
  • id (Key2) — Foreign key → Video.place_id — NOT NULL
  • content (Field3)
  • likes_count (Field4)

Comment_Like (댓글 좋아요)

  • id (Key) — Primary key — NOT NULL
  • user_id (Foreign Key) — Foreign key → User.id — NOT NULL
  • id (Foreign Key2) — Foreign key → Comment.id — NOT NULL
  • id (Key22) — Foreign key → Comment.id — NOT NULL

CourseDetail (경로 상세정보)

  • id (Key) — Primary key — NOT NULL
  • place_id (Foreign Key2) — Foreign key → Place.id — NOT NULL
  • user_course_day_id (Foreign Key) — Foreign key → User_Course_Day.id — NOT NULL
  • place_order (Field)

Place (장소)

  • id (Key) — Primary key — NOT NULL
  • posX (Field)
  • posY (Field2)
  • name (Field3)
  • mainImg (Field4)
  • content (Field5)

User (유저)

  • id (Key) — Primary key — NOT NULL
  • nickname (Field)
  • email (Field2)
  • password (Field3)
  • refreshToken (Field4)
  • Field5

User_Course (유저_경로)

  • id (Key) — Primary key — NOT NULL
  • user_id (Foreign Key) — Foreign key → User.id — NOT NULL
  • name (Field)

User_Course_Day (Untitled)

  • id (key) — Primary key — NOT NULL
  • user_course_id (Foreign Key) — Foreign key → User_Course.user_id — NOT NULL
  • day_num (Field)

Video (비디오)

  • id (Key) — Primary key — NOT NULL
  • place_id (Foreign Key) — Foreign key → Place.id — NOT NULL
  • title (Field)
  • content (Field2)
  • url (Field3)
  • likes_count (Field4)
  • tag (Field5)

Video_Like (비디오 좋아요)

  • id (Key) — Primary key — NOT NULL
  • user_id (Foreign Key) — Foreign key → User.id — NOT NULL
  • id (Key2) — Foreign key → Video.id — NOT NULL
  • id (Key22) — Foreign key → Video.place_id — NOT NULL