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