user

Tables (6)

attendance (Untitled3)

  • STUDENT_HP (hp) — varchar — Foreign key → student.STUDENT_HP — NOT NULL
  • ATTENDANCE_DATE (date) — varchar
  • SIGN_IN (sign_in) — datetime
  • SIGN_OUT (sign_out) — datetime

grade (Untitled6)

  • STUDENT_HP (hp) — varchar — Foreign key → student.STUDENT_HP — NOT NULL
  • FIRST_EXAM (first) — int
  • SECOND_EXAM (second) — imt
  • THIRD_EXAM (third) — int
  • ALGORITHM_GRADE (algorithm) — varchar

student (Untitled)

  • STUDENT_HP (hp) — varchar — Primary key — NOT NULL
  • TEACHER_HP (hp2) — varchar — Foreign key → teacher.TEACHER_HP — NOT NULL
  • STUDENT_ACCOUNT (account) — varchar
  • STUDENT_NAME (name) — varchar
  • STUDENT_AGE (age) — int
  • STUDENT_GENDER (gender) — varchar
  • STUDENT_CURRICULUM (curriculum) — int
  • STUDENT_REGION (region) — varchar
  • STUDENT_GROUP (group) — int

student-team (Untitled5)

  • Key — Primary key — NOT NULL
  • STUDENT_HP (hp) — varchar — Foreign key → student.STUDENT_HP — NOT NULL
  • TEAM_ID (id) — int — Foreign key → team.TEAM_ID — NOT NULL

teacher (Untitled4)

  • TEACHER_HP (hp) — varchar — Primary key — NOT NULL
  • TEACHER_ID (account) — varchar
  • TEACHER_NAME (name) — varchar

team (Untitled2)

  • TEAM_ID (id) — int — Primary key — NOT NULL
  • TEAM_NAME (team_name) — varchar
  • PROJECT_NAME (pjt_name) — varchar
  • PROJECT_GRADE (grade) — varchar