db

Tables (5)

Attendance

  • ATTENDANCE_PK — INT — Primary key
  • STUDENT_PK — INTEGER — Foreign key → Student.STUDENT_PK
  • ATTENDANCE — VARCHAR(20)
  • ATTENDANCE_DATE — DATE
  • ATTENDANCE_SIGN_IN — TIME
  • ATTENDANCE_SIGN_OFF — TIME
  • STUDENT_PK (STUDENT_PK2) — INT — Foreign key → Student.STUDENT_PK

Exam

  • EXAM_PK — INT — Primary key
  • STUDENT_PK — INTEGER — Foreign key → Student.STUDENT_PK
  • TEST_SCORE — INTEGER
  • TEST_ORDER — INTEGER
  • STUDENT_PK (STUDENT_PK2) — INT — Foreign key → Student.STUDENT_PK

Project

  • PROJECT — INT — Primary key
  • STUDENT_PK — INTEGER — Foreign key → Student.STUDENT_PK
  • PROJECT_SCORE — INTEGER
  • PROJECT_ORDER — INTEGER
  • STUDENT_PK (STUDENT_PK2) — INT — Foreign key → Student.STUDENT_PK

Student

  • STUDENT_PK — INT — Primary key
  • STUDENT_EMAIL — VARCHAR(50) — NOT NULL
  • STUDENT_NAME — VARCHAR(6) — NOT NULL
  • STUDENT_GENDER — VARCHAR(20)
  • STUDENT_HP — VARCHAR(20)
  • STUDENT_AGE — varchar(5)
  • STUDENT_CURRICULUM — VARCHAR(20)
  • STUDENT_REGION — VARCHAR(20)
  • STUDENT_GROUP — VARCHAR(20)
  • TEACHER_PK — INTEGER
  • ALGORITHM_GRADE — VARCHAR(20)
  • ALGORITHM_ACQUISITION_DATE — datetime

Teacher

  • STUDENT_PK — INT — Foreign key → Student.STUDENT_PK
  • TEACHER_PK — INT
  • TEACHER_NAME — VARCHAR(20) — NOT NULL
  • TEACHER_HP — VARCHAR(20) — NOT NULL