그린라이트 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