self-online

Tables (7)

ATTENDANCE

  • STUDENT_ACCOUNT (account_id) — VARCHAR(20) — Foreign key → Students.STUDENT_ACCOUNT — NOT NULL
  • 1/1 — TINYINT(1)
  • 1/1_SIGN_IN — DATETIME
  • 1/1_SIGN_OUT — DATETIME
  • 1/2 — TINYINT(1)
  • 1/2_SIGN_IN — DATETIME
  • 1/2_SIGN_OUT — DATETIME
  • 1/3 — TINYINT(1)
  • 1/3_SIGN_IN — DATETIME
  • 1/3_SIGN_OUT — DATETIME
  • 1/4 — TINYINT(1)
  • 1/4_SIGN_IN — DATETIME
  • 1/4_SIGN_OUT — DATETIME
  • 1/5 — TINYINT(1)
  • 1/5_SIGN_IN — DATETIME
  • 1/5_SIGN_OUT — DATETIME
  • 1/6 — TINYINT(1)
  • 1/6_SIGN_IN — DATETIME
  • 1/6_SIGN_OUT — DATETIME
  • 1/7 — TINYINT(1)
  • 1/7_SIGN_IN — DATETIME
  • 1/7_SIGN_OUT — DATETIME
  • 1/8 — TINYINT(1)
  • 1/8_SIGN_IN — DATETIME
  • 1/8_SIGN_OUT — DATETIME
  • 1/9 — TINYINT(1)
  • 1/9_SIGN_IN — DATETIME
  • 1/9_SIGN_OUT — DATETIME
  • 1/10 — TINYINT(1)
  • 1/10_SIGN_IN — DATETIME
  • 1/10_SIGN_OUT — DATETIME
  • REG_USER (reg_user) — VARCHAR(20)
  • REG_DT (reg_dt) — DATETIME
  • LAST_USER (last_user) — VARCHAR(20)
  • LAST_DT (last_dt) — DATETIME

Algorithms (algorithms)

  • STUDENT_ACCOUNT (account_id) — VARCHAR(20) — Foreign key → Students.STUDENT_ACCOUNT — NOT NULL
  • ALGORITHM_GRADE (grade) — VARCHAR(20)
  • ALGORITHM_ACQUISITION_DATE (acquisition_date) — DATETIME
  • REG_USER (reg_user) — VARCHAR(20)
  • REG_DT (reg_dt) — DATETIME
  • LAST_USER (last_user) — VARCHAR(20)
  • LAST_DT (last_dt) — DATETIME

Grades (grades)

  • STUDENT_ACCOUNT (account_id2) — VARCHAR(20) — Foreign key → Students.STUDENT_ACCOUNT — NOT NULL
  • GRADE_FIRST_EXAM (first) — VARCHAR(3) — NOT NULL
  • GRADE_SECOND_EXAM (second) — VARCHAR(3)
  • GRADE_THIRD_EXAM (third) — VARCHAR(3)
  • REG_USER (reg_user) — VARCHAR(20)
  • REG_DT (reg_dt) — DATETIME
  • LAST_USER (last_user) — VARCHAR(20)
  • LAST_DT (last_dt) — DATETIME

Groups (groups)

  • STUDENT_GROUP (group) — VARCHAR(20) — Primary key — NOT NULL
  • REG_USER (reg_user) — VARCHAR(20)
  • REG_DT (reg_dt) — DATETIME
  • LAST_USER (last_user) — VARCHAR(20)
  • LAST_DT (last_dt) — DATETIME

Projects (projects)

  • STUDENT_ACCOUNT (account_id) — VARCHAR(20) — Foreign key → Students.STUDENT_ACCOUNT — NOT NULL
  • FIRST_INFO (first_info) — VARCHAR(100)
  • FIRST_GRADE (first_grade) — VARCHAR(3)
  • SECOND_INFO (second_info) — VARCHAR(100)
  • SECOND_GRADE (second_grade) — VARCHAR(3)
  • THIRD_INFO (third_info) — VARCHAR(100)
  • THIRD_GRADE (third_grade) — VARCHAR(3)
  • REG_USER (reg_user) — VARCHAR(20)
  • REG_DT (reg_dt) — DATETIME
  • LAST_USER (last_user) — VARCHAR(20)
  • LAST_DT (last_dt) — DATETIME

Students (students)

  • STUDENT_ACCOUNT (account_id) — VARCHAR(20) — Primary key — NOT NULL
  • STUDENT_NAME (name) — VARCHAR(100)
  • STUDENT_HP (hp) — VARCHAR(20)
  • STUDENT_AGE (age) — VARCHAR(5)
  • STUDENT_GENDER (Field) — VARCHAR(20)
  • STUDENT_CURRICULLUM (curricullum) — VARCHAR(20)
  • STUDENT_REGION (region) — VARCHAR(20)
  • REG_USER (reg_user) — VARCHAR(20)
  • REG_DT (reg_dt) — DATETIME
  • LAST_USER (last_user) — VARCHAR(20)
  • LAST_DT (last_dt) — DATETIME
  • GROUP_TEACHER_ID (teacher_id) — VARCHAR(20) — Foreign key → TEACHERS.GROUP_TEACHER_ID — NOT NULL
  • STUDENT_GROUP (group) — VARCHAR(20) — Foreign key → Groups.STUDENT_GROUP — NOT NULL

TEACHERS (teachers)

  • GROUP_TEACHER_ID (teacher_id) — VARCHAR(20) — Primary key — NOT NULL
  • GROUP_TEACHER_NAME (teacher_name) — VARCHAR(20)
  • GROUP_TEACHER_HP (teacher_hp) — VARCHAR(20)
  • REG_USER (reg_user) — VARCHAR(20)
  • REG_DT (reg_dt) — DATETIME
  • LAST_USER (last_user) — VARCHAR(20)
  • LAST_DT (last_dt) — DATETIME