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