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