Page 30 - 4-4studylife

21

StudentCode varchar(20) No

StudentFullName varchar(120) No
AttendType tinyint(1) No 1

CheckIn datetime Yes NULL

LeftEarly tinyint(1) No 0

Remark varchar(400) Yes NULL

ตารางท 3.4 ชั้นเรียน (ClassEvent)
ี่
Column Type Null Default

ClassEventID (Primary) int(11) No

PermaToken varchar(32) No

del tinyint(1) No 0

OfficerCode varchar(30) No

AcadYear varchar(10) No

Semester varchar(5) No
ClassID varchar(20) No

CourseCode varchar(30) No

CourseName varchar(100) No
CourseNameEN varchar(100) Yes NULL

RoomID varchar(20) No

RoomName varchar(100) No
WeekDay varchar(50) No

WeekDayEN varchar(50) Yes NULL

TimeSlotFrom varchar(20) No

TimeSlotTo varchar(20) No

AdvisorFullname varchar(200) Yes NULL

ClassEventDate datetime No

ClassEventCreateTime datetime No CURRENT_TIMESTAMP

คู่มือการพัฒนาแอปพลิเคชัน Study Life