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