gradi
Tables (15)
Academy (academy)
- academy_id (Key) — Primary key — NOT NULL
- academy_name (Field)
- academy_code (Field2)
- academy_email (Field3)
- academy_phone (Field4)
- academy_website (Field5)
- academy_description (Field6)
- academy_road_address (Field7)
- academy_detail_address (Field8)
- academy_Latitude (Field9)
AcademyImage
- academy_image_id (Key) — Primary key — NOT NULL
- is_main_image (Field)
- academy_code (Field2)
- academy_image_url (Field3)
AcademySchedule
- academy_schedule_id (Key) — Primary key — NOT NULL
- academy_code (Field)
- day_of_week (Field2)
- start_time (Field3)
- end_time (Field4)
AcademyUser (userAcademy)
- academy_user_id (Key) — Primary key — NOT NULL
- class_id (Key2) — Foreign key → Class.class_id — NOT NULL
- academy_id (Key22) — Foreign key → Class.academy_id — NOT NULL
- user_id (Key4) — Foreign key → User.user_id — NOT NULL
- register_status (Field3)
- learner_id (Field2)
Assesment
- assess_id (Key) — Primary key — NOT NULL
- book_id (Field9)
- assigner_id (Field10)
- assignee_id (Field11)
- assess_deadline (Field2)
- assess_name (Field)
- assess_type (Field3)
- assess_status (Field6)
- assess_start_page (Field7)
- assess_end_page (Field8)
- created_at (Field4)
- updated_at (Field5)
Book (Untitled)
- book_id (Key) — Primary key — NOT NULL
- book_name (Field)
- book_publication_year (Field2)
- book_grade (Field3)
- book_page (Field4)
- question_count (Field5)
Chapter (chapter)
- chapter_id (Key) — Primary key — NOT NULL
- book_id (Key2) — Foreign key → Book.book_id — NOT NULL
- main_chapter_number (Field2)
- sub_chapter_number (Field3)
- main_chapter_name (Field)
- sub_chapter_name (Field4)
Class (class)
- class_id (Key) — Primary key — NOT NULL
- academy_id (Key2) — Foreign key → Academy.academy_id — NOT NULL
- class_name (Field2)
- class_grade (Field4)
- class_code (Field)
GradingHistory
- history_id — BIGINT — Primary key
- student_response_id (Key) — Foreign key → StudentResponse.student_response_id — NOT NULL
- total_score (score) — INT
- graded_at — TIMESTAMP
- grader_id — BIGINT
Question
- question_id (Key) — Primary key — NOT NULL
- chapter_id (Key2) — Foreign key → Chapter.chapter_id — NOT NULL
- page (Field7)
- point (Field5)
- question_number (Field)
- sub_question_number (Field2)
- answer (Field3)
- answer_count (Field4)
Student
- student_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
- student_name (Field3)
- student_grade (Field2)
- student_level (Field)
StudentAnswer
- student_answer_id (Key) — Primary key — NOT NULL
- student_response_id (Key2) — Foreign key → StudentResponse.student_response_id — NOT NULL
- chapter_id (Key22) — Foreign key — NOT NULL
- academy_user_id (Key222) — Foreign key — NOT NULL
- page (Field8)
- question_number (Field)
- sub_question_number (Field2)
- answer (Field3)
- is_correct (Field5)
- score (Field6)
- updated_at (Field4)
- created_at (Field7)
StudentResponse
- student_response_id (Key) — Primary key — NOT NULL
- academy_user_id (Key2) — Foreign key → AcademyUser.academy_user_id — NOT NULL
- assess_id (Key3) — Foreign key → Assesment.assess_id — NOT NULL
- book_id (Field3)
- unrecognized_response_count (Field4)
- response_start_page (Field5)
- response_end_page (Field6)
- created_at (Field)
- updated_at (Field2)
Teacher
- teacher_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
- teacher_description (Field5)
- teacher_name (Field)
User
- user_id (Key) — Primary key — NOT NULL
- account_id (Field6)
- email (Field)
- phone_number (Field7)
- password (Field2)
- name (Field3)
- created_at (Field4)
- updated_at (Field5)