day1

Tables (7)

ALGORITHM (Untitled4)

  • STUDENT_ID (STUDENT_ID2) — INT — Foreign key → STUDENT.STUDENT_ID — NOT NULL
  • GRADE — VARCHAR(20)
  • ACQUISITION_DATE — DATETIME

ATTENDANCE (Untitled5)

  • STUDENT_ID (STUDENT_ID2) — INT — Foreign key → STUDENT.STUDENT_ID — NOT NULL
  • DAY — VARCHAR(20)
  • CHECK — TINYINT(1)
  • SIGN_IN — DATETIME
  • SIGN_OUT — DATETIME

GRADE (Untitled3)

  • STUDENT_ID (STUDENT_ID2) — INT — Foreign key → STUDENT.STUDENT_ID — NOT NULL
  • FIRST_EXAM — INT
  • SECOND_EXAM — INT
  • THIRD_EXAM — INT
  • FIRST_PROJECT — INT

REG (Untitled6)

  • STUDENT_ID (STUDENT_ID2) — INT — Foreign key → STUDENT.STUDENT_ID — NOT NULL
  • REG_USER — VARCHAR(20)
  • REG_DT — DATETIME
  • LAST_USER — VARCHAR(20)
  • LAST_DT — DATETIME

STUDENT (Untitled)

  • STUDENT_ID — INT — Primary key — NOT NULL
  • ACCOUNT — VARCHAR(20)
  • NAME — VARCHAR(100)
  • HP — VARCHAR(20)
  • AGE — INT
  • GENDER — VARCHAR(20)
  • CURRICULUM — INT
  • REGION — VARCHAR(20)
  • GROUP — INT
  • TEAM_ID — INT — Foreign key → TEAM.TEAM_ID — NOT NULL
  • TEACHER_ID — INT — Foreign key → TEACHER.TEACHER_ID — NOT NULL

TEACHER (Untitled2)

  • TEACHER_ID — INT — Primary key — NOT NULL
  • ACCOUNT — VARCHAR(20)
  • NAME — VARCHAR(20)
  • HP — VARCHAR(20)

TEAM (Untitled7)

  • TEAM_ID — INT — Primary key — NOT NULL
  • TITLE — VARCHAR(20)