attendance

Tables (6)

attendanceList

  • userId — varchar(11) — Foreign key → user.userId — NOT NULL
  • startTime — timestamp — NOT NULL
  • endTime — timestamp
  • state — varchar(20) — NOT NULL
  • Field

attendanceStatus

  • userId — varchar(11) — Foreign key → user.userId — NOT NULL
  • lateCnt — int — NOT NULL
  • attendanceCnt — int — NOT NULL
  • earlyleaveCnt — int — NOT NULL
  • outingCnt — int — NOT NULL
  • absentCnt — int — NOT NULL

class

  • className — varchar(2) — Primary key — NOT NULL
  • teacherName — varchar(15) — NOT NULL
  • roomNum — varchar(10) — NOT NULL
  • progress — varchar(255) — NOT NULL
  • Field

notice

  • noticeId — bigInt — Primary key — NOT NULL
  • userId — varchar(11) — Foreign key → user.userId — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — text — NOT NULL
  • createTime — timestamp — NOT NULL
  • Field

tempuser (CopyOfuser)

  • userId — varchar(11) — Primary key — NOT NULL
  • userName — varchar(8) — NOT NULL
  • password — varchar(11) — NOT NULL
  • classNum — varchar(2) — NOT NULL
  • authority — int — NOT NULL
  • classNum (classNum1) — varchar(2) — NOT NULL
  • Field

user

  • userId — varchar(11) — Primary key — NOT NULL
  • className — varchar(2) — Foreign key → class.className — NOT NULL
  • userName — varchar(8) — NOT NULL
  • password — varchar(11) — NOT NULL
  • classNum — varchar(2) — NOT NULL
  • authority — int — NOT NULL