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