self_online1

Tables (6)

January_Date

  • STUDENT_ACCOUNT — varchar(20) — Foreign key → student.STUDENT_ACCOUNT — NOT NULL
  • date — int — NOT NULL
  • ATTENDANCE — tinyint(1)
  • SIGN_IN — datetime
  • SIGN_OUT — datetime
  • REG_USER — varchar(20)
  • REG_DT — datetime
  • LAST_USER — varchar(20)
  • LAST_DT — datetime

Level

  • STUDENT_ACCOUNT — varchar(20) — Foreign key → student.STUDENT_ACCOUNT — NOT NULL
  • GRADE_FIRST_EXAM — varchar(3)
  • GRADE_SECOND_EXAM — varchar(3)
  • GRADE_THIRD_EXAM — varchar(3)
  • ALGORITHM_GRADE — varchar(20)
  • ALGORITHM_ACQUISITION_DATE — datetime
  • REG_USER — varchar(20)
  • REG_DT — datetime
  • LAST_USER — varchar(20)
  • LAST_DT — datetime

Team

  • TEAM_ID (team_id) — int — Primary key — NOT NULL
  • TEAM_CLASS (team_class) — int — Primary key — NOT NULL
  • TEAM_ROLE (team_role) — varchar(20)
  • STUDENT_ACCOUNT — varchar(20) — Foreign key → student.STUDENT_ACCOUNT — NOT NULL

group_teacher

  • GROUP_TEACHER_ID — varchar(20) — Primary key — NOT NULL
  • GROUP_TEACHER_NAME — varchar(20) — NOT NULL
  • GROUP_TEACHER_HP — varchar(20) — NOT NULL
  • REG_USER — varchar(20)
  • REG_DT — datetime
  • LAST_USER — varchar(20)
  • LAST_DT — datetime

project

  • PROJECT_ID (project_id) — varchar(20) — Primary key — NOT NULL
  • PROJECT_KIND (project_kind) — varchar(20)
  • PROJECT_DOMAIN (project_domain) — varchar(20)
  • PROJECT_GRADE (project_grade) — varchar(3)
  • Field
  • TEAM_ID (team_id) — int — Foreign key → Team.TEAM_ID — NOT NULL
  • TEAM_CLASS (team_class) — int — Foreign key → Team.TEAM_CLASS — NOT NULL

student

  • STUDENT_ACCOUNT — varchar(20) — Primary key — NOT NULL
  • STUDENT_NAME — varchar(100) — NOT NULL
  • STUDENT_HP — varchar(20)
  • STUDENT_AGE — varchar(5)
  • STUDENT_GENDER — varchar(20)
  • STUDENT_CURRICULUM — varchar(20)
  • STUDENT_REGION — varchar(20)
  • STUDENT_GROUP — varchar(20) — NOT NULL
  • REG_USER — varchar(20)
  • REG_DT — datetime
  • LAST_USER — varchar(20)
  • LAST_DT — datetime
  • GROUP_TEACHER_ID — varchar(20) — Foreign key → group_teacher.GROUP_TEACHER_ID — NOT NULL
  • Field