1
Tables (7)
class
- class_id — TINYINT
- school_year_id — TINYINT — NOT NULL
- teacher_id — INT — NOT NULL
- teacher_assigned_at — DATE — NOT NULL
- class_name — VARCHAR(50)
- use_flag — BOOLEAN — NOT NULL
grade
- lecture_id — INT
- student_id — INT
- grade — TINYINT — NOT NULL
lecture
- lecture_id — INT
- subject_id — TINYINT — NOT NULL
- lecture_begin_at — DATE — NOT NULL
- teacher_id — INT — NOT NULL
- school_year_id — TINYINT — NOT NULL
school_year
- school_year_id — TINYINT
- school_year_name — VARCHAR(50)
student
- student_id — INT
- class_id — TINYINT
- student_number — TINYINT
- gender — ENUM('M', 'F')
- entrance_date — DATE — NOT NULL
- graduate_date — DATE
subject
- subject_id — TINYINT
- subject_name — VARCHAR(50)
teacher
- teacher_id — INT
- teacher_name — VARCHAR(50)