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