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