HR Bank

Tables (5)

Untitled (file)

  • Key (id) — bigint unsigned — Primary key — NOT NULL
  • Field (name) — varchar(255) — NOT NULL
  • Field2 (extension) — varchar(255) — NOT NULL
  • Field (size) — double precision — NOT NULL

Untitled (employee_history)

  • Key (id) — bigint unsigned — Primary key — NOT NULL
  • Field (type) — varchar(255) — NOT NULL — 직원 추가 / 정보 수정 / 직원 삭제
  • Key (employee_id) — UUID — Foreign key → employee.Key — NOT NULL
  • Field2 (changed_field) — varchar(255) — NOT NULL — 변경하는 필드
  • Field (before_value) — varchar(255) — NOT NULL
  • Field (after_value) — varchar(255) — NOT NULL
  • Field (memo) — text
  • Field (ip_address) — varchar(255) — NOT NULL
  • Field (created_at) — timestamp — NOT NULL

Untitled (backup_data)

  • Key (id) — bigint unsigned — Primary key — NOT NULL
  • Field (modifier) — varchar(255) — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (ended_at) — timestamp
  • Field (status) — varchar(30) — NOT NULL
  • Key (backup_file_id) — bigint — Foreign key → Untitled.Key — NOT NULL

department

  • id — bigint unsigned — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • Field (description) — varchar(255) — NOT NULL
  • description (established_date) — date — NOT NULL

employee

  • Key (id) — UUID — Primary key — NOT NULL — DB상 ID
  • Field (name) — varchar(255) — NOT NULL
  • Field2 (email) — varchar(255) — NOT NULL
  • Field (title) — varchar(255) — NOT NULL — 직함
  • Field (employee_number) — varchar(255) — NOT NULL — 사번
  • Field (joined_date) — date — NOT NULL
  • Field (status) — varchar(30) — NOT NULL
  • id (department_id) — bigint — Foreign key → department.id — NOT NULL
  • Key (profile_image_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field2 (updated_at) — timestamp