Hacker-School

Tables (7)

Country (Untitled5)

  • countryId — Primary key — NOT NULL
  • Name — string — NOT NULL

Evaluation (Untitled6)

  • evaluationId — int — Primary key — NOT NULL
  • Score — int
  • Pronunciation — int
  • Fluency — int
  • Integrity — int
  • Rhythm — int
  • Speed — int
  • createdAt — date
  • transcriptId — int — Foreign key → Transcript.transcriptId — NOT NULL
  • UserId — int — Foreign key → User.UserId — NOT NULL

Transcript (Untitled4)

  • transcriptId — int — Primary key — NOT NULL
  • Sentence — string
  • Start — double — NOT NULL
  • Duration — double — NOT NULL
  • soundLink — string — NOT NULL
  • VideoId — int — Foreign key → Video.VideoId — NOT NULL

User (Untitled)

  • UserId — int — Primary key — NOT NULL
  • Name — string
  • Password — string
  • Email — string
  • Nickname — string
  • Social — string
  • createdAt — date — NOT NULL
  • profileImageUrl — string — NOT NULL
  • Introduce — string
  • countryId — Foreign key → Country.countryId — NOT NULL

UserVideo (Untitled3)

  • UserId — int — Foreign key → User.UserId — NOT NULL
  • VideoId — int — Foreign key → Video.VideoId — NOT NULL

Video (Untitled2)

  • VideoId — int — Primary key — NOT NULL
  • Link — string — NOT NULL
  • videoTitle — string — NOT NULL
  • Creator — string — NOT NULL
  • Duration — double — NOT NULL
  • isDefault — bool — NOT NULL
  • Views — int — NOT NULL
  • youtubeViews — int
  • createdAt — date — NOT NULL
  • categoryId — int — Foreign key → VideoCategory.categoryId — NOT NULL

VideoCategory (Untitled7)

  • categoryId — int — Primary key — NOT NULL
  • Name — string