그린라이트 ERD

테이블 (6)

Attendance (근태)

  • Attendance_id (Key3) — 기본 키 — NOT NULL
  • employee_id (Key) — 외래 키 → Employees.employee_id — NOT NULL

Departments (부서)

  • department_id (Key) — 기본 키 — NOT NULL

Employees (사원)

  • employee_id (Key) — 기본 키 — NOT NULL
  • department_id (Key2) — 외래 키 → Departments.department_id — NOT NULL
  • password (Field)

Recruitment Documents (인사문서)

  • recruitment _document_id (Key) — 기본 키 — NOT NULL
  • employee_id (Key2) — 외래 키 → Employees.employee_id — NOT NULL
  • department_id (Key22) — 외래 키 → Employees.department_id — NOT NULL

Signatures (서명)

  • signature_id (Key) — 기본 키 — NOT NULL
  • employee_id (Key2) — 외래 키 → Employees.employee_id — NOT NULL
  • signature_image (Field)

Vacation (휴가)

  • vacation_id (Key) — 기본 키 — NOT NULL
  • employee_id (Key2) — 외래 키 → Employees.employee_id — NOT NULL