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