test

Tables (11)

ALGORITHM

  • ALGORITHM ID (ALGORITHM_ID) — int(11) — Primary key — NOT NULL
  • STUDENT ID (STUDENT_ID) — int(11) — Foreign key → STUDENT.STUDENT ID — NOT NULL
  • ALGORITHM GRADE (ALGORITHM_GRADE) — varchar(20)
  • ALGORITHM ACQUISITION DATE (ALGORITHM_ACQUISITION_DATE) — datetime

ATTENDANCE DATE (ATTENDANCE)

  • ATTENDANCE DATE (ATTENDANCE_DATE) — date — Primary key — NOT NULL
  • STUDENT ID (STUDENT_ID) — int(11) — Foreign key → STUDENT.STUDENT ID — NOT NULL
  • ATTENDANCE — tinyint(1)
  • ATTENDANCE SIGN IN (ATTENDANCE_SIGN_IN) — datetime
  • ATTENDANCE SIGN OUT (ATTENDANCE_SIGN_OUT) — datetime

GRADE

  • GRADE ID (GRADE_ID) — int(11) — Primary key — NOT NULL
  • STUDENT ID (STUDENT_ID) — int(11) — Foreign key → STUDENT.STUDENT ID — NOT NULL
  • GRADE FIRST EXAM (GRADE_FIRST_EXAM) — varchar(3)
  • GRADE SECOND EXAM (GRADE_SECOND_EXAM) — varchar(3)
  • GRADE THIRD EXAM (GRADE_THIRD_EXAM) — varchar(3)

GROUP TEACHER (GROUP_TEACHER)

  • Key (GROUP_TEACHER_ID) — int(11) — Primary key — NOT NULL
  • Key (CLASS_ID) — int(11) — Foreign key → STUDENT_GROUP.Key — NOT NULL
  • GROUP TEACHER ACCOUNT (GROUP_TEACHER_ACCOUNT) — varchar(20)
  • GROUP TEACHER NAME (GROUP_TEACHER_NAME) — varchar(20) — NOT NULL
  • GROUP TEACHER HP (GROUP_TEACHER_HP) — varchar(20) — NOT NULL

LAST

  • LAST ID (LAST_ID) — int(11) — Primary key — NOT NULL
  • STUDENT ID (STUDENT_ID) — int(11) — Foreign key → STUDENT.STUDENT ID — NOT NULL
  • LAST USER (LAST_USER) — varchar(20)
  • LAST DT (LAST_DT) — datetime

PROJECT

  • PROJECT ID (PROJECT_ID) — int(11) — Primary key — NOT NULL
  • PROJECT NAME (PROJECT_NAME) — varchar(100) — NOT NULL
  • PROJECT DOMAIN (PROJECT_DOMAIN) — varchar(20) — NOT NULL
  • PROJECT DATE (PROJECT_DATE) — datetime
  • PROJECT GRADE (PROJECT_GRADE) — varchar(3)

REG

  • REG ID (REG_ID) — int(11) — Primary key — NOT NULL
  • STUDENT ID (STUDENT_ID) — int(11) — Foreign key → STUDENT.STUDENT ID — NOT NULL
  • REG USER (REG_USER) — varchar(20)
  • REG DT (REG_DT) — datetime

STUDENT

  • STUDENT ID (STUDENT_ID) — int(11) — Primary key — NOT NULL
  • STUDENT ACCOUNT (STUDENT_ACCOUNT) — varchar(20) — NOT NULL
  • STUDENT NAME (STUDENT_NAME) — varchar(100) — NOT NULL
  • STUDENT HP (STUDENT_HP) — varchar(20) — NOT NULL
  • STUDENT AGE (STUDENT_AGE) — varchar(5) — NOT NULL
  • STUDENT GENDER (STUDENT_GENDER) — varchar(5) — NOT NULL
  • Key (CLASS_ID) — int(11) — Foreign key → STUDENT_GROUP.Key — NOT NULL

STUDENT_GROUP (CLASS)

  • Key (CLASS_ID) — int(11) — Primary key — NOT NULL
  • Field (STUDENT_REGION) — varchar(20) — NOT NULL
  • Field (STUDENT_GROUP) — varchar(5) — NOT NULL
  • Field (STUDENT_CURRICULUM) — varchar(5) — NOT NULL

TEAM

  • TEAM ID (TEAM_ID) — int(11) — Primary key — NOT NULL
  • PROJECT ID (PROJECT_ID) — int(11) — Foreign key → PROJECT.PROJECT ID — NOT NULL
  • TEAM NAME (TEAM_NAME) — varchar(20) — NOT NULL

Untitled (TEAM_MEMBER)

  • TEAM ID (TEAM_ID) — int(11) — Foreign key → TEAM.TEAM ID — NOT NULL
  • STUDENT ID (STUDENT_ID) — int(11) — Foreign key → STUDENT.STUDENT ID — NOT NULL
  • PROJECT ID (PROJECT_ID) — int(11) — Foreign key → TEAM.PROJECT ID — NOT NULL