USER

Tables (5)

algorithm (Untitled4)

  • id (Key) — not null — Primary key — NOT NULL
  • STUDENT_ID (Key2) — not null — Foreign key → student.id — NOT NULL
  • ALGORITHM_GRADE (Field) — default null
  • ALGORITHM_ACQUISITION_DATE (Field2)

attendance (Untitled5)

  • id (Key) — not null — Primary key — NOT NULL
  • STUDENT_ID (Key2) — not null — Foreign key → student.id — NOT NULL
  • ATTENDANCE (Field) — default null
  • ATTENDANCE_SIGN_IN (Field2) — default null
  • ATTENDANCE_SIGN_OUT (Field3) — default null

grade (Untitled2)

  • id (Key) — not null — Primary key — NOT NULL
  • STUDENT_ID (Key2) — not null — Foreign key → student.id — NOT NULL
  • GRADE_FIRST_EXAM (Field) — default null
  • GRADE_SECOND_EXAM (Field2) — default null
  • GRADE_THIRD_EXAM (Field3) — default null

student (Untitled)

  • id (Key) — not null — Primary key — NOT NULL
  • teacher_id (Key2) — not null — Foreign key → teacher.id — NOT NULL
  • STUDENT_ACCOUNT (Field) — not null
  • STUDENT_NAME (Field2) — not null
  • STUDENT_HP (Field3) — default null
  • STUDENT_AGE (Field4) — default null
  • STUDENT_GENDER (Field5) — default null
  • STUDENT_CURRICULUM (Field6) — default null
  • STUDENT_REGION (Field7) — default null
  • STUDENT_GROUP (Field8) — not null
  • REG_USER (Field9) — notnull
  • REG_DT (Field10) — default null
  • LAST_USER (Field11) — notnull
  • LAST_DT (Field12) — default null

teacher (Untitled3)

  • id (Key) — not null — Primary key — NOT NULL
  • GROUP_TEACHER_ID (Field) — not null
  • GROUP_TEACHER_NAME (Field2) — not null
  • GROUP_TEACHER_HP (Field3) — not null