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