test

Tables (12)

Algorithm (algorithm)

  • algorithm_pk — int — Primary key — NOT NULL
  • student_pk — int — Foreign key → Student.student_pk — NOT NULL
  • algorithm_grade — char(2) — NOT NULL
  • algorithm_acquisition_date — datetime — NOT NULL

Attendance (attendace)

  • attendance_pk — int — Primary key — NOT NULL — PK
  • student_pk — int — Foreign key → Student.student_pk — NOT NULL — PK
  • date_pk — int — Foreign key → AttendanceDate.date_pk — NOT NULL
  • attendance — tinyint
  • attendance_sign_in_time (datetime) — datetime
  • attendance_sign_out_time — datetime

AttendanceDate (attendance_date)

  • date_pk — int — Primary key — NOT NULL
  • attendace_date (attendance_date) — char(10) — NOT NULL

Exam (exam)

  • exam_pk — int — Primary key — NOT NULL
  • exam_name

GradeExam (grade_exam)

  • grade_exam_pk — int — Primary key — NOT NULL
  • student_pk — int — Foreign key → Student.student_pk — NOT NULL
  • exam_pk (exam_pk2) — int — Foreign key → Exam.exam_pk — NOT NULL
  • grade_exam_score — int — NOT NULL

GroupTeacher (group_teacher)

  • group_teacher_pk — int — Primary key — NOT NULL — PK
  • group_teacher_id — varchar — NOT NULL
  • group_teacher_name — varchar — NOT NULL
  • group_teacher_hp — varchar — NOT NULL

Student (student)

  • student_pk — int — Primary key — NOT NULL
  • group_teacher_pk — int — Foreign key → GroupTeacher.group_teacher_pk — NOT NULL
  • student_account — varchar(20) — NOT NULL
  • student_name — varchar(20) — NOT NULL
  • student_hp — varchar(20) — NOT NULL
  • student_age — int(3) — NOT NULL
  • student_gender — char(1) — NOT NULL
  • Field (reg_user) — varchar(20) — NOT NULL
  • Field2 (reg_dt) — datetime — NOT NULL
  • Field (last_user) — varchar(20) — NOT NULL
  • Field (last_dt) — datetime — NOT NULL

Untitled (project_team)

  • Key (project_team_pk) — int — Primary key — NOT NULL
  • Key (project_domain_pk) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (project_team_name) — varchar(20) — NOT NULL

Untitled (project_team_student)

  • Key (idx) — int — Primary key — NOT NULL
  • Key (project_team_pk) — int — Foreign key → Untitled.Key — NOT NULL
  • student_pk — int — Foreign key → Student.student_pk — NOT NULL
  • group_teacher_pk — int — Foreign key → Student.group_teacher_pk — NOT NULL
  • Key (project_pk) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (project_domain)

  • Key (project_domain_pk) — int — Primary key — NOT NULL
  • Field (project_domain_name) — varchar(20) — NOT NULL

Untitled (grade_project)

  • Key — Primary key — NOT NULL
  • Key (project_team_pk) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (project_domain_pk) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (grade_project_exam)

Untitled (project)

  • Key (project_pk) — int — Primary key — NOT NULL
  • Field (project_name) — varchar(10)