AI-LIT
Tables (16)
activities
- activity_id — UUID
- class_id — UUID
- activity_name — VARCHAR(100)
- description — TEXT
- created_at — TIMESTAMP
attendance
- attendance_id — UUID
- student_id — UUID
- class_id — UUID
- activity_id — UUID
- status — VARCHAR(20)
- attendance_date — DATE
audio_recordings
- audio_id — UUID
- class_id — UUID
- activity_id — UUID
- file_url — TEXT — NOT NULL
- recorded_at — TIMESTAMP
boards
- board_id — UUID
- class_id — UUID
- title — VARCHAR(255)
- created_at — TIMESTAMP
classes
- class_id — UUID
- class_name — VARCHAR(100) — NOT NULL
- grade — VARCHAR(50)
- created_at — TIMESTAMP
comments
- comment_id — UUID
- post_id — UUID
- author_id — UUID
- author_type — VARCHAR(20)
- comment — TEXT — EX
- created_at — TIMESTAMP
media_files
- file_id — UUID
- owner_id — UUID
- owner_type — VARCHAR(20)
- file_url — TEXT — NOT NULL
- file_type — VARCHAR(20)
- uploaded_at — TIMESTAMP
parents
- parent_id — UUID
- full_name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100)
- phone — VARCHAR(20)
- created_at — TIMESTAMP
posts
- post_id — UUID
- board_id — UUID
- author_id — UUID
- author_type — VARCHAR(20)
- content — TEXT
- created_at — TIMESTAMP
qna
- qna_id — UUID
- question — TEXT — NOT NULL
- student_id — UUID
- created_at — TIMESTAMP
qna_answers
- answer_id — UUID
- qna_id — UUID
- teacher_id — UUID
- answer — TEXT — NOT NULL
- created_at — TIMESTAMP
scores
- score_id — UUID
- student_id — UUID
- class_id — UUID
- subject — VARCHAR(100)
- score — NUMERIC(5,2)
- exam_date — DATE
students
- student_id — UUID
- full_name — VARCHAR(100) — NOT NULL
- class_id — UUID
- parent_id — UUID
- created_at — TIMESTAMP
system_logs
- log_id — UUID
- user_id — UUID
- action — TEXT
- created_at — TIMESTAMP
teacher_classes
- id — UUID
- teacher_id — UUID
- class_id — UUID
teachers
- teacher_id — UUID
- full_name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100)
- phone — VARCHAR(20)
- created_at — TIMESTAMP