day1

Tables (7)

GRADE

  • STUDENT_ID (PK, FK) — int — Foreign key → STUDENT.STUDENT_ID — NOT NULL
  • Field — varchar(3)
  • Field2 — varchar(3)
  • Field3 — varchar(3)

GROUP_TEACHER

  • GROUP_TEACHER_ID (PK) — varchar(20) — Primary key — NOT NULL
  • GROUP_TEACHER_NAME (Field) — varchar(20)
  • GROUP_TEACHER_HP (Field2) — varchar(20)

STUDENT

  • STUDENT_ID (PK) — int — Primary key — NOT NULL
  • GROUP_TEACHER_ID (FK) — varchar(20) — Foreign key → GROUP_TEACHER.GROUP_TEACHER_ID — NOT NULL
  • STUDENT_ACCOUNT (Field1) — varchar(20)
  • STUDENT_NAME (Field2) — varchar(100)
  • STUDENT_HP (Field3) — varchar(20)
  • STUDENT_AGE (Field4) — varchar(5)
  • STUDENT_GENDER (Field5) — varchar(20)
  • STUDENT_CURRICULUM (Field6) — varchar(20)
  • STUDENT_REGION (Field7) — varchar(20)
  • STUDENT_GROUP (Field8) — varchar(20)

Untitled (PROJECT)

  • Key (PK) — int — Primary key — NOT NULL
  • Field — varchar(100)
  • Field2 — varchar(3)

Untitled (PROJECT_TEAM)

  • STUDENT_ID (PK, FK) — int — Foreign key → STUDENT.STUDENT_ID — NOT NULL
  • Key (PK2, FK) — int — Foreign key → Untitled.Key — NOT NULL

Untitled2 (ALGORITHM)

  • STUDENT_ID (PK, FK) — int — Foreign key → STUDENT.STUDENT_ID — NOT NULL
  • Field — varchar(20)
  • Field2 — datetime

Untitled2 (ATTENDANCE)

  • Key (PK) — int — Primary key — NOT NULL
  • STUDENT_ID (FK) — int — Foreign key → STUDENT.STUDENT_ID — NOT NULL
  • Field — varchar(4)
  • Field2 — tinyint(1)
  • Field3 — datetime
  • Field4 — datetime