HR Bank

Tables (5)

backups (데이터 백업)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • worker (작업자) — VARHCAR — NOT NULL
  • startedAt (시작시간) — DATETIME
  • endedAt (종료 시간) — DATETIME
  • status (상태)
  • fileId (PK2) — BIGINT — Foreign key → file.fileId — NOT NULL

change-logs (직원정보수정)

  • id (PK) — BIGINT — Primary key — NOT NULL
  • employeeNumber (사원번호) — VARCHAR — NOT NULL
  • type (유형) — VARCHAR — NOT NULL
  • details (상세설명) — TEXT
  • memo (내용) — VARCHAR
  • ipAddress (ip주소) — VARCHAR — NOT NULL
  • at (수정시간) — DATETIME — NOT NULL

departments (부서)

  • departmentId (PK) — BIGINT — Primary key — NOT NULL
  • departmentName (부서이름) — VARCHAR(20) — NOT NULL
  • description (부서설명) — VARCHAR
  • establishedDate (설립일) — DATE — NOT NULL

employees (직원)

  • employeeId (PK) — UUID — Primary key — NOT NULL
  • name (이름) — VARCHAR(20)
  • email (이메일) — VARCHAR(20)
  • position (직함) — VARCHAR — NOT NULL
  • hireDate (입사일) — DATE — NOT NULL
  • status (상태) — VARCHAR — NOT NULL
  • profileImageId (프로필이미지) — Integer
  • employeeNumber (PK2) — VARCHAR(20) — Foreign key → change-logs.id — NOT NULL
  • departmentId (FK) — UUID — Foreign key → departments.departmentId — NOT NULL
  • fileId (FK2) — BIGINT — Foreign key → file.fileId

file (파일)

  • fileId (PK) — BIGINT — Primary key — NOT NULL
  • name (파일명) — VARCHAR — NOT NULL
  • type (파일형식) — VARCHAR — NOT NULL
  • size (파일 크기) — BIGINT — NOT NULL