Assignment
Tables (7)
Class
- Class ID (classID) — VARCHAR(20) — Primary key — NOT NULL
- Class'name (className) — VARCHAR(200)
- Description (description) — VARCHAR(1000)
- Practice days,hours (schedule) — VARCHAR(100)
- Price ( in $) (price) — FLOAT
- Maximun students in a class (maxStudent) — INT
- Period (in days) (period) — INT
- Genre of Class (genre) — VARCHAR(50)
- Difficult Level (difficulty) — VARCHAR(50)
- Mentor ID (mentorID) — VARCHAR(20) — Foreign key → Mentor.Mentor ID — NOT NULL
Dance Session (DanceSession)
- Dance Session ID (sessionID) — VARCHAR(25) — Primary key — NOT NULL
- Overall Score (score) — FLOAT
- Session TimeStamp (playAt) — TIMESTAMP
- VideoID (videoID) — VARCHAR(50) — Foreign key → Video.Video ID — NOT NULL
- User ID (userID) — VARCHAR(20) — Foreign key → User.User ID — NOT NULL
Feedback Detail (Evaluation)
- Feedback ID (feedbackID) — VARCHAR(25) — Primary key — NOT NULL
- timestamp of error movement (timestamp) — INT
- error part (bodypart) — VARCHAR(20)
- Error Type (error_type) — VARCHAR(50)
- is this move correct? (isCorrect) — Boolean — NOT NULL
- Dance Session ID (sessionID) — VARCHAR(25) — Foreign key → Dance Session.Dance Session ID — NOT NULL
Mentor
- Mentor ID (userID) — VARCHAR(20) — Foreign key → User.User ID — NOT NULL
- Biography (bio) — VARCHAR(1000)
- Certificates URL (certificate) — VARCHAR(200)
- Year of Experience (experience) — FLOAT
- Rating for Students (rating) — FLOAT
Subscription
- Subscription ID (subscriptionID) — VARCHAR(20) — Primary key — NOT NULL
- User ID (userID) — VARCHAR(20) — Foreign key → User.User ID — NOT NULL
- Class ID (classID) — VARCHAR(20) — Foreign key → Class.Class ID — NOT NULL
User
- User ID (userID) — VARCHAR(20) — Primary key — NOT NULL
- User's Display Name (username) — VARCHAR(30)
- Password (password) — VARCHAR(30)
- User Email (email) — VARCHAR(100) UNIQUE
- Full Name (fullname) — VARCHAR(100)
- Experience Level (experience) — VARCHAR(20)
- createAt — DATE
Video
- Video ID (videoID) — VARCHAR(50) — Primary key — NOT NULL
- Video title (title) — VARCHAR(200)
- Duration of Video session (duration) — FLOAT
- Genre of Video (genre) — VARCHAR(50)
- Difficulty of Video (difficulty) — VARCHAR(50)
- Keypoint Data (keypointData) — VARCHAR(10)
- Class ID (classID) — VARCHAR(20) — Foreign key → Class.Class ID