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