dada

Tables (13)

assignments

  • id — VARCHAR(255)
  • class_id — VARCHAR(255) — NOT NULL
  • session_id — VARCHAR(255)
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT — NOT NULL
  • type — ENUM('homework', 'project', 'presentation', 'report') — NOT NULL
  • max_score — INT — NOT NULL
  • due_date — TIMESTAMP — NOT NULL
  • assigned_date — TIMESTAMP
  • instructions — TEXT
  • materials — JSON
  • status — ENUM('active', 'completed', 'overdue') — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

class_sections

  • id — VARCHAR(255)
  • name — VARCHAR(50) — NOT NULL
  • class_id — VARCHAR(255) — NOT NULL
  • max_capacity — INT — NOT NULL
  • instructor — VARCHAR(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

class_sessions

  • id — VARCHAR(255)
  • class_id — VARCHAR(255) — NOT NULL
  • session_number — INT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • date — DATE — NOT NULL
  • topic — VARCHAR(200) — NOT NULL
  • description — TEXT
  • duration — INT — NOT NULL
  • status — ENUM('scheduled', 'in_progress', 'completed', 'cancelled') — NOT NULL
  • materials — JSON
  • homework — TEXT
  • notes — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

class_statistics

  • id — VARCHAR(255)
  • class_id — VARCHAR(255) — NOT NULL
  • period_start — DATE — NOT NULL
  • period_end — DATE — NOT NULL
  • total_sessions — INT — NOT NULL
  • average_attendance_rate — DECIMAL(5,2) — NOT NULL
  • total_students — INT — NOT NULL
  • active_students — INT — NOT NULL
  • dropout_students — INT — NOT NULL
  • average_score — DECIMAL(5,2)
  • average_gpa — DECIMAL(3,2)
  • highest_score — DECIMAL(5,2)
  • lowest_score — DECIMAL(5,2)
  • pass_rate — DECIMAL(5,2)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

classes

  • id — VARCHAR(255)
  • name — VARCHAR(100) — NOT NULL
  • school — VARCHAR(100) — NOT NULL
  • grade — INT — NOT NULL
  • subject — VARCHAR(100) — NOT NULL
  • teacher — VARCHAR(100) — NOT NULL
  • description — TEXT
  • schedule — JSON
  • max_capacity — INT — NOT NULL
  • tags — JSON
  • status — ENUM('active', 'inactive', 'completed') — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

exams

  • id — VARCHAR(255)
  • class_id — VARCHAR(255) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • type — ENUM('quiz', 'midterm', 'final', 'pop_quiz') — NOT NULL
  • max_score — INT — NOT NULL
  • duration — INT — NOT NULL
  • exam_date — TIMESTAMP — NOT NULL
  • location — VARCHAR(100)
  • instructions — TEXT
  • topics — JSON
  • status — ENUM('scheduled', 'in_progress', 'completed', 'cancelled') — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

grades

  • id — VARCHAR(255)
  • student_id — VARCHAR(255) — NOT NULL
  • class_id — VARCHAR(255) — NOT NULL
  • session_id — VARCHAR(255)
  • assignment_id — VARCHAR(255)
  • exam_id — VARCHAR(255)
  • type — ENUM('quiz', 'assignment', 'midterm', 'final', 'participation', 'homework', 'project', 'presentation') — NOT NULL
  • score — DECIMAL(5,2) — NOT NULL
  • max_score — DECIMAL(5,2) — NOT NULL
  • percentage — DECIMAL(5,2) — NOT NULL
  • grade — VARCHAR(5) — NOT NULL
  • feedback — TEXT
  • submitted_at — TIMESTAMP
  • graded_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

memo_links

  • id — VARCHAR(255)
  • memo_id — VARCHAR(255) — NOT NULL
  • student_id — VARCHAR(255)
  • class_id — VARCHAR(255)
  • link_type — ENUM('student', 'class') — NOT NULL
  • CHECK — ( (link_type = 'student' AND student_id IS NOT NULL AND class_id IS NULL) — NOT NULL

memos

  • id — VARCHAR(255)
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • tags — JSON
  • school — VARCHAR(100)
  • selected_class — VARCHAR(255)
  • selected_student — VARCHAR(255)
  • author — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

session_attendances

  • id — VARCHAR(255)
  • session_id — VARCHAR(255) — NOT NULL
  • section_id — VARCHAR(255)
  • attendance_rate — DECIMAL(5,2) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

student_attendances

  • id — VARCHAR(255)
  • session_attendance_id — VARCHAR(255) — NOT NULL
  • student_id — VARCHAR(255) — NOT NULL
  • status — ENUM('present', 'absent', 'late', 'excused') — NOT NULL
  • check_in_time — TIMESTAMP
  • notes — TEXT

student_class_enrollments

  • id — VARCHAR(255)
  • student_id — VARCHAR(255) — NOT NULL
  • class_id — VARCHAR(255) — NOT NULL
  • section_id — VARCHAR(255)
  • enrolled_at — TIMESTAMP
  • status — ENUM('active', 'dropped', 'completed') — NOT NULL
  • notes — TEXT

students

  • id — VARCHAR(255)
  • name — VARCHAR(100) — NOT NULL
  • school — VARCHAR(100) — NOT NULL
  • grade — INT — NOT NULL
  • department — VARCHAR(100)
  • phone_number — VARCHAR(20)
  • email — VARCHAR(100)
  • parent_contact — VARCHAR(20)
  • tags — JSON
  • image_url — VARCHAR(255)
  • status — ENUM('active', 'inactive', 'graduated') — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP