CREATE TABLE IF NOT EXISTS student_journal_tb (
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    class_id INT UNSIGNED NOT NULL,
    student_id INT UNSIGNED NOT NULL,
    session_date DATE NOT NULL,
    session_number SMALLINT UNSIGNED NOT NULL,
    note TEXT NOT NULL,
    is_completed TINYINT(1) NOT NULL DEFAULT 0,
    status TINYINT NOT NULL DEFAULT 1,
    date_created DATETIME NOT NULL,
    date_updated DATETIME NULL,
    user_created VARCHAR(255) NULL,
    user_updated VARCHAR(255) NULL,
    PRIMARY KEY (id),
    UNIQUE KEY uq_student_journal_entry (class_id, student_id, session_date),
    KEY idx_student_journal_class_session (class_id, session_date, status),
    KEY idx_student_journal_student (student_id, status)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;