Smart check-in

Tables (6)

Attendance_record (attendance_record)

  • arID — int — Primary key — NOT NULL
  • userID — varchar(8) — Foreign key → user.userID — NOT NULL
  • courserID (courseID) — int — Foreign key → Course.courserID
  • status — varchar(20)
  • date — date
  • period — int
  • type — varchar(10)
  • applicationDate — varchar(100)
  • approvalStatus — varchar(10)
  • requestAttendance — varchar(10)
  • content — text

Course (course)

  • courserID (courseID) — int — Primary key
  • courseUniversity — varchar(50)
  • courseYear — int
  • courseTerm — varchar(50) — NOT NULL
  • courseArea — varchar(50) — NOT NULL
  • courseMajor — varchar(50)
  • courseGrade — varchar(50)
  • courseTitle — varchar(100)
  • courseCredit — int
  • courseDivide — int
  • coursePersonnel — varchar(50)
  • courseProfessor — varchar(50)
  • courseTime — varchar(100)
  • courseRoom — varchar(100)

Message (message)

  • messageID — int — Primary key — NOT NULL
  • fromID — varchar(8) — Foreign key → user.userID — NOT NULL
  • toID — varchar(8) — Foreign key → user.userID — NOT NULL
  • title — varchar(50)
  • content — text
  • reg_dt — datetime

Notice (notice)

  • noticeID — int — Primary key — NOT NULL
  • userID — varchar(8) — Foreign key → user.userID — NOT NULL
  • noticeName — varchar(50)
  • noticeContent — varchar(1000)
  • noticeDate — date

Schedule (schedule)

  • courserID (courseID) — int — Foreign key → Course.courserID
  • userID — varchar(8) — Foreign key → user.userID — NOT NULL

user

  • userID — varchar(8) — Primary key — NOT NULL
  • password — varchar(30)
  • name — varchar(5)
  • type — ('student','professor')