Takma
Tables (12)
attendance
- attendance_id — BIGINT — Primary key — NOT NULL
- student_id — BIGINT — Foreign key → student.student_id — NOT NULL
- attendance_date — DATE — NOT NULL
- check_in_at — TIMESTAMP
- check_out_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
book
- book_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- school_level — VARCHAR(20) — NOT NULL
- grade — SMALLINT — NOT NULL
- semester — SMALLINT
- total_page — INT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
daily_learning
- daily_learning_id — BIGINT — Primary key — NOT NULL
- daily_study_id — BIGINT — Foreign key → daily_study.daily_study_id — NOT NULL
- learning_type — VARCHAR(30) — NOT NULL
- student_book_id — BIGINT — Foreign key → student_book.student_book_id
- content — VARCHAR(255)
- duration_minutes — INT
- difficulty — VARCHAR(20)
- start_page — INT
- target_page — INT
- end_page — INT
- target_problem_count — INT
- solved_problem_count — INT
- correct_problem_count — INT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
daily_study
- daily_study_id — BIGINT — Primary key — NOT NULL
- student_id — BIGINT — Foreign key → student.student_id — NOT NULL
- study_date — DATE — NOT NULL
- concentration — SMALLINT
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
homework
- homework_id — BIGINT — Primary key — NOT NULL
- daily_study_id — BIGINT — Foreign key → daily_study.daily_study_id — NOT NULL
- student_book_id — BIGINT — Foreign key → student_book.student_book_id
- homework_type — VARCHAR(30) — NOT NULL
- start_page — INT
- end_page — INT
- problem_count — INT
- content — VARCHAR(255)
- status — VARCHAR(20) — NOT NULL
- completed_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
notification
- notification_id — BIGINT — Primary key — NOT NULL
- student_id — BIGINT — Foreign key → student.student_id — NOT NULL
- parent_id — BIGINT — Foreign key → parents.parent_id — NOT NULL
- notification_type — VARCHAR(30) — NOT NULL
- attendance_id — BIGINT — Foreign key → attendance.attendance_id
- daily_study_id — BIGINT — Foreign key → daily_study.daily_study_id
- status — VARCHAR(20) — NOT NULL
- sent_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
parents
- parent_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- relationship — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
schedule
- schedule_id — BIGINT — Primary key — NOT NULL
- student_id — BIGINT — Foreign key → student.student_id — NOT NULL
- day_of_week — VARCHAR(10) — NOT NULL
- start_time — TIME — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
staff
- staff_id — BIGINT — Primary key — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
student
- student_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- student_pin — VARCHAR(4) — NOT NULL
- school_level — VARCHAR(20) — NOT NULL
- grade — SMALLINT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
student_book
- student_book_id — BIGINT — Primary key — NOT NULL
- student_id — BIGINT — Foreign key → student.student_id — NOT NULL
- book_id — BIGINT — Foreign key → book.book_id — NOT NULL
- current_page — INT
- status — VARCHAR(20) — NOT NULL
- started_at — DATE
- completed_at — DATE
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
student_parent
- student_parent_id — BIGINT — Primary key — NOT NULL
- student_id — BIGINT — Foreign key → student.student_id — NOT NULL
- parent_id — BIGINT — Foreign key → parents.parent_id — NOT NULL
- is_primary — BOOLEAN — NOT NULL
- receive_notification — BOOLEAN — NOT NULL