HRBank
Tables (6)
backups (데이터 백업 관리)
- id — Long — Primary key — NOT NULL
- worker — VARCHAR(45)
- status — VARCHAR(20) — CHECK(IN_PROGRESS, COMPLETED, SKIPPED, FAILED)
- started_at — TIMESTAMPTZ
- ended_at — TIMESTAMPTZ
- file_id — Long — Foreign key → files.id — NOT NULL — ON DELETE CASCADE
- created_at — TIMESTAMPTZ
change_logs (직원 정보 수정 이력 관리)
- id — Long — Primary key — NOT NULL
- type — VARCHAR(20) — NOT NULL — CHECK(CREATE, UPDATE, DELETE)
- employee_number — VARCHAR(50)
- memo — TEXT
- ip_address — VARCHAR(45)
- created_at — TIMESTAMPTZ
departments (부서 관리)
- id — Long — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(50)
- established_date — DATE — NOT NULL
- created_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
employee_change_details (Untitled)
- id — Long — Primary key — NOT NULL
- field_name — VARCHAR(100)
- old_value — TEXT
- new_value — TEXT
- log_id — Long — Foreign key → change_logs.id — NOT NULL — ON DELETE CASCADE
employees (직원 정보 관리)
- id — Long — Primary key — NOT NULL
- name — VARCHAR(100)
- email — VARCHAR(100)
- position — VARCHAR(20)
- hire_date — DATE
- status — VARCHAR(20) — CHECK(ACTIVE, ON_LEAVE, RESIGNED)
- employee_number — VARCHAR(50)
- department_id — Long — Foreign key → departments.id — NOT NULL
- profile_id — Long — Foreign key → files.id — NOT NULL — ON DELETE SET NULL
- crreated_at (created_at) — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ
files (파일 관리)
- id — Long — Primary key — NOT NULL
- file_name (filename) — VARCHAR(50)
- type — VARCHAR(50)
- size — Long
- created_at — TIMESTAMPTZ