数据库er图

用户类型

userTypeId int userTypeName text

教室表

roomId int roomSite text

用户专业表

userProfessId int userId int professId int

用户表

userInfoId int userInfoCardId textuserInfoName textuserInfoPassword textuserInfoTypeId text

申请停课表

applyId int applyUserId int applyProfessId int applyCourseId int applyState text

专业表

professId int professName textdepartmentId int

申请调课表

applyId int applyUserId int applyProfessId int applyCourseId int applyWeek textapplyDay textapplyRoomId int applyState textapplyRecallTime textapplyExpiryDate textapplyDeadline intrefuseReason text

院系表

departmentId int departmentName text

课程表

courseId int courseName textdayOfWeek textcourseOfDay textteacherId int professId int roomId int deadline intoldDayOfWeek textoldCourseOfDay textcolor text