DAY01

Tables (7)

Untitled (STUDENT)

  • Key (STUDENT_ACCOUNT) — VARCHAR(20) — Primary key — NOT NULL
  • Field (STUDENT_NAME) — VARCHAR(100) — NOT NULL
  • Field (STUDENT_HP) — VARCHAR(20) — NOT NULL
  • Field (STUDENT_AGE) — VARCHAR(5) — NOT NULL
  • Field (STUDENT_GENDER) — VARCHAR(20) — NOT NULL
  • Field (STUDENT_CURRICULUM) — VARCHAR(20) — NOT NULL
  • Field (STUDENT_REGION) — VARCHAR(20) — NOT NULL
  • Field (STUDENT_GROUP) — VARCHAR(20) — NOT NULL
  • Key (GROUP_TEACHER_ID) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (GROUP_INFO)

  • Key (GROUP_TEACHER_ID) — VARCHAR(20) — Primary key — NOT NULL
  • Field (GROUP_TEACHER_NAME) — VARCHAR(20)
  • Field (GROUP_TEACHER_HP) — VARCHAR(20)

Untitled (GRADE)

  • Key (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (GRADE_NUM) — VARCHAR(3) — NOT NULL
  • Field (GRADE_SCORE) — VARCHAR(3)

Untitled (ALGORITHM)

  • Key (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (ALGORITHM_GRADE) — VARCHAR(20)
  • Field (ALGORITHM_ACQUISITION_DATE) — DATETIME

Untitled (ATTENDANCE)

  • Key (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (ATTENDANCE_SIGN_IN) — DATETIME
  • Field (ATTENDANCE_SIGN_OUT) — DATETIME
  • Field (ATTENDANCE_DATE) — DATETIME

Untitled (STUDENT_INFO)

  • Key (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (REG_USER) — VARCHAR(100)
  • Field (REG_DT) — DATETIME
  • Field (LAST_USER) — VARCHAR(20)
  • Field (LAST_DT) — DATETIME

Untitled (PROJECT)

  • Key (STUDENT_ACCOUNT) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (PROJECT_NAME) — VARCHAR(100) — NOT NULL
  • Field (PROJECT_TEAM) — VARCHAR(3) — NOT NULL
  • Field (PROJECT_SCORE) — VARCHAR(3)