hw1

Tables (6)

algorithm

  • Key (PK) — INT(11) — Primary key — NOT NULL
  • Field (ALGORITHM_GRADE) — VARCHAR(20)
  • Field (ALGORITHM_ACQUISITION_DATE) — DATETIME
  • Field2 (FK) — VARCHAR(20) — Foreign key → student.Field2

attendance

  • Key (PK) — INT(11) — Primary key — NOT NULL
  • Field (ATTENDANCE_1/1) — TINYINT
  • Field (ATTENDANCE_1/1_SIGN_IN) — DATETIME
  • Field (ATTENDANCE_1/1_SIGN_OUT) — DATETIME
  • Field (ATTENDANCE_1/2) — TINYINT
  • Field (ATTENDANCE_1/2_SIGN_IN) — DATETIME
  • Field (ATTENDACE_1/2_SIGN_OUT) — DATETIME
  • Field (ATTENDANCE_1/3) — TINYINT
  • Field (ATTENDANCE_1/3_SIGN_IN) — DATETIME
  • Field (ATTENDANCE_1/3_SIGN_OUT) — DATEIME
  • Field2 (FK) — VARCHAR(20) — Foreign key → student.Field2

grade

  • Key (PK) — INT(11) — Primary key — NOT NULL
  • Field2 (FK) — VARCHAR(20) — Foreign key → student.Field2
  • Field (GRADE_FIRST_EXAM) — VARCHAR(3)
  • Field (GRADE_SECOND_EXAM) — VARCHAR(3)
  • Field (GRADE_THIRD_EXAM) — VARCHAR(3)

log

  • Key (PK) — INT(11) — Primary key — NOT NULL
  • Field (REGUSER) — VARCHAR(20)
  • Field (REG_DT) — DATETIME
  • Field (LAST_USER) — VARCHAR(20)
  • Field (LAST_DT) — DATETIME
  • Field2 (FK) — VARCHAR(20) — Foreign key → student.Field2

student

  • Field2 (PK) — VARCHAR(20) — Primary key
  • Field3 (STUDENT_NAME) — VARCHAR(100)
  • Field4 (STDENT_HP) — VARCHAR(20)
  • Field (SUDENT_AGE) — VARCHAR(5)
  • Field (STUDENT_GENDER) — VARCHAR(20)
  • Field (STUDENT_CURRICULUM) — VARCHAR(20)
  • Field (STUDENT_REGION) — VARCHAR(20)
  • Field (STUDENT_GROUP) — VARCHAR(20)

teacher

  • Key (PK) — INT(11) — Primary key — NOT NULL
  • Field (GROUP_TEACHER_ID) — VARCHAR(20)
  • Field (GROUP_TEACHER_NAME) — VARCHAR(20)
  • Field (GROUP_TEACHER_HP) — VARCHAR(20)
  • Field2 (FK) — VARCHAR(20) — Foreign key → student.Field2