T78
Tables (54)
tbl_answer (Câu trả lời)
- answer_id (Key) — integer — Primary key — NOT NULL
- question_id (Key2) — integer — Foreign key → tbl_question.question_id — NOT NULL
- document_id (Key22) — integer — Foreign key → tbl_question.document_id — NOT NULL
- capacity_assessment_part_id (Key222) — integer — Foreign key → tbl_question.capacity_assessment_part_id — NOT NULL
- capacity_assessment_id (Key2222) — integer — Foreign key → tbl_question.capacity_assessment_id — NOT NULL
- content (Field) — string
- is_correct (Field2) — boolean — true là câu trả lời đúng. false là câu hỏi sai
tbl_capacity_assessment (Ngân hàng câu hỏi)
- capacity_assessment_id (Key) — integer — Primary key — NOT NULL
- type (Field) — string — LISTEN || READ || WRITE || SPEAK
- description (Field2) — string
- time_to_do (Field3) — integer — Đơn vị tính bằng phút
tbl_capacity_assessment_exam (Bài thi)
- capacity_assessment_exam_id (Key) — integer — Primary key — NOT NULL
- capacity_assessment_id (Key2) — integer — Foreign key → tbl_capacity_assessment.capacity_assessment_id — NOT NULL
- capacity_assessment_period_id (Field) — integer
- is_start (Field2) — boolean — Giám thị đã bắt đầu cho làm bài chưa
- time_start (Field3) — string — Thời gian bắt đầu được phép làm bài
- date_start (Field7) — string — Ngày tổ chức thi
- staff_id_1 (Field4) — integer — Giám thị coi thi 1
- staff_id_2 (Field5) — integer — Giám thị coi thi 2
- staff_id_3 (Field6) — integer — Giám thị coi thi 3
tbl_capacity_assessment_exam_code (Đề thi)
- capacity_assessment_exam_code_id (Key) — integer — Primary key — NOT NULL
- capacity_assessment_exam_id (Key2) — integer — Foreign key → tbl_capacity_assessment_exam.capacity_assessment_exam_id — NOT NULL
- capacity_assessment_id (Key22) — integer — Foreign key → tbl_capacity_assessment_exam.capacity_assessment_id — NOT NULL
- exam_code (Field) — string
- time (Field3) — integer — Đơn vị tính bằng phút
- description (Field2) — string — Hướng dẫn làm bài
tbl_capacity_assessment_part (Phần thi)
- capacity_assessment_part_id (Key) — integer — Primary key — NOT NULL
- capacity_assessment_id (Key2) — integer — Foreign key → tbl_capacity_assessment.capacity_assessment_id — NOT NULL
- title (Field) — string — VD: Phần 1: Viết chính tả ...
- content (Field2) — string — VD: Đọc hiểu có 15 câu ...
tbl_capacity_assessment_period (Kỳ thi)
- capacity_assessment_period_id (Key) — integer — Primary key — NOT NULL
- name (Field) — string — Tên kỳ thi
- period_name (Field5) — string — Khóa thi ngày
- display_name (Field4) — string — Tên hiển thị
- exam_subject (Field6) — string — Đối tượng dự thi
- is_finish (Field7) — boolean — true: Đã kết thúc, false chưa kết thúc
- is_delete (Field2) — boolean — true: Đã xóa || false: chưa xóa
tbl_coefficient (Hệ số điểm)
- coefficient_id — Primary key — NOT NULL
- coefficient_code — string
- coefficient_name — string
- first_create_id — string
- last_update_id — string
- first_create_at — datetime
- last_update_at — datetime
- is_deleted — boolean
tbl_document (Tài liệu)
- document_id (Key) — integer — Primary key — NOT NULL
- capacity_assessment_part_id (Key2) — integer — Foreign key → tbl_capacity_assessment_part.capacity_assessment_part_id — NOT NULL
- capacity_assessment_id (Key22) — integer — Foreign key → tbl_capacity_assessment_part.capacity_assessment_id — NOT NULL
- document_number (Field7) — integer — Đọc và Viết
- document_number_from (Field5) — Integer — Nghe và Nói
- document_number_to (Field6) — Integer — Nghe và Nói
- type (Field) — string — AUDIO || TEXT || IMG || V
- file_path (Field2) — string — Nếu type == AUDIO thì file_path != null
- file_content (Field4) — string — Nội dung của file âm thanh
- content (Field3) — string
tbl_enrollment_class (Thông tin lớp học)
- enrollment_class_id — integer — Primary key — NOT NULL
- enrollment_class_name — string
- enrollment_numerical_order — integer
- is_finished — boolean
- first_create_id — string
- last_update_id — string
- first_create_at — datetime
- last_update_at — datetime
- is_deleted — boolean
tbl_enrollment_class_school_year (Quan hệ lớp học)
- enrollment_class_school_year_id — integer — Primary key — NOT NULL
- enrollment_class_id — integer — Foreign key → tbl_enrollment_class.enrollment_class_id — NOT NULL
- school_year_id — integer — Foreign key → tbl_school_year.school_year_id — NOT NULL
- staff_id — integer — Giáo viên chủ nhiệm
- first_create_id — string
- last_update_id — string
- first_create_at — datetime
- last_update_at — datetimeoffset
- is_diligently_lock — boolean
- is_mark_lock — boolean
- is_behavior_lock — boolean
- is_deleted — boolean
tbl_enrollment_class_school_year_staff (Phân công giảng dạy)
- tbl_enrollment_class_school_year_staff_id — integer — Primary key — NOT NULL
- staff_id — integer — Foreign key → tbl_staff.staff_id — NOT NULL
- enrollment_class_school_year_id — integer — Foreign key → tbl_enrollment_class_school_year.enrollment_class_school_year_id — NOT NULL
- first_create_id — string
- last_update_id — string
- first_create_at — datetime
- last_update_at — datetime
- is_deleted — boolean
tbl_enrollment_class_school_year_student (Lớp của học sinh)
- enrollment_class_school_year_student_id — integer — Primary key
- enrollment_class_school_year_id — integer — Foreign key → tbl_enrollment_class_school_year.enrollment_class_school_year_id — NOT NULL
- student_id — integer — Foreign key → tbl_student.student_id — NOT NULL
- first_create_id — string
- last_update_id — string
- first_create_at — datetime
- last_update_at — datetime
- is_deleted — boolean
tbl_enrollment_class_school_year_student_attendance_record (Chuyên cần)
- class_student_attendance_record_date — string — Primary key
- enrollment_class_school_year_student_id — integer — Foreign key → tbl_enrollment_class_school_year_student.enrollment_class_school_year_student_id
- enrollment_class_school_year_id — integer — Foreign key → tbl_enrollment_class_school_year_student.enrollment_class_school_year_id — NOT NULL
- class_student_attendance_record_type — string
- first_create_id — string
- last_update_id — string
- first_create_at — datetime
- last_update_at — datetime
- is_deleted — boolean
tbl_exam_answer (Đề thi - Câu trả lời)
- exam_answer_id (Key) — integer — Primary key — NOT NULL
- exam_question_id (Key2) — integer — Foreign key → tbl_exam_question.exam_question_id — NOT NULL
- exam_document_id (Key22) — integer — Foreign key → tbl_exam_question.exam_document_id — NOT NULL
- exam_capacity_assessment_part_id (Key222) — integer — Foreign key → tbl_exam_question.exam_capacity_assessment_part_id — NOT NULL
- capacity_assessment_exam_code_id (Key2222) — integer — Foreign key → tbl_exam_question.capacity_assessment_exam_code_id — NOT NULL
- capacity_assessment_exam_id (Key22222) — integer — Foreign key → tbl_exam_question.capacity_assessment_exam_id — NOT NULL
- capacity_assessment_id (Key222222) — integer — Foreign key → tbl_exam_question.capacity_assessment_id — NOT NULL
- content (Field) — string
- is_correct (Field2) — boolean — true là câu trả lời đúng. false là câu hỏi sai
tbl_exam_capacity_assessment_part (Đề thi - Phần thi)
- exam_capacity_assessment_part_id (Key) — integer — Primary key — NOT NULL
- capacity_assessment_exam_code_id (Key2) — integer — Foreign key → tbl_capacity_assessment_exam_code.capacity_assessment_exam_code_id — NOT NULL
- capacity_assessment_exam_id (Key22) — integer — Foreign key → tbl_capacity_assessment_exam_code.capacity_assessment_exam_id — NOT NULL
- capacity_assessment_id (Key222) — integer — Foreign key → tbl_capacity_assessment_exam_code.capacity_assessment_id — NOT NULL
- title (Field) — string — VD: Phần 1: Viết chính tả ...
- content (Field2) — string — VD: Đọc hiểu có 15 câu ...
tbl_exam_document (Đề thi - Tài liệu)
- exam_document_id (Key) — integer — Primary key — NOT NULL
- capacity_assessment_part_id (Key2) — integer — Foreign key → tbl_exam_capacity_assessment_part.exam_capacity_assessment_part_id — NOT NULL
- capacity_assessment_exam_code_id (Key22) — integer — Foreign key → tbl_exam_capacity_assessment_part.capacity_assessment_exam_code_id — NOT NULL
- capacity_assessment_exam_id (Key222) — integer — Foreign key → tbl_exam_capacity_assessment_part.capacity_assessment_exam_id — NOT NULL
- capacity_assessment_id (Key2222) — integer — Foreign key → tbl_exam_capacity_assessment_part.capacity_assessment_id — NOT NULL
- document_id (Field4) — integer
- type (Field) — string — AUDIO || TEXT || IMG || V
- file_content (Field5)
- file_path (Field2) — string — Nếu type == AUDIO thì file_path != null
- content (Field3) — string
tbl_exam_question (Đề thi - Câu hỏi)
- exam_question_id (Key) — integer — Primary key — NOT NULL
- exam_document_id (Key2) — integer — Foreign key → tbl_exam_document.exam_document_id — NOT NULL
- exam_capacity_assessment_part_id (Key22) — integer — Foreign key → tbl_exam_document.capacity_assessment_part_id — NOT NULL
- capacity_assessment_exam_code_id (Key222) — integer — Foreign key → tbl_exam_document.capacity_assessment_exam_code_id — NOT NULL
- capacity_assessment_exam_id (Key2222) — integer — Foreign key → tbl_exam_document.capacity_assessment_exam_id — NOT NULL
- capacity_assessment_id (Key22222) — integer — Foreign key → tbl_exam_document.capacity_assessment_id — NOT NULL
- group_uuid (Field7) — string — Bộ câu hỏi
- question_id (Field6) — integer
- type (Field) — string — TEXT || WRITE || AUDIO || SELECT || RECORD
- content (Field2) — string — Chỉ câu hỏi có type = TEXT thì mới có câu trả lời
- question_type (Field4) — string — Loại câu hỏi: Câu hỏi ngắn, câu hỏi dài, ...
- difficulty_level (Field3) — integer — Mức độ khó từ 1 -> 3 (Dễ, TB, Khó)
- capacity_level (Field5) — integer — Bậc năng lực 1 -> 6
- file_path (Field8) — string — Nếu type == AUDIO thì file_path != null
tbl_exam_template (Cấu hình đề mẫu)
- exam_template_id (Key) — integer — Primary key — NOT NULL
- capacity_assessment_id (Key2) — integer — Foreign key → tbl_capacity_assessment.capacity_assessment_id — NOT NULL
- capacity_assessment_period_id (Field) — integer
- time (Field2) — integer — Đơn vị tính bằng phút
- description (Field3) — string
tbl_exam_template_section (Các phần thi)
- exam_template_section_id (Key) — integer — Primary key — NOT NULL
- exam_template_id (Key2) — integer — Foreign key → tbl_exam_template.exam_template_id — NOT NULL
- capacity_assessment_id (Key22) — integer — Foreign key → tbl_exam_template.capacity_assessment_id — NOT NULL
- capacity_assessment_period_id (Field2) — integer
- description (Field) — string
tbl_menu (Menu)
- menu_id — bigint — Primary key — NOT NULL
- first_create_at — datetime(6)
- first_create_id — varchar(255)
- last_update_at — datetime(6)
- last_update_id — varchar(255)
- is_deleted — bit(1)
- menu_name — varchar(255)
- menu_parent_id — bigint
- icon — varchar(255)
- name_router — varchar(255)
tbl_question (Câu hỏi)
- question_id (Key) — integer — Primary key — NOT NULL
- document_id (Key2) — integer — Foreign key → tbl_document.document_id — NOT NULL
- capacity_assessment_part_id (Key22) — integer — Foreign key → tbl_document.capacity_assessment_part_id — NOT NULL
- capacity_assessment_id (Key222) — integer — Foreign key → tbl_document.capacity_assessment_id — NOT NULL
- group_question (Field7) — string — Bộ câu hỏi 1, 2, 3
- type (Field) — string — TEXT || WRITE || AUDIO || SELECT || RECORD
- content (Field2) — string — Chỉ câu hỏi có type = TEXT thì mới có câu trả lời
- question_type (Field4) — string — Loại câu hỏi: Câu hỏi ngắn, câu hỏi dài, ...
- difficulty_level (Field3) — integer — Mức độ khó từ 1 -> 3 (Dễ, TB, Khó)
- capacity_level (Field5) — integer — Bậc năng lực 1 -> 6
- status (Field6) — integer — 0 : Đã duyệt || 1: Chưa duyệt || 2: Cần sửa
- file_path (Field8) — string — Nếu type == AUDIO thì file_path != null
tbl_question_detail_template (Cấu trúc câu hỏi từng phần)
- question_detail_template_id (Key) — integer — Primary key — NOT NULL
- exam_template_section_id (Key2) — integer — Foreign key → tbl_exam_template_section.exam_template_section_id — NOT NULL
- exam_template_id (Key22) — integer — Foreign key → tbl_exam_template_section.exam_template_id — NOT NULL
- capacity_assessment_id (Key222) — integer — Foreign key → tbl_exam_template_section.capacity_assessment_id — NOT NULL
- question_group_id (Field6) — integer
- capacity_assessment_period_id (Field7) — integer
- question_type (Field) — string — Loại câu hỏi: Câu hỏi ngắn, câu hỏi dài, ...
- difficulty_level (Field2) — integer — Mức độ khó từ 1 -> 3 (Dễ, TB, Khó)
- capacity_level (Field3) — integer — Bậc năng lực 1 -> 6
- skill_id (Field4) — string — LISTEN || READ || WRITE || SPEAK
- capacity_assessment_part_id (Field5) — integer — Phần thi
tbl_question_rq (Yêu cầu tạo câu hỏi)
- question_rq_id (Key) — integer — Primary key — NOT NULL
- question_id (Key2) — integer — Foreign key → tbl_question.question_id — NOT NULL
- document_id (Key22) — integer — Foreign key → tbl_question.document_id — NOT NULL
- capacity_assessment_part_id (Key222) — integer — Foreign key → tbl_question.capacity_assessment_part_id — NOT NULL
- capacity_assessment_id (Key2222) — integer — Foreign key → tbl_question.capacity_assessment_id — NOT NULL
- staff_id_1 (Field) — integer — Giáo viên yêu cầu tạo
- staff_id_2 (Field2) — integer — Người phê duyệt
- note (Field3) — string
tbl_regis_number (Số báo danh)
- regis_number_id (Key) — integer — Primary key — NOT NULL
- capacity_assessment_period_id (Key2) — integer — Foreign key → tbl_capacity_assessment_period.capacity_assessment_period_id — NOT NULL
- prefix (Field) — string — Tiền tố
- start_number (Field2) — string — Giá trị bắt đầu
tbl_role (Quyền)
- role_id — integer — Primary key — NOT NULL
- role_name — string
- first_create_id — string
- last_update_id — string
- first_create_at — datetime
- last_update_at — datetime
- is_deleted — boolean
tbl_role_menu (Phân quyền menu)
- menu_id — bigint — Foreign key → tbl_menu.menu_id — NOT NULL
- role_id — integer — Foreign key → tbl_role.role_id — NOT NULL
tbl_role_menu_api (Phân quyền API)
- menu_id — bigint — Foreign key → tbl_role_menu.menu_id — NOT NULL
- role_id — bigint — Foreign key → tbl_role_menu.role_id — NOT NULL
- endpoint — string
tbl_school_year (Năm học)
- school_year_id — integer — Primary key — NOT NULL
- date_start — datetime
- date_end — datetime
- is_finished — boolean
- first_create_id — string
- last_update_id — string
- first_create_at — datetime
- last_update_at — datetime
- is_deleted — boolean
tbl_staff (Nhân viên)
- staff_id — integer — Primary key — NOT NULL
- user_id — integer — Foreign key → tbl_user.user_id — NOT NULL
- username — string
- position_name — string
- staff_status_name — string
- position_code — string
- staff_status_code — string
- full_name — string
- date_of_birth — string
- gender — boolean
- address — string
- phone_number — string
- email — string
- citizen_identification — string
- first_create_id — string
- last_update_id — string
- first_create_at — datetime
- last_update_at — datetime
- is_deleted — boolean
tbl_staff_role (Phân quyền nhập)
- staff_id — integer — Foreign key → tbl_staff.staff_id — NOT NULL
- role — string — GVCN, GVBM, RD, LISTEN, READ , WRITE, SPEAK
tbl_student (Học sinh)
- student_id — integer — Primary key — NOT NULL
- user_id — integer — Foreign key → tbl_user.user_id — NOT NULL
- student_category_name — string
- student_level_name — string
- student_status_name — string
- student_category_code — string
- student_level_code — string
- student_status_code — string
- username — string
- full_name — string
- date_of_birth — string
- gender — boolean
- address — string
- phone_number — string
- place_of_birth — string
- first_create_id — string
- last_update_id — string
- first_create_at — datetime
- last_update_at — datetime
- is_deleted — boolean
tbl_student_answer (Câu trả lời của học sinh)
- answer_id (Key) — integer — Primary key — NOT NULL
- student_question_id (Key2) — integer — Foreign key → tbl_student_question.student_question_id — NOT NULL
- student_document_id (Key22) — integer — Foreign key → tbl_student_question.student_document_id — NOT NULL
- student_capacity_assessment_part_id (Key222) — integer — Foreign key → tbl_student_question.student_capacity_assessment_part_id — NOT NULL
- student_capacity_assessment_exam_id (Key3) — integer — Foreign key → tbl_student_question.student_capacity_assessment_exam_id — NOT NULL
- capacity_assessment_exam_code_id (Key4) — integer — Foreign key → tbl_student_question.capacity_assessment_exam_code_id — NOT NULL
- capacity_assessment_exam_id (Key22222) — integer — Foreign key → tbl_student_question.capacity_assessment_exam_id — NOT NULL
- capacity_assessment_id (Key222222) — integer — Foreign key → tbl_student_question.capacity_assessment_id — NOT NULL
- student_exam_id (Key2222) — integer — Foreign key → tbl_student_question.student_exam_id — NOT NULL
- content (Field) — string
- answer (Field5) — string
- file_path (Field4) — string
- is_correct (Field2) — boolean — true là câu trả lời đúng. false là câu hỏi sai
- is_selected (Field3) — boolean — true là được chọn. false là không được chọn
tbl_student_capacity_assessment_exam (Bài thi của học sinh)
- student_capacity_assessment_exam_id (Key3) — integer — Primary key — NOT NULL
- capacity_assessment_exam_code_id (Key) — integer — Foreign key → tbl_capacity_assessment_exam_code.capacity_assessment_exam_code_id — NOT NULL
- capacity_assessment_exam_id (Key22) — integer — Foreign key → tbl_capacity_assessment_exam_code.capacity_assessment_exam_id — NOT NULL
- capacity_assessment_id (Key222) — integer — Foreign key → tbl_capacity_assessment_exam_code.capacity_assessment_id — NOT NULL
- student_exam_id (Key2) — integer — Foreign key → tbl_student_exam.student_exam_id — NOT NULL
- type (Field) — string — LISTEN || READ || WRITE || SPEAK
- date_start (Field3) — Dateime — Thời gian thực tế thí sinh bắt đầu làm bài
- mark (Field2) — double — Nếu là bài thi nghe hoặc đọc sau khi hoàn thành thì sẽ có điểm
- is_finish (Field4) — boolean — true: Đã kết thúc, false chưa kết thúc
tbl_student_capacity_assessment_part (Phần thi của học sinh)
- student_capacity_assessment_part_id (Key) — integer — Primary key — NOT NULL
- student_capacity_assessment_exam_id (Key3) — integer — Foreign key → tbl_student_capacity_assessment_exam.student_capacity_assessment_exam_id — NOT NULL
- capacity_assessment_exam_code_id (Key4) — integer — Foreign key → tbl_student_capacity_assessment_exam.capacity_assessment_exam_code_id — NOT NULL
- capacity_assessment_exam_id (Key22) — integer — Foreign key → tbl_student_capacity_assessment_exam.capacity_assessment_exam_id — NOT NULL
- capacity_assessment_id (Key222) — integer — Foreign key → tbl_student_capacity_assessment_exam.capacity_assessment_id — NOT NULL
- student_exam_id (Key2) — integer — Foreign key → tbl_student_capacity_assessment_exam.student_exam_id — NOT NULL
- title (Field) — string — VD: Phần 1: Viết chính tả ...
- content (Field2) — string — VD: Đọc hiểu có 15 câu ...
tbl_student_document (Tài liệu của học sinh)
- student_document_id (Key) — integer — Primary key — NOT NULL
- student_capacity_assessment_part_id (Key2) — integer — Foreign key → tbl_student_capacity_assessment_part.student_capacity_assessment_part_id — NOT NULL
- student_capacity_assessment_exam_id (Key3) — integer — Foreign key → tbl_student_capacity_assessment_part.student_capacity_assessment_exam_id — NOT NULL
- capacity_assessment_exam_code_id (Key4) — integer — Foreign key → tbl_student_capacity_assessment_part.capacity_assessment_exam_code_id — NOT NULL
- capacity_assessment_exam_id (Key222) — integer — Foreign key → tbl_student_capacity_assessment_part.capacity_assessment_exam_id — NOT NULL
- capacity_assessment_id (Key2222) — integer — Foreign key → tbl_student_capacity_assessment_part.capacity_assessment_id — NOT NULL
- student_exam_id (Key22) — integer — Foreign key → tbl_student_capacity_assessment_part.student_exam_id — NOT NULL
- type (Field) — string — AUDIO || TEXT || IMG || V
- file_path (Field2) — string — Nếu type == AUDIO thì file_path != null
- content (Field3) — string
- file_content (Field4) — string
tbl_student_enrollment_class_cert (Danh hiệu)
- student_enrollment_class_cert_id — integer — Primary key
- enrollment_class_school_year_student_id — integer — Foreign key → tbl_enrollment_class_school_year_student.enrollment_class_school_year_student_id
- name — string
tbl_student_enrollment_class_graduation (Điều kiện tốt nghiệp)
- student_enrollment_class_graduation_id — integer — Primary key
- enrollment_class_school_year_student_id — integer — Foreign key → tbl_enrollment_class_school_year_student.enrollment_class_school_year_student_id
- is_pass — boolean
tbl_student_exam (Đối tượng dự thi)
- student_exam_id (Key) — integer — Primary key — NOT NULL
- capacity_assessment_period_id (Field12) — integer — Kỳ thi
- regis_number (Field11) — string — Số báo danh
- first_name (Field) — string — họ
- last_name (Field2) — string — tên
- gender (Field3) — boolean — giói tính
- date_of_birth (Field4) — string — ngày sinh
- place_of_brith (Field5) — string — Nơi sinh
- country (Field6) — string — Quốc tịch
- student_object (Field7) — string — Đối tượng
- class_name (Field8) — string — Lớp
- student_level_name (Field9) — string — Bậc học
- passport_number (Field10) — string — Hộ chiếu
tbl_student_exam_room (Ca thi)
- student_exam_room_id (Key) — integer — Primary key — NOT NULL
- capacity_assessment_period_id (Key2) — integer — Foreign key → tbl_capacity_assessment_period.capacity_assessment_period_id — NOT NULL
- name (Field) — string — tên ca thi VD: Ca 1, Ca 2, ....
- is_start (Field2) — boolean — true: Đã bắt đầu || false: Chưa bắt đầu
- type (Field3) — string — LISTEN || READ || WRITE || SPEAK
tbl_student_exam_room_skill (Ca thi theo kĩ năng)
- student_exam_id (Key) — integer — Foreign key → tbl_student_exam.student_exam_id — NOT NULL
- student_exam_room_id (Key2) — integer — Foreign key → tbl_student_exam_room.student_exam_room_id — NOT NULL
tbl_student_mark_capacity_assessment (Điểm do GV chấm thi)
- student_mark_capacity_assessment_id (Key) — integer — Primary key — NOT NULL
- student_capacity_assessment_exam_id (Key3) — integer — Foreign key → tbl_student_capacity_assessment_exam.student_capacity_assessment_exam_id — NOT NULL — Bài thi của học sinh
- student_exam_id (Key2) — integer — Foreign key → tbl_student_capacity_assessment_exam.student_exam_id — NOT NULL
- teacher_exam_id_1 (Field5) — integer — GV 1
- teacher_exam_id_2 (Field6) — integer — GV 2
- mark_1 (Field) — double — điểm do GV1 chấm, làm tròn đến 1 số thập phân
- mark_2 (Field2) — double — điểm do GV2 chấm, làm tròn đến 1 số thập phân
- mark_final (Field3) — double — làm tròn đến 1 số thập phân
- status (Field4) — string — Nếu |mark_1 - mark_2| >=1 thì trạng thái là: F ngược lại thì là P
tbl_student_question (Câu hỏi của học sinh)
- student_question_id (Key) — integer — Primary key — NOT NULL
- student_document_id (Key2) — integer — Foreign key → tbl_student_document.student_document_id — NOT NULL
- student_capacity_assessment_part_id (Key22) — integer — Foreign key → tbl_student_document.student_capacity_assessment_part_id — NOT NULL
- student_capacity_assessment_exam_id (Key3) — integer — Foreign key → tbl_student_document.student_capacity_assessment_exam_id — NOT NULL
- capacity_assessment_exam_code_id (Key4) — integer — Foreign key → tbl_student_document.capacity_assessment_exam_code_id — NOT NULL
- capacity_assessment_exam_id (Key2222) — integer — Foreign key → tbl_student_document.capacity_assessment_exam_id — NOT NULL
- capacity_assessment_id (Key22222) — integer — Foreign key → tbl_student_document.capacity_assessment_id — NOT NULL
- student_exam_id (Key222) — integer — Foreign key → tbl_student_document.student_exam_id — NOT NULL
- group_uuid (Field7) — string — Bộ câu hỏi
- topic_type (Field4) — string — LISTEN || READ || WRITE || SPEAK
- type (Field) — string — TEXT || WRITE || AUDIO || SELECT || RECORD
- question_type (Field6) — string — Loại câu hỏi: Câu hỏi ngắn, câu hỏi dài, ...
- content (Field2) — string — Chỉ câu hỏi có type = TEXT thì mới có câu trả lời
- difficulty_level (Field3) — integer — Mức độ khó từ 1 -> 3 (Dễ, TB, Khó)
- capacity_level (Field5) — integer — Bậc năng lực 1 -> 6
- file_path (Field8) — string — Nếu type == AUDIO thì file_path != null
- mark (Field9) — double — Điểm chấm bởi GV1
- mark_2 (Field10) — double — Điểm chấm bởi GV2
- mark_re_score (Field11) — double — Điểm phúc khảo GV1
- mark_re_score_2 (Field12) — double — Điểm phúc khảo GV2
tbl_student_result_exam (Kết quả thi DGNL)
- student_result_exam_id (Key) — integer — Primary key — NOT NULL
- exam_times (Field) — integer
- listen_mark (Field2) — integer
- speak_mark (Field3) — integer
- writer_mark (Field4) — integer
- read_mark (Field5) — integer
- capacity_assessment_period_id (Field6) — integer — Kỳ thi
- regis_number (Field7) — string — Số báo danh
tbl_student_school_year_behavior (Điểm rèn luyện)
- student_school_year_behavior_id — integer — Primary key — NOT NULL
- enrollment_class_school_year_student_id — integer — Foreign key → tbl_enrollment_class_school_year_student.enrollment_class_school_year_student_id
- student_id (student_id2) — integer — Foreign key → tbl_enrollment_class_school_year_student.student_id — NOT NULL
- comment — string
- mark — double
- name — string
- first_create_id — string
- last_update_id — string
- first_create_at — datetime
- last_update_at — datetime
- is_deleted — boolean
tbl_student_school_year_mark (Điểm tổng kết môn học)
- student_school_year_mark_id — integer — Primary key — NOT NULL
- enrollment_class_school_year_student_id — integer — Foreign key → tbl_enrollment_class_school_year_student.enrollment_class_school_year_student_id
- subject_id — integer
- mark — float
- first_create_id — string
- last_update_id — string
- first_create_at — datetime
- last_update_at — datetime
- is_deleted — boolean
tbl_subject (Môn học)
- subject_id — integer — Primary key — NOT NULL
- subject_name — string
- first_create_id — string
- last_update_id — string
- first_create_at — datetime
- last_update_at — datetime
- is_deleted — boolean
tbl_subject_coefficient (Hệ số điểm - môn học)
- enrollment_class_school_year_id — integer — Foreign key → tbl_enrollment_class_school_year.enrollment_class_school_year_id — NOT NULL
- coefficient_id — Foreign key → tbl_coefficient.coefficient_id — NOT NULL
- subject_id — integer — Foreign key → tbl_subject.subject_id — NOT NULL
- coefficient — float
- first_create_id — string
- last_update_id — string
- first_create_at — datetime
- last_update_at — datetime
tbl_subject_student_mark (Điểm môn học)
- subject_student_mark_id — integer — Primary key — NOT NULL
- enrollment_class_school_year_id — integer — Foreign key → tbl_subject_coefficient.enrollment_class_school_year_id — NOT NULL
- coefficient_id — Foreign key → tbl_subject_coefficient.coefficient_id — NOT NULL
- subject_id — integer — Foreign key → tbl_subject_coefficient.subject_id — NOT NULL
- student_school_year_mark_id — integer — Foreign key → tbl_student_school_year_mark.student_school_year_mark_id — NOT NULL
- enrollment_class_school_year_student_id — integer — Foreign key → tbl_enrollment_class_school_year_student.enrollment_class_school_year_student_id
- enrollment_class_student_mark — float
- first_create_id — string
- last_update_id — string
- first_create_at — datetime
- last_update_at — datetime
- is_deleted — boolean
tbl_subject_student_mark_history (Lịch sử nhập điểm)
- subject_student_mark_history_id — integer — Primary key — NOT NULL
- subject_student_mark_id — integer — Foreign key → tbl_subject_student_mark.subject_student_mark_id — NOT NULL
- enrollment_class_student_mark — float
- first_create_id — string
- first_create_at — datetime
- last_update_id — string
- last_update_at — datetime
tbl_teacher_exam (GV chấm thi)
- teacher_exam_id (Key) — integer — Primary key — NOT NULL
- capacity_assessment_period_id (Key2) — integer — Foreign key → tbl_capacity_assessment_period.capacity_assessment_period_id — NOT NULL
- first_name (Field3) — string — Họ
- last_name (Field4) — string — Tên
- gender (Field5) — boolean — giới tính
tbl_teacher_exam_2 (GV phúc khảo)
- teacher_exam_id (Key) — integer — Primary key — NOT NULL
- capacity_assessment_period_id (Key2) — integer — Foreign key → tbl_capacity_assessment_period.capacity_assessment_period_id — NOT NULL
- first_name (Field3) — string — Họ
- last_name (Field4) — string — Tên
- gender (Field5) — boolean — giới tính
tbl_user (Tài khoản)
- user_id — integer — Primary key — NOT NULL
- user_name — string
- user_pass — string
- first_create_id — string
- last_update_id — string
- first_create_at — datetime
- last_update_at — datetime
- is_deleted — boolean
tbl_user_exam (Tài khoản thi và chấm thi)
- user_exam_id (Key) — integer — Primary key — NOT NULL
- username (Field) — string
- password (Field2) — string
- password_decode (Field6) — string
- exam_type (Field3) — string — LISTEN || READ || WRITE || SPEAK
- uuid (Field4) — string
- object_id (Field7) — integer — Khóa chính của bảng tbl_student_exam hoặc tbl_teacher_exam hoặc tbl_teacher_exam_2
- object_type (Field5) — string — STUDENT || TEACHER || TEACHER_2
tbl_user_role (Phân quyền người dùng)
- user_id — integer — Foreign key → tbl_user.user_id — NOT NULL
- role_id — integer — Foreign key → tbl_role.role_id — NOT NULL