HRBank_ERD

Tables (5)

backup_history

  • id — BIGINT — Primary key — NOT NULL
  • worker — VARCHAR(50) — NOT NULL
  • start_time — TIMESTAMP — NOT NULL
  • end_time — TIMESTAMP
  • status — VARCHAR(20) — NOT NULL
  • backup_file_id — BIGINT — Foreign key → file.id

change_history

  • id — BIGINT — Primary key — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • employee_number — VARCHAR(50) — NOT NULL
  • memo — VARCHAR(500)
  • ip_address — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

department

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • established_date — DATE — NOT NULL

employee

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • employee_number — VARCHAR(50) — NOT NULL
  • department_id — BIGINT — Foreign key → department.id — NOT NULL
  • position — VARCHAR(100) — NOT NULL
  • hire_date — DATE — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • profile_image_id — BIGINT — Foreign key → file.id

file

  • id — BIGINT — Primary key — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_type — VARCHAR(50) — NOT NULL
  • size — BIGINT — NOT NULL