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