Online-Day1

Tables (4)

attendance (Untitled4)

  • Field
  • Field2
  • Field3

teacher (Untitled)

  • TEACHER_ID — varchar(20) — Primary key — NOT NULL
  • TEACHER_NAME — varchar(100)
  • TEACHER_HP — varchar(20)
  • REGION — varchar(20)

team (Untitled2)

  • PROJECT_CODE — varchar(20) — Primary key — NOT NULL
  • PROJECT_TYPE — varchar(20)
  • Field2
  • Field3
  • Field4

user_change (USER_CHANGE)

  • STUDENT_CODE — varchar(20) — Primary key — NOT NULL
  • STUDENT_ACCOUNT — varchar(20)
  • 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)
  • GRADE_FIRST_EXAM — varchar(3)
  • GRADE_SECOND_EXAM — varchar(3)
  • GRADE_THIRD_EXAM — varchar(3)
  • Field
  • Field2
  • ALGORITHM_GRADE — varchar(20)
  • ALGORITHM_ACQUISITION_DATE — datetime
  • REG_USER — varchar(20)
  • REG_DT — datetime
  • LAST_USER — varchar(20)
  • LAST_DT — datetime