skala_practice
Tables (10)
Assignment
- assignment_id — long — Primary key — NOT NULL
- title — varchar(64)
- description — varchar(240)
- due_date — datetime
- created_at — datetime
- course_id — long — Foreign key → Course.course_id — NOT NULL
Assignment_Submit
- assignment_submit_id — long — Primary key — NOT NULL
- submitted_at — datetime
- score — int
- student_id — long — Foreign key → Student.student_id — NOT NULL
- assignment_id — long — Foreign key → Assignment.assignment_id — NOT NULL
Attendence
- attendence_id — long — Primary key — NOT NULL
- attendence_date — datetime
- status — Enum(PRESENT/ ABSENT/ LATE)
- created_at — datetime
- student_id — long — Foreign key → Student.student_id — NOT NULL
- course_id — long — Foreign key → Course.course_id — NOT NULL
Course
- course_id — long — Primary key — NOT NULL
- title — varchar(64)
- start_date — datetime
- end_date — datetime
- level — int
- created_at — datetime
- instructor_id — long — Foreign key → Instructor.instructor_id — NOT NULL
- manager_id — long — Foreign key → Manager.manager_id — NOT NULL
Course_Enrollment
- course_enrollment_id — long — Primary key — NOT NULL
- enrolled_at — datetime
- student_id — long — Foreign key → Student.student_id — NOT NULL
- course_id — long — Foreign key → Course.course_id — NOT NULL
Description
- description_id — long — Primary key — NOT NULL
- content — varchar(240)
- created_at — datetime
- updated_at — datetime
- course_id — long — Foreign key → Course.course_id — NOT NULL
Instructor
- instructor_id — long — Primary key — NOT NULL
- name — varchar(64)
- email — varchar(64)
- phone — varchar(64)
- created_at — datetime
Manager
- manager_id — long — Primary key — NOT NULL
- name — varchar(64)
- email — varchar(64)
- phone — varchar(64)
- created_at — datetime
Review
- review_id — long — Primary key — NOT NULL
- rating — int
- content — varchar(240)
- created_at — datetime
- student_id — long — Foreign key → Student.student_id — NOT NULL
- course_id — long — Foreign key → Course.course_id — NOT NULL
Student
- student_id — long — Primary key — NOT NULL
- name — varchar(64)
- email — varchar(64)
- phone — varchar(64)
- created_at — datetime