sprint1-part2-team7
테이블 (6)
백업 (backup_history)
- id — BIGINT — 기본 키 — NOT NULL — PK
- file_id — BIGINT — 외래 키 → 파일.id — NOT NULL — FK
- worker — VARCHAR(50) — NOT NULL
- start_time — TIMESTAMPTZ — NOT NULL
- end_time — TIMESTAMPTZ
- status — VARCHAR(50) — NOT NULL — enum(진행중, 완료, 실패, 건너뜀)
부서 (DEPARTMENTS)
- id — BIGINT — 기본 키 — NOT NULL — PK
- description — VARCHAR(500) — NOT NULL — UK
- established_date — TIMESTAMPTZ — NOT NULL
- name (Field) — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ
직원 (EMPLOYEES)
- id — BIGINT — 기본 키 — NOT NULL — PK
- department_id — BIGINT — 외래 키 → 부서.id — NOT NULL — FK (Cascade Set Null)
- binary_content_id — BIGINT — 외래 키 → 파일.id — FK (Cascade Set Null)
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(50) — NOT NULL — UK
- job_title — VARCHAR(50) — NOT NULL
- hire_date — TIMESTAMPTZ — NOT NULL
- status — VARCHAR(50) — NOT NULL — enum(재직중, 휴직중, 퇴사)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ
- employee_number — VARCHAR(50) — NOT NULL
직원 수정 이력 (EMPLOYEE_HISTORY)
- id — BIGINT — 기본 키 — NOT NULL — PK
- type — VARCHAR(20) — NOT NULL — enum(CREATED, UPDATED, DELETED)
- details — JSONB
- memo — TEXT
- ip_address — INET — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- emplyee_number (employee_number) — VARCHAR(50)
- capture_date — DATE
직원 통계 (EMPLOYEE_STATISTICS)
- id — BIGINT — 기본 키 — NOT NULL — PK
- employee_count — BIGINT — NOT NULL
- type — VARCHAR(20) — NOT NULL — enum(YEAR, QUARTER, MONTH, WEEK, DAY)
- capture_date — DATE
파일 (BINARY_CONTENTS)
- id — BIGINT — 기본 키 — NOT NULL — PK
- file_name — VARCHAR(255) — NOT NULL
- file_type — VARCHAR(100) — NOT NULL
- file_size — BIGINT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ