PUBLIC HR-BANK ERD

Tables (6)

backups (백업)

  • id (PK) — Serial — Primary key — NOT NULL
  • created_at (Field4) — Timestamptz — NOT NULL
  • updated_at (Field6) — Timestamptz — NOT NULL
  • started_at_from (Field2) — Timestamptz — NOT NULL
  • started_at_to (Field3) — Timestamptz — NOT NULL
  • employee_ip (Field) — INET — NOT NULL
  • backup_status (Field5) — Varchar(15) — NOT NULL
  • binary_content_id (Field7) — Serial — Foreign key → binary_contents.id

binary_contents

  • id (Key) — long — Primary key — NOT NULL
  • emp_id (Key2) — Foreign key → employees.id — NOT NULL
  • created_at (Field) — timestamptz — NOT NULL
  • file_name (Field2) — timestamptz — NOT NULL
  • content_type (Field3) — varchar(30) — NOT NULL
  • size (Field4) — varchar(255) — NOT NULL

change_log_diff (Untitled6)

  • id(PK) (id) — Serial — Primary key — NOT NULL
  • id(PK) (id2) — Serial — Foreign key → employee_change_log.id(PK) — NOT NULL
  • property_name — Varchar(50) — NOT NULL
  • before_value — Varchar(255)
  • after_value — Varchar(255) — NOT NULL

departments

  • id (Key) — Serial — Primary key — NOT NULL
  • created_at (Field4) — Timestamptz — NOT NULL
  • updated_at (Field5) — Timestamptz
  • name (Field3) — Varchar(100) — NOT NULL
  • description (Field) — Varchar(500) — NOT NULL
  • established_date (Field2) — Date — NOT NULL

employee_change_log

  • id(PK) (id) — Serial — Primary key — NOT NULL
  • type — Varchar(10) — NOT NULL
  • memo — Text
  • ipAddress (IpAddress) — INET — NOT NULL
  • at (Field) — Timestamptz — NOT NULL

employees

  • id — Serial — Primary key — NOT NULL
  • department_id — Serial — Foreign key → departments.id — NOT NULL
  • profile_id(FK) (profile_id) — Serial
  • created_at — Timestamptz — NOT NULL
  • updated_at — Timestamptz
  • emp_no — Varchar(100) — NOT NULL
  • name — Varchar(10) — NOT NULL
  • email — Varchar(50) — NOT NULL
  • position — Varchar(50) — NOT NULL
  • hire_date — Date — NOT NULL
  • memo — Varchar(500)
  • status — Varchar(20) — NOT NULL