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