gardenERD
Tables (10)
ConnectedUser (connected_users)
- id (Key) — PK — Primary key — NOT NULL
- mentorPostId (Key2) — PK — Foreign key → MentorPost.id — NOT NULL
- menteeUserId (UID2) — PK — Foreign key → User.id — NOT NULL
- createdAt (Field) — NN
- modifiedAt (Field2)
- deletedAt (Field4)
- isDeleted (Field3) — NN
Interest (interests)
- id (Key) — PK — Primary key — NOT NULL
- tag (Field) — NN
- createdAt (Field2) — NN
- modifiedAt (Field3)
- deletedAt (Field5)
- isDeleted (Field4) — NN
MentorPost (mentor_posts)
- id (Key) — PK — Primary key — NOT NULL
- writer (UID) — PK — Foreign key → User.id — NOT NULL
- title (Field2) — NN
- content (Field3)
- state (Field7) — NN
- createdAt (Field4) — NN
- modifiedAt (Field5)
- deletedAt (Field)
- isDeleted (Field6) — NN
NotConnectedRegisterUser (not_connected_register_users)
- id (Key) — PK — Primary key — NOT NULL
- mentorPostId (Key4) — PK — Foreign key → MentorPost.id — NOT NULL
- menteeUserId (Key3) — PK — Foreign key → User.id — NOT NULL
- state (Field) — NN
- createdAt (Field2) — NN
- modifiedAt (Field3)
- deletedAt (Field4)
- isDeleted (Field5) — NN
Subtitle (subtitles)
- id (Key) — PK — Primary key — NOT NULL
- videoId (Key2) — PK — Foreign key → Video.id — NOT NULL
- korSubtitleContent (Field)
- engSubtitleContent (Field2)
- korStartTime (Field3)
- engStartTime (Field4)
- korEndTime (Field5)
- engEndTIme (Field6)
- createdAt (Field7) — NN
- modifiedAt (Field8)
- deletedAt (Field9)
- isDeleted (Field10) — NN
User (user)
- id (Key) — PK — Primary key — NOT NULL
- firstName (Field) — NN
- lastName (Field2) — NN
- email (Field3) — NN
- password (Field4) — NN
- country (Field5) — NN
- introduction (Field6)
- birthtime (Field7) — NN
- profileImage (Field8)
- phonenumber (Field14) — NN
- role (Field9) — NN
- createdAt (Field10) — NN
- modifiedAt (Field11) — NN
- deletedAt (Field12) — NN
- isDeleted (Field13) — NN
UserInterest (user_interests)
- id (Key) — PK — Primary key — NOT NULL
- userId (Key2) — PK — Foreign key → User.id — NOT NULL
- interestId (Key3) — PK — Foreign key → Interest.id — NOT NULL
- createdAt (Field) — NN
- modifiedAt (Field2)
- deletedAt (Field3)
- isDeleted (Field4) — NN
Video (videos)
- id (Key) — PK — Primary key — NOT NULL
- videoUrl (Field) — NN
- videoInfo (Field2) — NN
- videoStartTime (Field3) — NN
- videoEndTime (Field4) — NN
- videoThumbnail (Field9) — NN
- createdAt (Field5) — NN
- modifiedAt (Field6)
- deletedAt (Field7)
- isDeleted (Field8) — NN
VideoHistory (video_histories)
- id (Key) — PK — Primary key — NOT NULL
- userId (Key2) — PK — Foreign key → User.id — NOT NULL
- videoId (Key3) — PK — Foreign key → Video.id — NOT NULL
- createdAt (Field) — NN
- modifiedAt (Field2)
- deletedAt (Field3)
- isDeleted (Field4) — NN
VideoInterest (video_interests)
- id (Key) — PK — Primary key — NOT NULL
- interestId (Key2) — PK — Foreign key → Interest.id — NOT NULL
- videoId (Key3) — PK — Foreign key → Video.id — NOT NULL
- createdAt (Field) — NN
- modifiedAt (Field2)
- deletedAt (Field3)
- isDeleted (Field4) — NN