200309_day01

Tables (5)

ATTENDANCE

  • ATTENDANCE_DATE — datetime — Primary key
  • ATTENDANCE_SIGN_IN — datetime
  • ATTENDANCE_SIGN_OUT — datetime
  • Field2 (ATTENDANCE_CHECK) — tinyint(1)
  • STUDENT_ACCOUNT — varchar(20) — Foreign key → USER.STUDENT_ACCOUNT — NOT NULL

FIRST_PROJECT

  • STUDENT_ACCOUNT — varchar(20) — Foreign key → USER.STUDENT_ACCOUNT — NOT NULL
  • PROJECT_CLASS — integer — NOT NULL
  • PROJECT_DOMAIN — varchar(20) — NOT NULL
  • PROJECT_GROUP — integer — NOT NULL
  • PROJECT_GRADE — integer
  • PROJECT_TEACHER_ID — varchar(20) — NOT NULL

GRADE

  • STUDENT_ACCOUNT — varchar(20) — Foreign key → USER.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

TEACHER

  • TEACHER_ID — varchar(20) — Primary key — NOT NULL
  • TEACHER_NAME — varchar(20) — NOT NULL
  • TEACHER_HP — varchar(20)
  • TEACHER_REGION — varchar(20) — NOT NULL
  • TEACHER_GROUP — varchar(20) — NOT NULL

USER

  • 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) — NOT NULL
  • STUDENT_GROUP — varchar(20) — NOT NULL
  • REG_USER — varchar(20)
  • REG_DT — datetime
  • LAST_USER — varchar(20)
  • LAST_DT — datetime