FaceRecognitionServer

Tables (7)

CheckIn (인원체크현황)

  • id (PrimaryKey) — int
  • name (수업명) — varchar
  • peopleCount (출입인원수) — int
  • teacherName (교수명) — varchar
  • createdAt (생성날짜) — Date
  • updatedAt (수정날짜) — Date
  • deletedAt (삭제날짜) — Date
  • lessonId (과목Index) — int
  • Field

Groups (학과정보)

  • id (PrimaryKey) — int
  • name (수업명칭) — varchar
  • createdAt (개설날짜) — Date
  • updatedAt (수정날짜) — Date
  • deletedAt (폐강날짜) — Date

Images (사진정보)

  • id (PrimaryKey) — int
  • userCode (학번) — int
  • createdAt (생성날짜) — Date
  • updatedAt (수정날짜) — Date
  • deletedAt (삭제날짜) — Date
  • imageCount (이미지 장) — int

Lessons (수업들)

  • id (PrimaryKey) — int
  • name (수업명칭) — varchar
  • createdAt (개설날짜) — Date
  • updatedAt (수정날짜) — Date
  • deletedAt (폐강날짜) — Date
  • startPoint (시작시간) — Time
  • endPoint (끝나는시간) — Time

Teachers (교수정보)

  • id (PrimaryKey) — int
  • name (이름) — varchar
  • password (비밀번호) — varchar
  • teacherCode (사번) — int
  • createdAt (생성날짜) — Date
  • updatedAt (수정날짜) — Date
  • deletedAt (삭제날짜) — Date

Users (학생정보)

  • id (PrimaryKey) — int
  • name (이름) — varchar
  • password (비밀번호) — varchar
  • userCode (학번) — int
  • createdAt (생성날짜) — Date
  • updatedAt (수정날짜) — Date
  • deletedAt (삭제날짜) — Date

user_lesson (mapping)

  • id (PrimaryKey) — int
  • userId (UserCode입력) — int
  • lessonId (과목ID) — int
  • gorupId (학과ID) — int
  • Field