FacialRecognitionSystem
Tables (8)
commute_log (출퇴근기록)
- id (출퇴근기록번호) — int — Primary key — NOT NULL
- 사원번호 — int — Foreign key → employee.id — NOT NULL
- reason (사유) — int
- check_in_time (출근시간) — time
- check_out_time (퇴근시간) — time
- work_date (근무일) — datetime
- is_lated (지각여부) — boolean
commute_type (출퇴근타입)
- id (출퇴근타입번호) — int — Primary key — NOT NULL
- code (쵤퇴근타입코드) — enum
- check_in_time (출근시간) — time
- check_out_time (퇴근시간) — time
commute_type_log (출퇴근타입기록)
- id (출퇴근타입로그아이디) — int — Primary key — NOT NULL
- employee_id (사원번호) — int — Foreign key → employee.id — NOT NULL
- commute_type_id (출퇴근타입번호) — int — Foreign key → commute_type.id — NOT NULL
- start_date (시차적응시작일) — datetime
- end_date (시차적응종료일) — datetime
department (부서)
- id (부서번호) — int — Primary key — NOT NULL
- parent_id (상위부서번호) — int — Foreign key → department.id — NOT NULL
- name (부서명) — varchar
- role (직위) — varchar
- memo (메모) — int
door_log (입실퇴실기록)
- id (입실퇴실기록번호) — int — Primary key — NOT NULL
- employee_id (사원번호) — int — Foreign key → employee.id — NOT NULL
- type (타입) — enum
- time_stamp (시간) — datetime
- imageUrl (이미지) — varchar(255)
- floor_number (층수) — int
- simiarty (인식률) — floor
embedding (임베딩)
- id (임베딩번호) — int — Primary key — NOT NULL
- employee_id (사원번호) — int — Foreign key → employee.id — NOT NULL
- embedding_data (임베딩데이터) — binarya
employee (사원)
- id (사원번호) — int — Primary key — NOT NULL
- department_id (부서번호) — int — Foreign key → department.id — NOT NULL
- imageUrl (이미지) — varchar(255)
- name (이름) — varchar(255)
- email (메일) — varchar
- phone_number (휴대전호) — varchar
- call_number (전화번호) — varchar
- company_fax (회사팩스) — varchar
- extension_number (내선번호) — varchar
- is_deleted (삭제여부) — boolean
- is_working (근무여부) — boolean
- updated_at (갱신일) — timestamp
web_auth (웹인증)
- employee_id (사원번호) — int — Foreign key → employee.id — NOT NULL
- login_id (로그인아이디) — varchar
- password (패스워드) — varchar
- role (역할(권한)) — enum
- created_at (생성일) — timsstamp
- updated_at (갱신일) — timestamp