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