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)