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