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')