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